QuickBooks HelpQuickBooksHelpIntuit

Inventory control between e-commerce and QuickBooks Online with OneSaas

by Intuit Updated 1 month ago

Learn how to integrate your inventory levels between e-commerce systems with OneSaas and QuickBooks Online.

QuickBooks Connector (OneSaas) typically has the ability to integrate inventory levels between e-commerce systems and QuickBooks Online. Inventory control features can often be a part of your QuickBooks Online.

Learn how QuickBooks Connector works

  1. QuickBooks Connector pulls product data from both e-commerce and QuickBooks Online. This includes the SKU/Product Code and product name.
  2. QuickBooks Connector will then match products between the two systems based on SKU/Product Code.
  3. If the stock level option is selected, QuickBooks Connector will check your QuickBooks Online for inventory levels and then carry this across to the e-commerce system.
  4. Going forward, your QuickBooks Online will alert QuickBooks Connector if there have been any inventory level updates.

When a sale is made in the e-commerce system, inventory levels are processed in the following method:

  1. QuickBooks Connector pulls sales invoices from the e-commerce system and pushes this to your QuickBooks Online.
  2. Your QuickBooks Online takes the sale along with the product data and recalculates the inventory levels internally.
  3. QuickBooks Connector detects the change in inventory levels and passes these updates back to the e-commerce system.

Learn about QuickBooks Connector’s limitations

  • QuickBooks Connector can’t pull inventory levels from one e-commerce system and push this to another e-commerce system. The reason for this restriction is because there is no inventory-level control if a sale is made.
  • QuickBooks Connector can’t pull inventory levels, cost prices, and tax details from e-commerce system and push this to QuickBooks Online products.
  • QuickBooks Connector will only create products in QuickBooks if the items from the e-commerce system are set to track or manage inventory. If the items aren’t set up to track inventory from e-commerce, regardless of the setting, we will only create the products in QuickBooks as non-inventoried.
  • If there were any manual changes made to inventory levels within e-commerce systems, these will only be overwritten when QuickBooks Connector receives new updates from QuickBooks Online.

    This is because we don’t get any notifications from the e-commerce system when inventory is manually updated. We will only trigger inventory sync on that product if an update is detected in QuickBooks Online.

Sign in now for personalized help

See articles customized for your product and join our large community of QuickBooks users.