To update existing SKUs and Barcodes for variants in products that are already created, you will need to identify the variants correctly. Here are the steps and columns you need:
1. Export the current product data to get the necessary identifiers:
-
Export Products with Basic Columns and Inventory/Variants.
-
Ensure you include Variant ID and Variant SKU in the export.
2. Prepare your import file with the following columns:
-
ID or Handle (to identify the product)
-
Variant ID (to identify the specific variant)
-
Variant SKU (to update the SKU)
-
Variant Barcode (to update the Barcode)
Here is an example of how your import file should look:
ID,Handle,Variant ID,Variant SKU,Variant Barcode
1234567890,product-handle-1,9876543210,new-sku-1,new-barcode-1
1234567890,product-handle-1,9876543211,new-sku-2,new-barcode-2