Components - Single Item + Quantity
Requirement for customers to be able to place an order for parts or components
Column B has the inventory item attached to the answer
Column C applies a QTY to the inventory items (which is optional for this setup)
Note
Row 3 refers to the Heading that is linked to the inventory
Row 4 has QTY which determines the value entered as an answer for this Column will be a quantity value
Column D Is for the Admin staff - once the order has been placed, the admin staff can check if there is stock and amend the values
Note
If you input “Y” into row 12 (Below in Red) customers who login to place orders will not see these questions
Column E would be used to set the new quantity value if it requires amending
Note
Row 3 refers to the Heading that is linked to the inventory
Row 4 has QTY which determines the value entered as an answer for this Column will be a quantity value
Column F Is used to set the new price
Note
Row 3 refers to the Heading that is linked to the inventory
Row 4 has AMT which determines the value entered as an answer for this Column will be a $dollar value
You could replace AMT with RRP
AMT will override any price in BUZ to be the value entered in
RRP will override the price but still factor in the customer discount if there is one.
A | B | C | D | |
---|---|---|---|---|
1 | Component 12/05/2020 | Unique Option Name | HEADING | SELLBYEACH | SQTY |
2 | Inventory Code for Pricing |
|
|
|
3 | Value applies to Price from Related Option Name |
|
| SELLBYEACH |
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 | SELL BY EACH | Component | Quantity |
8 | Option Type | H | L | & |
9 | Is Required |
|
|
|
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 |
| Bolt M4|BOLTM4 |
|
18 | Answers from here down |
| Bolt M6|BOLTM6 |
|
19 | Answers from here down |
| Bolt M8|BOLTM8 |
|
20 |
|
| Nut M4|NUTM4 |
|
21 |
|
| Nut M6|NUTM6 |
|
22 |
|
| Nut M8|NUTM8 |
|
23 |
|
| Washer M4|WASHERM4 |
|
24 |
|
| Washer M6|WASHERM6 |
|
25 |
|
| Washer M8|WASHERM8 |
|
Multiple Products seperated by Headings
A | B | C | D | E | F | G | |
---|---|---|---|---|---|---|---|
1 | Component 12/05/2020 | Unique Option Name | HEADING | SELLBYEACH | SQTY | HEADING | SELLBYEACH2 | SQTY2 |
2 | Inventory Code for Pricing |
|
|
|
|
|
|
3 | Value applies to Price from Related Option Name |
|
| SELLBYEACH |
|
| SELLBYEACH2 |
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 | SELL BY EACH - Product 1 | Component | Quantity | SELL BY EACH - Product 1 | Component - 2 | Quantity - 2 |
8 | Option Type | H | L | & |
| L | & |
9 | Is Required |
|
|
|
|
|
|
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 |
| Bolt M4|BOLTM4 |
|
| Bolt M4|BOLTM4 |
|
18 | Answers from here down |
| Bolt M6|BOLTM6 |
|
| Bolt M6|BOLTM6 |
|
19 | Answers from here down |
| Bolt M8|BOLTM8 |
|
| Bolt M8|BOLTM8 |
|
20 |
|
| Nut M4|NUTM4 |
|
| Nut M4|NUTM4 |
|
21 |
|
| Nut M6|NUTM6 |
|
| Nut M6|NUTM6 |
|
22 |
|
| Nut M8|NUTM8 |
|
| Nut M8|NUTM8 |
|
23 |
|
| Washer M4|WASHERM4 |
|
| Washer M4|WASHERM4 |
|
24 |
|
| Washer M6|WASHERM6 |
|
| Washer M6|WASHERM6 |
|
25 |
|
| Washer M8|WASHERM8 |
|
| Washer M8|WASHERM8 |
|
A | C | D | F | G |
|
| |
---|---|---|---|---|---|---|---|
1 | Component 12/05/2020 | Unique Option Name | SELLBYEACH | SQTY | SELLBYEACH2 | SQTY2 | SELLBYEACH3 | SQTY3 |
2 | Inventory Code for Pricing |
|
|
|
|
|
|
3 | Value applies to Price from Related Option Name |
| SELLBYEACH |
| SELLBYEACH2 |
| SELLBYEACH3 |
4 | Related Column Data Field |
| QTY |
| QTY |
| QTY |
5 | Related Column is Add (Y) to else Set to (N) |
|
|
|
|
|
|
6 | Look Back @ BUZ Column Name |
|
|
|
|
|
|
7 | Question Heading | Bolts | Quantity | Nuts | Quantity | Washers | Quantity |
8 | Option Type | L | & | L | & | L | & |
9 | Is Required |
|
|
|
|
|
|
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 | Bolt M4|BOLTM4 |
| Nut M4|NUTM4 |
| Washer M4|WASHERM4 |
|
18 | Answers from here down | Bolt M6|BOLTM6 |
| Nut M6|NUTM6 |
| Washer M6|WASHERM6 |
|
19 | Answers from here down | Bolt M8|BOLTM8 |
| Nut M8|NUTM8 |
| Washer M8|WASHERM8 |
|
20 |
|
|
|
|
|
|
|
21 |
|
|
|
|
|
|
|
22 |
|
|
|
|
|
|
|
23 |
|
|
|
|
|
|
|
24 |
|
|
|
|
|
|
|
25 |
|
|
|
|
|
|
|