Table transformations
How to remove brand, SKU, and size from product names in a spreadsheet
Clean product names by removing brand, SKU, and size so the final name field stays short and readable.
Use cases — Page 5
Data transformation
How to build product tags from brand, category, color and size
Build product tags from brand, category, color, and size to prepare one field for search and filters.
Data transformation
How to build offer id from product id, color and size
Build a stable offer id from product ID, color, and size so product variants stay distinct during import.
XML transformation
How to remove XML offers without an image
Remove XML offers without an image so the export includes only products with a filled picture field.
Data transformation
How to calculate discount percent from old and new price
Calculate discount percent from old and new prices so the export gets a ready discount_percent field.
Data transformation
How to fill sale_price only for discounted products
Fill sale_price only for discounted products so regular items do not get a false sale price.
Data transformation
How to exclude products with prices outside an allowed range
Add row export conditions to the price column: the price must be greater than or equal to the minimum and less than or equal to the maximum.
Data transformation
How to convert cents or minor units into a price
Convert cents or minor units into normal money values so exported prices are not inflated.
Data transformation
How to normalize order statuses for a CRM
Normalize different order statuses to CRM values so paid, canceled, and local variants match.
Data transformation
How to split a customer full name into first and last name
Split a client full name into two columns so first and last name can be imported separately.
Data transformation
How to split rating and review count from one cell
Split rating and review count from one text field into separate numeric columns for reporting.
Data cleanup
How to remove Total and Subtotal rows from an export
Supplier tables can contain service rows such as Subtotal or Total. They should not be exported as product rows. In sku, add row export conditions: SKU is not empty, and name does not match the service marker.
Table transformations
How to split a category path into levels
The path column contains a value such as Clothing/Jackets/Winter. The export needs category_1, category_2, and category_3. Create three final columns from path and keep the needed part with a regex rule in each one.
Table transformations
How to build a category path from several columns
Category levels are stored in cat_1, cat_2, and cat_3. The result needs one category path without extra separators when a level is empty. Create category_path from cat_1. Then append cat_2 and cat_3 only when the corr...
Table transformations
How to merge order items into one row by order_id
Each order item is a separate row. The export needs one row per order_id and a list of SKUs joined with a separator. Create sku_list from sku, enable row merging, and merge rows by order_id.
Data cleanup and merging
How to Merge Adjacent Customer Duplicates by Email or external_id
Eofferix merges adjacent rows with the same non-empty key and joins unique values from other columns with a semicolon.
Feeds and marketplaces
How to rename supplier columns for a marketplace template
A supplier uses columns such as supplier_sku, product_name, supplier_price, and photo_link. The marketplace template needs sku, title, price, and image_url. Create final columns with the marketplace names and bind eac...
Feeds and marketplaces
How to turn relative image links into absolute URLs
The source sends image paths such as /upload/1001.jpg, while the receiver accepts only absolute URLs. In image_url, add a rule: if the current value does not contain http, add the site domain at the beginning.
Feeds and marketplaces
How to keep only rows with valid image links
A supplier file contains full image URLs, relative paths, and empty cells. Only rows where the image link starts with http:// or https:// should be exported. In image_url, add a row export condition: current value bef...
Table transformations
How to extract UTM tags from a link into separate columns
The url column contains a link with utm_source, utm_medium, and utm_campaign. The export needs a separate column for each tag. You can extract the value by removing parts of the string step by step. For many links, th...
Table transformations
How to extract a domain from a website URL
A table contains full page URLs. The export needs a separate domain column with only the domain, without http://, https://, www., path, query parameters, or anchor. You can do it without regular expressions by searchi...
Table editor
How to Normalize Country Names to ISO Codes
Normalize country names to ISO codes so CRM, ERP, or marketplace imports receive one format.
Table editor
How to Extract Pack Quantity from Text
Extract pack quantity from a text description to get a separate numeric pack_qty field.
Table editor
How to Convert mm, cm, and m to Centimeters in a Table
Convert mixed millimeter, centimeter, and meter values into one centimeter column for import.
Process data faster with Eofferix
Create a free account and use larger files, saved scenarios and team workflows.