Table editor

How to Create Availability Status from Stock Quantity

2026-06-20

Task

The table has numeric stock, while the feed needs text availability: in_stock or out_of_stock.

Short answer

Create availability from stock: if the value is <= 0, replace it with out_of_stock; if it is > 0, replace it with in_stock.

How to Do It in Eofferix

  1. Open the settings of the output availability column.
    Animation showing how to open the availability column settings
    The click is on the settings icon of the availability column.
  2. Add two rules: less than or equal to 0out_of_stock, then greater than 0in_stock.
    Screenshot of transformation rules for the availability column
    The Transformations block shows the full rule chain for this case.
  3. Save the column settings and go to the Export step.

Before / After

Before

source data
skustock
SKU-6005
SKU-6010

After

result
skuavailability
SKU-600in_stock
SKU-601out_of_stock

Process data faster with Eofferix

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

Sign up