Your normalized data uses your internal attribute names — color, weight, material. But each destination system expects its own column names. FeedPrep's export column mapping lets you translate your canonical attributes into whatever the target system requires, without changing your source data.
How It Works
Each export configuration includes an optional column mapping. This mapping defines which source attributes to include in the export and what name each one should have in the output file.
| Your Attribute | Shopify Export | Akeneo Export | Google Merchant Export |
|---|---|---|---|
name | Title | name-en_US | g:title |
description | Body (HTML) | description-en_US | g:description |
price | Variant Price | price-EUR | g:price |
color | Option1 Value | color | g:color |
weight | Variant Grams | weight | g:shipping_weight |
sku | Variant SKU | sku | g:id |
The same normalized data, three completely different output structures. Each export config maintains its own column mapping independently.
Field Transforms on Export
Sometimes a destination needs more than just a renamed column — it needs the value in a different format. FeedPrep supports field-level transforms that are applied during export without modifying your source data:
- html_wrap — wraps plain text in HTML paragraph tags for platforms that expect HTML descriptions
- kg_to_grams — converts weight values from kilograms to grams (e.g., Shopify's
Variant Gramsfield expects grams) - cm_to_mm — converts dimension values from centimeters to millimeters
- uppercase — converts text to UPPERCASE
- lowercase — converts text to lowercase
- titlecase — converts text to Title Case
Transforms are configured per column per export. For example, your Shopify export can apply kg_to_grams to the weight column and html_wrap to the description, while your Akeneo export sends the same data untransformed.
Multiple Export Configs per Feed
A single feed can have as many export configurations as you need. This is the key to a "normalize once, export everywhere" workflow:
- Webshop export — CSV with Shopify column names, weight in grams, HTML descriptions
- PIM export — CSV with Akeneo attribute codes, PIM codes for select values, measurements split into separate columns
- Marketplace export — XML with Google Merchant namespace-prefixed fields
- Internal review export — XLSX with your canonical attribute names for team review in Excel
Each configuration stores its own format, column mapping, field transforms, and row filters. Changing one export never affects the others.
Setting Up a Column Mapping
- Go to your feed's Exports tab
- Create a new export configuration or edit an existing one
- In the Column Mapping section, add entries for each attribute you want to include
- For each entry, select the source attribute and type the target column name
- Optionally add a field transform
- Attributes not included in the mapping are excluded from the export
If you leave the column mapping empty, FeedPrep exports all attributes using their canonical names.