cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Created with Sketch. The QuickBooks Community will be unavailable for approximately 1 hour beginning at 10:00 PM PDT on Wednesday, August 14th for database maintenance. All community forums will be unavailable during maintenance but feel free to browse our Support articles for help in the interim.
nrwoodward
Level 1

Can I synch my Square items with Quickbooks when a single item exists with multiple variants? I need to track the inventory quantity and cost separately for each variant.

 
3 Comments 3
KlentB
Moderator

Can I synch my Square items with Quickbooks when a single item exists with multiple variants? I need to track the inventory quantity and cost separately for each variant.

Hi there, nrwoodward.

 

Currently, the option to import Square items is unavailable in QuickBooks Online. The Sync with Square app can only import your sales, fees, refunds, tips, and transfers. After you connect, transactions are automatically imported on a nightly basis. Depending on the number of transactions, it might take about 24 hours to get all of your sales transactions. 

 

As a workaround, we can setup an identical item by manually uploading your Sqaure item list as a CSV file. Additionally, please make sure that item name and SKU matches with what you have in Square.

 

Here's how to do it:

 

  1. Click the Gear icon, then choose Import Data.
  2. Select Products and Services.
  3. On the Import products and services page, click Browse.
  4. Find and select your Excel file.
  5. Click Open, then Next.
  6. Map your information. Your Field represents the headers on your spreadsheet.
  7. From each drop-down menu , select the one that matches a field in QuickBooks Online.
  8. Click Next, then choose Overwrite all values for each product or service with the same name. 
  9. Select Import to complete the process.

To learn more about how your Square sales data are imported into QuickBooks Online, you can read this article: Sync Square with QuickBooks Online.

 

Do you have any other questions in mind? Feel free to leave them below and I'll get back to you as soon as I can.

honeygirlwaterwear
Level 2

Can I synch my Square items with Quickbooks when a single item exists with multiple variants? I need to track the inventory quantity and cost separately for each variant.

Why does it only say SQUARE ITEM within App Settings Square on QBO?  I have created 5,000 Item Names within Square that match my QBO Item Names.  Note: I am not using "SKU" in QBO, just "Item Name" on my invoices within QBO.  And I use the same exact Item Name in Square.

MJoy_D
Moderator

Can I synch my Square items with Quickbooks when a single item exists with multiple variants? I need to track the inventory quantity and cost separately for each variant.

Thank you for posting here in the Community, @honeygirlwaterwear.

 

I've checked that you've posted the same question twice and my colleague has already added an answer. If you haven't been notified of the new response, check this link

 

If you need further assistance, don't hesitate to leave a comment below. I'm always here to help.

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us