Configuration guide - Magento 1

This comprehensive guide provides start to finish instructions for users who are attempting to install and configure the connector for the first time.  It focuses on the most important things you need to know, and do, in order to get going. 

This guide doesn't cover advanced features. Full and comprehensive guidance can be found at dotmailer for Magento.

Contents

    Pre-Installation Health Check
    Connector Installation
    API & Transactional Credentials
    Mapping Data Fields
    Address Books
    Tracking
    Easy Email Capture
    Order Sync Settings
    Catalog Sync Settings
    Enable Sync
    Abandoned Carts

Pre-Installation Health Check

Compatibility

The dotmailer for Magento connector is compatible with both Community and Enterprise platforms of Magento.

  • For Community we're compatible with 1.6.1 +
  • For Enterprise we're compatible with 1.11.1 +

Conflicts

While every site is different, the connector could potentially come into conflict with other extensions. For example, abandon cart extensions and other SMTP tools could also possibly come into conflict with the connector, and this makes it important to state these during the installation process.

File Permissions

  • Requires full access (0777) to the var/export directory or full access to the CRON user running on the server.

Cron Tasks

The connector has several cron tasks attached with the install to ensure the connector functions correctly. Below is a list of current tasks and their timings:

  • ddg_automation_abandonedcarts - 5 minute intervals
  • ddg_automation_campaign - 5 minute intervals
  • ddg_automation_catalog_sync -15 minute intervals
  • ddg_automation_cleaner – 1st of every month
  • ddg_automation_customer_subscriber_guest_sync - 15 minute intervals
  • ddg_automation_importer – 5 minute intervals
  • ddg_automation_order_and_quote_sync - 15 minute intervals
  • ddg_automation_reviews_and_wishlist - 15 minute intervals
  • ddg_automation_status -15 minute intervals

The cron heartbeat should be running every 5 minutes to action the required tasks.

Have Multiple Websites?

The connector supports multiple websites.  If there are multiple sites within the same Magento instance then we recommend you link one site to one dotmailer account.  If you are configuring multiple sites to multiple dotmailer accounts, you will need to follow the entire process for each separate dotmailer account you have.

^ Back to Top


Installation

The installation of the Magento 1 connector can only be installed via FTP.  It is recommended to install the connector on a staging or development site prior to production.

  1. Download the files to the connector from GitHub located at https://github.com/dotmailer/dotmailer-magento-extension.
  2. Download it as a ZIP and unzip the file.
  3. Drop/move all of the source folder content inside the unzipped file into the corresponding destination folders. Destination folders can be found at https://raw.githubusercontent.com/dotmailer/dotmailer-magento-extension/testing/modman.
  4. Clear cache or disable the cache before installing the extension.
  5. Log out for the ACL to update and log in again.

^ Back to Top


Credentials

Create API User

To enable the connector to communicate with your dotmailer account and allow data synchronisation, you need to enter valid dotmailer API credentials.  API user credentials are made up of a username and password, and are required to authenticate each operation/method call that's made and to make sure you're connected to the correct account. 

Click on the person-and-cog icon in the bottom left corner to produce the settings menu and select Access.

Screen_Shot_2018-03-09_at_1.46.53_PM.png

A settings menu will appear;  select the API users tab and click on New user.

Screen_Shot_2018-03-09_at_2.54.07_PM.png

Create Transactional User 

You can make use of dotmailer's transactional email service to send, manage and track all of your transactional emails. The transactional service acts as a delivery mechanism for all the transactional emails such as order and shipping confirmations.  If you are looking to use dotmailer's easy editor to create and manage transactional emails for Magento please review the Transactional email templates article.

To use the transactional service a transactional user must be created. This process is similar to creating an API user. Select Access from the settings menu that appears when clicking the person-and-cog icon in the bottom left corner of the screen.

Screen_Shot_2018-03-09_at_1.46.53_PM.png

A settings menu will appear; select the Transactional email users tab and then click on New user to enter the details.

Screen_Shot_2018-03-09_at_1.54.17_PM.png

Enter API Credentials in Magento

Return to your Magento admin panel and select the API Credentials option from the Marketing Automation menu item.

Screen_Shot_2018-03-09_at_1.57.40_PM.png

Set 'Enabled' to Yes and then enter the credentials (username and password) of the API user just created

Screen_Shot_2018-03-09_at_1.32.11_PM.png

When finished click Save Config.  A confirmation is message is displayed notifying you the credentials are valid.

Screen_Shot_2018-03-09_at_2.00.33_PM.png

Enter Transactional Credentials in Magento

From Magento select Transactional Emails from the dotmailer menu.  The menu can be accessed under System >> Configuration.

Screen_Shot_2018-03-09_at_2.02.40_PM.png

Select Yes to enable the feature then enter the hostname, username and password.

  • r1-smtp.dotmailer.com if you have an account belonging to region 1 (Europe)
  • r2-smtp.dotmailer.com if you have an account belonging to region 2 (North America)
  • r3-smtp.dotmailer.com if you have an account belonging to region 3 (Asia)

