In this video, a simple workflow is demonstrated for syncing a WooCommerce catalog to Decathlon Marketplace Romania.
It removes manual XLS imports and keeps products, prices, stock, and images up to date.
At a glance: we read data from WooCommerce, log it in Google Sheets, fetch the product image from Drive, and then create or update the listing on Decathlon.
The process begins in WooCommerce.
For each SKU, we collect the essentials: title, attributes, price, stock quantity, and the main image URL.
Quick checks run immediately: SKU exists, price is numeric, and stock isn’t negative.
This clean record becomes the source of truth the rest of the workflow uses to decide whether Decathlon needs a new item or just an update.
Next, we look up the SKU in Google Sheets. We search the Catalog sheet by SKU to see whether this product already exists. If we find a match, we pull the row ID and the current price and stock. If there’s no match, we mark the SKU as new. This result is handed to the router. The router checks the lookup result and splits the flow. New SKUs go down the Create path. Existing SKUs go down the Update path. This keeps the Decathlon listing in sync without creating duplicates.
For a new product, we add a fresh row in the Products sheet. We write the SKU, title, key attributes, price, stock, the main image URL, and a status such as “pending publish.” This gives us a clean, trackable record for every item that will be sent to Decathlon. If the product already exists, we update the existing row instead. Typical updates include price, stock quantity, or small content fixes. The updated row stays aligned with WooCommerce while preserving its history.
Next, we fetch the product image from Google Drive using the file ID or URL. Images are verified for size and format so Decathlon receives a clean, consistent asset.
Finally, we send the product payload to Decathlon Marketplace Romania. New items are created; existing items are updated. We record the API response and any errors so issues can be retried without manual work.
The outcome is a catalog that stays synchronized: products, prices, stock, and images, without manual XLS imports or copy‑paste. Everything is tracked in Google Sheets, and the listings on Decathlon stay accurate.
