Find an overview of the store compatibility on: MailBeez Compatibility.
The MailBeez Coupon Engine is a sub-module which sends out personalized coupons, and can be utilized by any MailBeez module that allows generation of coupons.
The Coupon Engine allows you to create persolized coupons that can be sent to specific customers or as part of any email campaign. Personalized coupons offer a number of advantages that result in better control over your coupon offers.
Generally, there are two types of coupon codes used within MailBeez - static and personalized.
Static coupon codes are generic codes that can be redeemed multiple times by any number of customers. Usually a static coupon uses a single coupon code with no or few restrictions. To redeem the coupon, all that is needed is the coupon code. Once the code has been distributed e.g. via email, there is not much you can do to control the proliferation of the coupon (viral effect). The unintended consequences can be a coupon that is used many times by the same customer, or redeemed more times than you initialy intended.
These issues can be addressed, in part, with personalized, limited use coupon codes. Rather than releasing a single coupon code to everyone, you can create individual codes for each customer.
In comparison to static coupon codes, there are a number of advantages to using personlized coupons:
The coupon engine generates personalized coupons based on template coupons which are assigned to the respective email modules.
A template coupon is a "normal" coupon, but is distinguished by the coupon CODE, which MUST start with the pattern
Make sure to view the helper section "How to set up a template coupon" in the Tour tab on your MailBeez admin panel.
Creating a Template Coupon
As an example, let's create a "Birthday Coupon":
The first step will be to create a new coupon with
and enter the values accordingly (e.g. 10% off) - the expiry date is not used.
In module Birthday coupon you can now assign this template coupon (remember to save your settings).
During the generation process of birthday emails, a personalized coupon is generated for every recipient based on the settings of the template coupon. In addition, a random coupon code and a dynamic expiry date - e.g. 14 days after date of sending is also generated.
You can test the setup by running a simulation: In Simulation-Mode, execute the module. This will generate "real" emails with "real" coupons, which is sent to the configured email address you entered. This allows you to validate the coupon settings, and to even make a test-order.
In this module you'll find a range of features which will help you to maintain your coupons:
Coupon Search: Find a coupon and edit it, also available as Dashboard-Widget zur Verfügung.
Delete Simulation Coupons: When running a simulation "real" coupons are generated. This button allows you to clean up the mess ;)
Delete expired Coupons: Clean up expired coupons
Repair sync: In case coupons are not assigned to message you can repair this assignment
Please note: In each module you can configure the length of the coupon code. Long codes (e.g. 8 or 10 characters) can be generated very efficiently. With shorter code lengths (and many existing codes), code generation might take longer until a free code is found. This can cause issues like time-outs during the sending process.
As the “mother of all eCommerce Systems", osCommerce is kept as a clean core without having addons like a coupon system.
You probably have already added a coupon system to osCommerce, and MailBeez supports a number of different coupon systems as listed below. The table names listed might help you to identify, which coupon system you are using.
In case you have not yet installed a coupon engine, we recommend a CCGV based addon.
There are a number of coupon system addons based on the “CCGV” coupon system, e.g.:
These addons utilize an almost identical database structure
You should find following tables in your table definition in case you are using a CCGV based coupon engine
TABLE_COUPONS TABLE_COUPONS_DESCRIPTION TABLE_COUPON_EMAIL_TRACK TABLE_COUPON_REDEEM_TRACK TABLE_COUPON_RESTRICT
You should find following tables in your table definition in case you are using a DCC based coupon engine
TABLE_DISCOUNT_COUPONS TABLE_DISCOUNT_COUPONS_TO_ORDERS TABLE_DISCOUNT_COUPONS_TO_CATEGORIES TABLE_DISCOUNT_COUPONS_TO_PRODUCTS TABLE_DISCOUNT_COUPONS_TO_MANUFACTURERS TABLE_DISCOUNT_COUPONS_TO_CUSTOMERS TABLE_DISCOUNT_COUPONS_TO_ZONES
If you use a DC-based voucher system, you should find the following tables in the table definition:
In case you are using the fork Discount Codes BS http://addons.oscommerce.com/info/9460:
This module is not using constants to define tables, so please add following definitions to your system by creating a new file
with the content
<?php define('TABLE_DISCOUNT_CODES', 'discount_codes'); define('TABLE_CUSTOMERS_TO_DISCOUNT_CODES', 'customers_to_discount_codes'); define('FILENAME_DISCOUNT_CODES', 'discount_codes.php');
This will define the missing constants.
osCommerce 2.x coupon system required
MailBeez.io API V2
Found errors? Think you can improve this documentation? edit this page