Login / Sign up
WooCommerce CSV

How to Normalize WooCommerce Type to simple, virtual, downloadable

2026-06-21
Task

The CSV describes product type with internal words: physical, virtual, or downloadable. The WooCommerce Type column needs short values.

Short answer

Create Type: default to simple, set virtual for virtual, and downloadable for downloadable.

How to Do It in Eofferix

  1. Open the settings of the output Type column.
    Table snapshot screenshot with the Type column in Eofferix
    The screenshot shows the output Type column and the settings icon used to open its settings.
  2. In Transformations, set the simple default and add two rules for virtual and downloadable products.
    Screenshot of transformation rules for the Type column
    The Transformations block shows the full rule chain for this case.
  3. Save the column settings and go to the Export step.

Before / After

Before

source data
SKUNameproduct_kind
WC-100Desk lampphysical
WC-101Consultationvirtual
WC-102PDF catalogdownloadable

After

result
SKUType
WC-100simple
WC-101virtual
WC-102downloadable

Process data faster with Eofferix

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

Sign up