To mass edit existing SKUs and add new SKUs along with EAN codes, you can follow these steps using DataEase:
1. Export the Products:
-
In the DataEase app, go to the "Export" section.
-
Select "Products" and ensure you include "Inventory / Variants" in your export.
-
Apply any necessary filters to limit the number of products.
-
Press the "Export" button to start the export.
-
Download the exported file.
2. Edit the Exported File:
-
Open the exported file.
-
Locate the columns you need to update: ID, Handle, Variant ID, Variant SKU, and add a new column for Variant Barcode.
-
Update the Variant SKU with the new SKUs.
-
Add the EAN codes in the Variant Barcode column.
3. Prepare the File for Import:
-
Ensure you only keep the necessary columns: ID, Handle, Variant ID, Variant SKU, and Variant Barcode.
-
Save the file.
4. Import the Updated File:
-
Go back to the DataEase app and navigate to the "Import" section.
-
Upload the updated file.
-
The app will analyze the file and count how many products you are importing.
-
Press the "Import" button to start the import.
Here is an example of how your file should look:
ID*,Handle,Variant ID,Variant SKU,Variant Barcode*
1234567890,product-handle-1,9876543210,new-sku-1,ean-code-1
1234567891,product-handle-2,9876543211,new-sku-2,ean-code-2
1234567892,product-handle-3,9876543212,new-sku-3,ean-code-3