Step 1 – New Bundle Title and Shipping
1a. Brand
1b. Model Number
1c. Description (Check the Brands website for title information)
2b. Model Number
2c. Description (Check the Brands website for title information)
*Before moving forward make sure that you have your information input into the “brain” grid*
BUNDLE PRICING / BUNDLE SPREADSHEETS
All Bundle pricing can be found in Brand Grids under tab “Brand Managers”. We use the VLOOKUP formula to calculate the bundle price. Which we will go over below.
The Brain of the bundle will indicate which brand grid to look under. Example Denon AVR-X2700H 7.2 Ch AV Receiver | Klipsch R-620FB Reference 5.1 Speaker Bundle #1 would be under the Denon grid as it is the power source or the “brain”.
We use the product ID# as the SKU with bundles which can be found in the WooCommerce backend product tab, when hovering over a product it will show the product number in light grey, When you first create a listing from scratch it will be in the url as well. Ask your trainer if you are unsure.
VLOOK UP FORMULA FOR BUNDLES
1.$H129 represents what you want to look up
2.”https://docs.google.com/spreadsheets/d/1j7R3ob38u4r7rkEyDOXLpT9vl7r_VaDidfbRRb92BTU/edit#gid=1668378313 – is the url in which you are searching
3.”Duane / Sales! is the tab in which you are searching
4.A:H is the columns in which you will be searching
5.4, is the column in which it will take the data from.
6.0 is to end the formula with a true statement
Adding a Bundle to Fishbowl
You will need to create the bundle first keep it as a draft and use the product id # as the bundle sku.
Under Materials -Product – Select the drop down menu on New button and select New Kit.
