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:

1. Installation
2. Usage
3. E-commerce automations
4. Data fields sent to Rule

Installation

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

Usage

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:

1. Export a CSV File from E37
   Start by exporting a CSV file containing the data you want to import (this is done in E37).
   
   

2. 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
   
   

3. Enter the API Key and Upload the CSV File
   Visit the following link:
   E37 Orders Import
   
   

4. 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.