thread Re: Help with setting up and importing item list in Hardware Setup & Troubleshooting

Help with setting up and importing item list

Simon_Dennis — Sun, 21 Sep 2025 11:07:45 GMT

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

Re: Help with setting up and importing item list

lawnbrook — Tue, 17 Jan 2023 12:26:33 GMT

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

Re: Help with setting up and importing item list

Laurie_ — Wed, 18 Jan 2023 23:10:37 GMT

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!

Re: Help with setting up and importing item list

Simon_Dennis — Tue, 31 Jan 2023 12:27:49 GMT

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

Re: Help with setting up and importing item list

Simon_Dennis — Tue, 31 Jan 2023 12:28:52 GMT

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