Cannot import Variant stock levels

  • Posts: 46
  • Thank you received: 2
12 years 2 weeks ago #74730

Hi I have major issues for my shop which is in the final stages before it goes live.

I need to update the variant stock levels. Whenever I try to do this I get the error message

The product is of the type but it already exists in the database and is of the type variant. In order to avoid any problem the product insertion process has been skipped. Please correct its type before trying to reimport it.


and also

1 products found : 0 new products imported, 0 invalid product code, 1 already existing products

product_id product_quantity product_code
1085491 91 148757

I have tried importing with and without the product ID.

For the main products to populate the descriptions I simply used product_code and the product_description fields only and this worked fine.

I have attached the file with the entry.

File Attachment:

File Name: hikashopexport_62.csv
File Size:0 KB


If someone could please help.

Kind regards

Nav

Attachments:

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

  • Posts: 46
  • Thank you received: 2
12 years 2 weeks ago #74774

Hi I have update to the latest version with thanks to Nicolas as usual.

But I still have the same problem, see attached screenshot

Attachments:

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

  • Posts: 46
  • Thank you received: 2
12 years 2 weeks ago #74782

I think I found the answer

I had to put in the field product_type

product_type,product_code,product_quantity
variant,148757,91

Could this have been it?

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

  • Posts: 82868
  • Thank you received: 13378
  • MODERATOR
12 years 2 weeks ago #75634

Yes, the product_type column has to be specified for variants.

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

  • Posts: 250
  • Thank you received: 7
9 years 1 month ago #218438

Hi Nicolas,

Is this still the case? If so why?

I have the same problem, I want to import stock levels from another system which has no concept of variants - the product type field doesn't exist in the export. Is there away I can over ride this check which seems unnecessary. If the csv file has an SKU and stock level why does it matter whether it's a variant in Hikashop?

Thanks,

Ian

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

  • Posts: 82868
  • Thank you received: 13378
  • MODERATOR
9 years 1 month ago #218464

Hi,

That's because it's an import system to import new products (main products+variants) not an update system.
If you want to update variants with just the product_code and the product_quantity, it's possible with the mass actions system's CSV import filter.

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

Time to create page: 0.087 seconds
Powered by Kunena Forum