The problem of trash type products when importing

  • Posts: 112
  • Thank you received: 5
2 weeks 1 day ago #361941

-- HikaShop version -- : 5.0.4
-- Joomla version -- : 5.1
-- PHP version -- : 8.2
-- Error-message(debug-mod must be tuned on) -- : The product Cable Watch 1m (USB) /-MX2E2-/ is of the type main but it already exists in the database and is of the type trash. In order to avoid any problem the product insertion process has been skipped. Please correct its type before trying to reimport it.

Hi
I wanted to update the products from the previous site to the new site through the csv file. But it displayed the following message:

The product Cable Watch 1m (USB) /-MX2E2-/ is of the type main but it already exists in the database and is of the type trash. In order to avoid any problem the product insertion process has been skipped. Please correct its type before trying to reimport it.

It seems that during multiple updates, you didn't consider trash type products when importing products.

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

  • Posts: 82095
  • Thank you received: 13195
  • MODERATOR
2 weeks 1 day ago #361942

Hi,

No, we did consider it and that's why you get that message.
The product you're trying to import either has the type "product" in the column "product_type" of your CSV, or you don't have a column "product_type" in your CSV. And in your database you have a product with the exact same product_code in the trash (with the product_type "trash"). So either you need to clear your trash (go in the products listing, click on the "trash" button, and then the "clear" button if your want to remove all the products in the trash), or you want to set the product_type to "trash" for that product in your CSV so that the import can update the product in the trash. Then, you can import again the CSV file and it will work.

The following user(s) said Thank You: levelup

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

Time to create page: 0.070 seconds
Powered by Kunena Forum