How to import products to Square

Photo by Frans van Heerden: https://www.pexels.com/photo/assorted-medallions-631212/

Moving online platforms can be the most time consuming task for businesses of all sizes, each item needs to be added correctly to ensure a seamless transition for you and your customers. The quickest way to import a large number of items into Square is to import them using a CSV, which we will cover in todays blog. If you are looking to add individual products, check out this tutorial

[Watch] Learn how to import products in Square

Breakdown the import CSV

In this tutorial, we used Google Sheets to complete the CSV form for import. When inputting your item info ensure that the correct information is added to the right column, here is a breakdown of the headers and what goes in them.

Export File FieldDescriptions
TokenYour Square Dashboard will automatically populate this token. If you are importing a new item, leave this field blank, if you are editing items do not change the token.
Item NameCan include numbers, letters or symbols. Maximum 128 characters.
DescriptionCan include numbers, letters or symbols. Maximum 1024 characters.
CategoryCan include numbers, letters or symbols. Maximum 128 characters.
SKUEach variation should be assigned a unique SKU.
Variation NameCan include numbers, letters or symbols. Maximum 128 characters.
Unit and PrecisionUnit type and precision (decimal places).
PriceNumeric. Must be $0.00 or greater (a fixed price needs to be a positive number). You can also leave blank or write in “Variable” to indicate a variable price.
Option NameCan include numbers, letters or symbols. Maximum 128 characters.
Option ValueCan include numbers, letters or symbols. Maximum 128 characters.
Reference HandleA unique value used to reference variations within the import/export file. Specifically, this field is used to associate stock by variations with their sell by variations during inventory import.
Enabled [Your Location Name]Yes or No. This will set your item as visible in individual locations. If you only have one location and see this column, make sure all items are set to Yes.
Current Quantity [Your Location Name]Numeric. If you are using Inventory Management this is the current quantity of this item defined as in stock. Changes to this field are ignored on import.
New Quantity [Your Location Name]Numeric. If you are using Inventory Management, enter your current stock count here. This count will replace any existing stock count. You can also write in “No” to disable stock tracking for this item variation.
Stock Alert Enabled [Your Location Name]If you are using Inventory Management, you can set Yes or No to turn on items for inventory alerts.
Stock Alert Count [Your Location Name]Numeric. If you are using Inventory Management, and have alerts enabled, this is the quantity at which you will be alerted.
Price [Your Location Name]Numeric.
Tax [Your Tax Name]If you have created a tax, set to Yes or No to apply that to the item.
Subscribe
Notify of
guest

0 Comments
Inline Feedbacks
View all comments
0
Would love your thoughts, please comment.x
()
x