Vend POS to Quickbooks Commerce OMS Integration

Vend POS to Quickbooks Commerce OMS Integration

CartRover 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 CartRover 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 CartRover 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 CartRover 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 CartRover.

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 CartRover connection per outlet.
Send Cancellation/Return To WMS

Should CartRover sends order cancellation/return requests to WMS? 

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

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

No
Push Product Details

Should CartRover 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 CartRover 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 ...
    • Ebay to Quickbooks Commerce OMS Integration

      CartRover integrates Ebay and Quickbooks Commerce systems for loading orders and posting back tracking and inventory. This page covers the features supported and limitations of this connection. Supported Features Order Download Shipment Confirmation ...
    • Quickbooks Commerce OMS Tax Settings

      This article covers the tax options available when sending orders through CartRover to Quickbooks Commerce . These options are all configurable per order source. You will find these settings in the CartRover Carts tab by selecting the desired cart, ...
    • 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 CartRover's access to your account. These ...
    • Quickbooks Commerce OMS Order Settings

      When Quickbooks Commerce is selected as your CartRover WMS, there will be Quickbooks Commerce specific settings to set for each cart connection in CartRover. These settings are listed and explained below: Quickbooks Commerce Order Status Settings ...