• Blog / Cloud Bookkeeping Blog /

• Vend Composite Products and Xero Integration

One of the main reasons why your ‘stock on hand’ is out, is that the Xero/Vend integration is using composite products and not editing your average cost of the composite products correctly. This article is designed to show you the proper way of managing your composite products in Vend/Xero integration.

First of all, what are Composite Products? Composite products allow retailers to package different products together and create a pack or product bundle.

You can also use composite products for fractional stock, which can be useful if you sell products at different quantities such as grams or milliliters (like if you sell cake by the slice). Composite products are also helpful for creating packs made up of the same product, such as a box of 12 bottles.

Creating a Composite Product in Vend

Let’s go into Vend - Manage Your Business - Products - Products - Add Product

Name your composite product and click Composite under Product Type andInventory. Now, add your products. In this case, we are creating a business suite:

The price section is critical. Vend is not going to take into account the average supply price from the stock items that make up the composite product; you need to calculate it yourself and write it in Supply Price.

WARNING: If you leave this value as 0, in the future you will have problems with average costs as it will maintain constant 0 until you fix it viaCSV reupload (please contact us if you have this issue, and it requires a fix).

Supply Price vs. Average Cost in Vend

Supply price and average cost in Vend are not the same things, and the average cost in Vend is automatically calculated. Let’s say you had purchased ten products at $10 each; supply price will be $10, and average cost will be $10. Then you purchase another ten of the same product, but at $20 each — now you have 20 products in stock at an average cost of $15 each.

Vend is using average costs every time you sell a product to post to Xero. So you need to ensure that your average cost value is correct at all times.

Ordering New Stock for Composite Products.

When the time comes, and you need to order new stock for your composite products, you will need to go to each product individually and order them. If the average price of the stock changes, you will need to go back to the composite products and change the average cost for each of products (described below).

WARNING: If you try to order composite products and push it to Xero, please note that it will drive your composite products and ALL elements into your order and double up the stock on hand. Do NOT choose composite products when ordering stock with Xero integration!

As you can see stock on hand pushed to Xero, is double the real value.

Composite Product Average Cost Adjustment

For your Vend/Xero integration to work properly, you need to ensure that the supply price of the composite product is correct. Changing the supply price will allow you to modify the price for the next purchase order, but it will leave the average cost unchanged.

So what you need to do it so change the inventory stock type to standard, then change the stock price and then go back to composite. By doing that, you will need to re-add all of the standard products back again.

Subscribe by email and instantly get FREE Illustrated eBook. Adequate ‘positive’ cash flow is essential for the survival of any business, yet this is something that over 50% of small business owners struggle to manage.