Purchasing department one of the departments in your AI company

Dropshipping automation: supplier prices and stock update themselves

Dropshipping automation software imports supplier price lists and feeds, matches products, applies your markup and keeps prices and stock in your online store up to date. Elbuz does it on its own.

  • XLSX
  • CSV
  • XML
  • JSON
  • ZIP
  • FTP
  • API
  • AI
Cutaway of the Elbuz purchasing department: AI agents receive price lists, parse columns, change prices on price tags and statuses on warehouse shelves, and the manager only confirms

What your purchasing department does

Five daily buyer tasks your department's staff takes over. You set it up once and check the result.

Fetches the price list by itself

A price list or feed by email, FTP, URL or API, or even a website scraper: you pick the method once, and the file then arrives on its own at the set time. The supplier adds today's date to the file name every day? Elbuz fills in today's date, and if the file isn't there, it tries up to five days back.

Understands the columns

Price lists in Excel, CSV, XML, YML or JSON: the app checks the headers against its dictionary and shows where the name, price and SKU are. AI handles unfamiliar columns. If the supplier reorders the columns, Elbuz notices the shift and suggests the new positions.

Calculates your selling price

Pricing by rules, not by hand: exchange rate, automatic markup, shipping, rounding. Markup can differ by supplier, category and price range. Supplier promotions update automatically too: a discount on the whole price list is one rule with a minus.

Translates stock levels

Inventory sync without manual checks: “+”, “***”, “>3 pcs” or an empty cell all map to your own list: in stock, on order, out of stock. A product disappears from the supplier feed, and in your catalog it becomes “Out of stock” or is hidden from the storefront.

Watches every import

Protection from a bad price list: every run is logged for the source, with how many rows were read and how many had no price. If the price list shrinks more than you allowed, a stop rule blocks the file and you get a notification.

Who it's for

How dropshipping automation works: 6 steps

You set it up once, and every new price list follows this path by itself.

  1. 01

    Connect a source

    A three-step wizard: supplier, how the file arrives, column check. For email and FTP you start with a sample file and add the mailbox or server later in the source settings.

  2. 02

    Map columns and products

    The app marks up the file itself; you just check how it read the name, price and SKU. Then price list items are matched to your catalog by SKU, name and confirmed pairs, so duplicates don't pile up.

  3. 03

    Set the markup

    Exchange rate, markup or discount, shipping, rounding. General rules by category apply to all price lists, and you can add rules for a single supplier.

  4. 04

    Set up stock statuses

    Point to the stock column and add your supplier's spellings to the statuses. Anything you add once works in every price list that has no rule of its own.

  5. 05

    Turn on the schedule

    Price lists update on a schedule: the app fetches the file itself and, once all price lists are in, updates the catalog and exports.

  6. 06

    Check the log

    Every supplier has a status dot for the last run. Red means a stop rule blocked the file; click it to open the log with the reason.

What happens to a price list in one run: from file to website prices

One run of supplier feed processing: the supplier file passes through the source, columns, rules, AI matching, prices and stock, and reaches your catalog, website and marketplaces.

Demo: one run, step by step.

Before and after: one price list, five products

On the left, the supplier's file as it is. On the right, the same products in your catalog after processing.

What the supplier senttheir own headers, price in dollars, stock as symbols
CodeItem descriptionPrice, $Note
TWK-17Kettle el. 1.7L s/steel24.10+
HD-350HAIR DRYER 2200W w/diffuser20.70***
PVA-05PVA glue 0.5kg1.22>3 pcs
GL-45Pruner gard. 4544.90on order
HS-20Hose 1/2" 20m8.150
  1. Columns detected: code, name, price, stock
  2. Price: × 0.92 €/$, +25%, round up to .99
  3. “+”, “***”, “>3 pcs” → “In stock”
What your catalog gotyour names, selling price, your statuses
SKUProductPriceStock
TWK-17Electric kettle 1.7 L€27.99In stock
HD-350Hair dryer 2200 W with diffuser€23.99In stock
PVA-05PVA glue 0.5 kg€1.99In stock
GL-45Garden pruner€51.99On order
HS-20Garden hose 1/2", 20 m€9.99Out of stock

Example only: you set your own exchange rate, markup and rounding. Product names in your catalog stay yours; the price list updates price and stock.

Currency, exchange rates and rounding

The supplier price is converted at an exchange rate that Elbuz updates automatically or takes from your own source. Then markup and shipping are added, and finally the price is rounded: to cents, to whole numbers or, say, to the nearest ten. If a rate jumps by more than 30%, the app does not apply it on its own.

  1. $24.10price in the price list
  2. × 0.92 €/$= €22.17
  3. + 25%= €27.72
  4. up to .99= €27.99

