Prevent Duplicate SKUs

Tourist
6 0 11

Is there a setting within Shopify to prevent or disallow duplicate SKU numbers? I want to make sure I don't use the same SKU number across multiple products or variants, but right now there is no easy way to see if a SKU is already in use. It would be great is Shopify prevented me from saving a product until I changed the SKU to something unique.

Does this exist???

1 Like
Shopify Staff
Shopify Staff
283 0 45

Hi Mary,

I wish I could advise on a way to enable this type of restriction on Shopify, but there is not. We can try exporting a CSV file of all your products, isolating the SKU column, and try to find matches using one of these guides:

Essentially, you would use formulas in spreadsheet editors to see if the data appears more than once. That is the only workaround I can think of, I hope that helps.

Hugh

Happy selling! :)
0 Likes
Shopify Partner
5 0 8

How is this not a standard feature for Shopify? Unique SKU's are essential for inventory management solutions to work properly (i.e. barcode scanning, reporting, shipping/receiving, etc...). Can you please add this in as a Shopify feature request? Once the product has been created with duplicate SKU's, the damage is already done. Correcting it is possible, but there could already be issues with reporting in our inventory or shipping systems...

2 Likes
New Member
1 0 1

@IncredibleHabit wrote:

How is this not a standard feature for Shopify? Unique SKU's are essential for inventory management solutions to work properly (i.e. barcode scanning, reporting, shipping/receiving, etc...). Can you please add this in as a Shopify feature request? Once the product has been created with duplicate SKU's, the damage is already done. Correcting it is possible, but there could already be issues with reporting in our inventory or shipping systems...



Agreed.  One of the reason of having a SKU is to prevent duplications.  It should be a pretty basic function.

1 Like

Just resurrecting this to see if anyone has found an easy way to find duplicate barcodes or skus inside shopify variants & Products.

1 year e-commerce, 7 years B&M store. www.shopbraeheid.com
0 Likes
New Member
2 0 0

You would think someone would have created an app for that if Shopify is not interested in helping us out.

0 Likes
Explorer
65 0 22

http://trunkinventory.com can email you if duplicate SKUs are found

How Trunk works is it builds its own centralized inventory from your Shopify listings. If it finds a duplicate SKU, it will notify you 👍

⚡Sync inventory + bundles/kitting in real-time between Shopify, Amazon, eBay, Etsy, Faire, Squarespace, Square with Trunk @ trunkinventory.com
0 Likes
Shopify Partner
172 25 43

Realise this is a bit of an old thread but we have the same issue. I have found two apps that look like they may do the trick, just thought i'd post to help anyone else out with same issue.

 

https://apps.shopify.com/quality-product-data-watch?surface_detail=pump&surface_inter_position=1&sur...

 

https://apps.shopify.com/sku-generator-1?surface_detail=sku&surface_inter_position=1&surface_intra_p...

 

Not tried either of them yet, so will update if I do.

If helpful then please Like and Accept Solution
0 Likes
New Member
1 0 0

Hello,

 

If you really want to make sure you don't have Dups you have two options.

 

A - Take the Manf. SKU and add a prefix. If you look at all the Big Box Stores, they all do this. This is due to manufacturers having the same SKUs. In which case you would have the same situation your in. 

 

B - Use the bar-code as your SKU.

0 Likes
Excursionist
12 0 8

Yet another basic functionality that should be part of Shopify without needing to turn to a third party app. Any news on this, ?

0 Likes