Internationalisation - Product catalog

Through this guide, we will deep dive on how you can manage your product internationalisation in Splio from the data ingestion until the activation.

The challenges

Each business has unique characteristics that complicate data modeling. When operating in multiple markets, companies must take into account:

Currencies and conversions (product price)
Language translations such as (title, size, description...)
Product availabilities (back in stock use case)
Product URL

The different ingestion mode

We offer different possibilities to integrate this data :

API
Datahub
Standard connectors (you must ensure the data is stored in your source)

The impact on product catalog

One product reference by market

You sell in 2 markets (ES and FR), the structure of the product catalog will look like this :

{
  "external_id": "hat_M_FR",
  "name": "Porto-Vecchio",
  "description": "L'incontournable de l'été !",
  "brand": "Splio",
  "sku": "0001",
  "category": "Chapeau de paille",
  "img_url": "https://cdn.shopify.com/s/files/1/0649/4466/8841/files/mahdi-chaghari-P2-1.jpg?v=1721379603",
  "price": 99,
  "created_at": "2019-02-15 12:55:00",
  "updated_at": "2019-02-22 17:12:15",
  "custom_fields": [
    {
      "id": 0,
      "name": "Size",
      "value": "M",
      "data_type": "text"
    },
    { 
      "id": 1,
      "name": "product_url",
      "value": "https://fr.splio-demo.com/collections/chapeaux/products/barcelona",
      "data_type": "text"
    }
  ]
}

Same reference for spanish market :

{
  "external_id": "hat_M_ES",
  "name": "Porto-Vecchio",
  "description": "¡El imprescindible del verano!",
  "brand": "Splio",
  "sku": "0002",
  "category": "Sombrero de paja",
  "img_url": "https://cdn.shopify.com/s/files/1/0649/4466/8841/files/mahdi-chaghari-P2-1.jpg?v=1721379603",
  "price": 99,
  "created_at": "2019-02-15 12:55:00",
  "updated_at": "2019-02-22 17:12:15",
  "custom_fields": [
    {
      "id": 0,
      "name": "Size",
      "value": "M",
      "data_type": "text"
    },
    {
      "id": 1,
      "name": "product_url",
      "value": "https://es.splio-demo.com/collections/chapeaux/products/barcelona",
      "data_type": "text"
    }
  ]
}

Pros	Cons
Facilitate custom fields management for each product reference	Complexify events mapping with other sources for purchases and web tracking data
Use of standard product block in mail design

One product reference for all markets

You sell in 2 markets (ES and FR), the structure of the product catalog will look like this :

{
  "external_id": "hat_M",
  "name": "Porto-Vecchio",
  "description": "L'incontournable de l'été !",
  "brand": "Splio",
  "sku": "0001",
  "category": "Chapeau de paille",
  "img_url": "https://cdn.shopify.com/s/files/1/0649/4466/8841/files/mahdi-chaghari-P2-1.jpg?v=1721379603",
  "price": 99,
  "created_at": "2019-02-15 12:55:00",
  "updated_at": "2019-02-22 17:12:15",
  "custom_fields": [
    {
      "id": 0,
      "name": "size_fr",
      "value": "M",
      "data_type": "text"
    },
    { 
      "id": 1,
      "name": "product_url_fr",
      "value": "https://fr.splio-demo.com/collections/chapeaux/products/barcelona",
      "data_type": "text"
    },
    { 
      "id": 2,
      "name": "size_es",
      "value": "M",
      "data_type": "text"
    },
    { 
      "id": 3,
      "name": "product_url_es",
      "value": "https://es.splio-demo.com/collections/chapeaux/products/barcelona",
      "data_type": "text"
    },
    { 
      "id": 3,
      "name": "description_es",
      "value": "¡El imprescindible del verano!",
      "data_type": "text"
    }
  ]
}

Pros	Cons
Product data can be enrich by another source (like a PIM) rather than the CMS / PoS	Custom product block in design to display

The impact on your designs and activation

One product reference for all markets

You can personnalize your emails thanks to our liquid language available in the design, you'll find an example below:

To know more about you can refer to these two documentations :

Additional questions

Check fulfillement process if you want to manage product availabilities in Splio to propose the best solution
Product integrations thanks to the PIM