Help with setting up and importing item list

[Simon_Dennis]

Hi all - I am in the process of setting up Square registers for our Junior Rugby League club. I have downloaded the template for ITEM LIBRARY to import all of our items, but the Excel template doesn't align with the fields listed in this help article:

https://squareup.com/help/au/en/article/5153-import-items-online

Anyone know why that might be - I require the list from the article so I can add price, unit cost etc. The template available in square has these fields

Token

Item Name

Variation Name

SKU

Description

Category

Price

Sellable

Stockable

Option Name 1

Option Value 1

Current Quantity

New Quantity

Stock Alert Enabled

Stock Alert Count

Tax - GST (10%)

Any help is appreciated?

[lawnbrook]

HI @Simon_Dennis ,

I think the columns may vary depending on subscription, or the article may be out of date.

As its a fresh start I'd just give it a go. I've managed to export/edit import with no problems so I'm sure it will be fine. If there's no data in there, and it doesn't work right, at least you can just clean it up and try again.

Bruce

[Simon_Dennis]

Thanks so much. Everyone's help has been great and we are now up and running

[Laurie_]

Hey there @Simon_Dennis,

@lawnbrook raises a great point here, there are certain subscriptions (such as Square for Retail) that can have an impact on how these files appear.

However, in this case, given you are in the process of setting up your account, I wonder if you have created an item yet in your Item Library?  As a rule of thumb, I always create at least one item before exporting the template so that all the fields in the template appear correctly.

It's important to note that the Support Article won't show every field in the exact order it is generated in the template, however, those key fields should definitely be generated each time you export your library.

Additionally, some fields will appear on different sheets within the spreadsheet file. 

Let me know how you go on your end! 

[Simon_Dennis]

Thanks for the advice - appreciate it and now have everything sorted