Troubleshooting · Square → QuickBooks Online

Square items CSV won’t import into QuickBooks Online: all four causes, in order of likelihood

The frustrating part of a failed Products and Services import is that QuickBooks often rejects the file row by row, error by error, so you fix one problem only to surface the next. If your CSV came from Square’s “Export library,” the failures are predictable. Here are all four, so you can fix the file once.

1. Duplicate names from variations

Square exports each item variation as its own row sharing one item name; QuickBooks requires unique Product/Service names. This is the cause of the “name supplied already exists” error and it affects every item that has sizes, flavors, or options. The fix is merging item and variation names into one unique name per row — covered in detail in our dedicated guide.

2. Colons in item or category names

This one fails silently, which makes it worse. QuickBooks uses the colon as its category separator — Flowers:Roses means “Roses, inside the Flowers category.” An item called “Coffee: House Blend” does not error; it quietly imports as a sub-item called “House Blend” under a new item called “Coffee.” You discover it weeks later when reports look wrong. Replace colons with a dash in both item names and category names before importing.

3. “Variable” in the price column

Items with variable pricing export from Square with the literal word variable where a number should be. QuickBooks cannot parse it. Blank those cells (and note which items they were, so you can set prices inside QuickBooks later). While you are there, strip currency symbols and thousands separators — $1,250.00 should be 1250.00.

4. Names over 100 characters and ghost rows

QuickBooks caps Product/Service names at 100 characters; long descriptive names plus a merged variation can exceed it. And Square exports sometimes contain effectively empty rows that import as blank items. Truncate the former, delete the latter.

Fix order matters

Do colons first, then merge variations, then re-check for duplicates — because the merge can itself create new collisions. Then prices, then lengths. Or do all of it in one pass with the converter below.