Recent releases of ASPDotNetStorefront have an updated promotion engine with a lot more flexibility for managing your eCommerce promotions.
However, once you have a lot of promotion codes in your store, you may find it difficult keeping track of the active/unexpired promotions in your database. If this is the case, this SQL Statement will give you all active promotion codes in descending expiry date order:
select Code, Description, AutoAssigned,
CAST(CAST(CAST(PromotionRuleData AS XML).query('data(//PromotionRuleBase/ExpirationDate)') as varchar(100)) as datetime) as expires
where Active = 1
order by expires desc
Tags3d Add new tag apple asp aspdotnetstorefront backups bugzilla cgi chrome cloud computing cms content management CRM css Document Management drupal ecommerce expression engine flash google hiring host hosting img_assist interprise JQuery KnowledgeTree mac mamp modules mouse nginx opencart php PRINCE2 printer project management snow leopard ssl tinymce Tips translation unix webgains wordpress