Video · 2:02

How to Import a PDF Price List into Shopify as Products

To import a PDF price list into Shopify, drop the PDF into Csvio: it finds the product table, you check the mapping and confirm. Here a supplier's one-page price list becomes three draft products, with colors as variants, prices and photos.

Try Csvio free on your own file

Chapters

  1. 0:00The PDF price list as it arrives
  2. 0:18Upload the PDF; Csvio finds the product table
  3. 0:42Map the PDF's columns to Shopify fields
  4. 1:05Colors as variants in the preview
  5. 1:24Import, report and the products in Shopify

Transcript

The PDF price list as it arrives

The top three products came from my supplier's PDF price list. Each one has its photo and its stock. Here's that price list, just as they sent it. A letterhead, a table of products, and the terms underneath.

Upload the PDF; Csvio finds the product table

Here's how. I opened csvio's Import page. A PDF goes in just like a CSV. I drop it in, just as it came. It found six rows and eight columns. The letterhead and the terms are left out. These products are new, so it's Create. I click Continue.

Map the PDF's columns to Shopify fields

The columns keep the PDF's own headers. Code is the SKU, and Product the title. Color becomes the variant option. Trade is what I pay, without the dollar sign. RRP is what customers pay. Stock is how many I have. The barcode goes in too. And the image link becomes each product's photo.

Colors as variants in the preview

The preview shows three products. The tea towel has three colors. I open it. Natural has 200 in stock. Indigo, 160. And Rust, 140, all at $11.

Import, report and the products in Shopify

50. I click Import to Shopify. It asks first, and they'll come in as drafts. I confirm. Done: three products, saved as drafts. They stay hidden until I publish them. In Shopify, here's the tea towel. Its photo came across from the image link. Three colors, each with its price and stock. Try csvio free, on your own supplier's PDF. The link's in the description.

Step-by-step guides

More Csvio tutorials

See all tutorials