QuickBooks import error · price column

The word “variable” in your Square export breaks the QuickBooks price column

Square lets you sell items with no fixed price — the cashier enters an amount at the register. Useful in the store; a problem in your books migration. When you export your item library, those items carry the literal word variable in the Price column, and QuickBooks Online’s import validator expects a number there. The row gets flagged as invalid.

The fix

1. Filter the Price column for the value variable.
2. Clear those cells — an empty Sales price is valid in QuickBooks and simply means “set at transaction time,” which is the honest representation of a variable-priced item anyway.
3. Keep a list of which items those were. After import, decide item by item whether to leave the price blank or set a default inside QuickBooks.

While you’re in the price column

Two adjacent problems live in the same column. Currency formatting — $1,250.00 — should be stripped to 1250.00; the dollar sign and the thousands comma can both confuse the import, and a comma inside an unquoted CSV field can shift every column after it. And check for stray text like N/A that ends up in price cells of catalogs that have been hand-edited over the years.

Why this hits Square sellers in particular

Service businesses, coffee shops with open-amount items, donation lines, and custom-order retailers all lean on Square’s variable pricing — so their exports almost always contain at least a few of these rows. It tends to be discovered last, too: you fix the duplicate-name errors, re-import, and then the price rows fail. Fixing the file in one pass beats discovering the failure modes serially.