Updating/re-grouping products at SKU level - by CSV??

Shopify Discussion

Topic summary

A user needs to upload ~10,000 motorcycle part SKUs to Shopify and wants to initially upload each as a separate product, then later group related SKUs as variants under shared product handles.

Key Issue:
Shopify identifies products by handle, not SKU. Changing a handle in a second CSV upload creates a new product rather than updating the existing one, resulting in duplicate SKUs across different products.

Recommended Solution:
Upload products with variants in a single step instead of two:

  • Use the same handle and title for all related SKUs
  • Define variant-specific details (model, SKU) in separate rows
  • Use Option columns (e.g., “Option1 Name: Model”, “Option1 Value: Yamaha/Honda/Kawasaki”) to differentiate variants

Status:
The two-step approach as originally proposed won’t work due to how Shopify handles product identification. The discussion suggests a one-step variant upload method as the viable alternative.

Summarized with AI on November 1. AI used: claude-sonnet-4-5-20250929.
1

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?

2

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