WooCommerce product import
Easy product import with variations. WooMate prepares it for you
You upload a CSV or Excel file from your supplier, and WooMate maps the columns, groups rows into variations, recalculates prices and checks what will change in your store. All you do is approve the save.
A file from a URL or a Google Sheet can also update prices and stock on its own every few hours. No WordPress plugin.
- 14 days with no WooMate fee, no credit card
- Import works without AI and without an API key.
We'll help you set things up and run your first import. Free.
A file from your supplier
15 rows from the supplier, 3 products in your store. No spreadsheet fixing
WooMate maps the columns and groups rows into variations on its own. From names like “11 kW” and “15 kW” it builds a power selector on the product page.
- CSV or Excel with columns named any way you like: “Item code”, “Item name”, “Qty”
- Variations from the name or SKU: power, capacity, size, color
- Row filter: e.g. only the “Boilers” category or stock above 0
- Column layout remembered for the next file from that supplier
15 rows in the file · 3 products (1 simple, 2 variable) · 3 categories
- Defro Komfort Eko Mini coal pellet boilerSKU k-gro-def-002 · variable product · from $10,690.00
Power:11 kW15 kW20 kW24 kW30 kW40 kW
- Kamen WDS coal boilerSKU k-kamen-wds-001 · variable product · from $7,390.00
Power:10 kW15 kW20 kW26 kW32 kW
- DEFRO MP1 magnetic filterSKU 602171 · simple product · from $1,087.30
Price rule
Your supplier's purchase price turns into your store price, ending in .99
You set a markup or margin, your supplier discount and VAT once per supplier. Every next file recalculates on its own, variation prices included.
- Markup or margin calculated from the price after your discount
- Net or gross in the file and in the store
- Rounding to the cent, up to .99 or up to a whole unit
| Product | Price in file (net) | Store price (gross) |
|---|---|---|
| Defro Komfort Eko Mini boiler 11 kW | $7,040.00 | $10,282.99 |
| Kamen WDS coal boiler 10 kW | $4,860.00 | $7,098.99 |
| DEFRO DGP 25/180 pump group | $1,180.00 | $1,723.99 |
| DEFRO MP1 magnetic filter | $715.00 | $1,044.99 |
Dry run
You see every price change before it reaches your store
New price list from your supplier? WooMate compares the file with your store and shows before and after. It skips bad rows and gives you the row number and reason.
- Update, New, Unchanged, Skip: the whole file in a few numbers
- Before → after for every field, variation prices included
- Unchanged products are skipped, not saved a second time
- A list of issues to CSV, and the rest saves without them
- A dry run doesn't change your store and doesn't use your limit
- 2Update
- 0New
- 1Unchanged
- 2Skip
- 1Not in file
Examples: before → after
- Defro Komfort Eko Mini · 11 kW variationPrice
$10,280.00$10,690.00 - Defro Komfort Eko Mini · 20 kW variationPrice
$12,298.00$12,790.00 - Defro Komfort Eko Mini · 40 kW variationPrice
$17,249.00$17,939.00 - DEFRO MP1 magnetic filterPrice
$1,045.50$1,087.30
Not in file: 1 product will be marked as unavailable. For example: DEFRO DFM 2 magnetic filter.
3 rows with issues will be skipped
- Row 14 Price: invalid value “on request”.
- Row 15 Duplicate SKU 602299 (rows 15, 16). Skipping all of these rows.
- Row 16 Duplicate SKU 602299 (rows 15, 16). Skipping all of these rows.
I'll change only these fields in the store: price, stock. An empty cell in these columns will clear the field in the product.
Wholesaler sync
Supplier prices and stock update on their own, and big changes wait for you
You give the address of a file or a Google Sheet. Every few hours WooMate fetches it, checks it and saves on its own only small price and stock changes.
- A file from a URL or a Google Sheet, CSV or Excel
- Every 1, 6, 12 or 24 hours, or on demand
- Saves on its own only up to a threshold, e.g. a 30% price change
- New products and big changes wait in the store panel for your approval
- every 6 hours
- saves on its own up to a 30% price change
- 06:00
No changes in 214 products
- 12:00
Saved automatically: 3 prices (up to 6%) and 18 stock levels
- 18:00
Missing from the file: 2 products marked as out of stock
- 00:00
1 price changes by more than 30%: waiting for you
Waiting for you
Defro Komfort Eko Mini · 40 kW: price $17,249.00 → $24,499.00 +42%
Background work and undo
Import runs in the background, checks every save, and you undo it with one button
After saving, WooMate reads the product back from your store. If something goes wrong, Undo import restores the values from before the import.
- Read-back after saving for every product and variation
- Needs checking instead of a duplicate when a save is interrupted
- Undo import: old prices and stock come back, new products become drafts
- Defro Komfort Eko Mini · 11 kWConfirmed
- Defro Komfort Eko Mini · 15 kWConfirmed
- Defro Komfort Eko Mini · 20 kWConfirmed
- Defro Komfort Eko Mini · 24 kWConfirmed
- Kamen WDS · 10 kWConfirmed
- Kamen WDS · 15 kWConfirmed
- Kamen WDS · 20 kWConfirmed
- DEFRO MP1 magnetic filterConfirmed
8 of 8 products confirmed by reading the store
Supplier price lists
New manufacturer price list? The price changes are ready for your approval
Every 24 hours WooMate checks the manufacturer's website. It compares a new PDF with the previous one and calculates your store prices using your rule.
- A quote and page number for every price from the PDF
- Discount, markup and VAT in one price rule
- Preview, save and undo of changes in your store
- PDF reading by AI on your own key, with a cost limit before it starts
Source
Defro — boilersNew price list version: 3 price changes. Compare the items before you approve changes in your store.
| Model | Net list price | In store → suggested |
|---|---|---|
| Komfort Eko Mini 11 kWp. 4: “Komfort Eko Mini 11 kW … 7,590.00 net” | 10,280.00 → $10,680.04 | |
| Komfort Eko Mini 15 kWp. 4: “Komfort Eko Mini 15 kW … 8,120.00 net” | 10,999.00 → $11,425.81 | |
| Komfort Eko Mini 20 kWp. 4: “Komfort Eko Mini 20 kW … 9,090.00 net” | 12,298.00 → $12,790.72 |
WooMate or WP All Import Pro?
WP All Import is a popular WordPress import plugin. WooMate works differently: it prepares the import outside your store and shows every price change before saving.
Installation
WooMate ImportNothing to install in WordPress. WooMate connects to your store through the WooCommerce API.
WP All Import ProA WordPress plugin; the import runs on your store's server.
Preparing the import
WooMate ImportColumns mapped automatically, variations grouped by name or SKU, e.g. power “11 kW”, and the test run starts without clicking.
WP All Import ProAutomatic setup or a manual field template. You group variations by parent, Group ID or title.
Check before saving
WooMate ImportA dry run on the whole file: Update, New, Unchanged, Skip, and every price before → after, variations included.
WP All Import ProA preview of how the product looks in the admin and on the storefront.
Price rule
WooMate ImportMarkup or margin, supplier discount, VAT and .99 endings in a few fields, no coding.
WP All Import ProCalculations in the import template, including PHP functions.
Supplier feed sync
WooMate ImportA file from a URL or a Google Sheet every 1–24 h. Saves changes up to a set threshold on its own; bigger changes and new products wait for approval.
WP All Import ProImport from a URL, FTP or Google Sheets on a schedule: a cron job on the server or a paid service.
Products missing from the file
WooMate ImportMarks products in a chosen scope (SKU prefix, category) as out of stock, with a list before saving.
WP All Import ProDeletes or marks as out of stock the records that aren't in the file.
Undoing an import
WooMate ImportOne button: products go back to their values from before the import, new ones become drafts.
WP All Import ProThe documentation doesn't describe undoing an import.
Manufacturer price lists in PDF
WooMate ImportChecks the manufacturer's website every 24 h, reads the new PDF and calculates your store prices using your rule.
WP All Import ProDoesn't read PDFs. Supports CSV, Excel and XML.
Formats and sources
WooMate ImportCSV and Excel (XLSX) up to 10 MB from your computer, a URL or Google Sheets.
WP All Import ProCSV, Excel and XML up to 256 MB, also from FTP.
Help
WooMate ImportFree help with your first file, step by step by email.
WP All Import ProDocumentation and support.
Price
WooMate ImportImport in the Pro plan for $99 a month, together with Studio, Monitor and WooMate AI.
WP All Import ProWooCommerce import bundle from $169 a year, import only.
Want supplier prices and stock to update on their own, without the risk of a wrong price in your store? Choose WooMate. Need XML import or files over 10 MB? That's where WP All Import has the edge.
WP All Import Pro data from wpallimport.com, as of November 3, 2026. The WP All Import name belongs to its owner.
Import limits and costs
Import and sync work without AI, so you don't pay for tokens. An AI key is only useful for reading PDF price lists.
- 10 MB
CSV or Excel (XLSX) file, with encoding and delimiter detected automatically
- 10,000
products in one file, after grouping rows into variations
- $0
for AI during import and sync
- every 1 h
the most frequent supplier sync, up to 10 sources per store
- 50
products to save during the free trial; a dry run doesn't count toward the limit
What should you know before you start?
Which files does WooMate Import support?
CSV and Excel (XLSX) up to 10 MB, from your computer, a URL or a Google Sheet. Save older XLS files as XLSX. Supplier price lists accept PDFs up to 12 MB.
Do I have to fix my supplier's file?
Usually not. Column names can be anything, because you map them in the app. The file needs unique headers, the same number of columns in every row and a SKU or ID in each row.
Will updating prices change my descriptions?
Not unless you map their columns. Update mode maps only SKU, ID, prices and stock by default.
Will products go on sale right away?
If you don't specify a status, they are created as published. To create drafts, add a column with the value draft and map it to status.
Can I close the tab during an import?
Yes. Import runs on the server. You'll find the progress and result on the Import screen and in the history.
What happens if the server stops in the middle of saving?
The item that was being saved gets the Needs checking status, and the import waits for your decision. WooMate doesn't retry that save on its own.
Does Import need an API key?
File import and sync don't. An API key is only needed for reading PDF price lists with AI. You can also add items by hand.
Will the sync save anything without my approval?
Only what you allow: price and stock changes up to the threshold you set, e.g. 30%. New products and bigger changes wait for approval in the store panel. Automatic saving is off by default.
Can I undo an import?
Yes. Undo import restores prices, stock and other fields from before the import, and turns products created by the import into drafts. It doesn't undo images and categories, and it skips products changed in the store after the import.
How is WooMate different from WP All Import?
WooMate doesn't install a plugin in WordPress, prepares the import on its own, shows every price change before saving and undoes an import with one button. Supplier feed sync saves on its own only changes up to a set threshold. WP All Import also supports XML, FTP and files up to 256 MB. See the comparison
What doesn't the import do?
It doesn't read XML files or the older XLS format, doesn't fetch files from FTP and doesn't change the type of an existing product. It doesn't transfer dimensions, tags or sale dates, and it doesn't match products by name: updates need a SKU or ID. You can prepare descriptions in WooMate Studio.
What does the free trial include?
For 14 days you can test WooMate on one store. The import limit is 50 products, counted after grouping rows into variations. A dry run doesn't use the limit, and items that weren't saved don't count toward it. After the trial, Import is included in the Pro, Pro Lifetime and Agency plans. Compare plans
We'll go through your first file together. Free
Have a CSV from your supplier? We'll help you connect your store, map the columns and choose how to group variations. Together we'll go through the check and the first save.
Onboarding happens by email. We reply to requests within 24 hours.
Have a question? Write to us
Ask whether WooMate can handle your store, your catalog or a specific task. We reply personally, usually on the same business day.
- Reply within 24 hours
- No account needed
- You can also email hello@getwoomate.com