Zum Inhalt
HALOWERK

Agentenwerk

oss opencart order export reconciliation

Rebuilds the orders you supply inside a private, non-root OpenCart database and checks your export against what the native code computes. Each export row is matched to a ledger order, and every difference is named: a total that does not add up under the stated arithmetic policy, a currency conversion applied at the wrong point, a localized status that maps to nothing.

POST https://agent.halowerk.com/v1/oss-opencart-order-export-reconciliation

Eingaben

Felder des veröffentlichten Eingabeschemas
FeldTypPflichtBeschreibung
currenciesarrayJa
languagesarrayJa
statusesarrayJa
ledgerobjectJa
exportobjectJa
amount_modeSiehe SchemaJa
policiesarrayJa
Vollständiges Eingabeschema anzeigen
{
  "type": "object",
  "properties": {
    "currencies": {
      "type": "array",
      "items": {
        "type": "object",
        "properties": {
          "currency_id": {
            "type": "integer",
            "minimum": 1,
            "maximum": 2147483647
          },
          "code": {
            "type": "string",
            "minLength": 3,
            "maxLength": 3,
            "pattern": "^[A-Z]{3}$"
          },
          "decimal_place": {
            "type": "integer",
            "minimum": 0,
            "maximum": 3
          }
        },
        "required": [
          "currency_id",
          "code",
          "decimal_place"
        ],
        "additionalProperties": false
      },
      "minItems": 1,
      "maxItems": 8
    },
    "languages": {
      "type": "array",
      "items": {
        "type": "object",
        "properties": {
          "language_id": {
            "type": "integer",
            "minimum": 1,
            "maximum": 2147483647
          },
          "code": {
            "type": "string",
            "minLength": 5,
            "maxLength": 5,
            "pattern": "^[a-z]{2}-[a-z]{2}$"
          }
        },
        "required": [
          "language_id",
          "code"
        ],
        "additionalProperties": false
      },
      "minItems": 1,
      "maxItems": 4
    },
    "statuses": {
      "type": "array",
      "items": {
        "type": "object",
        "properties": {
          "order_status_id": {
            "type": "integer",
            "minimum": 1,
            "maximum": 2147483647
          },
          "language_id": {
            "type": "integer",
            "minimum": 1,
            "maximum": 2147483647
          },
          "name": {
            "type": "string",
            "minLength": 1,
            "maxLength": 32,
            "pattern": "^[^\\x00-\\x08\\x0b\\x0c\\x0e-\\x1f\\x7f\\ud800-\\udfff]*$"
          }
        },
        "required": [
          "order_status_id",
          "language_id",
          "name"
        ],
        "additionalProperties": false
      },
      "minItems": 0,
      "maxItems": 64
    },
    "ledger": {
      "type": "object",
      "properties": {
        "orders": {
          "type": "array",
          "items": {
            "type": "object",
            "properties": {
              "order_id": {
                "type": "integer",
                "minimum": 1,
                "maximum": 2147483647
              },
              "store_id": {
                "type": "integer",
                "minimum": 0,
                "maximum": 2147483647
              },
              "customer_id": {
                "type": "integer",
                "minimum": 0,
                "maximum": 2147483647
              },
              "customer_group_id": {
                "type": "integer",
                "minimum": 0,
                "maximum": 2147483647
              },
              "language_id": {
                "type": "integer",
                "minimum": 1,
                "maximum": 2147483647
              },
              "language_code": {
                "type": "string",
                "minLength": 5,
                "maxLength": 5,
                "pattern": "^[a-z]{2}-[a-z]{2}$"
              },
              "currency_id": {
                "type": "integer",
                "minimum": 1,
                "maximum": 2147483647
              },
              "currency_code": {
                "type": "string",
                "minLength": 3,
                "maxLength": 3,
                "pattern": "^[A-Z]{3}$"
              },
              "currency_value": {
                "type": "string",
                "minLength": 1,
                "maxLength": 20,
                "pattern": "^(?:0|[1-9][0-9]{0,3})(?:\\.[0-9]{1,8})?$"
              },
              "total": {
                "type": "string",
                "minLength": 1,
                "maxLength": 24,
                "pattern": "^-?(?:0|[1-9][0-9]{0,6})(?:\\.[0-9]{1,4})?$"
              },
              "order_status_id": {
                "type": "integer",
                "minimum": 0,
                "maximum": 2147483647
              },
              "transaction_id": {
                "type": "string",
                "minLength": 0,
                "maxLength": 100,
                "pattern": "^[^\\x00-\\x08\\x0b\\x0c\\x0e-\\x1f\\x7f\\ud800-\\udfff]*$"
              },
              "comment": {
                "type": "string",
                "minLength": 0,
                "maxLength": 2048,
                "pattern": "^[^\\x00-\\x08\\x0b\\x0c\\x0e-\\x1f\\x7f\\ud800-\\udfff]*$"
              }
            },
            "required": [
              "order_id",
              "store_id",
              "customer_id",
              "customer_group_id",
              "language_id",
              "language_code",
              "currency_id",
              "currency_code",
              "currency_value",
              "total",
              "order_status_id",
              "transaction_id",
              "comment"
            ],
            "additionalProperties": false
          },
          "minItems": 0,
          "maxItems": 16
        },
        "products": {
          "type": "array",
          "items": {
            "type": "object",
            "properties": {
              "order_product_id": {
                "type": "integer",
                "minimum": 1,
                "maximum": 2147483647
              },
              "order_id": {
                "type": "integer",
                "minimum": 1,
                "maximum": 2147483647
              },
              "product_id": {
                "type": "integer",
                "minimum": 0,
                "maximum": 2147483647
              },
              "master_id": {
                "type": "integer",
                "minimum": 0,
                "maximum": 2147483647
              },
              "name": {
                "type": "string",
                "minLength": 0,
                "maxLength": 255,
                "pattern": "^[^\\x00-\\x08\\x0b\\x0c\\x0e-\\x1f\\x7f\\ud800-\\udfff]*$"
              },
              "model": {
                "type": "string",
                "minLength": 0,
                "maxLength": 64,
                "pattern": "^[^\\x00-\\x08\\x0b\\x0c\\x0e-\\x1f\\x7f\\ud800-\\udfff]*$"
              },
              "quantity": {
                "type": "integer",
                "minimum": 0,
                "maximum": 10000
              },
              "price": {
                "type": "string",
                "minLength": 1,
                "maxLength": 24,
                "pattern": "^-?(?:0|[1-9][0-9]{0,6})(?:\\.[0-9]{1,4})?$"
              },
              "total": {
                "type": "string",
                "minLength": 1,
                "maxLength": 24,
                "pattern": "^-?(?:0|[1-9][0-9]{0,6})(?:\\.[0-9]{1,4})?$"
              },
              "tax": {
                "type": "string",
                "minLength": 1,
                "maxLength": 24,
                "pattern": "^-?(?:0|[1-9][0-9]{0,6})(?:\\.[0-9]{1,4})?$"
              },
              "reward": {
                "type": "integer",
                "minimum": 0,
                "maximum": 1000000
              }
            },
            "required": [
              "order_product_id",
              "order_id",
              "product_id",
              "master_id",
              "name",
              "model",
              "quantity",
              "price",
              "total",
              "tax",
              "reward"
            ],
            "additionalProperties": false
          },
          "minItems": 0,
          "maxItems": 128
        },
        "options": {
          "type": "array",
          "items": {
            "type": "object",
            "properties": {
              "order_option_id": {
                "type": "integer",
                "minimum": 1,
                "maximum": 2147483647
              },
              "order_id": {
                "type": "integer",
                "minimum": 1,
                "maximum": 2147483647
              },
              "order_product_id": {
                "type": "integer",
                "minimum": 1,
                "maximum": 2147483647
              },
              "product_option_id": {
                "type": "integer",
                "minimum": 0,
                "maximum": 2147483647
              },
              "product_option_value_id": {
                "type": "integer",
                "minimum": 0,
                "maximum": 2147483647
              },
              "name": {
                "type": "string",
                "minLength": 0,
                "maxLength": 255,
                "pattern": "^[^\\x00-\\x08\\x0b\\x0c\\x0e-\\x1f\\x7f\\ud800-\\udfff]*$"
              },
              "value": {
                "type": "string",
                "minLength": 0,
                "maxLength": 2048,
                "pattern": "^[^\\x00-\\x08\\x0b\\x0c\\x0e-\\x1f\\x7f\\ud800-\\udfff]*$"
              },
              "type": {
                "type": "string",
                "minLength": 1,
                "maxLength": 32,
                "pattern": "^[^\\x00-\\x08\\x0b\\x0c\\x0e-\\x1f\\x7f\\ud800-\\udfff]*$"
              }
            },
            "required": [
              "order_option_id",
              "order_id",
              "order_product_id",
              "product_option_id",
              "product_option_value_id",
              "name",
              "value",
              "type"
            ],
            "additionalProperties": false
          },
          "minItems": 0,
          "maxItems": 256
        },
        "totals": {
          "type": "array",
          "items": {
            "type": "object",
            "properties": {
              "order_total_id": {
                "type": "integer",
                "minimum": 1,
                "maximum": 2147483647
              },
              "order_id": {
                "type": "integer",
                "minimum": 1,
                "maximum": 2147483647
              },
              "extension": {
                "type": "string",
                "minLength": 0,
                "maxLength": 255,
                "pattern": "^[^\\x00-\\x08\\x0b\\x0c\\x0e-\\x1f\\x7f\\ud800-\\udfff]*$"
              },
              "code": {
                "type": "string",
                "minLength": 1,
                "maxLength": 32,
                "pattern": "^[^\\x00-\\x08\\x0b\\x0c\\x0e-\\x1f\\x7f\\ud800-\\udfff]*$"
              },
              "title": {
                "type": "string",
                "minLength": 0,
                "maxLength": 255,
                "pattern": "^[^\\x00-\\x08\\x0b\\x0c\\x0e-\\x1f\\x7f\\ud800-\\udfff]*$"
              },
              "value": {
                "type": "string",
                "minLength": 1,
                "maxLength": 24,
                "pattern": "^-?(?:0|[1-9][0-9]{0,6})(?:\\.[0-9]{1,4})?$"
              },
              "sort_order": {
                "type": "integer",
                "minimum": -1000,
                "maximum": 1000
              }
            },
            "required": [
              "order_total_id",
              "order_id",
              "extension",
              "code",
              "title",
              "value",
              "sort_order"
            ],
            "additionalProperties": false
          },
          "minItems": 0,
          "maxItems": 256
        }
      },
      "required": [
        "orders",
        "products",
        "options",
        "totals"
      ],
      "additionalProperties": false
    },
    "export": {
      "type": "object",
      "properties": {
        "orders": {
          "type": "array",
          "items": {
            "type": "object",
            "properties": {
              "order_id": {
                "type": "integer",
                "minimum": 1,
                "maximum": 2147483647
              },
              "store_id": {
                "type": "integer",
                "minimum": 0,
                "maximum": 2147483647
              },
              "customer_id": {
                "type": "integer",
                "minimum": 0,
                "maximum": 2147483647
              },
              "customer_group_id": {
                "type": "integer",
                "minimum": 0,
                "maximum": 2147483647
              },
              "language_id": {
                "type": "integer",
                "minimum": 1,
                "maximum": 2147483647
              },
              "language_code": {
                "type": "string",
                "minLength": 5,
                "maxLength": 5,
                "pattern": "^[a-z]{2}-[a-z]{2}$"
              },
              "currency_id": {
                "type": "integer",
                "minimum": 1,
                "maximum": 2147483647
              },
              "currency_code": {
                "type": "string",
                "minLength": 3,
                "maxLength": 3,
                "pattern": "^[A-Z]{3}$"
              },
              "currency_value": {
                "type": "string",
                "minLength": 1,
                "maxLength": 20,
                "pattern": "^(?:0|[1-9][0-9]{0,3})(?:\\.[0-9]{1,8})?$"
              },
              "total": {
                "type": "string",
                "minLength": 1,
                "maxLength": 28,
                "pattern": "^-?(?:0|[1-9][0-9]{0,12})(?:\\.[0-9]{1,4})?$"
              },
              "order_status_id": {
                "type": "integer",
                "minimum": 0,
                "maximum": 2147483647
              },
              "transaction_id": {
                "type": "string",
                "minLength": 0,
                "maxLength": 100,
                "pattern": "^[^\\x00-\\x08\\x0b\\x0c\\x0e-\\x1f\\x7f\\ud800-\\udfff]*$"
              },
              "comment": {
                "type": "string",
                "minLength": 0,
                "maxLength": 2048,
                "pattern": "^[^\\x00-\\x08\\x0b\\x0c\\x0e-\\x1f\\x7f\\ud800-\\udfff]*$"
              },
              "order_status": {
                "anyOf": [
                  {
                    "type": "string",
                    "minLength": 0,
                    "maxLength": 32,
                    "pattern": "^[^\\x00-\\x08\\x0b\\x0c\\x0e-\\x1f\\x7f\\ud800-\\udfff]*$"
                  },
                  {
                    "type": "null"
                  }
                ]
              }
            },
            "required": [
              "order_id",
              "store_id",
              "customer_id",
              "customer_group_id",
              "language_id",
              "language_code",
              "currency_id",
              "currency_code",
              "currency_value",
              "total",
              "order_status_id",
              "transaction_id",
              "comment",
              "order_status"
            ],
            "additionalProperties": false
          },
          "minItems": 0,
          "maxItems": 32
        },
        "products": {
          "type": "array",
          "items": {
            "type": "object",
            "properties": {
              "order_product_id": {
                "type": "integer",
                "minimum": 1,
                "maximum": 2147483647
              },
              "order_id": {
                "type": "integer",
                "minimum": 1,
                "maximum": 2147483647
              },
              "product_id": {
                "type": "integer",
                "minimum": 0,
                "maximum": 2147483647
              },
              "master_id": {
                "type": "integer",
                "minimum": 0,
                "maximum": 2147483647
              },
              "name": {
                "type": "string",
                "minLength": 0,
                "maxLength": 255,
                "pattern": "^[^\\x00-\\x08\\x0b\\x0c\\x0e-\\x1f\\x7f\\ud800-\\udfff]*$"
              },
              "model": {
                "type": "string",
                "minLength": 0,
                "maxLength": 64,
                "pattern": "^[^\\x00-\\x08\\x0b\\x0c\\x0e-\\x1f\\x7f\\ud800-\\udfff]*$"
              },
              "quantity": {
                "type": "integer",
                "minimum": 0,
                "maximum": 10000
              },
              "price": {
                "type": "string",
                "minLength": 1,
                "maxLength": 28,
                "pattern": "^-?(?:0|[1-9][0-9]{0,12})(?:\\.[0-9]{1,4})?$"
              },
              "total": {
                "type": "string",
                "minLength": 1,
                "maxLength": 28,
                "pattern": "^-?(?:0|[1-9][0-9]{0,12})(?:\\.[0-9]{1,4})?$"
              },
              "tax": {
                "type": "string",
                "minLength": 1,
                "maxLength": 28,
                "pattern": "^-?(?:0|[1-9][0-9]{0,12})(?:\\.[0-9]{1,4})?$"
              },
              "reward": {
                "type": "integer",
                "minimum": 0,
                "maximum": 1000000
              }
            },
            "required": [
              "order_product_id",
              "order_id",
              "product_id",
              "master_id",
              "name",
              "model",
              "quantity",
              "price",
              "total",
              "tax",
              "reward"
            ],
            "additionalProperties": false
          },
          "minItems": 0,
          "maxItems": 256
        },
        "options": {
          "type": "array",
          "items": {
            "type": "object",
            "properties": {
              "order_option_id": {
                "type": "integer",
                "minimum": 1,
                "maximum": 2147483647
              },
              "order_id": {
                "type": "integer",
                "minimum": 1,
                "maximum": 2147483647
              },
              "order_product_id": {
                "type": "integer",
                "minimum": 1,
                "maximum": 2147483647
              },
              "product_option_id": {
                "type": "integer",
                "minimum": 0,
                "maximum": 2147483647
              },
              "product_option_value_id": {
                "type": "integer",
                "minimum": 0,
                "maximum": 2147483647
              },
              "name": {
                "type": "string",
                "minLength": 0,
                "maxLength": 255,
                "pattern": "^[^\\x00-\\x08\\x0b\\x0c\\x0e-\\x1f\\x7f\\ud800-\\udfff]*$"
              },
              "value": {
                "type": "string",
                "minLength": 0,
                "maxLength": 2048,
                "pattern": "^[^\\x00-\\x08\\x0b\\x0c\\x0e-\\x1f\\x7f\\ud800-\\udfff]*$"
              },
              "type": {
                "type": "string",
                "minLength": 1,
                "maxLength": 32,
                "pattern": "^[^\\x00-\\x08\\x0b\\x0c\\x0e-\\x1f\\x7f\\ud800-\\udfff]*$"
              }
            },
            "required": [
              "order_option_id",
              "order_id",
              "order_product_id",
              "product_option_id",
              "product_option_value_id",
              "name",
              "value",
              "type"
            ],
            "additionalProperties": false
          },
          "minItems": 0,
          "maxItems": 512
        },
        "totals": {
          "type": "array",
          "items": {
            "type": "object",
            "properties": {
              "order_total_id": {
                "type": "integer",
                "minimum": 1,
                "maximum": 2147483647
              },
              "order_id": {
                "type": "integer",
                "minimum": 1,
                "maximum": 2147483647
              },
              "extension": {
                "type": "string",
                "minLength": 0,
                "maxLength": 255,
                "pattern": "^[^\\x00-\\x08\\x0b\\x0c\\x0e-\\x1f\\x7f\\ud800-\\udfff]*$"
              },
              "code": {
                "type": "string",
                "minLength": 1,
                "maxLength": 32,
                "pattern": "^[^\\x00-\\x08\\x0b\\x0c\\x0e-\\x1f\\x7f\\ud800-\\udfff]*$"
              },
              "title": {
                "type": "string",
                "minLength": 0,
                "maxLength": 255,
                "pattern": "^[^\\x00-\\x08\\x0b\\x0c\\x0e-\\x1f\\x7f\\ud800-\\udfff]*$"
              },
              "value": {
                "type": "string",
                "minLength": 1,
                "maxLength": 28,
                "pattern": "^-?(?:0|[1-9][0-9]{0,12})(?:\\.[0-9]{1,4})?$"
              },
              "sort_order": {
                "type": "integer",
                "minimum": -1000,
                "maximum": 1000
              }
            },
            "required": [
              "order_total_id",
              "order_id",
              "extension",
              "code",
              "title",
              "value",
              "sort_order"
            ],
            "additionalProperties": false
          },
          "minItems": 0,
          "maxItems": 512
        }
      },
      "required": [
        "orders",
        "products",
        "options",
        "totals"
      ],
      "additionalProperties": false
    },
    "amount_mode": {
      "enum": [
        "stored_decimal",
        "native_formatted"
      ]
    },
    "policies": {
      "type": "array",
      "items": {
        "type": "object",
        "properties": {
          "order_id": {
            "type": "integer",
            "minimum": 1,
            "maximum": 2147483647
          },
          "require_line_arithmetic": {
            "type": "boolean"
          },
          "subtotal_id": {
            "anyOf": [
              {
                "type": "integer",
                "minimum": 1,
                "maximum": 2147483647
              },
              {
                "type": "null"
              }
            ]
          },
          "grand_total_id": {
            "anyOf": [
              {
                "type": "integer",
                "minimum": 1,
                "maximum": 2147483647
              },
              {
                "type": "null"
              }
            ]
          },
          "component_ids": {
            "type": "array",
            "items": {
              "type": "integer",
              "minimum": 1,
              "maximum": 2147483647
            },
            "minItems": 0,
            "maxItems": 256
          }
        },
        "required": [
          "order_id",
          "require_line_arithmetic",
          "subtotal_id",
          "grand_total_id",
          "component_ids"
        ],
        "additionalProperties": false
      },
      "minItems": 0,
      "maxItems": 16
    }
  },
  "required": [
    "currencies",
    "languages",
    "statuses",
    "ledger",
    "export",
    "amount_mode",
    "policies"
  ],
  "additionalProperties": false
}

