Shopify CSV

Fill Shopify SEO title when it is empty

2026-06-21
Task

This case prepares the SEO title column from seo_title_source for the final CSV.

Short answer

Keep the existing SEO title when it is filled; use Title as a fallback for empty SEO title cells.

How to do it in Eofferix

  1. Select the source column or create the output column from the specified source. seo_title_sourceSEO title.

  2. Open the settings of the output column SEO title.

    Open settings: SEO title
    Real animation: opening the output column settings in the table editor.
  3. In Transformations, add the rules shown below.

    Transformations: SEO title
    Real screenshot of the Transformations block for this column.
  4. Save the settings, go to export, and check the values in the downloaded CSV.

Check target column names and accepted values against the official CSV documentation. Shopify CSV.

Before / after

Before

source data
HandleTitleseo_title_source
lampDesk lamp blackBlack desk lamp for home office
posterWall poster
mugCoffee mugCeramic mug 350 ml

After

result
HandleTitleSEO title
lampDesk lamp blackBlack desk lamp for home office
posterWall posterWall poster
mugCoffee mugCeramic mug 350 ml

Process data faster with Eofferix

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

Sign up