I'm having a little difficulty in importing a range of products with variants. My main issue is with the column 'product_code', as I need to set this correctly.
I'm about to import 3000+ items, and this is driving me a little insane.
Here's my csv file as it is.
product_code,product_id,product_parent_id,product_name,product_short_desc,product_description,product_quantity,product_dimension_unit,product_width,product_length,product_height,product_access,price_value ,price_currency_id ,categories,parent_category,product_published,images,related,options,Frame Number,Locking Options,Frame Size,Colours
27.12.75.00,27.12.75.00,,MTE 12H ,Holds 12 frames with 75mm spacing. Options of locking or non-locking with fixings and turning key.,Single Rod aluminium. Option of either open or locking with turning key. Holds 12 glasses. Distance between the frame holders 75mm.,-1,mm,1060,170,190,all,67.90,4,Single Rods/Mini Tubix,Mini Tubix,1,4,,,,Non-locking,,
27.12.75.05,27.12.75.05,27.12.75.00,MTE 12H ,Holds 12 frames with 75mm spacing. Options of locking or non-locking with fixings and turning key.,Single Rod aluminium. Option of either open or locking with turning key. Holds 12 glasses. Distance between the frame holders 75mm.,-1,mm,1060,170,190,all,111.80,4,Single Rods/Mini Tubix,Mini Tubix,1,4,,,,locking,,
My issue is this:
The main product will have a product_code of : 27.12.75.00, and the variant is the locking version, with 27.12.75.05. All good so far. But... The main product and first variant are the same product and theoretically the same product code. At the moment, the import adds both items, but only shows the locking version, with the non-locking imported but not available.
I found an example which I've tried to follow:
product_code,product_parent_id,color,size
prod1,,blue,10
prod1_1,prod1,blue,10
prod1_2,prod1,red,10
In my case, prod1 and prod1_1 are the same item, and need the same code. This is already defined in a published catalogue, so cannot accept alternatives.
If I'm doing anything wrong, I'll certainly experiment. I'm also using the latest version of hikashop.