Delete multiple products/combinations by using a csv

Delete multiple products/combinations by using a csv

Sep 14, 2018
pillepalle12 wrote
I look for a way to delete combinations and/or products that are listet in a csv. I hope it's possible with Store Manger.

So a have more than 7000 producst in my shop and a lot of mainproducts and combinations are not longer availible.
All these products are listet in one csv. Some of them are single products and some of them are combination.
Some combination also using the reference from the main product.

e.g.

Main product is
111112
Combinations are
111112 - Small
111113 - Medium
111114 - Large

Combiantion 111112 - Small is no longer avalible, but Medium and Large are still there.
So is there a way to delete these Combinations and also single products from a csv?
I ask because i have to delete more than 2000 products/combiantions and it will be take a lot of time to make this for each product by search and select them.

My CSV looks like this

Ref
111112 (main- and combi product)
111113
222222 (main product)

Reply
10 Answers
Sep 16, 2018
pillepalle12 wrote
So no answer in 2 days? I guess there is no way to delete multiple Items (combination and/or main proucts) with a csv? :(
Sep 17, 2018
pillepalle12 wrote
To bad. I thought the Store Manager was a good tool to manage my prestashop, but if i have to select a product manually one by one to delete specific combinations or products than i don't need it, because it's the same way i can do in prestashop.
Why is there NO WAY to do it with a csv or xml?
Avatar image
Sep 17, 2018
Olha Berestetka agent wrote
Hello!

thank you for contacting us via forum.
Store manager does not have option to delete products that are in import file.
Though it has option to assign them to certain category with import.
After import, you can simply delete whole category with all its products.

If you have some additional questions please contact us also by email: contact@emagicone.com

Thank you and have a good day!
Sep 17, 2018
pillepalle12 wrote
Hi Inna
thanks for the answer.

The suggested methode will well work for a product, But how can i do that for combination.
In my case by example i have a product and it has 4 combination (small, medium, large and xl). So if large and small are no longer availible i usually delete these 2 combination. The other two combination are still there. So i guess there is no way to assign these combination to a ne cat two?
I guess the only way is to re-assign the deleted combination to a now product that not really exist and put them then to a new cat?
So if that will work is my next question if i can assign combination to a new product?
Sep 19, 2018
pillepalle12 wrote
I have handled to delete combinations by making a php script. I wonder why such a function isn't implented into Prestashop or any Manager yet.
Avatar image
Sep 22, 2018
Andrii Yanosh agent wrote
Hello pillepalle12,

This feature will be considered as the improvement in further versions of Store Manager.
Jan 22 (7 months ago)
Noel Samos wrote
it is very important to remove joins when they are no longer available and it would be nice if they implement a solution SOON
Jan 22 (7 months ago)
Noel Samos wrote
*it is very important to remove combinations when they are no longer available and it would be nice if they implement a solution.
Avatar image
Feb 17 (6 months ago)
Nadia Bezpalko agent wrote
There has been already added the option to delete or set q-ty to 0 for products and combinations that are not listed in csv https://prnt.sc/zusn0y
Feb 24 (6 months ago)
System wrote
Hello,

We haven't heard back from you for last 7 days, please confirm that all questions were answered and issues are resolved. In case you haven't received an answer, please check your spam folder or check the status of ticket online at:
https://support.emagicone.com

Maybe we are waiting for some information from your side? In this case please get back to us.

In case we haven't replied you back or in case of any misunderstanding, please reply to this mail with all details so we could proceed.

If you do not reply us back, the ticket will be automatically closed within 24 hours.

With kind regards,

The eMagicOne Administration Team