Screen_Shot_2018-03-09_at_1.44.15_PM.png

Select an open port. Your options are 25,587 and 2525.

Screen_Shot_2018-03-09_at_1.44.54_PM.png

Click Save when finished.

Custom From Address

Remember to setup the accounts default Custom From Address. This is done from Transactional Email> Settings> From addresses. More information about Custom From Addresses can be found here.

^ Back to Top


Mapping Data Fields 

In addition to the basic contact information, the connector provides you the ability to map over 40 key retail information that you store on contacts from your Magento website to your dotmailer account.

To map the fields automatically choose the Developer option from the dotmailer menu.

Screen_Shot_2018-03-09_dev.png

Under the Sync Settings sections choose Run Now next to the 'Automap Data Fields' option. After a few moments, the page is reloaded with a success message.

Screen_Shot_2018-03-09_at_2.06.55_PM.png

^ Back to Top


Address Books 

The connector synchronises contacts to three different address books for three Magento contact types:

  • Customers - Registered customers of your Magento site that have a customer account.
  • Subscribers - Contacts who have opted into newsletter subscription on your site.
  • Guests - Email addresses from an order placed via guest checkout. They are neither a customer or a subscriber.

Before synchronisation begins, you need to create these address books so they can be selected and mapped to from within the connector.

Create

Address books can be created directly within the connector or within your dotmailer account.  To create address books from within the connector select the Sync Settings from the dotmailer menu.

Screen_Shot_2018-03-09_sync.png

Select the Create Address Book section towards the bottom of the page. Provide the address book a name and select the visibility. Selecting 'public' means contacts will be able to join or unsubscribe from it.  When finished, click Create New Address Book.

Screen_Shot_2018-03-09_at_2.13.37_PM.png

Repeat the steps above until all address books are created.

Mapping

Under the Address Book Mapping section choose the appropriate address books from the drop-down menu to map your customers, subscribers and guests to.

Screen_Shot_2018-03-09_at_2.17.52_PM.png

When finished with your mapping, select Save Config in the top right.

^ Back to Top


Tracking

Site tracking enriches your data and your understanding of your contacts' engagement with your site, whilst ROI tracking gives you a greater appreciation of your campaigns' ROI conversion rates.

Site Tracking is managed from Configuration.

Screen_Shot_2018-03-09_config.png

From the Tracking section select Yes for 'ROI Tracking Enabled' and/or 'Page Tracking Enabled'.

Screen_Shot_2018-03-09_at_2.23.41_PM.png

When finished, click Save Config.

^ Back to Top


Easy Email Capture

Easy email capture allows you to capture your site's user's email addresses when they haven't fully completed your checkout process or newsletter sign up process.

Easy Email Capture is managed from Configuration.

Screen_Shot_2018-03-09_config.png

From the Abandoned Carts section select Yes for “Easy Email Capture (Checkout)” and/or “Easy Email Capture (Newsletter)”.

Screen_Shot_2018-03-09_at_2.27.11_PM.png

When finished, click Save Config.

^ Back to Top


Order Sync Settings

Import Status

You have the option to only import and synchronise orders of a certain status, rather than all of them. For example, you might only be interested in sending campaigns or running segments based on orders that have been fulfilled. In this case, you might only want to import orders in a “Complete” status.

The order settings is managed from Configuration.

Screen_Shot_2018-03-09_config.png

From the Transactional Data section choose the status types to be imported from the "Import With Status" list.

Screen_Shot_2018-03-09_at_2.31.31_PM.png

When finished, click Save Config.

Custom Attributes

In addition to our standard default order data fields, you have the option to synchronize custom order attributes. This list comprises all of the order attributes that are available within the Magento system, allowing you to segment and send content based upon these too.

Under the Transactional Data section choose the attributes to be included in the import from the "Order Custom Attributes" list.

Screen_Shot_2018-03-09_at_2.34.59_PM.png

When finished, click Save Config.

Future Adjustments

Changes made to custom order attributes are reflected in new imports run after the adjustment has been made. To include these in previous imports the order insight collection must be deleted and the data re-imported

 

^ Back to Top


Catalog Sync Settings

The connector provides the facility to map and synchronise your product catalog against your dotmailer account. With your product catalog syncrhonised, you will be able to insert products into campaigns with ease by utilising the 'Products' building block or setup Product Recommendations.

You can choose to sync products of a certain visibility and/or product type rather than all products. This allows you to keep your catalog organised by excluding products that are no longer relevant on your site.

The catalog settings is managed from Configuration.

Screen_Shot_2018-03-09_config.png

From the 'Catalog Sync Settings' section choose the Store Value, Product Visibility and Product Types you want to sync. 

catalog_settings.png

When finished, click Save.

Broken Product Images?

Try setting the 'Store Value' to Store. This uses the store URL for the image path instead of the admin URL.

^ Back to Top


Enable Synchronisation 

After address books have been mapped and your order settings configured you can enable the sync.  Return to the Sync Settings page by selecting Sync Settings from the menu.

