Get 50% OFF QuickBooks for 3 months*

Buy now
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Simplify payday and set payroll to run automatically on QuickBooks.Explore Intuit QuickBooks Workforce
psorvik
Level 1

Square connector with item variations

Has anyone been successful using Square Connector to transfer sales transactions from Square with item variations? Specifics for this are as follows: Product Tracking in Square Connector set to ON. The product in QBO is category, Fruit>product name, Apple>product variant, Frostbite. Item in Square is category, Fruit>item name, Apple>item variation, Frostbite. The price and SKU are identical in QBO and Square. When a sales transaction gets into the review screen in Square Connector, only the item name Apple is in the description for the sold item. QBO tries to match it, but only with the category Fruit. On a csv transaction export for this sale from Square, the item variation of Frostbite is shown in an Item Variation column. So it would appear that Square Connector is not recognizing the item variation. Any input would be appreciated.

3 Comments 3
LollyNino_C
QuickBooks Team

Square connector with item variations

Hi @psorvik.

 

Thank you for reaching out about the trouble you’re experiencing syncing item variations. I understand how frustrating it is when detailed info like “Frostbite” doesn't appear in QuickBooks, especially after you've put in the work to match your SKUs and prices perfectly.

 

To troubleshoot, start by reviewing the configuration settings in Square Connector. Check for options that let you adjust how items are mapped during the sync. Look for settings that allow transactions to match based on SKUs or that include extended item descriptions, such as variations like “Frostbite.”

 

Considering that the syncing behavior of Square Connector depends on how Square organizes your transaction details, I recommend contacting Square’s support team directly. They can clarify whether item variations are fully supported during the syncing process and provide guidance specific to their platform.

 

If you continue encountering any issues or have updates about your progress, don’t hesitate to reach out. I understand these challenges can be tricky, but together we can find the best solution to make your workflows as smooth as possible. We’re here for you every step of the way!

psorvik
Level 1

Square connector with item variations

Hello LollyNino_C,

 

Thank you for your comments. There has been little progress on this issue. According to Intuit customer service, there is an investigation regarding syncing, but no response on what a fix might be yet. In your response, you stated to check on the Connector configurations regarding the mapping during sync. If you could let me know where to find or adjust the settings between product/services and items, that would be great. A great option for this would be the same type of 'mapping' screen that is presented during a csv file import. There, QBO requires input to map the connection between the QBO account and the item being imported. Maybe I am just missing where to do this.

 

You also indicated that this may be related to how Square sends the information to Connector. I am assuming that this is not a Square issue because a csv export of the sale transaction from Square shows the correct item and the item variation. 

 

This is might help someone or is at least is a bit of information. The connector did work in my situation...sort of. If you create a sale in Square, wait awhile, there is no forced sync, the transaction shows up in the review screen. In this screen the item description for the sold item may be displayed wrong, but I do know what it is because I created the sale. The 'best match' is also wrong, but you can find your product to match it correctly. Then confirm the sale. Upon another sale transaction for the same item, Connector did recognize the correct product. I just don't see this as a way to move forward with over 250 SKU's. Given this scenario, it would appear that the information is there from Square, but QBO is just not 'seeing' it until is is manually matched. 

 

Please share any of your experiences or ideas. 

Nathania_P
QuickBooks Team

Square connector with item variations

Hi there, Psorvik. 

 

Thank you for sharing your detailed experience. I recognize the challenges involved in navigating this syncing process, especially with a large number of SKUs. Your insights on the manual matching process and product mapping are incredibly valuable.

 

Since there is a syncing problem between Square and Connector, I recommend contacting our Live Support team for updates on the status and further steps. They can provide personalized assistance to help resolve this issue. Please share your case details with them for a quicker resolution.

 

Here’s how:

 

  1. Navigate to the Help menu.
  2. Select the Search option and type "contact support."
  3. Click the Contact Us tab at the bottom.
  4. Enter the question, keyword, or topic for which you need assistance.
  5. Follow the prompts, then choose your preferred way to connect with us: Have us call you or Chat with us.

 

If you have any additional concerns about QuickBooks, please reach out to us again. We’re always here to help.

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.

Need to get in touch?

Contact us