File Formatter for JSON & XML

To structure the data export, use the File Formatter for JSON and XML files.

To format the file, navigate to the set destination settings on the dashboard and select the format either JSON or XML. The File Formatter option will then be available. Refer to the help documentation for JSON and XML examples.

JSON example:

{ 
  "header": { "dateCreated": "{{ "now" | date: "%Y-%m-%d %H:%M:%S" }}" },
  "dataHeader": { "encodingTableCode": "E-Shop" },
  "data": {
    "orders": [{% for item in items %}
      {
        "delivery": {
          "name": "{{ item[1]["Customer Name (Shipping)"] }}",
          "streetAndNumber": "{{ item[1]["Shipping Address 1"] }}",
          "city": "{{ item[1]["Shipping City"] }}",
          "zip": "{{ item[1]["Shipping ZIP"] }}",
          "phone1": "{{ item[1]["Shipping Address Phone"] }}"
        },
        "lineItems": [{% for line in item[1][nil] %}
          {
            "lineId": "{{ line["Product ID"] }}",
            "itemCode": "{{ line["SKU"] }}",
            "ean": "{{ line["SKU"] }}",
            "quantity": {{ line["Quantity"] | times: 1 }},
            "unitOfMeasure": "VNT",
            "vatCode": 0,
            "unitNetPrice": {{ line["Product Price"] | times: 1}},
            "unitPriceVAT": {{ line["Product Price"] | times: 1.23 }},
            "vatAmount": {{ line["Product Price"] | times: 0.23 }},
            "netAmount": {{ line["Product Price"] | times: 1}}
          }{% if forloop.last == false %},{% endif %}
        {% endfor %}]
      }{% if forloop.last == false %},{% endif %}
    {% endfor %}]
  }
}

XML example:

<Document>
  <Data>
    {% for item in items %}
    <Order>
      <DeliveryPlace>
        <Name>{{ item[1]["Customer Name (Shipping)"] }}</Name>
        <StreetAndNumber>{{ item[1]["Shipping Address 1"] }}</StreetAndNumber>
        <City>{{ item[1]["Shipping City"] }}</City>
        <ZIP>{{ item[1]["Shipping ZIP"] }}</ZIP>
        <Phone1>{{ item[1]["Shipping Address Phone"] }}</Phone1>
      </DeliveryPlace>
      <Line>{% for line in item[1][nil] %}
        <Line-Item>
          <LineId>{{ line["Product ID"] }}</LineId>
          <ItemCode>{{ line["SKU"] }}</ItemCode>
          <EAN>{{ line["SKU"] }}</EAN>
          <Quantity>{{ line["Quantity"] }}</Quantity>
          <UnitOfMeasure>VNT</UnitOfMeasure>
          <VATCode>0</VATCode>
          <UnitNetPrice>{{ line["Product Price"] }}</UnitNetPrice>
          <UnitPriceVAT>{{ line["Product Price"] | times: 1.23 }}</UnitPriceVAT>
          <VATAmount>{{ line["Product Price"] | times: 0.23 }}</VATAmount>
          <NetAmount>{{ line["Product Price"] }}</NetAmount>
        </Line-Item>
      {% endfor %}</Line>
    </Order>
    {% endfor %}
  </Data>
</Document>

This format will export out the orders in Shopify according to the fields that are mentioned in the format. The fields mentioned must be the Field Name in the data file.

Updated on: 08/04/2026