FeedPrep for Shopify
Get clean, correctly formatted product data into your Shopify store. Map supplier columns to Shopify's expected format, normalize values so filters and collections work, and export a CSV that Shopify accepts without manual cleanup.
The Problem
Your suppliers don't send data in Shopify's format. You have to fix it every single time.
Random Column Names
Supplier A calls it "product_name", Supplier B calls it "artikel_omschrijving", Supplier C calls it "desc". Shopify expects "Title". You rename columns by hand in a spreadsheet before every import.
Messy, Inconsistent Values
One supplier writes "Blk", another writes "BLACK", a third writes "black/noir". Your Shopify filters show five versions of the same color. Collections break. Customers can't find products.
Price and Unit Chaos
Prices arrive ex-VAT with comma decimals. Weights come in grams, kilograms, or just blank. You fix decimal separators, add VAT, convert units — and do it all again next month when the supplier sends an updated file.
What Shopify Needs
Shopify's CSV import is strict. Your data has to match exactly, or it fails silently or creates a mess.
Specific Column Names
Title, Body (HTML), Vendor, Type, Tags, Variant Price, Variant SKU, Image Src — Shopify expects these exact column headers. Any deviation and the data lands in the wrong field or gets ignored.
Clean, Consistent Values
Filter options and automated collections rely on exact value matches. If some products say "Cotton" and others say "cotton" or "100% cotton", your storefront filters and collection rules break.
Correct Price Formatting
Prices must use dot decimals, include VAT if you sell B2C, and match the expected column structure for variants. One wrong decimal separator and your prices are off by a factor of 100.
How FeedPrep Prepares Your Data
FeedPrep sits between your supplier files and Shopify. It transforms messy supplier data into exactly what Shopify expects.
Map Supplier Columns to Shopify Column Names
Drag "product_name" to "Title", "omschrijving" to "Body (HTML)", "merk" to "Vendor". FeedPrep suggests mappings automatically. Save them as a Supplier Adapter and never map that supplier again.
Normalize Values So Filters and Collections Work
"Blk", "BLACK", "black/noir" all become "Black". Define your canonical values once. FeedPrep applies them to every product, every feed, every supplier. One "Black" — not five variants cluttering your filters.
Add VAT With Transform Rules
Suppliers send ex-VAT prices. Create a transform rule that multiplies Variant Price by 1.25 (or your local rate). Applied automatically to every future feed from that supplier.
Strip or Keep HTML in Descriptions
Some suppliers send raw HTML in their descriptions. Some send plain text. FeedPrep lets you control this per column — strip HTML for clean plain text, or keep it for rich product descriptions in Body (HTML).
Export Shopify-Ready CSV
The output is a CSV file with the exact column names Shopify expects, clean values, correct decimal separators, and VAT-inclusive prices. Upload it to Shopify and you're done.
The Workflow
From raw supplier file to Shopify import in five steps.
Upload supplier feed. CSV, Excel, or XML — FeedPrep parses all common formats automatically.
Map to Shopify schema. Match supplier columns to Shopify's expected column names. FeedPrep suggests mappings based on column content.
Normalize values. Apply value mappings, unit conversions, VAT calculations, and HTML rules. Review the preview.
Export Shopify CSV. Download a CSV with correct Shopify column headers and clean, consistent data.
Import to Shopify. Go to Shopify Admin → Products → Import. Upload the file. Done.
Key Features for Shopify Users
Column Mapping
Map any supplier column name to the exact Shopify header — Title, Body (HTML), Vendor, Type, Tags, Variant Price, Variant SKU, and every other field Shopify expects. Saved per supplier, applied automatically.
Value Normalization for Filters
Ensure your Shopify filters and automated collections work correctly. Map all color, size, and material variations to canonical values so customers see one "Black", one "Medium", one "Cotton".
VAT Transform Rules
Define math-based transform rules on any column. Multiply ex-VAT prices by 1.25 (or any rate), round to two decimals, format correctly. Applied to every row, every feed.
HTML Control
Toggle HTML stripping per column. Keep rich HTML for Body (HTML) to preserve formatting in your product pages. Strip HTML from other fields where it would break the import or look wrong.
Scheduled Exports
Set up automated exports on a schedule. When your supplier sends updated data, FeedPrep processes it and has a fresh Shopify-ready CSV waiting for you to download.
Multiple Supplier Adapters
Each supplier gets their own adapter with their own column mappings, value rules, and transform settings. Manage 1 supplier or 50 — each one mapped once and reused forever.
Get Clean Data Into Shopify Today
Upload a supplier file. Map it to Shopify's format in 15 minutes. Export a CSV that imports without errors.
Start Free Trial — No Credit Card