x
Beta Member

Adding my items from my in store inventory to online store

I a new to Square Retail and have a large inventory catalog. What is the easiest way for me to add inventory from my current inventory library? 

2,712 Views
Message 1 of 10
Report
9 REPLIES 9

Hi @Andy212FL,

 

The easiest way is to import a CSV or Excel file into your item library in your Square Dashboard. Here is an article on Inventory Management, see the section on managing bulk inventory:

 

  1. Visit Items in your online Square Dashboard.
  2. Click Actions > Export Library.
  3. In this report, update your Stock Alert Enabled [Location] and New Quantity values and save the Excel (.xlsx) or CSV file to your computer.
    Note: At this time, Excel (.xlsx) and CSV (.csv) file templates are the only supported file types for bulk import. Custom templates aren’t supported.
  4. Drag and drop your saved file to the Import Inventory window and click Upload > Confirm > Done.
2,685 Views
Message 2 of 10
Report
Beta Member

@mattd Thank you for your help 

2,682 Views
Message 3 of 10
Report
Beta Member

@mattd 

One last question. What is the best way to combine all sizes into one page for an item? My spreadsheet is coming across one by one as far and not all sizes are grouped together. 

2,680 Views
Message 4 of 10
Report

Do you mean with the import tool? If using the import tool, it is very important that you assign the Square Core Product Attributes correctly.

 

Or are you adding an item manually in your Square Dashboard?

 

Regarding the size question, how I would recommend is something like the following:

TshirtInventory.png

 

To clarify, are you saying your current inventory has a row for each item in your inventory? So there are duplicate lines if you have two of something?

2,685 Views
Message 5 of 10
Report
Beta Member

@mattd 

 

Yes. I am using the import tool. I am transferring from another ipad system and they come across as one by one on the items. looking at your example do I take out some of the tokens say I only assign one token for all sizes in Orange and one token for all sizes in Black? 

2,683 Views
Message 6 of 10
Report

The tokens are generated by Square, no need to worry about the tokens. Those are just preexisting one's that I have.

2,662 Views
Message 7 of 10
Report
Beta Member

@mattd 

 

Looking at your spreadsheet I see Tokens for Orange but not for the Red Shirts. Is that how I should do it? 

2,658 Views
Message 8 of 10
Report

No, on your first import you can leave the tokens blank. They will be automatically generated for you.

2,647 Views
Message 9 of 10
Report
Beta Member

@mattd 

 

Is it possible for one token with Square to have all Sizes and Colors grouped together? I sell clothes so the majority of my inventory has various colors and sizes. All I keep getting is every single item ends up with their own token. Is there an easy way to do this? 

 

2,589 Views
Message 10 of 10
Report