How to: Multiple Prices for a product

[Gaby_Pena]

Hi again!
So, I said in an earlier post, I have a small CBD distribution business.
We sell retail but we also sell to stores that re-sell the product… I’d like to be able to have multiple prices for every product i.e. retail price, wholesale price 1, wholesale price 2… I’m stuck…

Anyone out there who can help me out?

Thanks!

[Justin_Barrett]

My first inclination is to use a [Products] table, with fields to accommodate the various prices you want to use. In another table you would link to the product, and use something like a {Price Type} Single Select field to specify what type of price should be applied. Lookup fields (hidden) would bring in all prices for the selected product from the [Products] table, and a formula field would apply the correct price based on the Single Select choice.

[Gaby_Pena]

Thank you for the reply!
I’m going to try and do that :stuck_out_tongue:

[Gaby_Pena]

I have my product table made with another table for the Sales Orders… how do I “hide” the Lookup fields?

[Justin_Barrett]

Gaby_Pena:

how do I “hide” the Lookup fields?

Right-click (or click the downward arrow on the right end of) the header of a field to bring up its contextual menu, and choose “Hide Field” near the bottom. You could also use the Hidden Fields tool in the table toolbar (between the view name and the Filter tool)

[Gaby_Pena]

Thanks for taking the time Justin (: I appreciate it

[Gaby_Pena]

Can’t seem to make that work… )’:

[Justin_Barrett]

Can you be more specific? Describe the exact steps you’re following, and the exact results you get when doing so.

[Gaby_Pena]

I don’t know how to apply a formula to a single select field…

[Gaby_Pena]

When making a Single Select table, it only lets me add random numbers, not something linked to the product…