• Skip to main content

Victor Font Consulting Group, LLC

The DEX Intranet Specialists

Call Us:

+1 919-604-5828

  • Home
  • Care Plans
    • Care Articles
    • Optional Subscriptions
  • Consultations
  • Products
    • Code Snippets
    • Public GitHub Repositories
    • Gist Snippets
    • Pastebin Snippets (Free)
    • Free Plugins
  • FAQs
  • Support
    • Graphic Design
  • Contact
    • Speakers
    • Portfolio
  • Resources
    • Free WordPress Video Training
    • Tutorials
    • Articles
    • Cybersecurity
    • EU Referral Network
You are here: Home / Quickbooks / Quickbooks-WooCommerce Product Sync

Quickbooks-WooCommerce Product Sync

By Victor M. Font Jr.
December 4, 20142 Comments

Due to the closing of the 61Extensions site and the abandonment of their plugin, the Troubleshooting Guide is out of print and no longer available for sale.

Quickbooks-WooCommerce Troubleshooting Guide front coverA frequently asked question about the QuickBooks-WooCommerce plugin by 61Extensions.com is, "Can the plugin upload products from my QuickBooks installation into WooCommerce?"

The simple answer is, "No, it can't!"

Many WooCommerce users buy variations of the 61Extensions plugin in the hope of seamlessly integrating the eCommerce solution with their QuickBooks Desktop or Point of Sale system. After days, weeks or sometimes a month or more, someone will find one of my QuickBooks-WooCommerce articles or purchase the Quickbooks-WooCommerce Integration Troubleshooting Guide. In many cases, the troubleshooting guide is sufficient to help the user solve their problem with setting up the plugin. Once the plugin is setup, it works nicely and it's pretty much hands-off from there.

New Product Integration is a One-way Sync

The marketing materials used to sell the plugin state in various forms:

Sync inventory AND pricing from QuickBooks to your store. Once you receive new stock in QuickBooks, it’ll update the qty on your website as well.

People read this and get excited because they make the assumptions that inventory items in QuickBooks will automatically transfer to WooCommerce. But if you read the 61Extensions site a little more closely, you'll also see:

The QuickBooks Connector Extension for WooCommerce seamlessly transfers orders, customers and inventory to your QuickBooks software.

Notice the phrase I bolded and underlined for emphasis? It says, "to your QuickBooks software." This means that new inventory item additions and synchronizing them between WooCommerce and QuickBooks is a one-way sync from WooCommerce to Quickbooks. Inventory already in Quickbooks and not yet in WooCommerce will not transfer to WooCommerce. You have to set the products up in WooCommerce first, then they will transfer to QuickBooks. Only after you have your products setup in both WooCommerce and Quickbooks will the quantity and pricing synchronization work bi-directionally.

Transferring Products from QuickBooks to WooCommerce

So what happens if you setup your inventory in QuickBooks first? I recently had a client call and ask me to help with this problem. They have over 8,500 products in their QuickBooks POS system and want 855 of them, all in one specific category, transferred to their WooCommerce installation. The only answer that can support this request is Export/Import, but unless you have a technical background, there is no easy solution.

QuickBooks provides functionality to export your entire inventory list to an Excel spreadsheet. You have to create a spreadsheet first and then tell QuickBooks that that is the spreadsheet you want to use. If you want to load your entire inventory into WooCommerce, then this is fine. But what if you only want to load a subset of your products, as this client requested? Then you have to sort your spreadsheet by category and item number, if you have a category setup, then delete all of the extraneous rows and export the remaining items from Excel to a CSV file. It's all a little complicated, right?

That's not even the hard part! Now you have to import the CSV into WooCommerce. But wait! There's no way to do that unless you buy another $200 plugin! Then you have to learn how to use the plugin, map the exported data to WooCommerce fields and import the CSV file. If you make mistakes or something doesn't go right, you're right back to square one.

The alternative, is that you can save a lot of time and frustration if you ask for my help as soon as you can. I've helped many, many users get their WooCommerce/QuickBooks integration working properly and the time we've spent together has never exceeded 4 hours. I've had about a 98% success rate. Sometimes, because of hosting policies or server configurations, there isn't anything we can do to make the plugin work, but what have you got to lose?

Start by purchasing and downloading the Quickbooks-WooCommerce Integration Troubleshooting Guide. It's only $7.95 and it may be able to save you hours of frustration. Just click the button below to add it to the cart. If the troubleshooting guide doesn't help you, then give me a call. What's a 4-hour investment worth compared to the days, weeks and hours you've already spent driving yourself crazy?

  • 2shares
  • Facebook0
  • Twitter0
  • Pinterest0
  • LinkedIn2
  • Print
  • SMS0

About Victor M. Font Jr.

Victor M. Font Jr. is an award winning author, entrepreneur, and Senior IT Executive. A Founding Board Member of the North Carolina Executive Roundtable, he has served on the Board of Advisors, of the North Carolina Technology Association, the International Institute of Business Analysis, Association of Information Technology Professionals, Toastmasters International, and the North Carolina Commission for Mental Health, Developmental Disabilities, and Substance Abuse Services. He is author of several books including The Ultimate Guide to the SDLC and Winning With WordPress Basics, and Cybersecurity.

Reader Interactions

VictorFont.com runs on the Genesis Framework

Genesis FrameworkThe Genesis Framework empowers you to quickly and easily build incredible websites with WordPress. Genesis provides the secure and search-engine-optimized foundation that takes WordPress to places you never thought it could go.

Check out the incredible features and the selection of designs. It's that simple—start using Genesis now!

Click here to download The Genesis Guide for Absolute Beginners (PDF - 1.4 MB)

Leave a Reply Cancel reply

Your email address and website will not be published. Required fields are marked *
Posting a comment means that you agree with and accept our Comment & Product Review Policy

Comments

  1. Sol

    September 19, 2017 at 3:06 pm

    Victor,
    If you’re interested in a way to reduce the stress of copying all of those products over (from QB to WooCommerce or WooCommerce to QB) and sync all data both ways automatically check this plugin out the MyWorks Software WooCommerce Sync for QuickBooks Those 855 products could have been synced over with one click. It’s available for QuickBooks Desktop too. Thought you might want to check this out!

    Reply
  2. Sol

    March 8, 2017 at 6:32 am

    Hi Victor,

    Great article! Manually syncing data from QuickBooks to WooCommerce and WooCommerce to QuickBooks isn’t easy! I’m glad you’ve found a way to make it work.

    Reply

Call: +1 919-604-5828

Send us an E-mail

Accessibility Statement | Affiliate Marketing Disclosure | Capability Statement

Cookie Policy | Comment & Product Review Policy | Privacy Policy | Site Map | Terms & Conditions

Copyright © 2003–2023 Victor M. Font Jr.

Return to top of page