if you are using the PrestaShop ecommerce platform and would like to engage into email marketing with your customers then you will probably find this article interesting.

You will see how to map nuevoMailer to PrestaShop, import and synchronize your customers with nuevoMailer mailing lists.
Taking it a step further you will also see how to import the last order date, total number of orders and total revenue by customer.
Using nuevoMailer advanced search you can perform customer segmentation, setup autoresponders, send order follow-up emails to customers or reminders about incomplete/pending orders.

In case you are using WooCommerce for WordPress then refer to this article.

Create these custom subscriber fields in nuevoMailer

Or use your existing ones. Basically the minimum you need is the email. The rest are optional.
  1. First name (use a text field - ignore if you already have one)
  2. Last name (use a text field - ignore if you already have one)
  3. Orders # (use an integer number)
  4. Total $ (use a decimal number)
  5. Last order date (use a date field)
In the same page you may want to create this view.
Custom subscriber fields setup

Create two mailing lists

This is optional but as you will see below very handy.
Let's name them,
PrestaShop customers (order completed)
PrestaShop customers (payment pending)

Create an external database connection

Start with a new connection to MySQL.
Adjust database name, server name, username and password accordingly.

Field mapping

Source table and fields
This field will hold the total number of orders from this customer.
This field will hold the total sales from this customer.
This field will retreive the customer's birthday.

Custom SQL statement

This is the most important piece. Copy it from below. current_state refers to the order status/state. PrestaShop has many order statuses and you can also create custom ones.
Where to Find PrestaShop Order Status Settings
In the SQL box below we used (2,9). These mean:
2: Payment accepted
9: On backorder (paid)
If you are shipping products then you may also want to use:
5: Delivered

"AND newsletter=1" may be omitted. But in case you use it at PrestaShop then include it. Means that it will lookup customers who have consented to receiving your newsletters.

Key points & further ideas

  • Depending on the nature of the goods you sell and your business processes you may want to create several data sources that differentiate by order status.
  • For example you may create a data source that pulls customers having "Awaiting payment" and/or "Processing in progress" and assign them to a "Pending list".
  • Another source may pull customers having "Delivered (5)" and assign them to your main customers list.
  • In both cases you can setup autoresponders following up on the "Last order date" field.
  • An autoresponder can be used to remind customers to pay and/or follow-up after they've paid.
  • The timing of your autoresponders is again related to your business model and is very important.
    In case you create a "Payment reminder" autoresponder a good idea would be to add a Trigger on this that removes the customer from the "Pending list" as soon as the email is sent. See an example.
    Processing in progress is an intermediate state. So if you plan to create an autoresponder let some time pass. Do not send it immediately.
  • Using a cron job you can automate this process and synchronize your data sources as often as you need.

See also,

Top of page