Square product import from a supplier spreadsheet
Square builds new items from four columns it will not import without: Item Name, Variation Name, Description and SKU. A business with more than one location also needs an Enabled column per location. A supplier file rarely carries any of those names. This page reads the file you were sent and matches its columns to the ones Square asks for. The rest of the template is left as Square expects to find it. Item names are checked for duplicates, because Square refuses a file that repeats one. Rows that belong to the same product are grouped into one item with variations. Size and colour then do not arrive as separate products. The download is an .xlsx you import from the Dashboard.
Two ways in: upload your export, or connect Square.
Loading the tool
Related pages
- Excel to SquareConvert an Excel price list to a Square file. Reads .xlsx and legacy .xls in the browser, no upload.
- Square inventory importImport stock counts into Square from a supplier file. New Quantity replaces the count, so see every number first.
- Square SKU importImport SKUs into Square with leading zeros intact and no scientific notation. Duplicates listed first.