QuickBooks import error · explained & fixed

“The name supplied already exists” — the QuickBooks import error Square sellers hit most

If you exported your item library from Square and tried to import it into QuickBooks Online as Products and Services, there is a very good chance this error stopped you. It is not random, and it is not your spreadsheet skills. It is a structural mismatch between how the two systems think about items.

Why it happens

Square treats variations as children of one item: a single “T-Shirt” with Small, Medium, and Large underneath it. When Square exports your library, each variation becomes its own row — but every row carries the same item name. Your export contains three rows all named “T-Shirt.”

QuickBooks Online requires every Product/Service name to be unique. The first “T-Shirt” row imports; the second one trips the error. One popular item with six variations produces five rejections.

The manual fix

Open the CSV in a spreadsheet and make every name unique, usually by combining the item name and variation name into one string:

1. Insert a new column.
2. Use a formula like =A2 & " - " & B2 to join Item Name and Variation Name.
3. Handle rows where the variation is blank or “Regular” (you usually do not want “Mug - Regular”).
4. Check for collisions that survive the merge — two items can still end up with identical combined names, especially gift cards and bundles.
5. Paste the result over the name column, delete your helper column, and re-export as CSV.

For a catalog of 40 items this is annoying. For a catalog of 600 it is an afternoon, and one missed collision sends you back to the start of the import.

One more thing: variants are gone for good

As of June 1, 2026, QuickBooks Online no longer supports product variants at all — existing variants were converted into standard products. So flattening each Square variation into its own uniquely named product is not a workaround anymore; it is the officially correct shape for your data.