Inventory Sync

How do I test syncing inventory to my website from QuickBooks Desktop?

Connex pulls items by their modified date. Making a change to an item will cause it to sync with your website. You must update a product in QuickBooks, run the connector, view it in your queue, then run the task.

Should QuickBooks be my inventory master?

Yes, our tool syncs updates from QuickBooks to your website. If you enter stock on your website and you update an item in QuickBooks, our tool will overwrite the website amount; if the website says 5 and QuickBooks says -2, the website will say -2. Please ensure that QuickBooks has the correct quantity on hand, before syncing. 

I made inventory updates a few days ago. Can I sync them without changing them again?

Yes, you can change your sync timers:

  1. Login to Connex.
  2. Click manage.
  3. Expand inventory.
  4. Expand sync inventory from QuickBooks.
  5. Adjust the after date to yesterday.

What kind of changes can I make?

Here is a list:

  • Perform an inventory adjustment.
  • Create a sales receipt or invoice, which adjusts the stock level.
  • Create a PO and a bill, which increases the stock.
  • Open the item in QuickBooks. Make a change to it.

In this guide, we will just make a small change to an item.

Update QuickBooks Product

If you have a product that is having issues syncing over, try this simple workaround:

  1. In QuickBooks, go to lists > item list.
  2. Double click a product.
  3. Add the phrase "Test" to the purchase description.
  4. Click OK.
  5. Go back to the product and remove "Test": 
  6. Click OK.
  7. Run the web connector.