FeedPrep for WooCommerce
Turn messy supplier data into clean, WooCommerce-ready product CSVs. Map columns once, normalize attribute values, and import with confidence — every time.
The Problem
WooCommerce Expects a Specific CSV Format
The WooCommerce product importer requires exact column headers like regular_price, categories, and attribute:Color. Supplier files never use these names. You end up manually renaming columns in a spreadsheet before every import.
Inconsistent Attributes Break Variable Products
Variable products rely on consistent attribute values for variations to work. If one supplier sends "Blauw", another sends "blue", and a third sends "BLUE" — you get three separate filter options instead of one. Customers can't find what they're looking for.
Messy Categories and Tags
Supplier category trees don't match your store's taxonomy. Importing them raw creates duplicate categories, orphaned tags, and a navigation structure that confuses both customers and search engines.
What WooCommerce Needs
A successful WooCommerce product import requires three things that supplier data almost never provides out of the box.
Correct CSV Column Format
WooCommerce expects headers like SKU, Name, regular_price, sale_price, categories, images, and attribute:<Name>. Every column must match exactly or the importer skips it.
Consistent Attribute Values
For variable products, attribute values must be identical across parent and variation rows. "Large" and "large" are two different options in WooCommerce. Filters and layered navigation only work when values are perfectly consistent.
Clean Categories and Tags
Categories should use WooCommerce's hierarchy format (Clothing > T-Shirts). Tags should be normalized and deduplicated. Importing raw supplier taxonomies pollutes your store's navigation and SEO structure.
How FeedPrep Prepares Your Data
FeedPrep sits between your supplier files and WooCommerce. It transforms raw data into import-ready CSVs using rules you define once.
Map Supplier Columns to WooCommerce CSV Format
Drag your supplier's columns onto WooCommerce fields. artikelnr becomes SKU. omschrijving becomes Name. prijs_excl becomes regular_price. FeedPrep remembers the mapping for every future file from this supplier.
Normalize Attribute Values for Consistent Variations
Define approved values for each attribute. FeedPrep maps "Blauw", "blauw", "BLUE", and "Bl." to "Blue". Variable products get consistent variation options. Filters work as expected.
Approved Values for Filters and Layered Navigation
Maintain a controlled list of allowed values per attribute. Any value not on the list gets flagged for review. Your store's layered navigation stays clean and usable for customers.
Transform Rules for Pricing
Add VAT automatically. Convert currencies using configurable rates. Apply rounding rules (e.g., always round to .95). Calculate sale prices as a percentage of regular price. All defined once, applied to every import.
Export WooCommerce-Compatible CSV
The final export matches WooCommerce's expected format exactly — correct column headers, proper delimiter, UTF-8 encoding. Upload directly via WooCommerce's built-in product importer or WP All Import.
The Workflow
From raw supplier file to WooCommerce import in four steps.
Upload supplier file. CSV, XLSX, or XML — FeedPrep parses all common formats. Column types are auto-detected.
Map and transform. Map supplier columns to WooCommerce fields. Set approved values for attributes. Configure pricing rules. Save as a Supplier Adapter.
Review and approve. Preview the normalized data. Check flagged values. Fix any issues before export. See completeness scores per product.
Export and import. Download a WooCommerce-ready CSV. Upload it via the built-in WooCommerce importer. Products, variations, and attributes are correct on the first try.
Key Features for WooCommerce Users
Supplier Adapters
Each supplier gets a saved adapter with column mappings, value translations, and pricing rules. When they send a new file next month, upload it and the adapter handles everything automatically.
Attribute Value Control
Define approved values for Color, Size, Material, and any custom attribute. FeedPrep normalizes incoming values and flags anything it can't match — so your variable products always have consistent, filterable options.
Category Mapping
Map supplier category trees to your WooCommerce taxonomy. "Kleding > Bovenkleding > T-shirts" becomes "Clothing > T-Shirts". Defined once per supplier, applied to every future feed.
Feed Health Reports
Before you export, see exactly which products are missing required fields, have suspicious prices, or contain unrecognized attribute values. Fix issues before they reach your store.
Pricing Transform Rules
Add VAT at configurable rates. Convert EUR to GBP. Round to psychological price points. Calculate margin-based pricing. All applied consistently across thousands of products.
Multi-Supplier Merge
Combine products from multiple suppliers into a single WooCommerce import file. FeedPrep deduplicates by SKU and lets you set priority rules when suppliers overlap.
Clean Supplier Data for WooCommerce — In Minutes, Not Hours
Upload your messiest supplier file. Map it to WooCommerce format in 15 minutes. Never do it manually again.
Start Free Trial — No Credit Card