Group Options Quantity
- Alex Morrisson
There will be times when you may need to add more than one product or component to an order. The examples below will show you how to set up the questions so that you can price for multiple items.
Scenario 2
One inventory item with an option to select multiple
On the right is an example of an inventory item with a pricing Co-Efficient
Both Columns E & F do the same thing
Column E allows you to have different Inventory Codes
Column F will only price from the one Inventory Item
(In the example below)
| A | B | C | D | E |
OR | E |
|---|---|---|---|---|---|---|---|
1 | Generic Product 22/11/2019 | Unique Option Name | ITEMWIDTH | ITEMHEIGHT | ITEMDEPTH | TEST1 | TEST2 | |
2 | Inventory Code for Pricing |
|
|
|
| INVCOSEH1 | |
3 | Value applies to Price from Related Option Name |
|
|
|
|
| |
4 | Related Column Data Field |
|
|
| QTY | QTY | |
5 | Related Column is Add (Y) to else Set to (N) |
|
|
|
|
| |
6 | Look Back @ BUZ Column Name |
|
|
|
|
| |
7 | Question Heading | Width | Drop | Depth | Hood Ext Brkts | Hood Ext Brkts | |
8 | Option Type | R | R | R | L | L | |
9 | Is Required | Y | Y |
|
|
| |
10 | Can Mass Update |
|
|
|
|
| |
11 | Clear value when Copied to new item |
|
|
|
|
| |
12 | Is Not for Online Wholesale Ordering |
|
|
|
|
| |
13 | Is Not for Shopping Cart Ordering |
|
|
|
|
| |
14 | Use First valid Answer as default |
|
|
|
|
| |
15 | Help Message |
|
|
|
|
| |
16 | Picture URL |
|
|
|
|
| |
17 | Answers from here down | 1000 | 1000 | 1000 | 1|INVCOSEH1 | 0 | |
18 | Answers from here down | 2800 | 2800 | 2800 | 2|INVCOSEH1 | 1 | |
19 | Answers from here down | Not Recommended | Not Recommended | Not Recommended | 3|INVCOSEH1 | 2 | |
20 | 1000 | 1000 | 1000 | 4|INVCOSEH1 | 3 | ||
21 | 3000 | 3000 | 3000 | 5|INVCOSEH1 | 4 | ||
22 | Invalid size | Invalid size | Invalid size |
| 5 | ||
23 |
|
|
|
|
|
|
By adding QTY in Row 4, tells BUZ that there is a Quantity associated with the inventory and to ignore any other QTY values the sheet may have
| E |
OR | F |
1 | TEST1 | TEST2 | |
2 |
| INVCOSEH1 | |
3 |
|
| |
4 | QTY | QTY | |
5 |
|
| |
6 |
|
| |
7 | Hood Ext Brkts | Hood Ext Brkts | |
8 | L | & |
Scenario 3
Add Multiple Products with Multiple components to match
Row 4 no longer has QTY; the Inventory will be controlled by Column D’s QTY value
| A | B | C | D | E |
OR | E |
|---|---|---|---|---|---|---|---|
1 | Generic Product 22/11/2019 | Unique Option Name | ITEMWIDTH | ITEMHEIGHT | QTY | TEST | TEST | |
2 | Inventory Code for Pricing |
|
|
|
| INVCOSEH1 | |
3 | Value applies to Price from Related Option Name |
|
|
|
|
| |
4 | Related Column Data Field |
|
|
|
|
| |
5 | Related Column is Add (Y) to else Set to (N) |
|
|
|
|
| |
6 | Look Back @ BUZ Column Name |
|
|
|
|
| |
7 | Question Heading | Width | Drop | Quantity | Hood Ext Brkts | Hood Ext Brkts | |
8 | Option Type | R | R | & | L | L | |
9 | Is Required | Y | Y |
|
|
| |
10 | Can Mass Update |
|
|
|
|
| |
11 | Clear value when Copied to new item |
|
|
|
|
| |
12 | Is Not for Online Wholesale Ordering |
|
|
|
|
| |
13 | Is Not for Shopping Cart Ordering |
|
|
|
|
| |
14 | Use First valid Answer as default |
|
|
|
|
| |
15 | Help Message |
|
|
|
|
| |
16 | Picture URL |
|
|
|
|
| |
17 | Answers from here down | 1000 | 1000 |
| Yes|INVCOSEH1 | Yes | |
18 | Answers from here down | 2800 | 2800 |
| No| |
| |
19 | Answers from here down | Not Recommended | Not Recommended |
|
|
| |
20 | 1000 | 1000 |
|
|
| ||
21 | 3000 | 3000 |
|
|
| ||
22 | Invalid size | Invalid size |
|
|
| ||
23 |
|
|
|
|
|
|