In this Best Practice, we will show you how to add order details from Shopify (or another eCommerce data provider) to Transaction Related Data Table.

  1. Create a new Zap and choose Shopify.
  2. Choose  Mapp Connect 0.2.0   and   Create Transaction Event.
  3.  Mapping for transactions is set by default between Mapp Engage and Zapier so you need to provide a source from Shopify data fields.
 Fields mapping

Source

Mapp Engage

Required

Description

Type

Email

email

YES

User email is changed to userId. If the user is not in the system, they will be added.

string

OrderId

orderId

YES

Identification of this order 

datetime

Timestamp

timestamp

NO

If the timestamp is not provided, it saves time from an incoming call.

number

StoreId

storeId

NO

For multi-shop purposes

string

Currency

currency

NO

The default currency is set in transactional related data. If not provided here, default currency is assigned.

string

ProductSKU

productSKU

YES

Product identifier (stock-keeping unit)

string

ProductPrice

productPrice

YES

Product price: number only, without currency and spaces.

number

ProductQuantity

productQuantity

YES

Quantity of this product in this order.

number

ImageURL

imageURL

NO

Link (URL) to the product image.

string

ProductURL

productURL

NO

Link (URL) to the product page.

string

Category

category

NO

Category of this product.

string

Brand

brand

NO

Brand of this product.

string

Variant

variant

NO

Use this field if the productSKU does not provide variant, such as colour, material, or size.

string

DiscountValue

discountValue

NO

Value (without currency) of discount per order (not per item)

number

DiscountPercent

discountPercent

NO

The percentage value of discount per order (not per item) - value from 0 to 1

number

PurchaseSource

purchaseSource

NO

Source (campaign name, Facebook, and so on) of this order 

string

customDetail1

customDetail1

NO

Custom transactional details need to be first defined in Transactional Related data structure and added to mapping similar to adding user attributes but in Transaction mapping. Add them in additional parameters (screenshot below)

defined by a customer in RD structure