How to Normalize Stock Values Like 10+, >10, Out of Stock, and Preorder

Task

The supplier mixes numbers and text in the stock column: 10+, >10, out of stock, preorder. The import needs a numeric stock value.

Short answer

First keep the number with \d+. For text values, add replacements to 0.

How to Do It in Eofferix

1. Open the settings of the output stock column.

   

2. Add \d+ with Remove everything except, then out of stock → 0 and preorder → 0.

   

3. Save the column settings and go to the Export step.

Before / After