All things Shopify and commerce
Hi everybody!
I have round 10.000 items/SKU's that i need to upload to my shop.
Many of them are related SKU's from same product series, but with unique SKU's for each item, hence fitting different applications (motorcycle parts)
i am looking to do this in steps:
1: upload every SKU as a unique product
2: start grouping similar products into variants by placing SKU's at same handle and title in CSV upload
is this possible???
First upload:
Handle | title | SKU | custom/variant | |
product_1 | Product 1 - Yamaha | PROD001 | x | |
product_2 | Product 2 - Honda | PROD002 | x | |
product_3 | Product 3 - Kawasaki | PROD003 | x |
Second upload:
Handle | title | SKU | custom/variant | |
grouped_product | Grouped Product | |||
grouped_product | PROD001 | Yamaha | ||
grouped_product | PROD002 | Honda | ||
grouped_product | PROD003 | Kawasaki |
Will it recognise the SKU and change the title/handle accordingly???
Am i missing something?
If you change the handle in a CSV upload for a product that has the same SKU, Shopify will treat it as a new product rather than overwriting the existing one. This is because Shopify uses the handle as the primary identifier for products - not the SKU - so SKU "PROD001" would exist for both "grouped_product" and "product_1" if you uploaded it twice.
I may be misinterpreting, but if each of the SKUs you upload should only exist for 1 variant and be associated with 1 product, you could upload the products in 1 step rather than 2. You would use the same handle and title for all SKUs related to a product and define their variant-specific details (e.g., model, SKU) in separate rows. Below is an example:
Handle | Title | Option1 Name | Option1 Value | SKU |
grouped_product | Grouped Product | Model | Yamaha | PROD001 |
grouped_product | Grouped Product | Model | Honda | PROD002 |
grouped_product | Grouped Product | Model | Kawasaki | PROD003 |
2m ago Learn the essential skills to navigate the Shopify admin with confidence. T...
By Shopify Feb 12, 2025Learn how to expand your operations internationally with Shopify Academy’s learning path...
By Shopify Feb 4, 2025Hey Community, happy February! Looking back to January, we kicked off the year with 8....
By JasonH Feb 3, 2025