A supplier PDF price list becomes a Shopify CSV when every product is a row with the importer's own column names — Handle, Title, Vendor, Variant SKU, Variant Price — and every variant shares its product's Handle. The fastest path is to upload the PDF, review the product table the engine builds from it, and export that table as the Shopify-format CSV you then load in Products > Import.
A real price list is 40 to 100 pages of section banners, one description shared by five variant rows, part numbers in one column and prices three columns away, sometimes a photographed printed page. Copy-paste from the PDF gives you shifted rows; a generic PDF to Excel converter gives you the page layout, not products. Either way the wrong price lands on the wrong SKU, and you find out after the import.
The MicroCity engine reads the supplier file as it arrives — PDF, Excel, scan or photo — and builds one product table: brand, product name, model or part number, category, key specs, price. Descriptions shared across variant rows are filled down; section banners become categories. From one real supplier PDF it returned 89 products with codes, categories and prices, each traceable to its source page. You check the table, then export it as a Shopify CSV with these columns:
shopify_products.csv — header row
Handle, Title, Body (HTML), Vendor, Type, Tags, Published, Option1 Name, Option1 Value, Variant SKU, Variant Grams, Variant Inventory Tracker, Variant Inventory Qty, Variant Inventory Policy, Variant Fulfillment Service, Variant Price, Variant Requires Shipping, Variant Taxable, Image Src
Honest limits: the export creates or updates products once — stock levels and prices are not kept in sync afterwards, and orders are not handled. The engine reads only the file you give it; it does not visit the manufacturer's site to fetch missing specs or images. There is no accuracy percentage to quote: supplier layouts vary too much for one honest number, which is why you review the table before it leaves.
No supplier file at hand? Download the sample supplier price list and run it through the demo.
Upload the first pages of any supplier file and see the product table before deciding anything. Plans, the one-time catalog pass and the agency tiers are on the pricing page; one file only? Use convert one supplier file. Questions: contact@microcitylabs.com.