Shopify - Default Data Mapping
Default mapping our Splio Shopify connector which can be completed during the setup phase upon request with your Splio contact. The default mapping can also be personalized if some data are not relevant to you (specified as default in the tables below).
Contact scope
| Shopify field | Splio field | Type |
|---|---|---|
| id | shp_id | mandatory |
| mandatory | ||
| email_marketing_consent.state | shp_accepts_email_marketing | mandatory |
| email_marketing_consent.consent_updated_at | shp_accepts_email_marketing_updated_at | mandatory |
| sms_marketing_consent.state | shp_accepts_sms_marketing | mandatory |
| sms_marketing_consent.consent_updated_at | shp_accepts_sms_marketing_updated_at | mandatory |
| created_at | creation_date | default |
| updated_at | shp_updated_at | mandatory |
| first_name | firstname | default |
| last_name | lastname | default |
| orders_count | shp_orders_count | default |
| state | shp_state | default |
| total_spent | shp_total_spent | default |
| last_order_id | shp_last_order_id | default |
| last_order_name | shp_last_order_name | default |
| phone | cellphone | default |
| tags* | shp_tags | default |
| default_address.city | shp_default_address_city | default |
| default_address.zip | shp_default_address_zip | default |
| default_address.country_code | shp_default_address_country_code | default |
| default_address.country_name | shp_default_address_country_name | default |
| default_address.company | shp_default_address_company | default |
| default_address.name | shp_default_address_name | default |
| shop_name** | shp_shop_name | default |
*each tag is encapsuled in []. By default truncated to 255 chars. If you are a heavy user of tags, you need to request an extension of field size to your Splio Contact.
** for multi-shop setup, please read more here
Product Scope
| Shopify field | Splio field | Comments |
|---|---|---|
| variants.id | external_id | |
| title | name | |
| body_html | description | Make sure the description is under 120 char, otherwise you will have a non valid HTML. |
| vendor | brand | |
| variants.sku | sku | |
| product_type | category | |
| image.src | img_url | |
| variants.price | price | |
| variants.id | shp_variant_id | |
| id | shp_product_id | |
| variants.title | shp_variant_title | |
| variants.option1 | shp_variant_option1 | |
| variants.option2 | shp_variant_option2 | |
| variants.option3 | shp_variant_option3 | |
| variants.inventory_quantity | shp_variant_inventory_quantity | |
| variants.created_at | shp_created_at | |
| variants.updated_at | shp_updated_at | |
| tags | shp_product_tags | each tag is encapsuled in []. By default truncated to 255 chars. If you are a heavy user of tags, you need to request an extension of field size to your Splio Contact. |
| variants.barcode | shp_variant_barcode | |
| product.status | shp_product_status |
Note that the product catalog in Splio is at the variant level (and not the parent). If you need to use the parent level for display purpose in your email designer, reach out to your contact at Splio.
Orders scope
| Shopify field | Splio field | Comments |
|---|---|---|
| id | external_id | (order_id in datahub) |
| customer.id | contact_id | (customer_key in datahub) |
| processed_at | order_date | |
| total_price | total_price | (total_amount in datahub) |
| total_discounts | discount_amount | |
| total_tax | tax_amount | |
| total_shipping_price_set.shop_money.amount | shipping_amount | |
| currency | currency | |
| discount_codes.code | discount_codes | |
| location_id | shp_location_id | |
| total_price_set.presentment_money.currency_code | shp_presentment_money_currency | |
| total_price_set.presentment_money.amount | shp_presentment_money_total_price | |
| total_discount_set.presentment_money.amount | shp_presentment_money_discount_amount | |
| total_shipping_price_set.presentment_money.amount | shp_presentment_money_shipping_amount | |
| created_at | shp_created_at | |
| updated_at | shp_updated_at | |
| customer_locale | shp_customer_locale | |
| order_status_url | shp_order_status_url | |
| processing_method | shp_processing_method | |
| discount_codes.code[0] | shp_discount_codes | |
| app_id | shp_app_id | |
| source_name | shp_source_name | |
| order_number | shp_order_number | |
| tags | shp_tags |
line_items / order items
| Shopify field | Splio field | Comments |
|---|---|---|
| line_item.variant_id | product_id | |
| currency | currency | |
| line_item.quantity | quantity | |
| line_item.price | unit_price | |
| line_item.total_discount | discount_amount | |
| line_item.tax_lines.price_set.shop_money.amount | tax_amount |
Note that total_line_amount in Splio is calculated as line_item.price_set.shop_money.amount * line_item.quantity) - splioSum([number(line_item.discount_allocations.amount_set.shop_money.amount)])
Abandoned checkouts
| Shopify field | Splio field | Comments |
|---|---|---|
| id | order_id | prefixed by 'ach_' |
| customer.id | contact_id | (customer_key in datahub) |
| created_at | order_date | |
| total_price | total_price | (total_amount in datahub) |
| total_discounts | discount_amount | |
| total_tax | tax_amount | |
| total_shipping_price_set.shop_money.amount OU shipping_lines.price | shipping_amount | |
| currency | currency | |
| location_id | shp_location_id | |
| abandoned_checkout_url | shp_abandoned_checkout_url | |
| total_price_set.presentment_money.currency_code | shp_presentment_money_currency | |
| total_price_set.presentment_money.amount | shp_presentment_money_total_price | |
| total_discount_set.presentment_money.amount | shp_presentment_money_discount_amount | |
| total_shipping_price_set.presentment_money.amount | shp_presentment_money_shipping_amount | |
| created_at | shp_created_at | |
| updated_at | shp_updated_at | |
| customer_locale | shp_customer_locale | |
| order_status_url | shp_order_status_url | |
| processing_method | shp_processing_method | |
| discount_codes.code[0] | shp_discount_codes | |
| app_id | shp_app_id | |
| source_name | shp_source_name | |
| order_number | shp_order_number | |
| tags | shp_tags |
line_items / order items
| Shopify field | Splio field | Comments |
|---|---|---|
| line_item.variant_id | product_id | |
| currency | currency | |
| line_item.quantity | quantity | |
| line_item.price | unit_price | |
| line_item.total_discount | discount_amount | |
| line_item.tax_lines.price_set.shop_money.amount | tax_amount |
Note that total_line_amount in Splio is calculated as line_item.price_set.shop_money.amount * line_item.quantity) - (count(line_item.discount_allocations) > 0 ? sum(line_item.discount_allocations.amount_set.shop_money.amount):0)
Refunds scope
The refund scope applies the same mapping as the order scope excpect from the total line amount formula:
total line amount = (number(refund_line_item.line_item.price_set.shop_money.amount) \* refund_line_item.line_item.quantity)
Updated about 1 month ago