...
Next I need to refer to this Heading in row 3 of columns E & F, I have entered COMPWIDTH
...
The next thing we need to do is to tell BUZ what type of value we want, so for this first table I require a width to be entered, Column E & F row 4 I have specified this by entering in the BUZ Keyword for width “ITEMWIDTH”
A | B | C | D | E | F | ||
1 | Test 2 16/11/2020 | Unique Option Name | ITEMWIDTH | ITEMHEIGHT | ITEMDEPTH | COMPWIDTH | COMPWIDTHVALUE | |
2 | Inventory Code for Pricing | ||||||
3 | Value applies to Price from Related Option Name | COMPWIDTH | COMPWIDTH | ||||
4 | Related Column Data FieldITEMWIDTH | ITEMWIDTH | |||||
5 | Related Column is Add (Y) to else Set to (N) | ||||||
6 | Look Back @ BUZ Column Name | ||||||
7 | Question Heading | Width | Drop | Depth | Component - Width | Width | |
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 | PG 100-5000 | |||||
16 | Picture URL | ||||||
17 | Answers from here down | 1000 | 1000 | Price Grid|INVPG25 | |||
18 | Answers from here down | 5000 | 5000 | Pricing Coefficient|INVCOSLMW1 | |||
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|INVCOSLMW10 | |||
20 | 1 | 1 | |||||
21 | 11000 | 11000 | |||||
22 | Range must be within 1-11000 | Range must be within 1-11000 |
...
1 | Test 2 16/11/2020 | Unique Option Name | ITEMWIDTH | ITEMHEIGHT | ITEMDEPTH | COMPHEIGHT | COMPHEIGHTVALUE | |
2 | Inventory Code for Pricing | ||||||
3 | Value applies to Price from Related Option Name | COMPHEIGHT | COMPHEIGHT | ||||
4 | Related Column Data FieldITEMHEIGHT | ITEMHEIGHT | |||||
5 | Related Column is Add (Y) to else Set to (N) | ||||||
6 | Look Back @ BUZ Column Name | ||||||
7 | Question Heading | Width | Drop | Depth | Component - Height | Height | |
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 | PG 100-5000 | |||||
16 | Picture URL | ||||||
17 | Answers from here down | 1000 | 1000 | Price Grid|INVPG28 | |||
18 | Answers from here down | 5000 | 5000 | Pricing Coefficient|INVCOSLMH1 | |||
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|INVCOSLMH10 | |||
20 | 1 | 1 | |||||
21 | 11000 | 11000 | |||||
22 | Range must be within 1-11000 | Range must be within 1-11000 |
...
A | B | C | D | E | F | |
1 | Test 2 16/11/2020 | Unique Option Name | ITEMWIDTH | ITEMHEIGHT | ITEMDEPTH | COMPDEPTH | COMPDEPTHVALUE |
2 | Inventory Code for Pricing | |||||
3 | Value applies to Price from Related Option NameCOMPDEPTH | COMPDEPTH | ||||
4 | Related Column Data FieldITEMDEPTH | ITEMDEPTH | ||||
5 | Related Column is Add (Y) to else Set to (N) | |||||
6 | Look Back @ BUZ Column Name | |||||
7 | Question Heading | Width | Drop | Depth | Component - DropDepthDrop | Depth |
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 | Price Grid Small 1-10|INVPG31 | ||
18 | Answers from here down | 5000 | 5000 | Price Grid Large|INVPG32 | ||
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|INVCOSLMD1 | ||
20 | 1 | 1 | Pricing Coefficient 10|INVCOSLMD10 | |||
21 | 11000 | 11000 |
...
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 |
Unknown value shows up for the component
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
...
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 NameCOMPWIDTH | 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 | |||||
...