External data experiments

[lazyeye]

When you add a custom property, or variable rather, you can link it to your external product database. For instance, if I add the variable discounOff and add a corresponding column in my products database, then I can easily set this property for all products via a simple sql query.
Doing that however has two limitations, one of which I don't really understand:

First: Every change made, within actinic, to either a product or the catalog tree, takes a few minutes to take effect. Working on the catalog becoms therefore a painfully tedious experience.

Second: Values of custom variables are not set for product containers. This makes sense because those containers are not in the products database. You can however retrieve those in the Product table of the ActinicCatalog database. But I wonder if you can add a column within that table, a column that could hold values that would then be read from within actinic.

[Duncan Rounding]

External linking can certainly slow down Actinic.
Not sure about you point 2 - but be very careful of side effects when dabbling directly with the database.

[Jan]

But I wonder if you can add a column within that table, a column that could hold values that would then be read from within actinic.

This wouldn't work and might well break Actinic.

Regards,