Integration of E37 | Rule Helpcenter

With E37 integrated into Rule, you can collect order history, customer, product, and behavioral data, providing insights for segmented, personalized, automated, and data-driven communication.

We will go through:

Installation
Usage
E-commerce automations
Data fields sent to Rule

Installation

Create an API key in Rule. Go to 'Settings' > 'Developer' > Create new API key > Name the API key > Copy
Log in to E37

If you need additional information you can always read more in E37's help article.

Usage

Tag in Rule	Description	Data sent to Rule
OrderCompleted	When the order is completed in the e-commerce platform	Subscriber & Order Data
CartInProgress	After the customer has left their shopping cart	Subscriber & Order Data
Newsletter	Customer has clicked to receive newsletters on the website or checked the box to receive newsletters in the checkout flow.	-

E-commerce automations

When the e-commerce platform is connected to Rule, you can set up automations for the events mentioned above.In this article, we have described common e-commerce automations. Data fields sent to Rule

Data fields sent to Rule

Subscriber

Subscriber.Source (är alltid "E37")
Subscriber.SourceSite (namnet på aktuell webbplats)
Subscriber.Name (om inloggad)
Subscriber.Birthday (om inloggad)
Subscriber.Country
Subscriber.CountryCode
Subscriber.Name
Subscriber.Number

OrderCompleted

Order.Number
Order.Date
Order.Total (totalsumma inkl. moms)
Order.Currency
Order.HasSalePriceProduct (Yes/No)
Order.HasAutoCampaigns (Yes/No)
Order.HasDiscountCodes (Yes/No)
Order.ProductCount
Order.Products
Order.Brands
Order.Names
Order.SKUs
Order.Variations
Order.Groups (ex: "/Barnkläder/Övrigt/Bad- och solskyddskläder/")

CartInProgress

Cart.CartUrl
Cart.Date
Cart.Total (totalsumma inkl. moms)
Cart.Currency
Cart.HasSalePriceProduct (Yes/No)
Cart.HasAutoCampaigns (Yes/No)
Cart.HasDiscountCodes (Yes/No)
Cart.ProductCount
Cart.Products
Cart.Brands
Cart.Names
Cart.SKUs
Cart.Variations
Cart.Groups (ex: "/Barnkläder/Övrigt/Bad- och solskyddskläder/")

Historical orderimport

OBS! This is done in E37.

To create a document which includes historical order data follow these steps;

Go to E-handel -> Rapporter

There you have the option to select different types of reports.

Choose the option “Rule orderrapport (för import av orderhistorik i Rule)” and file type “Semikolonseparerad textfil”:

When the above steps are done you have the option to select a time frame ans well as which order statuses you want to exclude (we recommend excluding "Annullerad").

If you have Shop-in-Shop you also need to choose which store you want to export data from.

When this is done, a file is generated that you can upload for your Rule account.

Step-by-step:

Export a CSV File from E37
Start by exporting a CSV file containing the data you want to import (this is done in E37).
Create an API Key in the Rule Account
Log in to Rule and create an API key needed for the import. This can be done under: Settings → API Key
API key
Enter the API Key and Upload the CSV File
Visit the following link:
E37 Orders Import
Ange API-nyckeln och ladda upp CSV-filen
- Enter the API key you created earlier.
- Upload the CSV file from E37.

Import Settings:

Default Setting: "Update current"
Om en e-postadress redan finns i Rule kommer informationen att uppdateras. Om en e-postadress saknas, läggs den inte till.
Alternative: "Import New"
This option creates new subscribers if they don’t already exist in the system.

Good to Know

Slow but Reliable Process
The import may take several hours, especially for larger accounts with over 100,000 members. Expect the process to take more than 12 hours to complete.
Order Data Management
- If there are multiple orders with the same order number in the file, only one will be saved in the custom fields history.
- For duplicates, existing orders in the system take priority over those in the file.

Nyehandel integration