Customer rows with the same email or external_id are grouped together. The export should contain one row per customer. Enable Change row structure, choose Merge similar rows, and use email or external_id as the merge...
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...
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.
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...
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...
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...
Create <code>country_code</code> from <code>country</code> and add replacements: <code>Germany</code> → <code>DE</code>, <code>Spain</code> → <code>ES</code>, <code>France</code> → <code>FR</code>.
Create <code>pack_qty</code> and keep the number before <code>pcs</code> or <code>units</code> with <code>\d+(?:[,.]\d+)?(?=\s*(?:pcs?|units?))</code>.
First keep the number. If the source contains <code>mm</code>, divide by <code>10</code>; if it contains the separate unit <code>m</code>, multiply by <code>100</code>; leave <code>cm</code> unchanged.
Keep the number with <code>\d+(?:[,.]\d+)?</code>, then divide the value by <code>1000</code>.
Create <code>availability</code> from <code>stock</code>: if the value is <code><= 0</code>, replace it with <code>out_of_stock</code>; if it is <code>> 0</code>, replace it with <code>in_stock</code>.
First keep the number with <code>\d+</code>. For text values, add replacements to <code>0</code>.
Create <code>color</code> from <code>name</code> and add a small dictionary: when the name contains a color, replace the value with the normalized color.
Create <code>size</code> from <code>name</code> and keep only the size with <code>\b(?:XS|S|M|L|XL|XXL|XXXL)\b|\b\d{2}\b</code>.
Split a value like 120 x 60 x 75 cm into three separate columns.
Build one product name column from several supplier columns.
A supplier table stores availability as short codes such as A and N. For an advertising feed, the final availability column must contain accepted values such as in_stock and out_of_stock. Open the final availability c...
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...
A price list contains prices without VAT or without markup. The final file needs the price increased by a percentage and then rounded. In the price column, add two transformations: Increase by % with value 20, then Ro...
A table contains qty and price. The final file needs a per-row amount in line_total. Create line_total from price and add a Multiply transformation with value {qty}.
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.
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.
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.
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...
Create a free account and use larger files, saved scenarios and team workflows.
