Email & SMS Reminders

Documentation

Go to System -> Users -> User Groups and give a desired group permissions to access and modify module/reminders. After that go to Extensions -> Modules, find Order Manager and setup accordingly.

How to use

The actual usage of this extension is pretty simple: enter number of days, select desired options and set a cron job to run in a given period of time. Cron link can be found in extension settings. If you don't know, how to setup cron, contact your hosting provider on the matter.

Global options:

• Action Link - Link for your cron job (see below).
• Action Secret - Random number of characters for cron link to avoid false script executions.
• Emails Limit - How many emails should be sent per cycle. Useful to avoid being banned for spamming by hosting provider.
• Send Report - Cron job report will be sent to your main store email.
• SMS Link - Your SMS provider action link to send SMS reminders.
• Add Signature - Add signature to every outgoing email.
• Signature - Signature text.
• Check Version - Check for new extension's version. Disable, if settings page is loading too slow and "No connection to server" message is displayed.
• Debug - When enabled, essential information will be saved in error log for further debugging. Disable this option, when not needed!
• Status - Quickly disable/enable extension.

SMS options:

• SMS Link - Your SMS provider action link to send SMS reminders.
• SMS on Register - Send SMS on customer registration.
• SMS on Login - Send SMS on each successful login attempt.
• SMS on Failure - Send SMS on each failed login attempt.
• Register SMS Text - SMS text for SMS on Register.
• Login SMS Text - SMS text for SMS on Login.
• Failure SMS Text - SMS text for SMS on Failure.

Reminder options:

• Title - User friendly reminder title for tab and report (HTML supported).
• Type - Which part of your store reminder affects: cart or order.
• Test Mode - When checked, items will be processed and counted, but neither action applied nor email sent.
• Period - Days passed since order was last added or modified or last customer activity recorded (for carts).
• Date Since - Date, when order or action was last added or order was modified.
• Action - What you want to do with order or cart, when reminder is processed.
• Order Statuses - List of order statuses to check for (orders only).
• Change To - Order status to change to (orders only).
• Recurring - All matching Orders will be processed multiple times in assigned period.
• Subscribed Only - Only customers, who subscribed to newsletter, will receive emails for this reminder.
• Add Comment - A comment will be added to order history (orders only).
• Comment Text - Some text for history comment (orders only).
• Notify Customer - A notification email will be sent to customer about his order or cart.
• HTML Email - Email will be sent in HTML format (No - in plain text)
• Email Subject - Any subject for email notification.
• Email Message - Any text for email notification.
• Customer Groups - Only orders from customers from selected groups will be processed.
• Status — Turns on/off the reminder.

When you done with setup, it is highly recommended to do a test run. Enable test mode for all your reminders and click the Action Link on General tab. A new window will open in your browser and you'll see a report right on screen. All possible error and success messages will be displayed out there. If everything looks good, you may disable test mode and go live.

NOTE: Be careful with the first run! Some reminders can send emails to ALL your orders. Do some testing first!

Reset and clear reminders

Sometimes it is necessary to reset all reminders, but don't send anything to customers to avoid duplicated emails. For example, when you did something wrong or new version with major update was released. To reset reminders, just add "reset" key to main URL and launch the script manually:

http://yoursite.com/index.php?route=module/reminders/cron&secret=XXX&reset=1

Reminder markers for all carts and orders will be removed and updated again. Emails will not be sent and customers will only get new reminders on the next run without "reset" key.

It is possible, that you'll loose some reminders upon reset. To minimize loses, run script manually BEFORE updating extension, then update it to new version and reset.

If you want to do a fresh start, use Clear Reminder button for each reminder separately instead of global reset. It will simply clear all markers for selected reminder from your database and allow you to send emails again.

SMS reminders

To send SMS reminders you need to find an SMS provider first and sign up for its services. Currently extension supports only providers, which provide an URL to send SMS. For example:

https://smsprovider.com/send.php?username=mylogin&password=123456&phone={telephone}&message={text}

To enable SMS sending functionality for your reminders take the action link from your provider and add it in SMS Link field in General settings. Add {telephone} and {text} tags to this URL like shown in the example above. When you run the script these tags will be replaced with customer's phone and SMS Text for currently processed reminder.

If you set everything, but SMS are not sent, enable Debug option. After that all responses from your SMS provider will be saved in error log and you will be able to find out the root of the issue. Disable this option, when issue is fixed and SMS processed properly!

{products} tag in SMS is replaced with the same products template, which is used for emails, but with stripped HTML tags. Do not change HTML template structure from table layout to something else! Otherwise SMS products layout will become broken.

NOTE: HTML is not supported in SMS text, all tags are stripped!

Using tags in reminders

To add any info about order or cart to message subject or body, signature or comment use tags: {tag_name}. Tag names should be typed strictly in Latin letters or they won't be processed!

Common tags:

• period - Number of days for current reminder.
• store_id - Your store ID.
• store_name - Your store name.
• store_url - Your store URL.
• store_telephone - Your store telephone.
• customer_id - Customer's ID.
• customer_group_id - Customer's group ID.
• customer_group - Customer's group name.
• firstname - Customer's first name.
• lastname - Customer's last name.
• telephone - Customer's phone number.
• fax - Customer's fax number.
• email - Customer's email.
• products - List of order or cart products.

Carts only:

• Any customer specific field name from "customer" table.

Orders only:

• order_id — Order ID.
• order_url — Order link in history.
• invoice_no — Invoice number.
• invoice_prefix — Invoice prefix.
• comment — Order comment.
• order_status — Order status name.
• Any order specific field name from "order" table.

Tag processing algorithm is very simple and absolutely fail safe. First, the script will read all available fields from "order" or "customer" tables: order_id, customer_id, firstname etc. Then it will take each field one by one and wrap its name in curly brackets {}, turning it into tag: {order_id}, {customer_id}, {firstname} etc. After that the script will search for tag in email text or comment and replace it with actual field value, if found.

If certain tag is not replaced with its value, there can be only two reasons: tag is not properly defined or there's no such field in given table. Most likely reason is wrong tag name, which can seem typed properly sometimes. For example, this tag name seems proper, but it's not: {firstnаme}. It has letter "a" typed in Cyrillic and thus will not be processed. Same can happen with other languages and keyboard layouts.

If you're having an issue with tag processing, check, that they all are typed correctly and in Latin letters only. There's no and can NOT be any other reason for tags not processing as expected besides two reasons mentioned above.

Custom tags

If you need to add some data from other tables, use Custom Tags option under General tab in extension settings. This option allows you to add literally any data you want in both SMS and email reminders. To add a custom tag click the Add Tag button at the bottom row of the table and enter necessary data (all fields are required!):

• Tag - Your custom tag name.
• Field - Field to take data from.
• Table - Table to take data from.
• Where - MySQL WHERE clause to select only single value by given parameters. You can use standard tags here (see above).

For example:

• Tag: shipping_cost
• Field: value
• Table: order_total
• Where: order_id={order_id} AND code='shipping'

This will be transformed into standard MySQL query, replacing {order_id} with current order tag:

SELECT `value` FROM `order_total` WHERE order_id=1 AND code='shipping'

If you add {shipping_cost} tag to your reminder, it will be then replaced with returned shipping cost for current order similar to standard tags.

NOTE! Custom Tags option requires understanding of MySQL basics. You must add field, table and especially WHERE clause properly, otherwise extension will stop working due to MySQL error.

Free support for MySQL errors caused by improperly added custom tags is not provided!