Supplier catalogs

How to normalize availability in a supplier JSON catalog

2026-06-28
Task

The supplier JSON API returns availability values such as available, preorder, and discontinued. Your catalog schema needs in_stock instead of available, while the other statuses stay explicit.

Short answer

Open the availability value settings and add replacement rules: available -> in_stock, preorder -> preorder, discontinued -> discontinued.

How to do it in Eofferix

  1. Open the JSON editor and find the availability value in the product object.

    JSON availability field in Eofferix
    The highlighted value is the field that will be normalized before export.
  2. Open the value settings.

    Opening availability settings in the JSON editor
    The animation shows opening settings for the repeated JSON field.
  3. Add replacement rules for each known supplier status.

    JSON availability replacement rules in Eofferix
    The rules map supplier values to the catalog vocabulary before export.

Before / after

Before

source data
{
    "supplier": "Northline",
    "products": [
        {
            "sku": "SKU-3001",
            "name": "Hudson lamp",
            "availability": "available"
        },
        {
            "sku": "SKU-3002",
            "name": "Parker chair",
            "availability": "preorder"
        },
        {
            "sku": "SKU-3003",
            "name": "Harbor shelf",
            "availability": "discontinued"
        }
    ]
}

After

result
{
    "supplier": "Northline",
    "products": [
        {
            "sku": "SKU-3001",
            "name": "Hudson lamp",
            "availability": "in_stock"
        },
        {
            "sku": "SKU-3002",
            "name": "Parker chair",
            "availability": "preorder"
        },
        {
            "sku": "SKU-3003",
            "name": "Harbor shelf",
            "availability": "discontinued"
        }
    ]
}

What to keep in mind

  • Normalize statuses before import so catalog rules do not depend on each supplier vocabulary.
  • When the API sends a nested products array, Eofferix still lets you configure the repeated field.
  • For unknown statuses, add a separate rule or leave them unchanged for review.

Process data faster with Eofferix

Create a free account to automate catalogs and price lists around your own rules.

Sign up