thread Importing items excel file in Orders, Menu Items, Catalog & Fulfilment

Importing items excel file

mattsdugout — Sat, 20 Sep 2025 11:02:17 GMT

Hi Everyone,

We are switching over to Sqaure Retail. I downloaded the excel file. And was able to upload the 1077 items. Problem is it says I have zero inventory. I am putting a screen shot of where I put the inventory in. Is that the wrong tab?

Thanks in advance.

Price	Option Name 1	Option Value 1	Default Unit Cost	Default Vendor Name	Default Vendor Code	Current Quantity Matt’s Dugout	New Quantity Matt’s Dugout	Stock Alert Enabled Matt’s Dugout	Stock Alert Count Matt’s Dugout
0			0			9850
1			0.9			689
10			9			829
20			17			749
3			2.75			784
5			4.6			907
1			0.9			887
0.1			0			1474
10.99			7			23
11.99			10			10
3.49			3			24
1.99			1			36

Re: Importing items excel file

Candlestore — Sun, 15 Jan 2023 22:57:24 GMT

@mattsdugout ;

Easy fix Export your current inventory, And where it says Current inventory it will show 0 for everything from what you are saying and should show 0 in your square dashboard. You want to put the New inventory counts in the column NEW QUANTITY.... What ever number for Quantity is in the NEW Quantity is like doing a Full count. Make sure that is the only column you change. If you change or delete the Token Box it will make a new Item also.... and when you import it Update the inventory. Let me know how that works.

Re: Importing items excel file

mattsdugout — Sun, 15 Jan 2023 23:11:58 GMT

omg thank you so much IT WORKED. Appreciate the help.