More on pricing: markup and pricing rules.

Product record: selling price, cost, automatic markup and stock from the price list
Product record: price, cost, markup and stock.
Product record in the catalog: 12 photos that came from the supplier price list
Product record: 12 photos that came from the price list.

How Elbuz matches supplier products to your catalog

On every import the app looks for a match in your catalog for each price list row. Matching methods run in a queue: the first one that works takes the row.

  1. Confirmed pairspairs you have already linked come back from the dictionary
  2. Manufacturer part numberexact match, 5 characters or more
  3. Product nameexact match of the name in the catalog and the price list
  4. AI or youAI matching or manual review handles the rest

A new file never erases manual pairs, so duplicates don't pile up. You can add your own matching methods and change their order in the queue.

Supplier price list item: photos, price list and catalog prices, markup, stock, the linked catalog product and offers from other suppliers
Price list item: prices, stock, linked product and other offers.

Several suppliers for one product

No limit on suppliers or price lists. When a product is in several price lists, Elbuz picks the price and stock for your catalog by itself.

One price by your rule

On every catalog update the app takes the minimum, average or maximum price across all price lists. No need to compare them by hand.

Stock matters more than cents

You can give your main supplier priority, and prefer an in-stock product over a cheaper one that is only on order. If no price list has the product, it can be hidden from the storefront.

All price lists in one search

Price lists combined without a master spreadsheet: the “Base catalog and price lists” window searches your catalog and every supplier's price list at once.

Supplier prices compared with the catalog: profit potential and RRP violations
Profit and prices: potential, RRP violations, price vs catalog.

How to work out where to buy cheaper: see the article on comparing supplier prices.

What the AI agent does and what you decide

The app does most of the work by rules, AI steps in where rules aren't enough, and the final say is yours.

The Elbuz price list room: robots merge price lists into one, an analyst watches prices

The app: on its own, every time

  • Fetches the file at the set time: by email, URL, FTP or API.
  • Reads the columns using the mapping made on the first file.
  • Calculates prices by your rules and turns stock values into your statuses.
  • Blocks a file that lost more items than you allowed.
  • Updates the catalog and exports once all price lists are in.

AI: when rules aren't enough

  • Reads price lists with non-standard names and columns the dictionary didn't recognize, looking at sample values too.
  • Parses the tags of a supplier's XML feed.
  • The “✦ AI” button in the log explains at which step a run failed and what the supplier's server replied.
  • Suggests a fix to the column mapping or import time as a plan, with a confirm button.

You: once, and when needed

  • Check the mapping of the first file.
  • Set price rules and the stop-rule threshold.
  • Add your own stock spellings; they work in all price lists.
  • Approve the new positions when a supplier reorders columns.
  • Confirm the AI's plan: it never changes anything on its own.

Log and source health: can you trust this supplier?

Every supplier gets a score from 0 to 100 based on runs over the last 90 days. The score has three parts, so you can see exactly what pulls it down.

  • 40%Reliabilityshare of runs that finished successfully; a blocked run also counts as a failure
  • 35%Data qualityshare of rows without a price or with suspicious prices
  • 25%Freshnesshow long ago the last successful import was
  • Healthy80 and above
  • Needs attention50–79
  • Problematicbelow 50
Supplier price list analytics: health, coverage, reliability and freshness of each source
Source analytics: health, coverage, reliability and freshness.

The log keeps the last 200 runs of each source: what arrived this time, what it was before and at which step a run failed.

What it looks like in the app

Real Elbuz windows with demo data. The software runs in your browser, with nothing to install.

your-store.elbuz.com
Supplier price list with photos → “Update my catalog” → product record with the new price and stock.
your-store.elbuz.com
Detailed price list analytics: hints on the source reliability and freshness charts, then a smooth move to “Profit and prices” with a price comparison against the catalog.
Supplier price list products in Elbuz: photos and product preview before matching to the catalog
Price list products with photos and a product preview.
Supplier price list product preview: photos, prices and specs for matching to the catalog
Price list product preview: photos, prices, specs.
Price list import log: source health score 100/100 and charts for every import
Source log: Health 100/100 and charts for every import.
Product price history: chart of the supplier price and selling price over a period
Product price history: chart and totals for the period.

Elbuz, spreadsheets or a store plugin: what to use for supplier feeds

Processing price lists by hand in Excel, an import plugin for WooCommerce, OpenCart and other platforms, or dedicated software: what each option takes on and what it leaves to you.

