I finally after 2 hours got my template to upload now instead of say $24 it reads .24..........will not correct.......this is a major issue.   I was suppose to get a call yesterday  not call back??

@sunni148 - I went ahead and moved your comment here. We'll be sure to share updates in this thread. 

Any update??? Huge issue!  About to change POS companies. 

@highcottonal - It looks like you've been working directly with a supporter. They'll be sure to update you directly via email. 🙃

New Square Template w/Location Indicator On

Here's a template I made by downloading all my current stock as CSV, opening in Google Sheets and then cleaning out. My location indicator's on (which I hate - accidentally turned on + can't turn off), so not sure how that affects the template for everyone else.  This is the only work-around I've found. After populating the sheet, I download ans CSV and upload to Square. One hint, price has to be in a whole number form on the sheet, it gets converted in Square. When doing this, be sure to confirm your Price field on Square to make sure your decimal's in the correct place. be sure to pupulate your tax and inventory tracking on the sheet, saving you gouing back in and doing it one item/time.

@Domestica - Thanks so much for taking the time to put together a sample file with details about each row. This is very useful! Also, apologies for the trouble and time this has cost you. 

As a followed up, we do recommend that each seller uses a brand new export of their .CSV in the new format before they make any changes to their Item library. Also, in your template, you recommended that sellers delete their item tokens. This could cause a bit of an issue because a blank token field is interpreted as a new item to Square. If someone selected to "Modify" the catalog after deleting the item tokens from existing items, they may end up with duplicate items or receive errors on import. 

Sean,

Thanks.  Since I didn't see anything that said it's best download your own inventory .CSV, clear it out + use it as your template, I just posted mine as help.  I didn't advise that anyone clear their tokens from a .CSV inventory download. My advice was to leave that column blank when uploading new stock via this spreadsheet templatesince it's a Square-populated cell.

Thanks,

Chrissy @Domestica

@Domestica, what is the difference between the two price columns in your sheet?  Do you use one for wholesale and one for retail, or did you create the 2nd one to deal with the issue you mentioned with square using whole numbers?  If it's the latter case, do you need to delete one of the columns before importing--I don't see a 2nd price column in square's template?  Please advise.  Thanks!

@llij96 - You'll definitely want to use a fresh copy of your own .CSV from the Dashboard. You won't want to alter the format in any way, as well. This will cause you to run into import errors.

Would you mind sharing a few more details about what you'd like to set up? I'm happy to advise. 

@Sean, i'm trying to get my intial inventory into square and i see lots of people are having issues with your template, so was trying to use @Domestica's. gave up on that and downloaded square's multiple times, but keep getting errors (separate thread).  really disappointed that i can't use the barcode scanner to import items.

@llij96 - I see the other thread now. Just reach out directly with the .CSV and we can sort that out. As for using the barcode scanner, I've seen other sellers log in to the Dashboard from their mobile device and use the barcode scanner to adjust inventory from the Items tab. 

Definitely need to download your items via .csv and then I upload to Google Sheets, add inventory, save as a .csv and then upload to Square. The two price columns I think are a way to adjust price. I've been addng the price to both columns because I can't figure out which one populates price on the Square Register. 

Originally, I posted a link to a sample template when they first started making changes, but now they've changed even more, so using that one's going to leave some things out of your listing/place numbers in wrong cells. It's best to download your own items list, clear and add new stock.