Remove store view from SKU

[Josch-]

Hi,

we're getting nuts on this problem.

We have a multi-store setup with two websites and some store views (one website with four and one with two store views).

• Website 1 (Website) -- Store 1 (Store) --- ws1_german (Store View) --- ws1_english (Store View) --- ws1_german_b2b (Store View) --- ws1_english_b2b (Store View)
• Website 2 (Website) -- Store 2 (Store) --- ws2_german (Store View) --- ws2_english (Store View)

When we import products with magmi, we can set the store views, e.g.

"store","sku","price" "ws1_german,ws2_german","12345","9.99"

We tried to remove the second store view from sku 12345, but nothing worked.

Is there an easy way to handle this? Like with the "product relater" plugin? There you can delete related products with a minus (-) as a prefix. So what we want is something like this:

"store","sku","price" "ws1_german,-ws2_german","12345","9.99"

to remove the store view ws2_german. But that doesn't work, because -ws2_german is recognized as the whole store view name and so "-ws2_german" is not found. Of course! ;-)

Thanks a lot for your patience :-)

Regards,

Josch

[dweeves]

Hi, unhopefully for your case products are not bound to store views but websites.

So using "websites" column , you may get what you want but at "website" level only.

Say:

you have sku001 in Website 1 & Website 2 and you want to remove it from WebSite 2

the following file:

"sku","websites","store"
"sku001","Website 1","ws1_german,ws1_english"

should do the trick (but will of course remove your item from all views from website 2) The "store" column is just here for websites to be handled correcly & not return "admin" (default value if store not set) which would sort of cancel websites setting.

To "remove" a product from a given "store view" only,the best would be to "not show" it for this store view. ie set its visibility to "Not visible individually" for this particular store view.

Say

"sku","store","visibility"
"sku001","ws2_german","1"

would disable item for ws2_german store view.

[Kamik]

status has scope website, not store view. cannot disabled for store view. And I see that product can delete only from website, not from store view. or did I miss something?

[dweeves]

you're right for status, let's play with visibility then , updated above post accordingly.

[Josch-]

Hi,

thanks a lot for your answers. I'll try to specify the problem a little bit more.

@dweeves: we tried out your suggestion but that - as mentioned - only changes the visibilty of the SKU under "Product Information" > "General" > "Visibility".

What we need is to assign a SKU to one or more websites. But that does not work. The SKU appears generally on ALL websites under "Product Information" > "Websites". How can we achieve that?

When we import like this:

"sku","websites" "12345","Website 1"

the SKU appears in Website 1 AND Website 2. Before running this update we unselected all Websites under "Product Information" > "Websites". After the import listed above all websites are selected instead of only Website 1.

What goes wrong here? Are we possibly missing a Magmi Plugin?

Thanks a lot in advance

Josch

[dweeves]

after a quick look at the code, you also need to put "store" column , otherwise it will default to admin & get all websites back for assignment. updating sample This is not very natural however, i'll try to update this to support the case in a rapid patch release.

[Josch-]

Hi dweeves,

thanks a lot. We tried it out. Now we've imported this:

"sku","websites","store" "12345","Website 1","Store 1"

That produces an error in the Magmi import, that says that the store code "Store 1" is unknown.

When we import this:

"sku","websites","store" "12345","Website 1","ws1_german"

here we set a store view code - not a store code - then it works and the SKU has the Website "Website 1" enabled under "Product Information" > "Websites".

Thats a little bit weird %-/

But that also works with this import configuration:

"sku","store" "12345","ws1_german"

without the column "Websites".

That's the first strange thing.

Second problem - we are unable to delete a Website from a SKU.

Example: When we import this:

"sku","websites","store" "12345","Website 1,Website 2","ws1_german"

The SKU is enabled in "Website 1" and "Website 2". When we run this after it:

"sku","websites","store" "12345","Website 1","ws1_german"

The SKU is still enabled in BOTH Websites.

Seems as if that could be a bug?

Thanks a lot in advance

Josch

[Josch-]

Hi there - anything new about this problem?

Thanks a lot in advance and regards

Josch

[Josch-]

Uhm - we are stuck here and unable to bring our shop to the newest Magento version. Please help :-)

[aruna-emb]

Hi, I have two website English and Russian. I am trying to upload the products using magmi v0.7.18beta2 to both the websites.All the values are same even the URL except Product name and description.

1. When i import product sheet with magmi using mode "create new items & update existing ones" , all the data given for website mentioned in the last is overwritten.
2. If i import using mode "create new items only, skip existing ones" the data given for website mentioned in the first is taken and all other data is skipped. So i wanted product to be mapped to both English and Russian website,and display in the frontend without any error.Please find the attached screenshot of the csv file.

Thanks a lot in advance

Regards, Aruna

[Jeeva-Rathinam]

Multi Store Details : https://snag.gy/rGlAPY.jpg, csv details : https://snag.gy/ZNicAE.jpg, still not working, images not updated? what is my error?