Screen_Shot_2018-03-09_sync.png

Under the Sync section select Yes to all sync types you would like to enable. Most enable Customer, Subscriber, Guest, Order and Catalog.

Screen_Shot_2018-03-09_at_2.38.53_PM.png

Within 15 minutes contacts and insight data should begin to be batched.  Details for advanced synchronisation options such as Quote, Whistlist and Review can be found at dotmailer for Magento

Delay

When enabling order synchronisatoin for the first time there is an hour delay prior to importing the order information. This delay is in place to prevent order imports from failing due to missing contacts.

Status Check

There are several ways to check that that data syncing from Magento into dotmailer is taking place.

Contact Sync Report

Contacts that are successfully batch to be imported should be marked as imported with a green tick.  This is accessed under Marketing Automation > Reports > Contacts Sync

Screen_Shot_2018-03-09_at_2.46.34_PM.png

Importer Status 

Batched contacts/orders should exist in this report. Once the importer cron has run an import should be marked with a status of 'Importing‘. Shortly after data should appear in dotmailer.  This is access under Marketing Automation > Reports > Importer Status

Screen_Shot_2018-03-09_at_2.45.48_PM.png

Troubleshooting

Cron

Confirm dotmailer (ddg) cron jobs are running. Cron is a vital part of making sure your data syncing happens correctly. We recommend installing the AOE Scheduler to give you a real-time view of the tasks running throughout your site, as well as giving you the ability to manage and configure your cron jobs.

API user

Confirm API credentials are active and valid.  You can view the status of the API credentials on the dashboard.  The dashboard can be accessed under Marketing Automation >> Dashboard >> Connector Status.

Sync Enabled

Confirm at least one contact sync is turned on.

Check Permissions

Requires full access (0777) to the var/export directory or full access to the CRON user running on the server.

 

^ Back to Top


Abandoned Cart

Abandoned cart emails are an important tool and key sales recovery strategy for ecommerce businesses. Research by marketing industry experts has suggested that around 70% of online consumers abandon carts. That means about one in three carts gets checked out first time.

Abandoned carts are setup and configured directly within the interface of the connector and can be sent to customers and guests. Customers and guests can receive up to three different emails that are scheduled for different time intervals. If your Magento instance has more then once website, you can configure different emails and settings per website.

Using external dynamic content (EDC), you can include the contents of their cart within the body of the emails you send.

Creation

Abandoned carts uses a series of trigger campaigns.  To create and build trigger campaigns login to your dotmailer account.  From the main page choose the Automation menu item and then choose Trigger Campaign Content.  

Screen_Shot_2018-03-09_at_7.56.45_PM.png

Access the email content and drag the External Dynamic Content building block into the location where you would like the cart content to be displayed.

Screen_Shot_2018-03-09_at_8.21.48_PM.png

Return to Magento and navigate to Dynamic Content.  

Screen_Shot_2018-03-09_at_8.25.06_PM.png

Copy the Abandoned Cart URL and return to the campaign in dotmailer.

Screen_Shot_2018-03-09_at_8.26.46_PM.png

Select the External Dynamic Content building block. Paste the Abandoned Cart URL previously copied to the 'Address' field then click Apply.  

Screen_Shot_2018-03-09_at_8.29.17_PM.png

When done editing the campaign content click Save

New to Automation?

If you are new to program building we suggest you watch the Automation training videos or review our Automation section.

 Configuration

After the campaigns have been created access the Abandoned Carts menu item from Magento.

Screen_Shot_2018-03-23_at_2.57.12_PM.png

The page is broken down into two sections for Customers and Guests. Go through each section and enable the amount of abandoned cart emails you require.  Choose the time delay and Campaign to Send from each section.

Screen_Shot_2018-03-23_at_3.05.16_PM.png

When finished click the Save Config button.

Multiple Websites?

If you need to setup abandoned carts for separate websites select the website name from the site drop-down and then navigate to the Abandoned Cart menu item.

Status Check

You are able to check the status of abandoned cart emails by access the Campaign Sends report.  This can be access from the Marketing Automation menu item and then clicking 'Reports'

Screen_Shot_2018-03-23_at_3.32.39_PM.png

By reviewing this report you are able to tell whether abandoned cart emails are being queued for sending, whether they are being sent to dotmailer and whether anything is failing.  You can sort and filter this report in a number of ways to find the information you're looking for. 

Screen_Shot_2018-03-23_at_4.00.22_PM.png

Troubleshooting

External Dynamic Content

Confirm the external dynamic content link is correct that you’re using for pulling abandoned carts information into your campaign content. To check this select Dynamic Content from the dotmailer menu in Magento.

Cron

Confirm ‘ddg_automation_abandonedcarts’ and ‘ddg_automation_campaign’ cron jobs are running. Without both of these running abandoned cart emails will not be batched or sent.

Conflict

Disable extensions you might have used previously to send abandoned cart emails.

 

Have more questions? Submit a request

Comments