Categories
View Replies (1)

Resolved Duplicate entry for SKU

  1. Julius.Piwowar
    Julius.Piwowar
  2. RO CSVI
  3. Thursday, 24 September 2015
  4.  Subscribe via email
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!
0
Responses (1)
rolandd
rolandd
Accepted Answer Pending Moderation
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
  1. more than a month ago
  2. RO CSVI
  3. # 1
  • Page :
  • 1


There are no replies made for this post yet.
Be one of the first to reply to this post!