Group Options - Materials and Independent Components part 2
- Alex Morrisson
Purpose
On this page we will creating a Component (Inventory item) that has 2 requirements which have no relation to the Material/Fabric values
You may want a rail, track, pelmet, chain, post or something that isn't necessarily the same size as the Fabric
Design
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.
We want the component (or Inventory item) in Column E to not be affected by the values entered into Columns B, C or D and requires its own value in column F and G
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 step is to link the Component’s width (Column F) and the Components Height (Column G) to the Component (Column E). To do this enter the Heading of the Component into the Width & Height Column in row 3 (Highlighted in Blue)
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 |
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 |
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 | & | & |
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 |
|
|
|
|