Updating Product Codes Using Import Function

-- HikaShop version -- : 5.1.1 Biz
-- Joomla version -- : 4.4.9
-- PHP version -- : 8.2.25
-- Browser(s) name and version -- : Firefox
-- Error-message(debug-mod must be tuned on) -- : none

Greetings,

My client is redefining their part #'s. We have over 700 product codes to update including both main products and variants.

I'm attempting to use the product import function to perform these updates.

After some trial and error I've found a .csv file format that uploads without generating hikashop errors.

My latest iteration of .csv file format looks like this.....

product_id,product_parent_id,product_code,product_type
557,556,8511-BX,variant
558,556,8511-CS,variant
570,,690-159200201,main
581,,6400-SERIES,main
601,,TYPE-I-BARRICADE-SERIES,main
602,,TYPE-II-BARRICADE-SERIES,main
.....

It successfully uploads but leaves me with mixed results....

- some main products and variants update fine
- some update the product_code but also alter other fields.....descriptions, seo fields and others contents have disappeared, quantity has been changed to 0
- some products are updated in the database but no longer appear in the front end nor backend of the site.

got any ideas on what i;m doing wrong ?

your support is always appreciated,

Dave

Thanks nicholas for the quick response.

One question....

could the new method work if the two columns in my import file are product_id and the custom field instead of product_code and the custom field ?
would save me a bunch of work.

Thanks

Dave