Guides
Short fixes for common Square import problems.
Tasks
Each page opens the tool set up for one job.
Import new items
Update prices and stock
Fix codes and errors
All guides
- Export the Square item library without breaking SKUs
How to export items from Square, which file type and filter to pick, and how to open the file so Excel keeps the zeros in your SKUs and barcodes.
- Square duplicate items after an import: why and how to fix
An import can add a second copy of an item you already sell in Square. Why it happens, how to find and clear the copies, and how to import without them.
- Square GTIN vs SKU vs vendor code: which to match on
Square keeps a SKU, a GTIN and a vendor code on each variation. Who sets each one, and which to use when you match a supplier price list.
- Square default unit cost missing? Find and fill it
Items with no default unit cost leave gaps in your Square cost of goods sold report. How to find them and fill the costs from a supplier file.
- Supplier raised prices? Update Square costs
When a supplier raises prices, your costs change first and your margins follow. How to update costs in Square and raise only the prices that need it.
- Update Square unit costs from a supplier spreadsheet
Square uses unit cost for cost of goods sold and margin. How to bring in a supplier's new costs and leave the rest of your catalog alone.
- Create Square items from a supplier price list
Turn a supplier price list into new Square items. Which columns Square needs, which can stay blank, and what to do first.
- Leading zeros dropped from SKUs and UPCs
Open a supplier CSV in Excel and it can strip the zeros from your product codes. What that does in Square, and how to avoid it.
- GTIN must be 8, 12, 13 or 14 digits
Square rejects barcodes that scan fine in your shop. Why that happens, and how to repair the whole column before your next import.