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.
You may want a rail, track, pelmet, chain, post or something that isn't necessarily the same size as the Fabric
The Values in Yellow will not affect the values in Blue
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 |
Purpose
The table below has a component that requires its own value for the width, - Click here for an example where the component uses the width field from the Fabric
We want the component (or Inventory item) in Column E to not affected by the values entered into Columns B, C or D and requires its own value in column F
To make this happen we need to let inform BUZ that we are not using the standard headings (ITEMWIDTH, ITEMHEIGHT, ITEMDEPTH) to determine the Width, Height or Drop
Setup
I have created a heading in Column E - COMPWIDTH, (you can rename this for your products it is not a defined name)
Next I need to refer to this Heading in row 3 of columns E & F, I have entered COMPWIDTH
This is because column E is where the Inventory Item is selectable,
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 Field | ITEMWIDTH | 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 |
Setup is for Height
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 Field | ITEMHEIGHT | 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 |
Setup is for Depth
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 Name | COMPDEPTH | COMPDEPTH | |||
4 | Related Column Data Field | ITEMDEPTH | 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 - Drop | Drop |
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 |
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 | 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 |