Base Price Schedule

[Owen Drumm]

I have two prices listed in the price schedules as Retail and Trade respectively. The Retail is the base price. Is there any way of changing it so that the Trade price is now the base price and deleting the Retail price from the schedule?

TIA

[Jan]

You cannot remove the retail price schedule. I would suggest using access or excel to directly ammend the prices using a SQL query or a formula. Bear in mind that prices can appear in the product properties table as well as the product table.

Regards,

[Owen Drumm]

Thanks but it wouldn't work as there are literally hundreds of prices and the percentage ratios are all different. I guess it means changing each price individually and changing the name Retail to Trade

[cdicken]

I think you can just open the Access Database and then copy and paste the 'Price' column from the 'Product' table into 'Excel'. Then, multiply all the numbers by the same amount and paste them back into the Access database.

This should work OK, but do take a database backup before.

[harryha]

Hi
I don't understand what you mean when you say open the access database, how do you do this?
thanks
harryha

[cdicken]

All Actinic data is stored in an Access-style database called 'ActinicCatalog.mdb', which is within the 'Site1' (or equivalent) folder. You can edit this database directly if required, but make sure you back up your store beforehand.