How do your add an optional component to a product, where the component price will update and display on the web and the underlying price is modified via an Excel sheet?
For example if you sell product 1 and discrete 3 optional components with the following prices
1 $100
opt a $10
opt b $15
otp c $20
You want the customer to see the $100 price which they can, and the options prices listed against the options a,b or c. A, b, and c are not an attribute of a part but separate options.
I cannot find a way to have the Excel spreadsheet display the price in the description as the a, b and c prices are manually entered.
For example if you sell product 1 and discrete 3 optional components with the following prices
1 $100
opt a $10
opt b $15
otp c $20
You want the customer to see the $100 price which they can, and the options prices listed against the options a,b or c. A, b, and c are not an attribute of a part but separate options.
I cannot find a way to have the Excel spreadsheet display the price in the description as the a, b and c prices are manually entered.
Comment