Shopify - Advanced Data Mapping

💡
Our mapping solution is based on JSONATA. The jsonata mapping allows to map anything from a json content, with a simple syntax similar to Jsonpath . Their allows extensive data mapping to match your needs.

Use cases

Syncing only prospects based on a customer metafield or tag
If a transformation of a date is required
If a value mapping will improve data usability on your Marketing Automation, it is possible to define a specific mapping. For example to map a technical key “123” to a more user-friendly “Store ABC”.
For simplicity and compliance with future Splio rules, we should normalize Strings (for example : transform in Upercase, remove trailing spaces …)

During the setup, you will be provided with an excel template to help you with the mapping. Here's an example:

Content type	Metafield Key	Value mapping	Corresponding CF	Remarks
Customer	birthday	value	shp_dob	Timestamp to transform to ISO date
Customer	Preferences	store.name	shp_prefered_store_name	Json metafield
Customer	Gold member	value	sh_elite	Map true / false to 1 / 0

Keep in mind that the simpler the mapping and the transformation are, the simpler is the integration.