Guide · PrestaShopImport 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.
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.

- Reads PDF, Excel (.xlsx / .xls), CSV, scans and photos (JPG, PNG), including multi-page files and merged cells.
- Works with PrestaShop 1.7.4 to 9.x (tested on 8.2.8 and 9.1.5). Needs the PHP cURL extension, standard on almost all hosts.
- Needs a Microcity Labs account and its API key. The free plan works (daily free page quota); larger volumes need a paid plan on microcitylabs.com.
- Sends only the supplier file you upload, over HTTPS with your API key. Your shop database credentials never leave your server.
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.