Updating Database..

[lee05]

I am trying to see what tables get updated with the different information.
At the moment I have added three customer groups and three customer accounts. I have then gone into the product within actinic (i am using the default installation so the the default site 1 data) For calculator I have given the three groups different prices. I then view the catalog database to see what tables are holding this info. The price table has nothing in it?? What is the reason for this table should it not hold the standard prices? Where do a see the prices for my different groups? What table is this information held in?

Thx in advance

[Bruce]

Hi Lee,

You will find the standard price for your product in the 'Product' table.

For calculator I have given the three groups different prices. I then view the catalog database to see what tables are holding this info. The price table has nothing in it?? What is the reason for this table should it not hold the standard prices?

This table is used if you use 'Quantity based pricing' on your products.

Where do a see the prices for my different groups? What table is this information held in?

The calculation basis for the different customer groups / price schedules are in the 'Price Schedules' table. You will not see the different prices each individual product in the Database, these are generated based on the customer group the customer belongs to and the price schedule attached to it via the scripts.

Kind regards,

[Jan]

For calculator I have given the three groups different prices.

The group prices will be in the productproperties table.

Regards