Updating Catalog in Microsoft Access

[AviaTech]

I am updating prices in Catalog. Is there a document that defines the Tables and Field Names in ActinicCatalog.mdb so I can use Microsoft Access to update prices in groups rather than each one separately in Catalog? Which Table and Field Name contains Item Prices?

[chrisbrown]

Table: Product
Field: Price

[Jan]

If you have business you can define your table and so long as you use the same product references you can edit your prices in access and then link them into catalog using external linking.

You can also import data to catalog using comma separated files.

If you really want to edit prices in the actinic database, bear in mind that prices are stored all over the place, they are in the product table (product pricing) and the product property table (component pricing, overridden prices for price schedules and overridden prices for permutations). Then again if you only use product pricing then it is a simple as Chris said - prices are stored * 1000 on the database BTW.

I don't know of a generally available database schema document for Actinic.

Regards

[chrisbrown]

Yes Jan - I was assuming only simple product pricing.

prices are stored * 1000 on the database

It's *100 actually i.e. in pence or cents (or centimes, paise, puls, gopiks, fils, lumas, ore, etc) .

[Jan]

Yes 100, sorry that was a rather unfortunate typo.

Regards

[AviaTech]

Thank you both for your input. I have found I can segregate the component prices I need to update using filters on sString1 in the ProductProperties table.

[AviaTech]

Thank you both for your input. I have found I can segregate the component prices I need to update using filters on sString1 in the ProductProperties table.