Use cases — Page 6

Table editor

How to Convert Milliliters to Liters in a Table

Convert milliliters to liters so catalogs and marketplaces receive volume data in the required unit.

Table editor

How to Create Availability Status from Stock Quantity

Turn stock quantity into availability status so zero and positive values become clear import states.

Table transformations

How to Safely Convert 10+, >10, and Text Stock Values to Numbers

A guarded rule chain converts supported stock formats to numbers and leaves unknown text blank.

Table editor

How to Extract Product Color from the Product Name

Extract product color from the name and normalize it for variants, filters, and product cards.

Table editor

How to Extract Product Size from the Product Name

Extract product size from the name and turn it into a separate field for variants and filters.

Table editor

How to Split Product Dimensions into Length, Width, and Height

Split a value like 120 x 60 x 75 cm into three separate columns.

Table editor

How to Build Product Names from Brand, Model, Color, and Size

Build a product name from supplier columns so the final file has one clean name even when optional fields are empty.

Marketplace feeds

How to Build Separate Availability Values for Google Merchant and Meta

Build channel-specific availability values for Google and Meta while leaving unknown supplier codes blank.

Marketplace feeds

How to turn multiple image URLs into Shopify image rows

A supplier price list has several image links in one cell. For Shopify import, each image URL must become a separate row while keeping the same Handle. In the Image Src column settings, enable Change row structure, ch...

Table transformations

How to Add 20% to a Price, Round It, and Reject Invalid Values

Six ordered rules validate a source price, add 20%, round to an integer, and leave invalid values blank.

Table transformations

How to multiply quantity by price and get a line total

Calculate each line total from quantity and price so the exported table contains a ready line_total value.

Table transformations

How to convert weight from grams to kilograms

A table has weight in grams, sometimes with a suffix such as g. The final field must contain weight in kilograms. In weight_kg, keep the numeric part with a regex rule and then divide the value by 1000.

Table transformations

How to format a date as YYYY-MM-DD

The source table has a date written as 24.06.2026, while the receiver needs YYYY-MM-DD. In the date column, add a Convert date transformation and choose DD.MM.YYYY → YYYY-MM-DD.

Table transformations

How to replace status or category codes with a small dictionary

A feed stores status or category as short codes, for example A and N. The final file needs readable values. For a small dictionary, add several replacement rules in one column: A → active, N → inactive.

JSON

How to convert yes/no, y/n, and 1/0 to true/false in JSON

A JSON flag arrives as a string: yes, ye, y, no, n, 1, or 0. The final JSON needs true and false values. For a small set of values, add sequential replacements: replace y, yes, ye, and 1 with true; replace n, no, and...

JSON

How to omit an empty JSON field in Eofferix

Omit an empty optional key from the resulting JSON while keeping its parent object.

Table editor

How to Remove HTML Tags from a Product Description

Remove HTML markup from product descriptions so the final file keeps clean text without tags.

Interpreter

How to Move XML Attributes into CSV Columns

Move XML product attributes into CSV or XLSX columns so id, code, and similar values become table fields.

Table editor

How to Split a List in One Cell into Separate Rows

Split a list from one cell into separate rows when values are separated by commas or semicolons.

Table editor

How to Merge Rows with the Same SKU

Collect values from repeated rows into one cell using SKU or another grouping key.

Table editor

How to Create a URL Slug from a Product Name

Turn a product name into a URL slug with transliteration, hyphens, and cleanup of extra characters.

Table editor

How to Remove Rows with an Empty Required Field

Remove rows with an empty required field, such as missing SKU, so import does not create broken products.

Table editor

How to Remove Products from a Table by a Short SKU or Brand Blacklist

Filter products by a small SKU or brand blacklist so blocked items do not reach the import.

Table editor

How to Remove Products from a Price List by Brand, Category, or Status

Exclude rows by brand, category, or status when part of a supplier file must not enter the import.

Process data faster with Eofferix

Create a free account and use larger files, saved scenarios and team workflows.

Sign up