The following only applies if importing using a. If you have created a tax, set to Yes or No to apply that to the item. If you are using Inventory Management, and have alerts enabled, this is the quantity at which you will be alerted. If you are using Inventory Management, you can set Yes or No to turn on items for inventory alerts. You can also write in “No” to disable stock tracking for this item variation. This count will replace any existing stock count. If you are using Inventory Management, enter your current stock count here. Changes to this field are ignored on import. If you are using Inventory Management this is the current quantity of this item defined as in stock. If you only have one location and see this column, make sure all items are set to Yes. This will set your item as visible in individual locations. You can also leave blank or write in “Variable” to indicate a variable price. Must be $0.00 or greater (a fixed price needs to be a positive number). Unit type and precision (decimal places). Maximum 1024 characters.Įach variation should be assigned a unique SKU.

Maximum 128 characters.Ĭan include numbers, letters or symbols. If you are importing a new item, leave this field blank, if you are editing items do not change the token.Ĭan include numbers, letters or symbols. Your Square Dashboard will automatically populate this token. If you wish to use the exported item library file to perform number functions, you must change the file to a numbers format. Keep in mind: The Excel file template is formatted to text, not numbers. A spreadsheet will then download to your computer. Select between Excel (.xlsx) or CSV format. Visit Items in your online Square Dashboard.Ĭlick Actions > Export Library > Confirm Export. These are supported by most modern spreadsheet tools like Numbers, Sheets and Microsoft Excel, which don’t require a purchase or subscription. Note: While CSV files are supported with the import/export process, we strongly recommend using an Excel (.xlsx) file format. To create a unit type and set the precision, head to the Units tab of your online Square Dashboard.īefore you make any alteration to your library, we recommend exporting a copy of your item library and saving a distinct file before continuing - so you can always revert back to the previous state in case any issues come up. Note: You will not be able to create unit types via import. Upload and manage multiple items at once from the online Square Dashboard with the bulk import tool.

Export Your Library Edit CSV File Upload Your Item Library for the First Time Upload Images to Your Item Library

Excel import xml or csv