Bulk Upload product_code field

air-diensten
Topic Author
Offline

11 years 2 months ago #207963 by air-diensten

Bulk Upload product_code field was created by air-diensten

-- HikaShop version -- : HikaShop Business 2.5.0
-- Joomla version -- : 3.4.3
-- PHP version -- : 5.5.44
-- Browser(s) name and version -- : all

Due to a update by my supplier on product code I have want to create a bulk upload to update the product_code field in Hikashop.

When i create a bulk upload file with the product_id and product_code Hikashop creates a new product.

How can by bulk upload (300+ items) to update the product_code field?

The Product Code is necesery for my for stock and licencing perposes. Is there a handy way beside SQL update (im not that handy with SQL queries)

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

nicolas
Away

11 years 2 months ago #207973 by nicolas

Replied by nicolas on topic Bulk Upload product_code field

Hi,

The import bases itself on the product_code so it's not meant to update the product_code value of the products. You'll have to do it with a MySQL query.
Here is an example:

Code:

INSERT INTO #__hikashop_product (product_id,product_code) VALUES 
(1,'new_code1'),
(2,'new_code2'),
...etc...
(29999,'new_code29999')
  ON DUPLICATE KEY UPDATE product_code=VALUES(product_code);

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

Time to create page: 0.173 seconds