E-commerce
Update your store's stock and prices from a supplier feed
Every week your supplier sends a stock and price file. Mergy matches it with your catalog on the SKU or barcode and gives you a file ready to import, without VLOOKUP and without losing a single zero.
A concrete example
Your catalog (file A) holds your product pages. The supplier feed (file B) holds purchase prices and stock. The shared column is the barcode.
| Barcode | Product | Retail price |
|---|---|---|
| 0376012345690 | LED desk lamp | 39.90 |
| 0376012345706 | Ergonomic chair | 189.00 |
| 0376012345713 | XL mouse pad | 14.90 |
| ean13 | cost_price | stock |
|---|---|---|
| 0376012345690 | 18.40 | 120 |
| 0376012345706 | 96.00 | 14 |
| 0376012345737 | 3.80 | 1,250 |
| Statut | Barcode | Product | Retail price | cost_price | stock |
|---|---|---|---|---|---|
| A+B | 0376012345690 | LED desk lamp | 39.90 | 18.40 | 120 |
| A+B | 0376012345706 | Ergonomic chair | 189.00 | 96.00 | 14 |
| A | 0376012345713 | XL mouse pad | 14.90 | ||
| B | 0376012345737 | 3.80 | 1,250 |
The mouse pad is no longer in the supplier feed (A only): check it before keeping it on sale. The last item is new at the supplier (B only): a product page still needs to be created.
How to do it, in three steps
- 1
Drop catalog and feed
Excel, CSV or ODS, exactly as they come out of your store and your supplier.
- 2
Link them by barcode
“Barcode” on one side, “ean13” on the other: Mergy suggests the right pair from the content.
- 3
Export the import file
Keep the columns your store expects, in the right order, and drop out-of-stock rows if needed.
Every week, in two minutes
The feed changes, so does your catalog, but the routine stays the same: drop both files, check the suggested column, export. The A+B, A and B counters tell you right away how many products were updated, how many left the feed and how many are new.
Pitfalls to watch
If your catalog and the feed share a column name, say “Price”, Mergy keeps the catalog's value and only fills it from the supplier when it is empty. To replace your prices with the feed's, keep different names and only tick the supplier's column.
If a barcode appears twice in the feed (two pack sizes, for instance), the product appears twice in the result. The row total flags it before export.
Frequently asked questions
My supplier uses a different column name. Does it still work?
Yes. You pick the column in each file, and Mergy shows the number of matching values so you can check.
Are the leading zeros of my barcodes kept?
Yes. Every cell is read as text: no barcode turns into scientific notation.
My catalog has more than 15,000 rows.
The free plan stops at 15,000 rows per merge. The Pro plan has no limit.
Your next catalog update takes two minutes.
Update my catalog