None of my products have SKUs. I am wanting to start implementing an inventory system but I need SKUs in order to do that. What is the best way to generate SKUs for all of my products?
You may use Flow to assign SKUs to your products automatically.
Say you can simply use something like variant.id which is a random number generated by Shopify and assign these as SKUs.
But better to get some meaningful data in SKU, It’s a good idea to have some kind of a system with your SKUs.
First, Marketplace you can find Apps generating SKU’s.
Second, You can follow simple steps as below:
- Login, Goto Products
- Click on Product
- Scroll down to Inventory and click on “SKU”
- Enter a unique identifier for the product
- Repeat the process for remaining products
Third, option is export data, fill the SKU column and import the CSV
Hi,
If you have thousands of products and their multiple variants, creating SKU for each variant will not be easy. This can be done easily with script using Shopify GraphQL API to update SKU for each variant.
Here is the flow to assign SKUs to product which have none:
“get product variant data” action should be configured as per this post
- use “get product variants data” action
- use query
sku:""- set sort order to “SKU” – important.
The flow sets SKU to “test-XXX” where XXX is the variant legacy id.
Obviously, can be replaced with something more meaningful.