Excluding externally-linked products from marketing?

[Sadcase]

We have the main products of our site linked to a Sage database via Actinic Link. However we also have some second-hand items available which are not included in the Sage database, but are stored in a separate Access database file. This is added to the online store via the 'external links' in Actinic.

Unfortunately, these second-hand items are included by default in the marketing lists (new products, also bought, related items) - but we don't want them to be.

My questions is: can these be excluded in an easy way with the minimum of effort?

When we were using v7, we created fields in the database which held the information used by Actinic (template used, stock, price etc.) which were then mapped to the relevant fields in the 'External links' window.

However, I can't see any field in this window that links through to the 'include in marketing' checkboxes that appear on each product under the marketing tab. I had originally hoped to be able to create a field in the database (with a value of 'false') which, when linked, would in effect turn off all of the marketing for these products.

Can someone please advise if there any way of doing this automatically?

My other alternative is to turn the marketing off on each product manually, which I don't want to do, as we have 1,125 items in the second-hand database …

[Kiran]

Hi Mark

I'm afraid there is no easy way of doing this. You will have to use the marketing tab. The only way I can see this being done is if you create a sql query to run on the database.

Kind regards
Kiran

[Sadcase]

Thanks Kiran,

I'd figured as much, but just thought I'd check.

Is this something that can be added to the wish list for version 9? Perhaps adding the ability to exclude specific product groups from marketing items (which would make it available for both imported products and externally-listed products)?