Vend integration guide

This feature was added in vintrace Version 6.4.1

Vend is a Cloud based Point of Sale system ideal for retail wine sales through your own tasting room or cellar door.

You can automatically sync your daily sales totals from Vend to vintrace. All completed sales for wine products in Vend will generate sales orders in vintrace and calculate any WET/Excise liability. These sales orders, once set as approved in vintrace, will automatically reduce stock levels from your inventory in vintrace.

Vend integration overview

Step 1: Generate API key in Vend

Click here for details on how to generate the API key in Vend.

Step 2: Create a system user in vintrace to perform the Vend auto sync

You will need an additional vintrace user licence for the Vend integration to function. Contact sales to add one if you’ve reached your limit. Once the user is created please ensure it has the following permissions:

  • Have the “Operator” role assigned
  • Can manage sales orders
  • Submit operations
  • Can submit inventory actions
  • Can switch between winery facilities (multi winery mode)
  • Has a default winery set (multi winery mode)

Important: The system user also needs to have an email address set in the address book to receive the email notifications regarding the Vend sync.

Step 3: Configure Point of Sales in vintrace

Go to Winery Setup – Infrastructure – Winery and select the winery you want to link to Vend.

Configure 1

Click on Point of Sale setup… link.

Configure 2

Select VEND in POS Vendor dropdown menu, enter the Vend store name, and the enter the API key. Click here for more details on how to generate the API key. Click on Test connectivity button.

Configure 3

Click on Ok button in the Successfully connected to POS dialog.

Vend 1

Enter all the necessary information such as Outlet, Staff customer group, Retail price list, etc. Then click on Save button.

 

Vend 2

  1. Outlet – mandatory, the Vend store outlet you want to connect to this winery.
  2. Staff customer group – mandatory, the customer group you want to set as staff where all sales orders created for this customer group will be set as “Staff” sale type in vintrace.
  3. Retail price list – mandatory, the price list you want to set for all the sales orders created in vintrace that are synced from Vend. Important: This price list needs to have a Tax inclusive tax policy set.
  4. Sales region – optional, the sales region you want to set for the sales orders in vintrace that are generated from your Vend sales.
  5. Preferred Sales Order State – mandatory, this is the state you want to set for the sales orders in vintrace that are generated from your Vend sales. If you select anything other than “Approved” someone will need to manually approve the sales orders in vintrace so stock levels and sales data can be finalised.
  6. Sync start date – mandatory, the date of the first sync from Vend to vintrace.
  7. Default storage area – optional, the storage area that you want to set for the auto stock receival for refunds in vintrace that are generated from Vend returns.
  8. Run as – mandatory, the user id that will be used in syncing the Vend into vintrace.

Back to top

Step 4: Other configuration settings to consider

If you are using Vend and Xero that we recommend to use the 4 decimal places setting in the Xero set-up in vintrace.

Go to Winery Setup – System policy – Accounting Integration Configuration, set Decimal Precision to Four Decimal Precision.

Configure 6

Back to top

Step 5: Sync a stock item to Vend

For this example, we are going to sync a Single x1 stock item type. Go to Winery Setup – Wine stock items – Single x1. Click on the stock item you want to sync.

Please refer to this article if you want to sync a stock item to Vend via the importer utility.

Sync stock 1

Enter the Vend SKU of the product you want to sync then hit [ENTER] key, then select a Revenue account to link to your vintrace sales orders generated from Vend sales. Make sure that the Sync to Vend checkbox is ticked and then click on Save.

Vend 3.1

If there are multiple products with the same SKU in Vend, you will be prompted to select which product to link the stock item. Select the correct product and then click on OK button.

Configure 7

View the stock item again and you should be able to see a View in Vend link beside the SKU.

Vend 4.1

Clicking on this link will open the product in Vend.

Sync stock 4

Back to top

Step 6: Viewing the created sales orders in vintrace that are generated from Vend

The sales orders in vintrace that are generated from Vend will be auto created everyday at 4:00AM and they are grouped per day per customer per winery.

View synced sales 1

Back to top

Other related pages