Skip to content

Automation · Marketplaces

Keep price and stock current between your store and Mercado Libre

How an AI agent reconciles WooCommerce price and stock with Mercado Libre every day, and takes inventory down when a marketplace sale comes in.

How do I stop selling something on Mercado Libre that already sold out in my store?

A scheduled task reconciles every managed listing against the store catalog: it matches on SKU, mirrors the stock with whatever safety buffer you define, and recalculates the channel selling price so that you net what the product is worth in your store. In the other direction only one thing travels, the sale: when a Mercado Libre order comes in, stock goes down in the store by SKU and quantity. The store is the only valid origin of the data. The marketplace is a destination, never a source.

Where it applies: Colombia. The category commission and the category dictionary correspond to Mercado Libre Colombia.

What starts it

At a set time

A task on a recurring (cron) trigger. The bulk reconciliation runs once or twice a day; the sale arriving from the marketplace is reflected when the order comes in, not on the next run.

A task on a recurring (cron) or date and time trigger. It runs on its own, with nobody logged in.

Who runs it

Igor, Warehouse manager

This is the recurring half of his trade. Igor asks explicitly which store is the source before syncing and never assumes it quietly, because that choice decides which price governs.

What you need connected

5 steps · 11 tools

The procedure, step by step

Each step shows the tool that runs. They belong to the real connector: if one of them stopped existing, this page would not build.

  1. 1

    Measure the gap before moving anything

    The gap query answers how many products are in sync and how many are missing, matching the store against the marketplace on the server side so the conversation does not fill with thousands of lines. The store product count gives the denominator. It is the snapshot that tells you whether today's run fixed something or only spent calls.

  2. 2

    Reconcile stock and price in one pass

    The bulk sync walks every managed listing and, for each one carrying your SKU, mirrors the store stock and recalculates the price. The price is not copied as is: it computes the selling price that nets you what the product is worth in your store, counting the real category commission. Copying it without that calculation is selling at a loss and not noticing until settlement.

  3. 3

    Take inventory down when a marketplace sale comes in

    This is the only piece of data that travels from the marketplace back to the store. With the Mercado Libre order, the sale is reflected in WooCommerce stock by SKU and quantity. Recent events and the order search are there to verify that events are arriving, and to answer which sales came in today without opening the marketplace panel.

  4. 4

    Fix one product without running everything

    When the price of a single product changes, a full reconciliation is unnecessary: you find the listing by SKU and sync only its price or only its stock. The stock sync additionally carries two protections that stop it from zeroing out somebody else's listing: it only touches listings that are ours, and it respects the safety buffer.

  5. 5

    Reactivate what got paused for lack of stock

    A product that sold out and came back into stock stays paused until somebody turns it on. Activation walks the managed listings that are paused with stock available and turns them on, running each one through the requirements filter again first. It is money sitting idle that nobody had noticed.

Before you start

What you need ready

The Met solves none of these for you. If one is missing, the automation stops there.

The limits

What this automation does NOT solve

Better said here than discovered halfway through the rollout.

FAQ

Questions about this automation

Because Mercado Libre charges a commission and that commission comes out of what you receive. The sync computes the selling price that nets your store price, using the real category commission. Copying the number as is means selling cheaper than you think, across every listing at once.

It is a reserve that is not published on the marketplace. It exists because sales through other channels can come in between one run and the next, and promising the last unit in two places at once ends in a cancellation, which on Mercado Libre hits the seller's reputation.

Yes, and the shape is the same: there is one source store and the rest of the channels are destinations. Each marketplace is a separate integration, with its own publishing rules.

Keep going

Other automations built on the same tools

Want this automation running on your own data?

We will show it to you with your accounts connected, not with a canned demo.