...
A | B | C | D | E | F | |
1 | Test 2 16/11/2020 | Unique Option Name | ITEMWIDTH | ITEMHEIGHT | ITEMDEPTH | COMPQTY | COMPQTYV |
2 | Inventory Code for Pricing | |||||
3 | Value applies to Price from Related Option Name | COMPQTY | COMPQTY | |||
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 | Component - QTY | 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 | |||
18 | Answers from here down | 5000 | 5000 | Pricing Coefficient|INVCOSEH1 | ||
19 | Answers from here down | This size is not recommended & Warranty will not apply! (1000 to 5800 ) | This Height not recommended! (1000 to 3500) | Pricing Coefficient 10|INVCOSEH10 | ||
20 | 1 | 1 | ||||
21 | 11000 | 11000 | ||||
22 | Range must be within 1-11000 | Range must be within 1-11000 |
You may notice that the size includes the height of the fabric, this shouldn’t affect the price if you have setup the price grid/pricing co-efficient correctly
unfortunately the system is designed to include this, there are other scenarios where you may need this information,
...
If you only want the entered value to show there is a trick that you can do which will remove the other value, in this scenario I want to remove the Height..
...
So I have added another question which will set the height to zero, the question does not need to have a numerical value, the example below is a List with a Yes/No question.
We just need these 2 values in a question somewhere after the Width, it doesnt need to be the next question it could be 3 or 4 column later, it just needs to have the HEADING and Data Field (ITEMHEIGHT for this example)
...
Test 2 3/12/2020 | Unique Option Name | ITEMWIDTH | ITEMHEIGHT | ITEMDEPTH | COMPWIDTH | COMPWIDTHV | COMPHEIGHT |
Inventory Code for Pricing | ||||||
Value applies to Price from Related Option Name | COMPWIDTH | COMPWIDTH | COMPWIDTH | |||
Related Column Data Field | ITEMWIDTH | ITEMHEIGHT | ||||
Related Column is Add (Y) to else Set to (N) | ||||||
Look Back @ BUZ Column Name | ||||||
Question Heading | Width | Drop | Depth | Component - Width | Width | Unrelated Question |
Option Type | R | R | & | L | & | L |
Is Required | Y | Y | ||||
Can Mass Update | ||||||
Clear value when Copied to new item | ||||||
Is Not for Online Wholesale Ordering | ||||||
Is Not for Shopping Cart Ordering | ||||||
Use First valid Answer as default | ||||||
Help Message | PG 100-5000 | |||||
Picture URL | ||||||
Answers from here down | 1000 | 1000 | Price Grid|INVPG25 | Yes | ||
Answers from here down | 5000 | 5000 | Pricing Coefficient|INVCOSLMW1 | No | ||
Answers from here down | This size is not recommended & Warranty will not apply! (1000 to 5800 ) | This Height not recommended! (1000 to 3500) | Pricing Coefficient 10|INVCOSLMW10 | |||
1 | 1 | |||||
11000 | 11000 | |||||
Range must be within 1-11000 | Range must be within 1-11000 | |||||
...