Importing items excel file

[mattsdugout]

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

[Candlestore · Accepted solution]

@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.

[Candlestore · Accepted solution]

@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.

[mattsdugout · Accepted solution]

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