What we compareElbuzExcel or Power QueryStore plugin or your own script
Who starts the processingBuilt-in schedule: the file arrives on its ownA person opens, refreshes and checks the file every dayA server job, if someone set up the import
New supplier or formatColumns are mapped once; AI handles unfamiliar onesA new spreadsheet and new formulasA new import setup or a code change
Broken fileStop rules keep it off your websiteA person notices, if they checkDepends on whether someone wrote a check
Several suppliers per productOne price by your ruleCombine by handDepends on the plugin
AIColumns, product pairs and categories, each with a confidence scoreNoneDepends on the plugin

A comparison of capabilities, without numbers: how much time supplier price list analysis takes depends on your files. Elbuz is a browser-based service, with nothing to install.

Dropshipping automation: frequently asked questions

Can dropshipping be automated?

Yes, the routine part can. Dropshipping automation software takes the path from the supplier's file to prices and stock in your catalog: it fetches the price list or feed, reads the columns, finds your products in it and calculates the selling price. In Elbuz your purchasing department does this: the price list arrives by itself, and the catalog updates with no manual edits. You still choose suppliers and products and set the price rules.

Which price list formats does Elbuz support?

xlsx, csv, xml and zip files, plus a price list by URL, by email, from FTP, through an API or with a scraper on the supplier's website. Column mapping works for Excel, CSV, XML, YML and JSON.

What are the steps of processing a price list?

Fetching the file, mapping columns, processing rows (categories, filtering, cleaning names, stock, matching to the catalog, markup), checking with stop rules, updating the catalog and exports. A new price list gets these steps in the right order, so you don't build the process from scratch.

How does Elbuz match supplier products to my catalog?

Automatically, on every import: by confirmed pairs, manufacturer part number and name, and AI or you handle the rest.

What if a supplier changes the price list layout or sends a bad file?

The column mapping survives a new file: if the supplier reorders columns, the app notices the shift and suggests the new positions. Stop rules keep files with zeroed prices, empty names or far fewer items off your website. The price list keeps the data from the previous import, and you get a notification.

What happens to a product that is missing from the new price list?

By default it stays in the catalog as “Out of stock” with zero quantity. You can set such products to be hidden from the storefront and to come back automatically when they reappear in the price list.

How often do prices and stock update?

As often as you set in the source schedule. Once all price lists are in, the app updates the catalog and exports on its own.

Can I set different markups for different suppliers?

Yes. Each price list has its own rules (for the whole list, a category or a manufacturer), and general category rules apply to all price lists at once.

How are currency, exchange rates and rounding handled?

At an exchange rate that Elbuz updates automatically or takes from your own source; then markup and shipping are added, and rounding comes last.

How do I pick the best supplier when a product is in several price lists?

Elbuz picks for you: on every catalog update it takes one price by your rule (minimum, average or maximum), with supplier priority and stock taken into account.

Can I send processed prices to my accounting or ERP software?

Yes. Elbuz regularly exports prices as an XLSX or CSV spreadsheet or an XML file, by a permanent URL, to FTP or by email, and your accounting software imports that file. Software that works with APIs takes prices and stock directly through the Elbuz API v2.

Can I turn supplier price lists into a Google Shopping or marketplace feed?

Yes. Prices and stock from price lists go into your catalog, and from it Elbuz builds product feeds for Google Shopping, Meta, TikTok and marketplaces at a permanent URL that the channel fetches itself. After every price list import the feeds are rebuilt without you. More: Product feeds.

Why is this better than Excel, Power Query or my own script?

A spreadsheet or Power Query works as long as a person opens and checks the file every day, and a script has to be edited for every new supplier. In Elbuz the mapping, pairs and rules are set once and then applied to every new file on their own.

Does AI help with price lists?

Yes. AI maps unfamiliar columns, suggests matches for products the rules didn't link, and maps supplier categories, each pair with a confidence score and an explanation. High-confidence pairs can be applied automatically; doubtful ones stay with you for review.

How many suppliers and products can I connect?

No limits: connect as many suppliers and price lists as you need. This only affects the price, which depends on the number of products. More: Elbuz pricing.

How much does dropshipping automation cost?

There is no separate fee: the purchasing department is part of the single Elbuz plan along with your whole AI company. The amount depends on the larger list: products in your catalog or in your price lists. The first 14 days are free. What it comes to for your catalog: see pricing.

What is the difference between markup and margin?

Markup is calculated from the cost price, margin from the selling price. Buy for €100, sell for €150: the markup is 50%, the margin is 33%. Formulas and examples: markup and margin calculator.

14 days free

Connect your first supplier today

The purchasing department comes with your AI company along with every other department. Get €50 on your balance after sign-up, and our support team moves your data from another app or website for free.

Try Elbuz free