Vend POS to Quickbooks Commerce OMS Integration

Vend POS to Quickbooks Commerce OMS Integration

Extensiv Integration Manager integrates the Vend POS and Quickbooks Commerce systems very tightly for a seamless data flow keeping both systems in sync.

With this setup:

  • Vend acts as the frontend POS system that can be used from many retail locations at once.
  • Quickbooks Commerce acts as the backend Inventory Management system that tracks inventory across all Vend retail stores as well your online stores and marketplace listings.

Below is a description of all the types of data that Integration Manager keeps in sync across the two systems.

Orders

New Orders

Sales Orders created in Vend will sync to Quickbooks Commerce.

Order Returns/Cancellations

Order returns and cancellations created in Vend will sync to Quickbooks Commerce. 

Products

Products created or updated in Quickbooks Commerce will sync to Vend.

Products created or updated in Vend will not be synced to Quickbooks Commerce . Updates made directly in Vend may be overwritten by Quickbooks Commerce .

Product Rules in Quickbooks Commerce and Vend

  1. Please ensure that SKU in Quickbooks Commerce does not contain special character. Only alphabet and numbers are allowed. 
  2. Parent Products Names must be unique in Quickbooks Commerce. 
  3. The maximum number of variants allowed for a single Parent Product, in Vend, is 200. 
  4. Please DO NOT modify products directly in Vend. Otherwise, Vend internal product ID would be changed and Integration Manager would lose track of Product Sync. 
  5. Read all the Vend Product Sync Requirements.


Composite Products

Composite Products cannot be synced from Quickbooks Commerce to Vend without issues. You must perform the following actions:

  1. In the Integration Manager Merchant tab > Edit Setup, turn off the Download Composite Products option.
  2. Keep the Composite Components as Individual Items in Quickbooks Commerce.
  3. Manually create any Composite Products in Vend as needed.

These steps are necessary because the Vend API does not support Composite Products, so there is no way for them to be synced otherwise.


Stock Control

Order Stock

Receiving a purchase order in Vend will sync that inventory information to Quickbooks Commerce.

Purchase orders created in Quickbooks Commerce will not show up in Vend. Once they are received, the inventory in Vend will be adjusted to match though.

Return Stock

Performing stock returns in Vend will sync that information to Quickbooks Commerce.

Stock returns created in Quickbooks Commerce will not show up in Vend as returns. The inventory in Vend will be adjusted to match though.

Transfer Stock

Creating a location transfer in Vend will sync that same transfer location to Quickbooks Commerce. Both locations must also exist in Quickbooks Commerce and be connected via Integration Manager.

Location transfers created in Quickbooks Commerce will not show up as transfers in Vend. They will show up as item adjustments in both Vend locations. One negative and one positive.

Inventory Count

Inventory cycle counts or stocktakes performed in Vend will sync that information to Quickbooks Commerce. Performing a cycle count in Quickbooks Commerce will perform a standard adjustment in Vend.

Stock Adjustments

DO NOT perform stock adjustments in Vend without using one of the procedures listed above. Otherwise your adjustment will be overwritten.

You may perform adjustments in Quickbooks Commerce. They will be synced to Vend.


Vend Cart Settings

Cart SettingDescriptionDefaultNote
Order StatusOnly pull orders with the selected Order Status. CLOSED
Outlet NameOnly sync order and inventory with the given Outlet in Vend. Main OutletThis is a required field for Quickbooks Commerce users. If you have multiple Vend Outlets, setup one Integration Manager connection per outlet.
Send Cancellation/Return To WMS

Should Integration Manager sends order cancellation/return requests to WMS? 

No
Default to Outlet AddressIf an order does not have address info, should Integration Manager put the Outlet address on the order instead? Yes
Send Stock Adjustment to WMS (Beta)

Should Integration Manager send Stock Adjustments from Vend to Quickbooks Commerce? Ex. Stock Take, Stock Transfer, and Item Purchase/Return. 

No
Push Product Details

Should Integration Manager also push Product Details, such as name, description, and prices, to Vend? 

NoIf you connect your Quickbooks Commerce account to multiple Vend Outlets (under the same Vend account), you will need to enable Push Product Details for ONLY ONE of the connected Vend Carts.
Cart Products Retail PriceIf Push Product Details is enabled, which price field should be used as item Retail Price?RetailIf Custom is selected, please type in Quickbooks Commerce Price List name for Retail Price. 
Cart Products Supply PriceIf Push Product Details is enabled, which price field should be used as item Supply Price?RetailIf Custom is selected, please type in Quickbooks Commerce Price List name for Supply Price. 


Get Started

Once you have created your Integration Manager account, please use the following guides to connect your account to Quickbooks Commerce (as your WMS) and Vend (as a Cart). 


    • Related Articles

    • Quickbooks Commerce OMS Integration Overview

      is now Inventory and order management software for modern merchants. All of your inventory, orders and customers managed and accounted for in one place. Website: https://www.tradegecko.com/ Supported functions Order Send Inventory Sync Pickup ...
    • Quickbooks Commerce OMS Tax Settings

      This article covers the tax options available when sending orders through Extensiv Integration Manager to Quickbooks Commerce . These options are all configurable per order source. You will find these settings in the Integration Manager Carts tab by ...
    • Quickbooks Commerce OMS - The access token was revoked

      Problem All interfaces to your Quickbooks Commerce account are failing with the message: The access token was revoked Solution This can happen for several reasons if a change in Quickbooks Commerce removes Extensiv Integration Manager's access to ...
    • Quickbooks Commerce OMS Order Settings

      When Quickbooks Commerce is selected as your Extensiv Integration Manager WMS, there will be Quickbooks Commerce specific settings to set for each cart connection in Integration Manager. These settings are listed and explained below: Quickbooks ...
    • Setting Up Quickbooks Commerce OMS

      is now Required Parameters Credentials from Quickbooks Commerce that are needed to setup this connection in Extensiv Integration Manager . Quickbooks Commerce Account Username Quickbooks Commerce Account Password Step-by-step guide Go to the WMS ...