0

I need to remove some products from a single website, but I need to do it through CSV. I saw this question but it isn't what I need, since I have only read access to the Magento database for my store, so I need to do this through CSV import.

In our Magento2, we have 2 stores/websites at present. I want to erase the products from the 'base'/'default' website, while leaving them intact from the other website.

I tried two CSVs, for a single configurable product and its associated simple products, in our staging/testing environment. I import the CSVs at System > Data Transfer > Import > Products > Delete.

I first tried with a CSV that had this structure, specifying product_websites and store_view_code:

sku,url_key,product_websites,store_view_code
sku_to_delete,url_of_product,base,default

And it did nothing (similar to the results in this question).

Then I tried with a CSV with the following structure, specifying only product_websites:

sku,url_key,product_websites
sku_to_delete,url_of_product,base

And the product was fully deleted from Magento, all websites.

The links above were the closest I could find to solutions I needed, but they didn't exactly address/solve this issue. So, is there a way to effectively remove a product from one website (which happens to be the 'base' website) through CSV data import?

Thank you in advance!!

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.