...
On this page I will show you how to set up a product that has a Component (Inventory item) that is independent from the Material/Fabric dimensions.
...
The Values in Yellow will not affect the values in Blue - Once the Material and its values have been completed, then the Component it the required value will be calculated
These Values will not affect | This value | ||||
Fabric | width | Height | Drop | Component | width |
Fabric | width | Height | Drop | Component | Height |
Fabric | width | Height | Drop | Component | Drop |
Setup
The table below has a component (Inventory item) listed in Column E, that requires its own value for the width which is listed in Column F, we also want the component (Inventory item) in Column E to not be affected by the values entered into Columns B, C or D.
To make this happen we need to inform BUZ that we are not using the standard headings (ITEMWIDTH, ITEMHEIGHT, ITEMDEPTH) to determine the Width, Height or Drop for the component.
...
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 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 |
COMPHEADING | COMPWIDTH | |||||
2 | Inventory Code for Pricing | |||||
3 | Value applies to Price from Related Option Name |
COMPHEADING | ||||||
4 | Related Column Data Field | ITEMWIDTH | ||||
5 | Related Column is Add (Y) to else Set to (N) | |||||
6 | Look Back @ BUZ Column Name | |||||
7 | Question Heading | Width | Drop | Depth |
Product that will be seletected | Width of component | |||||
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 |
Product 1|INVPG25 | |||
18 | Answers from here down | 5000 | 5000 |
Product 2|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) |
Product3|INVCOSLMW10 | ||||||
20 | 1 | 1 | ||||
21 | 11000 | 11000 | ||||
22 | Range must be within 1-11000 | Range must be within 1-11000 |
Setup is for Height
1 | Test 2 16/11/2020 | Unique Option Name | ITEMWIDTH | ITEMHEIGHT | ITEMDEPTH |
COMPHEADING | COMPHEIGHT | |||||
2 | Inventory Code for Pricing | |||||
3 | Value applies to Price from Related Option Name |
COMPHEADING | ||||||
4 | Related Column Data Field | ITEMHEIGHT | ||||
5 | Related Column is Add (Y) to else Set to (N) | |||||
6 | Look Back @ BUZ Column Name | |||||
7 | Question Heading | Width | Drop | Depth |
Product that will be seletected | Height of component | |||||
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 |
Product 1| |
INVPG25 | |||
18 | Answers from here down | 5000 | 5000 |
Product 2| |
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) |
Product3| |
INVCOSLMW10 | ||||||
20 | 1 | 1 | ||||
21 | 11000 | 11000 | ||||
22 | Range must be within 1-11000 | Range must be within 1-11000 |
Setup is for Depth
A | B | C | D | E | F | |
1 | Test 2 16/11/2020 | Unique Option Name | ITEMWIDTH | ITEMHEIGHT | ITEMDEPTH |
COMPHEADING | COMPDEPTH | |||||
2 | Inventory Code for Pricing | |||||
3 | Value applies to Price from Related Option Name |
COMPHEADING | ||||||
4 | Related Column Data Field | ITEMDEPTH | ||||
5 | Related Column is Add (Y) to else Set to (N) | |||||
6 | Look Back @ BUZ Column Name | |||||
7 | Question Heading | Width | Drop | Depth |
Product that will be seletected | Depth of component | |||||
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 |
Product 1 |
| |
INVPG25 | |||
18 | Answers from here down | 5000 | 5000 |
Product 2|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) |
Product3| |
INVCOSLMW10 | |||
20 | 1 | 1 |
Pricing Coefficient 10|INVCOSLMD10
21 | 11000 | 11000 |
Setup is for Quantity
Note, if you have a QTY Column for the product and a QTY for component Column these will multiply
A | B | C | D | E | F | |
1 | Test 2 16/11/2020 | Unique Option Name | ITEMWIDTH | ITEMHEIGHT | ITEMDEPTH |
COMPHEADING | COMPQTYV | |||||
2 | Inventory Code for Pricing | |||||
3 | Value applies to Price from Related Option Name |
COMPHEADING | ||||||
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 | Depth |
Product that will be seletected | QTY of components | |||||
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 |
Product 1| |
INVPG25 | |||
19 | Answers from here down | This size is not recommended & Warranty will not apply! (1000 to 5800 ) | This Height not recommended! (1000 to 3500) |
Product 2|INVCOSLMW1 | ||||||
20 | 1 | 1 | Product3|INVCOSLMW10 | |||
21 | 11000 | 11000 | ||||
22 | Range must be within 1-11000 | Range must be within 1-11000 |
Unknown value shows up for the component
...
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 | ||||
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 |
Product that will be seletected | Width of component | 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 | |||||
...