Home
Guides
Splio Customer PlatformMobile Wallets

Shopify - Data initialization

Suggest Edits

Volume limitations

❗️

Please contact your project manager/customer care if you want to catch-up more than 200 000 events by asset (orders / contacts / products) during the init phase or the run

Keep in mind that we can catch-up approximately 50 000 events/hour.


Context

If you are migrating your CMS to Shopify for an existing business, you will likely need to update your historical purchases in both Shopify and Splio to fully segment and activate your database. Shopify allows you to import purchases without needing the product ID, whereas Splio does not because of the relational data model we propose.

This initialization guideline outlines how we will create these historical purchases in Splio during the project setup without requiring any intervention from your side.

Pre-requisite

In the ingestion, we expect to have an Id Product defined in the data from Shopify. However, we offer an alternate behavior. In fact, we have a handle-null-product feature to allow the order creation if the variant_id of the order is null.

When the feature is activated , "fake" product will be generated if the expected product_id is not filled (null). However, if the Id Product is filled but not in the Product table, it will be rejected.

By default, the following fields will be used to create the product:

AssetField used as Id ProductAlternative field (when Id Product is null)Product name
orders$line_items.variant_id$line_item.title$line_items.title
refunds$refund_line_item.line_item.variant_id$refund_line_item.line_item.variant_title$refund_line_item.line_item.variant_title

What if the alternative field does not fit the need?

We can overwrite this rule by defining the following fields:

  • The field to use as Product Id
  • The field we want to use as alternative field for the Id Product
  • The title we want to use as the product name

How does it work in Shopify

What happens for the following

When the feature is activated and the field used as Id Product is null, we will generate products in the Product table as follows:

AssetGenerate product methodProduct name
orders"autogen" + MD5 of $line_item.title + $line_items.shop_url$line_items.title
refunds"autogen" + MD5 of $refund_line_item.line_item.variant_title (we will hash the sku) + $line_items.shop_url$refund_line_item.line_item.variant_title

What happen for the following

In this section, we will take the example of orders asset. But it will be similar for refunds.

As a reminder, by default, for orders : the Id product is$line_items.variant_id

AssetField used as Id ProductAlternative field before the Go LiveProduct name
orders$line_items.variant_id$line_item.title$line_items.title

  • $line_items.variant_id null

    • Case 1 : When the feature is activated for the shop splio-demo

      • "Fake products" will be generated :

        • Id calculated based on $line_items.title and $line_items.shop_url -> "auto_gen_8ffd354b2fa23e0df4096df3ccfaccd0_splio-demo"
          • If $line_items.title is not filled -> All this lines will be related to the same product
        • Label: $line_items.title -> "QA T-Shirt"

      • In the product table:

        • Global:

        • Details

      • The order line :

        • Global:

        • Details:

    • Case 2 : When the feature is deactivated

      • The order will be rejected
    "line_items": [
      {
        "id": 123451568570,
        "admin_graphql_api_id": "gid://shopify/LineItem/123451568570",
        "attributed_staffs": [ ],
        "fulfillable_quantity": 5,
        "fulfillment_service": "manual",
        "fulfillment_status": null,
        "gift_card": false,
        "grams": 10,
        "name": "Product id to create",
        "price": 20,
        "price_set": {
          "shop_money": {
            "amount": 20,
            "currency_code": "EUR"
          },
          "presentment_money": {
            "amount": 20,
            "currency_code": "EUR"
          }
        },
        "product_exists": true,
        "product_id": 7773156857000,
        "properties": [ ],
        "quantity": 5,
        "requires_shipping": false,
        "sku": "null",
        "taxable": true,
        "title": "QA T-Shirt",
        "total_discount": 0,
        "total_discount_set": {
          "shop_money": {
            "amount": 0,
            "currency_code": "EUR"
          },
          "presentment_money": {
            "amount": 0,
            "currency_code": "EUR"
          }
        },
        "variant_id": null,
        "variant_inventory_management": null,
        "variant_title": "Variant Title",
        "vendor": null,
        "tax_lines": [ ],
        "duties": [ ],
        "discount_allocations": [
          {
            "amount": "0",
            "amount_set": {
              "shop_money": {
                "amount": "0",
                "currency_code": "EUR"
              },
              "presentment_money": {
                "amount": "0",
                "currency_code": "EUR"
              }
            },
            "discount_application_index": 1
          }
        ]
      }
    ],
  • $line_items.variant_id not null
    • Case 1 : The Id Product is in the Product table
      • The orders will be created :
        • Id Product: $line_items.variant_id -> 1939477505094875
        • Product Name: $line_items.title -> "Title of the product id"
    • Case 2 : The Id Product is NOT in the Product table
      • The line will be rejected
    "line_items": [
      {
        "id": 123451568570,
        "admin_graphql_api_id": "gid://shopify/LineItem/123451568570",
        "attributed_staffs": [ ],
        "fulfillable_quantity": 5,
        "fulfillment_service": "manual",
        "fulfillment_status": null,
        "gift_card": false,
        "grams": 10,
        "name": "Product id to create",
        "price": 20,
        "price_set": {
          "shop_money": {
            "amount": 20,
            "currency_code": "EUR"
          },
          "presentment_money": {
            "amount": 20,
            "currency_code": "EUR"
          }
        },
        "product_exists": true,
        "product_id": 7773156857000,
        "properties": [ ],
        "quantity": 5,
        "requires_shipping": false,
        "sku": "null",
        "taxable": true,
        "title": "Title of the product id",
        "total_discount": 0,
        "total_discount_set": {
          "shop_money": {
            "amount": 0,
            "currency_code": "EUR"
          },
          "presentment_money": {
            "amount": 0,
            "currency_code": "EUR"
          }
        },
        "variant_id": 1939477505094875,
        "variant_inventory_management": null,
        "variant_title": "Variant Title",
        "vendor": null,
        "tax_lines": [ ],
        "duties": [ ],
        "discount_allocations": [
          {
            "amount": "0",
            "amount_set": {
              "shop_money": {
                "amount": "0",
                "currency_code": "EUR"
              },
              "presentment_money": {
                "amount": "0",
                "currency_code": "EUR"
              }
            },
            "discount_application_index": 1
          }
        ]
      }
    ],

Updated 16 days ago