Update permutation Pricing with Access

[jliveston]

My client has spent the last few days creating their catalog. Each product of the catalog has permutations with pricing.

Here is an example:

Photo A
5x7" = 5.00
8x10= 7.00
11x7=10.00
sheet of wallets = 10.00

They have about 250 products and all the permutations are the same, 5.00,7.00,10.00 and 10.00.

But they have just realized that each of the prices need to be changed say, 6.95,7.95,10.95,10.95.

They don't want to fix all four permutation prices for all 250, making a total of 1000 changes, so I have seen where people have updated prices with simple pricing using a query in the Access database but am curious on where the permutation prices are stored as well as what the query would look like to correct this issue.

Any ideas would be great.
Thanks,
Jason

[Jan]

The permutation prices are stored in the productProperties table.
For a permutation, nType will be 8 and the price is stored in the field called nValue1.

Regards,

[jliveston]

Hi,

Thanks for the reply. I actually looked around and found the productproperties table. I created a few update queries in Access because I also had to change the description that is displayed from sString1 and sString3 as well, I then created a module and called all the queries and it works like a charm.

Instead of using nType I used the bFlag1 field that is set to -1. I assume this is always -1 or should I use nType.

Thanks,
Jason

[Jan]

Use nType, the productProperty table is used for all sorts of data, and the nType field determines what type of thing is held in the row in the table.

Regards,