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, 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 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 | ||||
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 | 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 | ||||
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 | 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 | ||||
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 | Component - Depth | 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 |
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 | ||||
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 | 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
unfortunately the system is designed to include this, there are other scenarios where you may need this information,
If you only want the entered value to show there is a trick that you can do which will remove the other value, in this scenario I want to remove the Height..
So I have added another question which will set the height to zero, the question does not need to have a numerical value, the example below is a List with a Yes/No question.
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 | 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 | |||||
