thread Re: Do I have to use Square template to import items? in Archived Discussions (Read Only)

Do I have to use Square template to import items?

mrsblastfmr — Fri, 09 Mar 2018 01:47:45 GMT

I need to set up my item library. Do I have to download the Square template, fill it out and upload it, or if I already have a csv file with the item info, can I just upload that? I'm not very techy. I am hoping to avoid having to manually fill in every item on the Square import template, and was hoping to be able to use a pre-existing spreadsheet of items (if I can get my hands on one) to save time and trouble.

Thanks!

Re: Do I have to use Square template to import items?

Sean — Wed, 03 Jul 2019 14:18:30 GMT

@mrsblastfmr - Welcome to the Seller Community!

Yes you do need to use our template. We don't currently support alternate spreadsheets. Also, you'll want to make sure you don't delete rows or columns from the template.

Hope this helps!

Re: Do I have to use Square template to import items?

mrsblastfmr — Fri, 06 Jan 2017 05:02:02 GMT

Thanks Sean!

Re: Do I have to use Square template to import items?

mrsblastfmr — Fri, 14 Apr 2017 08:42:01 GMT

Hi Sean. Finally getting around to filling out the import template. Is there a document with descriptions for each of the fields that you can share with me? I want to make sure I'm filling it all out correctly. For example, I understand what Current Quantity means, and I assume the New Quantity is what I want to carry. But what is Stock Alert Enabled for Stock Alert Count? The SKU number - if the items I have don't actually have a SKU, can that be just any identifying number I choose to use? What is Token? Variation Name - would that be where I enter sizes maybe, if I have a product in multiple sizes?

Thanks so much!

Re: Do I have to use Square template to import items?

mrsblastfmr — Fri, 14 Apr 2017 08:47:56 GMT

Two more questions. In the Price column, do I need to add $ to each price or will that be done automatically during import? Last, In the Tax column, is that a Yes or No field, or Y or N?? I just want to do this one time, so I need to get it right.

Re: Do I have to use Square template to import items?

Tom — Fri, 14 Apr 2017 19:25:36 GMT

Hey @mrsblastfmr, thanks for circling back!

Jumping in for Sean here — you can find a chart of the CSV field descriptions and additional details on what they refer to in our Support Center.

Sounds like you're right on track — you don't need to add "$" to your price and a simple "Y or N" will do for the Tax column. 🙂

Hope this helps get you in the right direction. Please let us know if anything else comes up!

Re: Do I have to use Square template to import items?

mrsblastfmr — Mon, 17 Apr 2017 05:40:51 GMT

Hi Tom. I reviewed the chart and it's very helpful, thank you. I do have one question still. Even after reading the descriptions, I don't understand what the difference is between Current Quantity and New Quantity:

Current Quantity [Your Location Name]	Numeric. If you are using Inventory Management this is the current quantity of this item defined as in stock. Changes to this field are ignored on import.
New Quantity [Your Location Name]	Numeric. If you are using Inventory Management, enter your current stock count here. This count will replace any existing stock count.

Re: Do I have to use Square template to import items?

mrsblastfmr — Mon, 17 Apr 2017 05:46:56 GMT

Sorry, one more question. In Variation Name, is that where I would enter the different sizes of product I carry? For example, Pomegranate Cleanser, I carry 6.5 oz and 16 oz. So I would enter the Name and Description in the corresponding fields, but then the size in the Variation Name field? Thanks!

Re: Do I have to use Square template to import items?

Spenser — Mon, 17 Apr 2017 18:24:05 GMT

Yep, @mrsblastfmr, the variation name is usually the second descriptor of the item. For example your Item would be "Shirt" and variations would be "Small, Medium, Large." Does that make sense?

Re: Do I have to use Square template to import items?

mrsblastfmr — Mon, 17 Apr 2017 19:14:45 GMT

Thanks Spenser, that does make sense!

Any input on my prior question regarding Current Quantity vs New Quantity?

Re: Do I have to use Square template to import items?

Spenser — Mon, 17 Apr 2017 21:00:37 GMT

Oops, missed that part! Those are two fields on the import/export sheet. When you export, you'll be given Current Quantity at the time of export. If you need to update your item count, you'd use the New Quantity field to do so when importing the file back. Does that help?

Re: Do I have to use Square template to import items?

mrsblastfmr — Tue, 18 Apr 2017 00:56:52 GMT

Ohhhh! Ok! So if I'm setting up my initial inventory, I will use the Current Quantity field and leave the New Quantity field blank. Then in the future when I'm making updates, I will use the New Quantity field.

Thanks so much Spenser!

Re: Do I have to use Square template to import items?

TSK — Sat, 07 Oct 2017 18:38:08 GMT

Adding another question to the template question. Is there an easy way to add item cost using the template? Or do I have to go back in later and update costs for all my items?

Re: Do I have to use Square template to import items?

Helen — Tue, 10 Oct 2017 17:54:31 GMT

@TSK You can use the template to enter a price for each of your items! When you download the template look for the Price column. This is where you can edit the cost of your items before importing the template back to the Dashboard.

If you haven't set a price for an item yet you can enter $0.00 or leave the field blank. For any items with a variable price, type Variable in the price column.

Re: Do I have to use Square template to import items?

Shopthestream — Thu, 01 Mar 2018 04:10:48 GMT

Jumping in here, as I am setting up my inventory for the first time as well. For the variation column, if I carry the same item in sizes XS-XL, would I then need to create a row for each size? So on my spredasheet I would have 5 rows for one shirt to represent each size variation?

If so, will all of these sizes be grouped together under 1 item in the sqaure dashboard or will there be multiple listing for one item?

Many thanks,

Mercedes

Re: Do I have to use Square template to import items?

Helen — Thu, 01 Mar 2018 22:34:45 GMT

You've got it @Shopthestream!

As long as you enter the same name under Item Name in each row, you can then add the different sizes under the Variation column. That way these size variations will grouped under that item on your Dashboard and in the Point of Sale app.

Re: Do I have to use Square template to import items?

rmcubam — Wed, 11 Apr 2018 01:40:07 GMT

What do I do if each variation has a different sku number and price? When in square I can edit that, but how do I enter that into the excel to import it?

Re: Do I have to use Square template to import items?

Tom — Fri, 13 Apr 2018 23:48:41 GMT

Hey @rmcubam, you'll be able to download the template and enter the appropriate number in the SKU column. In addition, the corresponding variation name and price columns should line up in the template. Are you able to see those options?

Re: Do I have to use Square template to import items?

AVMercantile — Thu, 14 Nov 2019 17:29:47 GMT

Which column in the import spreadsheet is for price (cost) and price (retail)?

Re: Do I have to use Square template to import items?

Joe — Fri, 15 Nov 2019 19:34:58 GMT

Hi there, @AVMercantile - I just tested this out using my own exported Item Library and re-uploaded after altering.

It looks like item price as related to cost will be in Column G, while unit cost can be added and edited in Column S.

I understand that this CSV can orient differently based upon device or software, so I recommend reaching out to our Support Team for further assistance and hands-on troubleshooting.