One common issue eCommerce sellers face is duplicate SKUs (Stock Keeping Units) appearing in their inventory, which can cause syncing errors across platforms --this is mostly common to Shopify sellers. In this article, we’ll guide you step-by-step on how to resolve this issue:
Step 1: Identify Duplicate SKUs in Shopify
- Log into Shopify: Navigate to your Shopify admin panel.
- Go to Products > Inventory: This section displays all your products along with their SKUs.
- Search for Duplicates: Look for repeated SKUs in the list or use Shopify’s search bar to locate specific items.
Step 2: Bulk Edit SKUs in Shopify
-
Select All Products:
- Use Shopify’s bulk edit feature to modify multiple products at once.
- Click on “Bulk Edit” after selecting all products.
-
Remove Existing SKUs:
- In the bulk edit table, clear the current SKUs column for all selected products.
- This step removes the duplicates and prepares your inventory for a clean synchronization.
-
Save Changes:
- Confirm your edits and save changes to the inventory list.
Step 3: Sync Products with QuickSync
-
Access QuickSync Dashboard:
- Log into your QuickSync account and go to the dashboard.
-
Enable Sync Options:
- Select the Sync Products button.
- Check the boxes for Create Products and Create SKUs.
These settings ensure that any missing products are recreated. Unique SKUs are automatically assigned during the sync process.
-
Run the Sync Process:
- Click on the “Start Syncing” button.
- Allow a few moments for QuickSync to process the data.
- Once complete, your inventory will have unique, clean SKUs.
Step 4: Verify the Sync Results
-
Confirm that all SKUs are now unique.
Handling duplicate SKUs doesn’t have to be a headache. By following these steps, you’ll save time, reduce errors, and create a seamless experience for your customers across platforms.