Delete all products before import CSV

  • Posts: 147
  • Thank you received: 6
9 years 7 months ago #196288

-- HikaShop version -- : 2.3.5

Hi,
What is the best way to delete all products?
I mean, we have thousands of products so going through the administrator, select and delete is not an option.

We usually import the products via CSV. Sometimes I move products from one category to the other, or a variant that was listed and a parent to another parent. And then I get the message saying the product already exist. Even if I delete it from the CSV.

Ideally when I import my CSV there would be an option to remove the product there doesn't exist in the CSV and only import the ones that are there.

I tried creating a mass action to delete the products but I had no lucky.
If this is the best way could you walk me through? or send a mass action file that deletes all products?

Thanks

Please Log in or Create an account to join the conversation.

  • Posts: 13201
  • Thank you received: 2322
9 years 7 months ago #196290

Hi,

Yes the mass actions seems to be the best way to delete all the products.
But as you have thousands of products you can't run only one action to delete them all.

We recommend to not have more that 500 elements in a query.
So in your case you have to set the limit on 0 > 500 and process the mass action until all the products have been deleted.

The delete function of the mass action only call the delete function of the product class in HikaShop with the desired ids.

Please Log in or Create an account to join the conversation.

Time to create page: 0.068 seconds
Powered by Kunena Forum