Quickbooks handles discounting of Bundles very differently than typical products. By default Quickbooks has two methods to sell what your DTC Platform calls Bundles: Inventory Assemblies and Groups. With WGits for QB, we have designed the system to work specifically with Groups as this is the only option that tracks the component SKUs of your bundles and tracks the inventory properly.
How to use Groups in Quickbooks
Group Items in QuickBooks (QB) offers an alternative to using Inventory Assemblies for items that are sold together, like a bundled selection of wines. Groups are nearly an equivalent of a Bundle in WineDirect, but there are a few differences.
When you create a Group in QB, you cannot assign a price to a Group, rather, QB uses the individual prices of each of the items in the Group to determine the selling price of the Group. This is not the case in most DTC Platforms. With your DTC platform, you can create a Bundle and set a price for the Bundle.
When the Bundle is transferred over to QB in an order from ecommerce system, you must set the prices of the individual items in QB to match the price of the Bundle in your ecommerce system.
How does this work?
Example: Let’s say a bundle named GIFT_PACK is created in your DTC Platform that consists of two items, each selling for $50 each when purchased separately.
The manually set price of the two bundled items is $80 (a lower price than the usual $100), which is the price of the Bundle in the ecommerce system.
Now, we must create the same Group in QB, named GIFT_PACK except that we cannot set a price for the QB Group, so we must adjust the prices of the two components in the Group, so they together total $80. When an order for GIFT_PACK in the DTC Platform is placed, and it is sent to QB, the Group price is the same $80 value.
The pricing set on your products in your DTC Platform is always the price used in the order received into Quickbooks, with the single exception of a Group product.
In our example, assume the price of the two items in GIFT_PACK were reduced from $50 to $40 so the Group price would match the Bundle price set in WD. However, we still want to sell one of the individual items separately for $50. Since the price for the single item is still $50 in the DTC Platform, and the pricing is the price set in the order, the $50 price is used, regardless of the price in QB.
This means that in QB, these two bundled items can be set to be $40 to accomodate the GIFT_PACK Group properly. If it sells for $50 in your DTC Platform, that proper price of $50 will still pull through into QB.
In cases when a Bundle in your DTC Platform needs to be discounted or sold for a lower price, we need to create an Item in Quickbooks setup as an “Other Charge” with the name of Discount or Bundle Discount. This is designed to map exactly with whenever you discount a bundle in your ecommerce system.
Example: Let’s assume for Black Friday, we place our GIFT_PACK bundle on sale for $70 over the standard price of $80, but this is just an additional discount for the day, not a permanent change. In the DTC Platform, we can create a Promo, which will then be a Bundle Discount in the order as it is carried over to QB.
In QB, the order will show now as a GIFT_PACK sold at $80 with a Bundle Discount of $10, for a total, final price of $70. Since the Bundle Discount was used, no change in the QB pricing is necessary. The price of this Bundle Discount doesn’t actually matter as the amount that was discounted automatically pulls over from your DTC Platform into Quickbooks.