Categories
View Replies (2)

Resolved Changing SKU numbers via CSV

  1. WhiteCastlePtyLtdAdmin1
    WhiteCastlePtyLtdAdmin1
  2. RO CSVI
  3. Sunday, 20 March 2016
  4.  Subscribe via email
Joomla 3.4.8
Virtuemart 3.0.14
CSVI 6.5.4
A supplier has changed all their SKU numbers. Is there a method to update SKUs from the old number to the new number with CSV?
0
Responses (2)
rolandd
rolandd
Accepted Answer Pending Moderation
Hello,

You can change the SKUs and there are 2 options. First you can use another field as unique identifier. In the VirtueMart import template you have the option to set another field that CSVI uses as unique identifier, by default this is the product_sku. This is only possible if you have another field that also has a unique value for every product. Second, this is probably the most likely one to use. You can create a custom table import/export. Create an export template of the type CSVI Custom and select the table virtuemart_products on the Options tab. Add the fields virtuemart_product_id and product_sku. Export these two fields and you can change the SKU in this file. Then create an import template of the type CSVI Custom and select the table virtuemart_products on the Options tab. Add the fields virtuemart_product_id and product_sku. Import the file where you changed the SKUs and you can update the SKUs that way.
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
WhiteCastlePtyLtdAdmin1
WhiteCastlePtyLtdAdmin1
Accepted Answer Pending Moderation
Thanks for response.
I used solution 2. Solved.
  1. more than a month ago
  2. RO CSVI
  3. # 2
  • Page :
  • 1


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