VM: 3
joomla 3.4
CSVI Pro
Hey When exporting my product details into a table in excel I realized I have used duplicate values for SKU (e.g. 10 Porducts with the same SKU). Is there a way to rename the SKU with CSV. Just replacing the SKU by a new value did not work.
Duplicate entry '198' for key 'PRIMARY' SQL=UPDATE `aw2hd_virtuemart_products` SET `virtuemart_product_id`='198',`virtuemart_vendor_id`='1',`product_parent_id`='0',`product_gtin`='',`product_mpn`='',`product_weight`='0.5000',`product_weight_uom`='KG',`product_length`='98.0000',`product_width`='60.0000',`product_height`='118.0000',`product_lwh_uom`='CM',`product_url`='',`product_in_stock`='8',`product_ordered`='0',`low_stock_notification`='0',`product_available_date`='2014-04-27 00:00:00',`product_availability`='on-order.gif',`product_special`='0',`product_sales`='0',`product_unit`='KG',`product_packaging`='1.0000',`product_params`='min_order_level=\"0\"|max_order_level=\"0\"|step_order_level=\"\"|product_box=\"0\"|',`intnotes`='',`metarobot`='',`metaauthor`='',`layout`='0',`published`='1',`pordering`='0',`created_on`='2015-08-19 12:47:43',`created_by`='982',`modified_on`='2015-09-24 08:29:44',`modified_by`='982',`locked_on`='0000-00-00 00:00:00',`locked_by`='0' WHERE `product_sku`='14135-0027'
Thanks a lot!
- Julius.Piwowar
- RO CSVI
- Thursday, 24 September 2015
- Subscribe via email
- Page :
- 1
There are no replies made for this post yet.
Be one of the first to reply to this post!
Be one of the first to reply to this post!