Base Price Contingent on multiple fields in table

Help Please,
Would like to modify PowerStore 2 for pricing from look up query need help,?
Here is a sample of Price Table,
(pcode=Product Code),(width=width),(drop=Length),(table=Price Table name),(price0=BasePrice),(price1=option1),(price2=option2),(price3=option3)

Prices would be contingent on pcode,width,drop

pcode | width | drop | table | price0 | price1 | price2 | price3
10000 | 24.000 | 30.000 | wb2in | 113.00 | 8.00 | 0.00 | 0.00
10000 | 24.000 | 36.000 | wb2in | 129.00 | 8.00 | 0.00 | 0.00
10000 | 24.000 | 48.000 | wb2in | 154.00 | 8.00 | 0.00 | 0.00
10000 | 24.000 | 54.000 | wb2in | 170.00 | 8.00 | 0.00 | 0.00
10000 | 24.000 | 66.000 | wb2in | 203.00 | 8.00 | 0.00 | 0.00

Thanks in advance

You can achieve this behavior through the add product options functionality built into powerstore. You can change the price based on the options selected.

Basically when you add or edit a product, add options to it and on the Add Options page, there is a button labeled: "Click Here To Manage Options", which allows you to put certain options available online or not available online. After making the options you want available online, you can go back to the product update page for that product and set the prices based on the options. You will also be able to change the description for each set of different options chosen.

So in your case, you'd add options for pcode, width, and drop and the different options that they have. Then you'd go to update product and select each of the different options combination that you want to set a different price for.

The Cart I am trying to build has many many variations and options for widths and lengths

Thanks for your help so far but I am still not sure on how to proceed I tried your method but when I added about 10 options it shut down my store trying to query.

Loyd

Is there any way you can reduce the number of options on the product or values in each option?

Basically modifying Powerstore to look up the price from the table you've set up would require quite a bit of hand coding. There may be users that can help you with this or you can hire someone by posting this in the Job Board.