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!
Hello Julius,
Is there a way to rename the SKU with CSV
Easiest would be to create an import and export template of the type CSVI PRO / Custom table and select the virtuemart_product table as table to export and import from. Only export the fields virtuemart_product_id and product_sku. Change the SKUs as needed and import this CSV file.
Kind regards,
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Log in to reply to this topic.