There will be times where 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 1
I want to be able to add multiple of the same product to the order at once, all values will be the same.
A
B
C
D
E
1
Generic Product 22/11/2019 | Unique Option Name
ITEMWIDTH
ITEMHEIGHT
ITEMDEPTH
QTY
2
Inventory Code for Pricing
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
Depth
Quantity
8
Option Type
R
R
R
&
9
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
18
Answers from here down
2800
2800
2800
19
Answers from here down
Not Recommended
Not Recommended
Not Recommended
20
1000
1000
1000
21
3000
3000
3000
22
Invalid size
Invalid size
Invalid size
23
The Qty values can be seen the in red boxes below
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 |
