5 min read
Edit a PrestaShop or WooCommerce XML product export
Running an e-commerce catalog and need to change hundreds of product entries? Instead of going one by one in the admin, export them as XML, edit them in Excel, and re-import. Here's the full method.
The bulk-editing problem
PrestaShop, WooCommerce, Magento and most PIMs can export the catalog as XML. But that format is built for machines, not human editing. Changing a margin across a whole category, translating descriptions or fixing SKUs quickly becomes unmanageable by hand.
The fix: convert the XML to a spreadsheet, make your changes with the tools you know (formulas, filters, copy-paste), then regenerate the import XML.
The method
- Export your products as XML from your store (native export module or extension).
- Drop the file on ExcelifyXML to get a CSV: one row per product, one column per attribute.
- Edit in Excel — for example apply +10% price on a selection, or a find-and-replace on descriptions.
- Rebuild the XML: the original hierarchy (categories, variants, attributes) is restored.
- Re-import the file into your store.
What to know about the round-trip
ExcelifyXML keeps attributes, nested elements and field order, so the XML stays accepted by your import. Multilingual fields (per-locale tags) are preserved as separate columns.
Standard e-commerce import behavior: an empty or missing field means "don't change the existing value". So even if an empty self-closing tag disappears in the process, your import won't overwrite anything by mistake.
Works on Mac, Windows, Linux
Everything happens online, no install: both transformation and reconstruction run from the site, on any browser — Mac, Windows or Linux.
Edit your product catalog now:
Transform a file