thread Re: Entering items with variations in Archived Discussions (Read Only)

How to import items with price variations?

RCP — Sun, 07 Apr 2019 19:05:26 GMT

We are a community theatre that only sells show tickets. Each item is a show night and there are 3 variations based on age with 3 price point. How can this be added to the CSV spreadsheet so that they are all uploaded together?

Re: How to import items with price variations

RHatch — Fri, 16 Aug 2019 15:31:37 GMT

Here is how part of you csv file should look. Your Item name, description is the same - the Variation name is different.

Item Name	Description	Category	SKU	Variation Name	Price
Widget Name	Widget Description (Just put it in the first item line)	Drinks	45529590045 (Must all be different)	Blue Raspberry Lemonade	3
Widget Name		Drinks	45529590014	Fruit Punch	3
Widget Name		Drinks	45429589965	Orange Blast	3
Widget Name		Drinks	45529589858	Watermelon	3

How do I add sizes of items during mass import?

FAB-STYLE — Wed, 11 Apr 2018 17:47:20 GMT

This reply created from merging an existing thread: "How do I add sizes of items during mass import?" The author has been notified via email.

I have downloaded the square import doc and am filling it out. I have several hundred SKUS to import so I am needing to mass import. It is clothing so we have 3-4 sizes of each sku. I have tried to upload the template by filling out the Variables column like this: Small, Medium, Large however this did not work. Without having to create a seperate line item for every size, what is the easiest and fastes way of doing this usng the Template and mass import option?

How to import variations with excel instead of it creating another item

rmcubam — Wed, 11 Apr 2018 03:21:44 GMT

When I created inventory using the template, it added each variation as another item instead of being under 1 item. How do I fix this?

Re: How to import variations with excel instead of it creating another item

puka — Wed, 11 Apr 2018 22:45:10 GMT

Hey @rmcubam - I've merged your post with a thread on a similar topic. @RHatch's response might help clarify how your CSV file should look in order for it to import correctly. If it looks as described, but you're still having issues, let us know!

Re: How to import variations with excel instead of it creating another item

eaglefangear — Mon, 22 Oct 2018 14:43:08 GMT

is there an answer to this posted somewhere

Re: How to import variations with excel instead of it creating another item

Helen — Tue, 23 Oct 2018 18:02:03 GMT

Hey @eaglefangear! This post above has an picture of how your CSV file should look if you're importing items with variations.

For step-by-step instrucions to import items using the CSV template you can review this Support Center article: Import Items Online.

If you have any quesitons reply here to let me know!

Is there a way to bulk-upload Item Variants or Price Points to Square?

OnwardUP — Thu, 04 Apr 2019 17:23:44 GMT

I'm uploading hundreds of products and they all have applicable Item Variants. Can I upload these as part of the Item Upload, or so they each have to be edited individually?

Re: Is there a way to bulk-upload Item Variants or Price Points to Square?

Helen — Sun, 07 Apr 2019 19:05:56 GMT

Hi @OnwardUP! Yes you can use the bulk import tool (choose Modify Item Library) to update existing items.

This Support Center article has step-by-step instructions: Upload Your Item Library, and this Community post might help to: How to import items with price variations?

importing Items

siralec — Fri, 16 Aug 2019 15:36:17 GMT

This reply was created from merging an existing thread: importing Items

Importing multiple Items with each item to have 2 variations with it's own SKU. When I hit to import items it does not give me the option to put the second SKU for the other variation. What can I do?

Re: importing Items

Helen — Fri, 16 Aug 2019 15:35:11 GMT

Hello @siralec! You should be able to add a second SKU to your exported item library CSV file. This thread has a bit more information about importing items with variations and SKUs. I hope it helps but reply here if you're still having trouble!

Entering items with variations

islandpainter — Fri, 06 Nov 2020 06:12:36 GMT

I had been entering an original painting, and then as variations I entered different size prints with their own SKU numbers. THat worked fine. But now I no longer see variations, I only see Options and Modifiers. Options doesn't work for this for me.

Re: Entering items with variations

Goldneye — Fri, 06 Nov 2020 14:41:49 GMT

HI, yes there was change in the Add Item page. The Options and pricing IS the variations. Once you input your information, it will appear as the old Variations.

Hope this helps!

Terri

🛍 Shop my store

Resale Collection - http://bit.ly/HangerHues