Bulk Upload product_code field

  • Posts: 20
  • Thank you received: 2
9 years 4 months ago #207963

-- 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.

  • Posts: 82863
  • Thank you received: 13372
  • MODERATOR
9 years 4 months ago #207973

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:

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.056 seconds
Powered by Kunena Forum