Sync Inventory from QuickBooks POS to Online Store.
You can sync inventory updates from QuickBooks POS to your website. Our tool syncs inventory updates from the date of set-up of the Connex for QuickBooks account settings to current day.
The sync happens in the background. QuickBooks POS will send Connex a list of updated inventory items and Connex holds them in a queue. Every fifteen minutes, the queue is processed by sending inventory updates to your website when the web connector runs and cleared.
Initial Inventory Sync
Connex can handle a few hundred products, however, it's not built to sync several thousand at once. We recommend exporting your data into a spreadsheet, then using your e-commerce solution's spreadsheet uploader tool. For support uploading spreadsheets, contact your e-commerce provider.
To export the data, follow these steps:
- Log onto the server with QuickBooks POS.
- Go to File > Utilities > Export.
- Click next.
- Click next.
Here is a sample of the data.
How do I perform an initial sync with WooCommerce?
Our software will not create products in WooCommerce. Our software will update the stock of existing products only. You can use the WooCommerce CSV importer to import a spreadsheet of products:
How Does Connex match products in QuickBooks POS and my website?
Connex will match the product SKU from you website and to one of the QuickBooks POS fields you choose in the Product Matching menu in your Connex account.
If there is no match, then you must set-up a mapping.
Does my store need any special settings before I begin?
For WooCommerce users, ensure that enable stock management at product level is turned on.
Testing Inventory Updates
For testing individual products, please read this guide.