Login / Sign up
Shopify CSV

How to Fill Shopify Gift card from Product Type

2026-06-21
Task

The CSV has regular products and gift cards. The Gift card column should be true only for certificates or gift cards.

Short answer

Create Gift card: default to false, and set true when product_type contains gift card or certificate.

How to Do It in Eofferix

  1. Open the settings of the output Gift card column.
    Table snapshot screenshot with the Gift card column in Eofferix
    The screenshot shows the output Gift card column and the settings icon used to open its settings.
  2. In Transformations, set false by default and add a separate rule for gift cards.
    Screenshot of transformation rules for the Gift card 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
HandleTitleproduct_type
gift-card-50Gift card 50gift card
desk-lampDesk lampphysical

After

result
HandleGift card
gift-card-50true
desk-lampfalse

Process data faster with Eofferix

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

Sign up