Multiple products with multiple quantity values independent of the product QTY
- Alex Morrisson
In this example we will have 1 or multiple products but the components will have an independent values.
In column D you can set how many overall products you need for the order, and then in Column E you can set the Component value.
Note: If you expand the lines (in the finalise area) this will change the amount of components allocated to each product, I will show you an example below.
| A | B | C | D | E |
|---|---|---|---|---|---|
1 | Generic Product 22/11/2019 | Unique Option Name | ITEMWIDTH | ITEMHEIGHT | QTY | COMPONENT |
2 | Inventory Code for Pricing |
|
|
| INVCOSEH5 |
3 | Value applies to Price from Related Option Name |
|
|
|
|
4 | Related Column Data Field |
|
|
| QTY |
5 | Related Column is Add (Y) to else Set to (N) |
|
|
|
|
6 | Look Back @ BUZ Column Name |
|
|
|
|
7 | Question Heading | Width | Drop | Quantity | Extra Product |
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 |
| 1 |
18 | Answers from here down | 2800 | 2800 |
| 2 |
19 | Answers from here down | Not Recommended | Not Recommended |
| 3 |
20 | 1000 | 1000 |
| 4 | |
21 | 3000 | 3000 |
| 5 | |
22 | Invalid size | Invalid size |
| 6 | |
23 |
|
|
|
| 7 |
|
|
|
|
|
|
To explain what is happening above
Line 1 has 1 product and 1 Component
Line 2 has 2 products and 1 Component (if you expand this a second component will be added with a price increase)
Line 3 has 1 products and 2 Components
Line 4 has 2 products and 2 Components (1 for each product)
Example for expanding
If you have multiple products and multiple components once you expand the lines the Components will stay at the original value and duplicate to the new product lines.
In this example we have 3 Products with a total of 2 Components.
Once expanded we still have 3 products (which you can see individually) but now we have 2 Components per line/product and the total price has been updated to reflect the new components.