Can you please let me know what the correct format is for importing a product with two variants, for example color and size ?
I've tried including options1name and options2Name on the same line for a product but get errors when importing.
Then i tried on separate lines and still got errors
Thanks for your help
|Handle||Title||Body (HTML)||Vendor||Type||Tags||Published||Option1Name||Option1Value||Option2Name||Option2Value||Option3Name||Option3 Value||Variant SKU||Variant Grams||Variant Inventory Tracker||Variant Inventory Qty||Variant Inventory Policy||Variant Fulfillment Service|
<h2 TABLE LAMP</h2>
When creating a product that has more than one variant option, then you'll need to ensure that each possible variation is created. This means that if you have White, then you need to have a line for white/small and white/large as the system won't automatically assume that each option has a specific size associated to it.
Hope that helps!
If your CSV file doesn't have any "handle", you can try the Moose Sync app to import your products and schedule some automatic updates.
By default, if the handle is missing, it will "fill" it with the Product title data. If you don't have any product title either, well that's bad from a customer-experience point of view, but still, Moose Sync can make it work by filling the Product title with the content from one or more other "columns" (csv field). For example, using a "virtual field", you can aggregate 2 fields, let's say "SKU" and "ShortDescription" into one single field (Product title) and import your data smoothly in your Shopify store.
Our help doc here dives into the steps on how to add multiple images to your CSV file for each product. If you have any issues getting that setup, let me know!
I am facing a similar issue, have to upload hundred but not succesfull for 5 also.
Please help solve below error:
|Handle||Title||Body (HTML)||Vendor||Type||Tags||Published||Option 1||Option 1 Value||Option 2||Option 2 Value||Option 3||Option 3 Value||Variant SKU||Variant Grams|
|Brass Figurine||PAGADI GANESHA||Premium Brass Ganesha||Mantra||Figurine||God figurine||TRUE||Colour||Brass Copper||Size||19"||Warranty||2 year||20000|
|Brass Figurine||Premium Brass Ganesha||Mantra||Figurine||God figurine||TRUE||Colour|
|Brass Figurine||LAKSHMI||Premium Brass Figurine||Mantra||Figurine||God figurine||TRUE||Colour||Micro Gold Coating||Size||3.25"||Warranty||5 Years||270|
|Brass Figurine||GOMATHA||Blessing of Holy Cow||Mantra||Figurine||figurine||TRUE||Colour|
|Brass Figurine||GOMATHA||Blessing of Holy Cow||Mantra||Figurine||figurine||TRUE||Colour||Brass Copper||Size||2.75||Warranty||2 year||420|
All of your handles are the same, but you have multiple titles that indicate these are separate products. You would need to update the handles if they are separate products, or remove the titles except for the first one and try again.
I have been trying everything suggested on this forum but still have this same problem.Validation failed: The variant 'Default Title' already exist.
Can you check my csv file
As you're using the additional fields for images, and not variants, the CSV file is confusing the system by having values in the following columns:
Removing the values that appear in each of the columns for rows 3-5, 7-9, and 11-13 will result in a successful import. A few things to note about your CSV file:
Let me know if you run into any issues!