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

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

MMP58
Tourist
4 0 2

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:

HandletitleSKUcustom/variant 
product_1Product 1 - YamahaPROD001x 
product_2Product 2 - HondaPROD002x 
product_3Product 3 - KawasakiPROD003x 

 

Second upload:

HandletitleSKUcustom/variant 
grouped_productGrouped Product   
grouped_product PROD001Yamaha 
grouped_product PROD002Honda 
grouped_product PROD003Kawasaki 


Will it recognise the SKU and change the title/handle accordingly???


Am i missing something?

Reply 1 (1)

AutomyzeInvPlan
Shopify Partner
11 1 0

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:

 

HandleTitleOption1 NameOption1 ValueSKU
grouped_productGrouped ProductModelYamahaPROD001
grouped_productGrouped ProductModelHondaPROD002
grouped_productGrouped ProductModelKawasakiPROD003
Founder | Automyze Inventory Planning
Automyze Inventory Planning: Forecasting, reorder insights, OTB plans, reports, & analytics