Import API: Import Data Using POST & PUT

{
  "type": "categories",
  "data": [
    {
      "categories_id": 142,
      "parent_id": 110,
      "status": 1,
      "languages": {
        "de": {
          "categories_name": "Produktattribute",
          "categories_description": "<p>Beschreibung als HTML-String...</p>"
        }
      }
    }
  ]
}

{
  "success": true,
  "api_version": "2.1.0",
  "type": "categories",
  "stats": {
    "total": 2,
    "inserted": 1,
    "updated": 1,
    "failed": 0
  },
  "errors": [],
  "timestamp": "2026-01-27 14:00:00",
  "records": [
    {"index": 1, "categories_id": 144, "status": "inserted"},
    {"index": 2, "categories_id": 142, "status": "updated"}
  ]
}

Additional fields for a product are written exclusively via the extra_fields field—not as a field at the top level of the product. A key such as google_product_category directly next to products_model is ignored (and reported in the response as UNKNOWN_FIELD ).

Starting with v2.51.0, any of the following formats are accepted—either using the field ID or the field name (case and spaces are ignored):

{
  "type": "products",
  "data": [{
    "products_model": "ABC-123",

    "extra_fields": {
      "Google Produktkategorie (xoPort)": "1234",
      "Google Zustand (xoPort)": "new",
      "Google Verfügbarkeit (xoPort)": "in stock"
    }

    // ... alternativ nach Feld-ID:
    // "extra_fields": {"7": "1234", "8": "new", "9": "in stock"}

    // ... oder als Liste:
    // "extra_fields": [{"products_extra_fields_id": 7, "products_extra_fields_value": "1234"}]
  }]
}

The structure returned by the JSON export (an object keyed by field ID) can also be imported again without any changes.

Google Shopping Fields

The fields in the Google feed are standard additional fields with fixed IDs:

Product tabs (e.g., “Product Description,” “Data Sheet,” “Installation Instructions”) are maintained via the tabs field—a flat array of tab objects. A nested format such as {"de": […]} is not supported and is ignored without an error message (no warning, no tabs).

{
  "type": "products",
  "data": [{
    "products_model": "ABC-123",

    "tabs": [
      {
        "tab_name": "Leistungsbeschreibung",
        "tab_content": "<h3>Leistungsbeschreibung</h3><p>...</p>",
        "language_id": 2,
        "sort_order": 0
      },
      {
        "tab_name": "Service description",
        "tab_content": "<h3>Service description</h3><p>...</p>",
        "language_id": 1,
        "sort_order": 0
      }
    ]
  }]
}

Behavior in Detail

• New creation: Any entry without ` tab_id ` creates a new tab with its own ` tab_id ` —one per language. Multilingual tabs are therefore sent as one entry per language (see example above); the frontend displays only the tabs for the active language, filtered by language.
• tab_id Update: Using ` tab_id ` updates the existing tab in the specified language—but only if the language entry already exists. A missing language version of an existing tab cannot be created retroactively via the API (to do so, send a new tab without ` `).
• No “Delete-on-absent”: Tabs not included in the request remain unchanged. Tabs are deleted in the backend at the product level.
• Export round trip: GET /products returns the tabs as an object keyed by tab_id (including tab_name, tab_content, language_id, and sort_order).

Stock, safety stock, and reorder point for each warehouse are maintained in the product import exclusively via the field storages —a flat array of warehouse objects, each with storages_id (alias warehouse_id). Since v2.45.0, this is a partial update: a partial payload such as {"storages_id": 3, "products_reorder_level": 10} changes only the reorder point for this warehouse and does not set the remaining warehouse columns to 0.

This requires the extended inventory system to be enabled (EXTENDED_STORAGE_SYSTEM); otherwise, the field is ignored and the response includes the warning “ STORAGE_SYSTEM_DISABLED.” All fields, their semantics, and potential pitfalls are described in the “Inventory & Reorder Points per Warehouse ” section of the Products reference.