...
On this page we will creating a Component (Inventory item) that has 2 requirements which have no relation to the Material/Fabric values
...
The Values in Yellow will not affect the values in Blue, Below are 2 examples that you can see on this page, there are plenty of other setups that you can do that involve Width, Height, Depth and or QTY
These Values will not affect | These values | |||||
Fabric | width | Height | Drop | Component | Width | Height |
Fabric | width | Height | Drop | Component | Height | QTY |
Setup
The table below has a component (Inventory item) listed in Column E, that requires its own value for the Width and Height.
...
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 and Height to be entered. Column F/Row 4 I have specified this by entering in the BUZ Keyword for width “ITEMWIDTH” and for Column G/Row 4 “ITEMHEIGHT”
You can also add or substitute ITEMDEPTH, or QTY if required.
A | B | C | D | E | F | G | |
1 | Test 2 16/11/2020 | Unique Option Name | ITEMWIDTH | ITEMHEIGHT | ITEMDEPTH |
COMPHEADING | COMPWIDTH | COMPHEIGHT | |||||
2 | Inventory Code for Pricing | ||||||
3 | Value applies to Price from Related Option Name |
COMPHEADING |
COMPHEADING | |||||||
4 | Related Column Data Field | ITEMWIDTH | 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 | Width of component | 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 Height
A | B | C | D | E | F | G |
H (Optional)
1 | Test 2 16/11/2020 | Unique Option Name | ITEMWIDTH | ITEMHEIGHT | ITEMDEPTH |
COMPHEADING | COMPHEIGHT | COMPQTY |
2 | Inventory Code for Pricing | ||||||
3 | Value applies to Price from Related Option Name |
COMPHEADING |
COMPHEADING |
COMPONENT
4 | Related Column Data Field | ITEMHEIGHT | 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 | Height of component | QTY |
of components | |||||||
8 | Option Type | R | R | & | L | & | & |
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 |
Yes
18 | Answers from here down | 5000 | 5000 |
Product 2| |
INVCOSLMW1 |
No
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 |