Originalschema öffnen

Veröffentlichtes Eingabebeispiel

{
  "currencies": [
    {
      "currency_id": 1,
      "code": "USD",
      "decimal_place": 2
    },
    {
      "currency_id": 2,
      "code": "EUR",
      "decimal_place": 2
    },
    {
      "currency_id": 3,
      "code": "CHF",
      "decimal_place": 2
    },
    {
      "currency_id": 4,
      "code": "JPY",
      "decimal_place": 0
    },
    {
      "currency_id": 5,
      "code": "KWD",
      "decimal_place": 3
    }
  ],
  "languages": [
    {
      "language_id": 1,
      "code": "en-gb"
    },
    {
      "language_id": 2,
      "code": "de-de"
    },
    {
      "language_id": 3,
      "code": "fr-fr"
    }
  ],
  "statuses": [
    {
      "order_status_id": 2,
      "language_id": 1,
      "name": "Recorded"
    },
    {
      "order_status_id": 2,
      "language_id": 2,
      "name": "Erfasst"
    },
    {
      "order_status_id": 3,
      "language_id": 1,
      "name": "Adjusted"
    },
    {
      "order_status_id": 3,
      "language_id": 2,
      "name": "Angepasst"
    }
  ],
  "ledger": {
    "orders": [
      {
        "order_id": 101,
        "store_id": 0,
        "customer_id": 1101,
        "customer_group_id": 1,
        "language_id": 1,
        "language_code": "en-gb",
        "currency_id": 1,
        "currency_code": "USD",
        "currency_value": "1.00000000",
        "total": "40.2961",
        "order_status_id": 2,
        "transaction_id": "opaque-'101-reference",
        "comment": "Snapshot O'Reilly & Grüße 🎯"
      },
      {
        "order_id": 303,
        "store_id": 0,
        "customer_id": 1303,
        "customer_group_id": 1,
        "language_id": 2,
        "language_code": "de-de",
        "currency_id": 2,
        "currency_code": "EUR",
        "currency_value": "0.91234567",
        "total": "99.9999",
        "order_status_id": 3,
        "transaction_id": "opaque-'303-reference",
        "comment": "Snapshot O'Reilly & Grüße 🎯"
      }
    ],
    "products": [
      {
        "order_product_id": 2001,
        "order_id": 101,
        "product_id": 501,
        "master_id": 500,
        "name": "Variant snapshot",
        "model": "SKU-ONE",
        "quantity": 3,
        "price": "12.3456",
        "total": "37.0368",
        "tax": "0.1234",
        "reward": 6
      },
      {
        "order_product_id": 2005,
        "order_id": 101,
        "product_id": 502,
        "master_id": 0,
        "name": "Tiny decimal snapshot",
        "model": "SKU-TINY",
        "quantity": 2,
        "price": "0.0001",
        "total": "0.0002",
        "tax": "0.0000",
        "reward": 0
      }
    ],
    "options": [
      {
        "order_option_id": 5011,
        "order_id": 101,
        "order_product_id": 2001,
        "product_option_id": 41,
        "product_option_value_id": 91,
        "name": "Colour snapshot",
        "value": "Red O'Reilly",
        "type": "select"
      },
      {
        "order_option_id": 5033,
        "order_id": 101,
        "order_product_id": 2001,
        "product_option_id": 42,
        "product_option_value_id": 0,
        "name": "Engraving snapshot",
        "value": "Grüße 🎯\nLine 2",
        "type": "text"
      }
    ],
    "totals": [
      {
        "order_total_id": 4010,
        "order_id": 101,
        "extension": "opencart",
        "code": "tax",
        "title": "First tax",
        "value": "0.2702",
        "sort_order": 30
      },
      {
        "order_total_id": 4011,
        "order_id": 101,
        "extension": "opencart",
        "code": "tax",
        "title": "Second tax",
        "value": "0.1000",
        "sort_order": 30
      },
      {
        "order_total_id": 4020,
        "order_id": 101,
        "extension": "opencart",
        "code": "shipping",
        "title": "Shipping",
        "value": "4.0000",
        "sort_order": 20
      },
      {
        "order_total_id": 4030,
        "order_id": 101,
        "extension": "opencart",
        "code": "coupon",
        "title": "Discount",
        "value": "-1.1111",
        "sort_order": 40
      },
      {
        "order_total_id": 4050,
        "order_id": 101,
        "extension": "opencart",
        "code": "sub_total",
        "title": "Subtotal",
        "value": "37.0370",
        "sort_order": 10
      },
      {
        "order_total_id": 4090,
        "order_id": 101,
        "extension": "opencart",
        "code": "total",
        "title": "Grand total",
        "value": "40.2961",
        "sort_order": 100
      },
      {
        "order_total_id": 7010,
        "order_id": 303,
        "extension": "opencart",
        "code": "sub_total",
        "title": "Subtotal",
        "value": "19.0000",
        "sort_order": 10
      },
      {
        "order_total_id": 7020,
        "order_id": 303,
        "extension": "opencart",
        "code": "tax",
        "title": "Tax",
        "value": "3.6100",
        "sort_order": 20
      },
      {
        "order_total_id": 7090,
        "order_id": 303,
        "extension": "opencart",
        "code": "total",
        "title": "Grand total",
        "value": "22.6100",
        "sort_order": 100
      }
    ]
  },
  "export": {
    "orders": [
      {
        "order_id": 101,
        "store_id": 0,
        "customer_id": 1101,
        "customer_group_id": 1,
        "language_id": 1,
        "language_code": "en-gb",
        "currency_id": 1,
        "currency_code": "USD",
        "currency_value": "1.00000000",
        "total": "40.2961",
        "order_status_id": 2,
        "transaction_id": "opaque-'101-reference",
        "comment": "Snapshot O'Reilly & Grüße 🎯",
        "order_status": "Recorded"
      },
      {
        "order_id": 303,
        "store_id": 0,
        "customer_id": 1303,
        "customer_group_id": 1,
        "language_id": 2,
        "language_code": "de-de",
        "currency_id": 2,
        "currency_code": "EUR",
        "currency_value": "0.91234567",
        "total": "99.9999",
        "order_status_id": 3,
        "transaction_id": "opaque-'303-reference",
        "comment": "Snapshot O'Reilly & Grüße 🎯",
        "order_status": "Angepasst"
      }
    ],
    "products": [
      {
        "order_product_id": 2001,
        "order_id": 101,
        "product_id": 501,
        "master_id": 500,
        "name": "Variant snapshot",
        "model": "SKU-ONE",
        "quantity": 3,
        "price": "12.3456",
        "total": "37.0368",
        "tax": "0.1234",
        "reward": 6
      },
      {
        "order_product_id": 2005,
        "order_id": 101,
        "product_id": 502,
        "master_id": 0,
        "name": "Tiny decimal snapshot",
        "model": "SKU-TINY",
        "quantity": 2,
        "price": "0.0001",
        "total": "0.0002",
        "tax": "0.0000",
        "reward": 0
      }
    ],
    "options": [
      {
        "order_option_id": 5011,
        "order_id": 101,
        "order_product_id": 2001,
        "product_option_id": 41,
        "product_option_value_id": 91,
        "name": "Colour snapshot",
        "value": "Red O'Reilly",
        "type": "select"
      },
      {
        "order_option_id": 5033,
        "order_id": 101,
        "order_product_id": 2001,
        "product_option_id": 42,
        "product_option_value_id": 0,
        "name": "Engraving snapshot",
        "value": "Grüße 🎯\nLine 2",
        "type": "text"
      }
    ],
    "totals": [
      {
        "order_total_id": 4010,
        "order_id": 101,
        "extension": "opencart",
        "code": "tax",
        "title": "First tax",
        "value": "0.2702",
        "sort_order": 30
      },
      {
        "order_total_id": 4011,
        "order_id": 101,
        "extension": "opencart",
        "code": "tax",
        "title": "Second tax",
        "value": "0.1000",
        "sort_order": 30
      },
      {
        "order_total_id": 4020,
        "order_id": 101,
        "extension": "opencart",
        "code": "shipping",
        "title": "Shipping",
        "value": "4.0000",
        "sort_order": 20
      },
      {
        "order_total_id": 4030,
        "order_id": 101,
        "extension": "opencart",
        "code": "coupon",
        "title": "Discount",
        "value": "-1.1111",
        "sort_order": 40
      },
      {
        "order_total_id": 4050,
        "order_id": 101,
        "extension": "opencart",
        "code": "sub_total",
        "title": "Subtotal",
        "value": "37.0370",
        "sort_order": 10
      },
      {
        "order_total_id": 4090,
        "order_id": 101,
        "extension": "opencart",
        "code": "total",
        "title": "Grand total",
        "value": "40.2961",
        "sort_order": 100
      },
      {
        "order_total_id": 7010,
        "order_id": 303,
        "extension": "opencart",
        "code": "sub_total",
        "title": "Subtotal",
        "value": "19.0000",
        "sort_order": 10
      },
      {
        "order_total_id": 7020,
        "order_id": 303,
        "extension": "opencart",
        "code": "tax",
        "title": "Tax",
        "value": "3.6100",
        "sort_order": 20
      },
      {
        "order_total_id": 7090,
        "order_id": 303,
        "extension": "opencart",
        "code": "total",
        "title": "Grand total",
        "value": "22.6100",
        "sort_order": 100
      }
    ]
  },
  "amount_mode": "stored_decimal",
  "policies": [
    {
      "order_id": 101,
      "require_line_arithmetic": true,
      "subtotal_id": 4050,
      "grand_total_id": 4090,
      "component_ids": [
        4010,
        4011,
        4020,
        4030,
        4050
      ]
    },
    {
      "order_id": 303,
      "require_line_arithmetic": true,
      "subtotal_id": 7010,
      "grand_total_id": 7090,
      "component_ids": [
        7010,
        7020
      ]
    }
  ]
}

Ergebnis & Dokumentation

Maschinenlesbare Dokumentation dieses Hubs

Quelle dieser Seite: der veröffentlichte HALOWERK-Katalog. Stand: 2026-11-01, 15:19 UTC.

Weitere Endpunkte dieses Hubs

Alle Endpunkte dieses Hubs →