I want to exclude all the clearance-priced items from special customer pricing. In other words, I don't want to put a customer discount on top of the clearance price. I have well over 1000 of these products, so I don't want to edit each one in Actinic to un-tick the customer price "enabled" box for each and every product. I'd rather do it in Microsoft Access. But I can't find the fields. What table are they in?
Announcement
Collapse
No announcement yet.
Where in the database is the price flag?
Collapse
X
-
The product properties table, however the rows are only created the first time you untick the box, so I think you might need to do this the long way around.
Export, change and import might make is a little quicker.
Regards,Jan Strassen, Mole End Software - Plugins and Reports for Actinic V4 to V11, Sellerdeck V11 to V2018, Sellerdeck Cloud
Visit our facebook page for the latest news and special offers from Mole End
Top Quality Integrated label paper for Actinic and Sellerdeck
A4 Paper with one or two peel off labels, free reports available for our customers
Product Mash for Sellerdeck
Link to Google Shopping and other channels, increase sales traffic, prices from £29.95
Multichannel order processing
Process Actinic, Sellerdeck, Amazon, Ebay, Playtrade orders with a single program, low cost lite version now available from £19.95
Comment