Question

What is the correct way to set up products in QBO or Square item to correctly transfer through Square Connector? Connector is not recognizing product variations.

Forum|Forum|6 months ago
February 1, 2026
6 replies
48 views

Product/service in QBO is in category Fruit. The product is Apple with variant of Frostbite. Item is Square is category Fruit. The item is Apple with variation of Frostbite. Cost and SKU are the same in QBO and Square. Product tracking in Connector is set to on. When the sale shows in Connector, Apple only is in the description. The best match is generally listed as Fruit after a few trial transactions. The Best Match never shows Frostbite, although it does show other product choices in the Fruit category. Any ideas or direction would be appreciated.

QuickBooks Online

A

ArielI

QuickBooks Team

Hello, @psorvik.

The key to reliable transfers from Square to QuickBooks Online (QBO) is understanding how the Connector actually matches line items. Let me share some additional information about this.

QuickBooks (via the Connector) matches items using the item name that appears on each incoming Square line. In other words, it’s really based on the item name. Even if the SKU and cost are identical in QBO and Square, the Connector will often use name-first matching unless you’ve configured it to use SKU matching. QBO does not match product categories. Categories in QBO can’t be used as the sales transaction item, so seeing “Fruit” as a suggestion doesn’t mean Frostbite is being recognized as an item.

If you need "Frostbite" tracked separately, create a distinct QuickBooks item named for that variation. QuickBooks can’t differentiate variations when matching, so if Square sends only the parent name (e.g., “Apple”) on the sales line and not the variation, the Connector won’t recognize it. To fix this, update your Square item names to include the variation (for example, “Apple – Frostbite”) so the Connector can match by name.

Please let us know if you have any further questions. We'll be right here to help you anytime.

P

psorvikAuthor

Thank you Ariell for your comments on this issue. I appreciate the further explanation on the workings of the Connector app. It appears that you are correct on the matching of names only. I had assumed that the Connector made a correct match for the item variation because it worked for the same item on another sale. But after more trial, the Connector also chooses Frostbite for other items sold that are also variations of Apple.

So having found this out, it appears that item variations can be created and used in Square and also product variants in QBO, but the Square Connector will not recognize these. This is disappointing. Creating individual items for all variations in both systems is cumbersome and renders the use of product variants and item variations useless. The variations of products (items) makes product management much easier, which is why I assume both QBO and Square utilize that organizational feature.

Your comment about using SKU matching caught my attention. Am I missing a setting where I can tell Connector to match SKU's? Where would I find that setting?

I am not a software engineer, but it seems so close to make the connector work. Just add the mapping tool that is already in QBO for csv importing to the Connector app. This mapping would allow users to choose (map) the items directly rather than having Connector guess where to put it. Maybe in the future...?

C

ClaireSamanthaS

QuickBooks Team

Hi there, Psorvik.

Your thoughtful insights and feedback are greatly appreciated. Let me share some information below.

To address your question about SKU matching, you have not missed a setting where the Square Connector app can be configured to match SKUs in QuickBooks Online.

Please note that QuickBooks relies on the information and data that is synced from the Square Connector app. The issue you’re encountering appears to stem from the way the Square Connector app processes and transfers the data to QuickBooks.

We recommend reaching out to the Square Connector support team to check if there are any settings or updates to address the SKU matching issue. They might also share if a mapping tool, like in QuickBooks for CSV imports, is planned in the future. Your suggestion about adding mapping functionality is valuable and could help improve their application.

If you have additional questions or concerns, please add a comment below.

Sign up

Login with SSO

Let's get you signed in

Login with SSO