Supplier stock synchronization: how to set up price lists and updates

Supplier stock synchronization is the regular automatic receipt of a price list or feed with quantities and prices from the supplier and the update of products on your website. You set up the data source (a file, a link or an API), SKU matching, markup rules and a schedule, then check the result and respond to failures. Without this, the store sells goods that are no longer available.

In brief

• Agree with the supplier in writing on the format, source and frequency of data updates.
• Match the supplier's SKUs with yours so that every item has an unambiguous pair.
• Set price rules: markup by category, rounding, minimum margin and protection against anomalous values.
• Add availability rules: minimum stock, "on order" status, hiding items that have disappeared.
• Keep an import log and set up error notifications so that a failure does not go unnoticed.

Models of working with suppliers

The model determines how much you rely on someone else's data.

• Buying into your own warehouse. You keep the stock yourself; the supplier's price list is needed for purchasing and pricing.
• Shipping from the supplier's warehouse. The stock on the website depends entirely on the supplier's data, so up-to-date data are critical.
• Mixed model. Fast-moving goods are in your warehouse, rare ones are with the supplier. Each group needs its own rules.

When choosing a model, consider the speed of turnover, the cost of storage and how willing customers are to wait. Many stores start with shipping from the supplier's warehouse to test demand without buying stock. Fast-moving items are later moved to their own warehouse.

Supplier data formats

For large catalogs, a feed or an API that updates automatically is more convenient. A file and a spreadsheet are fine at the start if the supplier offers no other options.

How to set up synchronization

1. Agree on the data source, format and update frequency.
2. Match SKUs: the supplier's code and your SKU must form an unambiguous pair.
3. Define the fields to import: availability, quantity, purchase price, recommended price, name, description, photos.
4. Set price rules: markup, rounding, minimum margin.
5. Set availability rules: minimum stock, "on order" status, hiding products that are missing from the file.
6. Run a test import and compare the result with the price list on sample items.
7. Turn on the schedule and the change log, and set up error notifications.
8. Once a month, check a sample of products manually.

Prices and markup

The purchase price does not equal the price on the website. Added to it are the costs of delivery, packaging, payment system fees, returns and the desired margin. The markup usually differs by category: it is lower for fast-moving goods and higher for niche and expensive ones.

• Set up protection against anomalies: a price that is zero, suddenly reduced several times over or below cost must not reach the website automatically.
• Review the supplier's recommended prices and decide how to use them.
• If purchasing is tied to the exchange rate, decide how often to recalculate prices.
• Round prices by a single rule so there are no chaotic values on the website.

Stock: how to avoid selling items you do not have

The update frequency depends on turnover and the supplier's capabilities. Fast-moving goods need several updates a day or real-time data transfer, for slow ones one update a day is enough. Compare how quickly the supplier's stock changes with how quickly you sell.

Example of availability rules

The rules depend on your product and sales speed. Use the table below as an illustration and choose the thresholds yourself.

Protection against discrepancies

• Keep a buffer: show slightly less on the website than the supplier reports.
• For expensive and fast-moving items, have a manager confirm availability before shipping.
• Show the delivery time for goods from the supplier's warehouse.
• If the file has not been updated for longer than the allowed period, the system should warn you and, if necessary, switch the products to "on order" status.

Data quality and SEO

The supplier's file may contain errors: empty rows, a changed format, duplicates, missing items. That is why the import should check the data before writing them to the website.

• Do not delete product pages automatically when an item disappears from the price list. First change the status to "out of stock" and offer alternatives.
• For products that have been permanently discontinued, choose a redirect to the relevant category or another relevant page.
• Supplier texts and photos are often repeated across many stores. For key products, write your own descriptions and check your right to use the images.
• Make sure the availability and price on the page match what you send to advertising and product feeds.

Automatic checks during import

• The number of rows compared with the previous file: a sharp drop often means a failure.
• Required fields: SKU, name, price, stock.
• Price ranges: block values outside the expected limits for manual review.
• Duplicate SKUs in the file.
• File encoding and number format: comma and period in decimals, spaces in thousands.

Action plan when synchronization fails

1. Receive the alert and check the log: whether the source is available and whether the format has changed.
2. Stop publishing new prices if the data look doubtful.
3. Switch fast-moving products to "on order" status or confirm availability manually.
4. Contact the supplier and find out the cause and when the data will be restored.
5. After the fix, run the import, compare a sample with the price list and inform the team.
6. Write down the cause of the failure and add a check that will catch it earlier.

Several suppliers for one product

One product may be available from several suppliers with different prices and stock. Match items by barcode, manufacturer code or the brand plus model pair, since suppliers name products differently. Decide on the priority in advance: the lowest purchase price, the best availability or the shortest lead time. Switch the source by clear rules, otherwise the price on the website will jump and customers will notice.

Agreements with the supplier

Technical synchronization works better when the terms are fixed. Agree on: update frequency, file format and structure, a contact person for failures, how format changes are announced, terms of returns and replacements, picking times, minimum batches. Ask to be warned in advance about discontinued products and SKU changes.

What to check before connecting

• Stability of the source: whether the file is updated on time and whether its structure changes without warning.
• A test order: picking times, product quality, match with the description.
• Speed and quality of the manager's answers to questions.
• Terms for returning and replacing defective goods, and who bears the costs.
• Documents the supplier provides for the goods, if your category requires them.

Common mistakes

• SKUs are not matched, and data end up on the wrong products.
• The markup is the same for the entire range.
• There is no protection against zero prices.
• Pages of discontinued products are deleted automatically.
• The import runs without a log or notifications.
• The supplier's full stock is shown without a buffer.
• There is no written agreement on format and update frequency.
• The file is read in the wrong encoding, and product names turn into unreadable characters.

Questions and answers

How often should stock be updated?

It depends on turnover and the supplier's capabilities. For fast-moving goods, update several times a day or in real time; for slow ones, once a day is enough.

What should you do if a product disappears from the price list?

Do not delete the page automatically. Change the status to "out of stock" and offer alternatives. If the product is permanently discontinued, set up a redirect to the relevant category.

How do you calculate the markup?

Add up the purchase price, the costs of delivery, packaging, fees and returns, and the desired margin. Check the result against the market and compare it with the supplier's recommended price.

Can you copy the supplier's descriptions?

First check the terms of use for the texts and photos. Even if it is allowed, such descriptions are repeated across many stores, so write your own for important products.

Which is better: a file or an API?

For large catalogs, an API or a feed with automatic updates is more reliable. A file works at the start. What matters most is a stable source and accurate SKU matching.

Conclusion

Stable synchronization of stock and prices rests on clear agreements with the supplier, correct SKU matching, markup and availability rules and checking the results. Start with one supplier, set up the whole cycle from import to the error log, and only then add others. The LightSEO team from Mukachevo has been building websites and online stores since 2015 and can help with online store development and launch and SEO promotion of a catalog filled with supplier data.

Read also

• Your own website or a marketplace: how to combine channels
• Customer service standards in an online store: responses and response times
• Which CRM to choose for an online store: criteria and mistakes