Marketplaces
Prepare a marketplace import file from your exports
A marketplace expects a precise file: certain columns, in a certain order, with no incomplete row. Your data, meanwhile, is spread across several exports. Mergy brings them together and lets you choose exactly what goes into the import file.
A concrete example
Product data comes from your PIM (file A), prices and stock from your back office (file B). Both share the SKU, though not always with the same case.
| SKU | Title | Barcode |
|---|---|---|
| TS-001 | Organic cotton T-shirt white M | 0360002914015 |
| TS-002 | Organic cotton T-shirt black M | 0360002914022 |
| SW-010 | Grey hoodie L | 0360002914107 |
| CA-005 | Beige linen cap |
| sku | price | quantity |
|---|---|---|
| ts-001 | 19.90 | 42 |
| TS-002 | 19.90 | 7 |
| SW-010 | 49.00 | 15 |
| CA-005 | 24.90 | 8 |
| TS-003 | 19.90 | 12 |
| Statut | SKU | Title | Barcode | price | quantity |
|---|---|---|---|---|---|
| A+B | TS-001 | Organic cotton T-shirt white M | 0360002914015 | 19.90 | 42 |
| A+B | TS-002 | Organic cotton T-shirt black M | 0360002914022 | 19.90 | 7 |
| A+B | SW-010 | Grey hoodie L | 0360002914107 | 49.00 | 15 |
| A+B | CA-005 | Beige linen cap | 24.90 | 8 |
With “Only rows found everywhere”, T-shirt TS-003, missing from the PIM, is not exported. The cap has no barcode (hatched cell): the “Remove rows where Barcode is empty” rule drops it before export, to avoid a rejected import.
How to do it, in three steps
- 1
Drop your exports
Product data on one side, prices and stock on the other, as Excel or CSV.
- 2
Keep complete rows
Choose “Only rows found everywhere” and add a rule to remove rows without a barcode.
- 3
Order the columns
Tick the columns the marketplace asks for and drag them into its template's order, then export.
Follow the marketplace template
Open the import template provided by the marketplace and note its column order. In Mergy, tick only those columns and drag them into the same order: the exported file follows it. If the marketplace requires exact column names, rename them in your source exports or in the final file.
Pick the required format: CSV, Excel or TSV. Barcodes stay text in all three, which avoids the classic rejection of 12-digit codes instead of 13.
Clean up before sending
Cleanup rules apply to the result: remove rows where a column is empty, exclude rows containing a word (“clearance”, for instance), keep a single category, sort, or limit the number of rows for a first test import.
Frequently asked questions
Are lowercase SKUs linked to uppercase SKUs?
Yes. Leading and trailing spaces are removed and case is ignored before matching.
Can I prepare files for several marketplaces?
Yes: export again with another column selection and order, the dropped files stay on the page.
Does Mergy send the file to the marketplace?
No. You download the file and import it yourself in the seller portal.
Your next catalog update takes two minutes.
Prepare my import