Change existing SKU product in CSV bulk
-
Hi,
How do i update the SKU product using the parent ID? I refer to this : https://github.com/woocommerce/woocommerce/wiki/Product-CSV-Import-Schema#csv-columns-and-formatting and this : https://docs.woocommerce.com/document/product-csv-importer-exporter/#prettyPhoto, but no look, still not found.
I have Variation products
Shoes Black Pro – = parent name
Shoes Black Pro – Light = variation (variable value color)
Shoes Black Pro – Dark = variation (variable value color)Now, the i want to change/replace these = variation (variable value color)’s SKU to new one but failed
The page I need help with: [log in to see the link]
-
Hi there,
If your aim is to only update the SKUs of your variations, then here is a minimalist CSV layout that will help you achieve just that, using the parent’s ID in the Parent column:
Note that because you’re changing the SKUs of the variations, you’ll need the ID column to correctly match them to your database. The numbers shown are the variation/variable IDs on my sandbox site, which is where I exported the CSV from before editing it.
And when you import the CSV, remember to check the “Update Existing Products” checkbox too.
- The topic ‘Change existing SKU product in CSV bulk’ is closed to new replies.
