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.
Updated about 2 months ago