Fixing Duplicate SKUs, Barcodes and Titles

Ablestar Bulk Product Editor allows you to search for duplicate SKUs, barcodes or titles on your Shopify store.

After filtering and exporting products, we will upload a modified spreadsheet to make adjustments:

Step 1: Filter Products

1. Open the Bulk Product Editor app
2. Select Filters
3. Search "duplicate" and choose an option from the suggested list:
   1. Has Duplicate barcode
   2. Has Duplicate SKU
   3. Has Duplicate title
4. Select the Export button 

5. Once the 'Export Data' view appears, select Variant ID in the 'First column' dropdown. This will be the identifier column. (Learn more about product vs. variant-levels as first-column identifiers.)
6. You can leave all other items defaulted unless you have a preference
7. From the 'Variant Attributes' column, click See all to view all checkbox options and confirm these options are checked:

• SKU
• Option 1 Value
• Option 2 Value
• Option 3 Value

7. Click the Generate Spreadsheet button and the export will start processing.

8. Once the export is complete, click the Download button to save your own copy

Step 2: Modify and Upload Spreadsheet

Once you have downloaded the spreadsheet, you can view and then modify all products with duplicate SKUs

After the SKUs have been fixed, go back to the app dashboard and select Spreadsheet Edit from the menu options and upload your modified Excel or CSV file.

Once processed, you can confirm the mapped columns and data and then click the Run edit button.

✅ Tips and Troubleshooting

• Undoing bulk edits if you make any mistake is easy!
• Learn why we format the first column identifier on all spreadsheets.

(07.131)