OneFold Blog
Log in Start free
← Back to home
OneFold · Blog

How to turn a supplier PDF price list into Shopify and WooCommerce listings

A practical guide to getting products out of a supplier's PDF price list and into your store, without retyping rows or publishing duplicates.

Published · 3 minute read

Last updated

Most suppliers still send their catalogue as a PDF price list: a table with a product name, a code, a size and a price, sometimes a small picture beside each row. Turning that into store listings by hand means retyping every row, and it is where most catalogue mistakes start: a price typed into the wrong row, a size left out, the same product created twice.

This guide walks through doing it properly, whatever tool you use.

What a good import needs from the file

Before anything else, check the PDF itself.

  • It must contain real text. If you can select a product name with your mouse, the PDF has text. If the pages are scans or photographs, nothing can read the prices reliably, and you should ask the supplier for a spreadsheet (CSV or Excel) instead.
  • One product per row. A table with a product name, a code (SKU) and a price in their own columns imports cleanly. Headings reprinted on every page and section titles between groups of products are normal, and a good importer leaves them out.
  • A product code you can trust. The SKU or barcode is what lets you update a product later instead of creating it again, so keep it.

Step 1: match the columns once

Every supplier names their columns differently: "Item No.", "Art. Nr.", "Code", "SKU". Match each column to a listing field once (product name, SKU, barcode, price, size), and check the first few rows against the real file before you import the rest. Columns you do not recognise are better kept as extra detail than thrown away: they are often the specifications a buyer asks about later.

Step 2: keep sizes together

Price lists usually repeat a product once per size: the same cream in 50 ml, 100 ml and 200 ml on three rows. Imported row by row, that becomes three separate products competing with each other in search. Group the rows by the product name and use the size column as the option, so each size keeps its own price, SKU and barcode under one product.

Step 3: keep the pictures

If the PDF prints a picture beside each product, use it. A listing with the supplier's own product photo is far more useful than one with none, and it gives you something to improve later (a clean white background, or other angles) instead of starting from nothing.

Step 4: do not create what you already sell

Supplier files mix products you already sell with new ones, and they get re-sent every time a price changes. Match on the SKU or barcode: a row whose code is already in your store should update that product, not create a copy. Never match on the title alone; two different products often share one.

Step 5: fill the gaps honestly, then check

A price list gives you a name, a code and a price. Search engines and buyers want much more: a real description, specifications, care or safety information. Fill those in, but do not invent facts the supplier did not give you: weight, materials or certifications that are guessed end up as returns and complaints. Then check each listing against the rules of where you sell it, including the EU product-safety details (GPSR) if you sell to buyers in the EU.

How OneFold does this

OneFold's file import follows these steps: it reads CSV, Excel and PDF price lists (with real text), recognises common column names in several languages, keeps each row's picture from the PDF, groups sizes into one product when you choose a column, and updates a product already in your connected Shopify or WooCommerce store when the SKU or barcode matches exactly one product there. Importing itself uses no AI. Listings are published as drafts you approve.

You can try it free, or read more about importing supplier files.

Try it on your own products. OneFold turns product photos, supplier files and store catalogues into checked listings, published as drafts you approve.

Start free

More from the blog

← All posts