Guide · PrestaShop

Import supplier price lists into PrestaShop

PrestaShop imports products from a CSV or XLSX where every product is one clean row and every column is mapped to a field — and supplier price lists never arrive that way. The fastest path is to upload the supplier file as it is, PDF, Excel, scan or photo, review the product table the engine builds from it, and let the module create the products in your shop as disabled products you switch on when you are ready.

What PrestaShop's importer needs

Why supplier files break the import

A real supplier price list is a 40 to 100 page PDF with section banners, merged cells where one description covers several variants, prices in mixed formats, sometimes a photographed printed page. Retyping it into PrestaShop's template takes hours per supplier, every time prices change, and one shifted row puts the wrong price on the wrong reference.

The fast way: the Supplier Import module

Anything to Database Supplier Import is a module on PrestaShop Addons. From your back office you upload the supplier file as it arrives; the module sends it to the MicroCity engine, which reads it page by page with a visible status and page counter and returns store-ready product data. The module then creates the products locally through standard PrestaShop classes — name, reference, price tax excluded, description, stock 0 — always disabled, so nothing goes on sale until you approve it under Catalog > Products. Variant families are flattened into simple products (name plus option) so every priced row is reviewable, and any value the engine cannot read with confidence is flagged, never guessed.

PrestaShop back office, Catalog > Products: products created disabled by the Anything to Database Supplier Import module from a supplier PDF

Honest limit: the module creates products once. It does not overwrite products that already exist, does not sync stock or prices afterwards, does not fetch images or specs from manufacturer sites, and does not touch orders. You review every product before it goes live. That is by design.

Set-up in three steps

  1. Modules > Module Manager > Upload a module: upload the ZIP from Addons, then click Configure.
  2. Create a free account on microcitylabs.com, copy the API key from the account page and paste it in the module. Save.
  3. Upload a supplier file, read it page by page, review the table, click Import. The products appear under Catalog > Products, disabled. Activate what you want to sell.

Not on PrestaShop, or want the file first? Try it free

The same engine runs on microcitylabs.com without any module: upload a few pages of any supplier file and get the product table back as CSV or Excel. Plans and the agency tiers are on the pricing page; running PrestaShop for clients? Email contact@microcitylabs.com.