Multiple products with multiple quantity values
- Alex Morrisson
This example is a little complicated.
In column D you can set how many overall products you need for the order, this QTY will also select how many components you want to add.
But if you need to add an extra component per product you can also increase the amount in Column F
| A | B | C | D | E | F |
|---|---|---|---|---|---|---|
1 | Generic Product 22/11/2019 | Unique Option Name | ITEMWIDTH | ITEMHEIGHT | QTY | COMPONENT | COMPONENTQTY |
2 | Inventory Code for Pricing |
|
|
|
|
|
3 | Value applies to Price from Related Option Name |
|
|
|
| COMPONENT |
4 | Related Column Data Field |
|
|
|
| QTY |
5 | Related Column is Add (Y) to else Set to (N) |
|
|
|
|
|
6 | Look Back @ BUZ Column Name |
|
|
|
| COMPONENT |
7 | Question Heading | Width | Drop | Quantity | Extra Product | QTY |
8 | Option Type | R | R | & | 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|INVCOSEH5 | YES| |
18 | Answers from here down | 2800 | 2800 |
| NO | NO| |
19 | Answers from here down | Not Recommended | Not Recommended |
|
|
|
20 | 1000 | 1000 |
|
|
| |
21 | 3000 | 3000 |
|
|
| |
22 | Invalid size | Invalid size |
|
|
| |
23 |
|
|
|
|
|
|
The Qty values can be seen the in red boxes below
To explain what is happening above
Line 1 has 1 product and 1 Component
Line 2 has 2 products and 2 Components (1 for each product)
Line 3 has 1 products and 2 Components
Line 4 has 2 products and 4 Components (2 for each product)
Component details for reference.