Shopify/WooCommerce Sellers: Automate Packing Slips & Supplier PDFs into Sheets

If you run a Shopify or WooCommerce store, you already know the pain: supplier PDFs, packing slips, and order documents show up in different formats every day — and someone (usually you) ends up copying data into a spreadsheet line by line.

That’s not just slow. It creates mistakes that break inventory, margins, and fulfillment.

With img2sheet, you can turn those documents into clean Google Sheets rows automatically — using AI (not just OCR) — and you control the exact output format.

The real problem: “documents don’t match your spreadsheet”

Packing slips and supplier PDFs vary by:

  • Supplier layout changes
  • Different languages, currencies, and date formats
  • Missing or rearranged fields
  • Tables that look consistent to humans but aren’t consistent to software

Traditional OCR tools often just “read text.” You still spend time cleaning, matching fields, and reformatting.

AI extraction goes a step further: it understands what each value means (SKU vs quantity vs unit price) and places it where you want it.

How img2sheet fixes it: you define the structure once

Instead of adapting your sheet to the supplier’s PDF, you do the opposite:

1) Create a Structure (your extraction template)

You define your columns with:

  • Label (e.g., Order ID, SKU, Quantity, Unit Cost)
  • Type (text or number)
  • Prompt (what to extract exactly)

Example structure for supplier documents:

  • Supplier Name (text) — “Supplier or vendor name”
  • Invoice Number (text) — “Invoice/packing slip reference number”
  • Order Date (text) — “Document date”
  • Currency (text) — “Currency symbol or code”
  • SKU (text) — “Product SKU”
  • Product Name (text) — “Line item product title”
  • Quantity (number) — “Quantity ordered/shipped”
  • Unit Cost (number) — “Cost per unit”
  • Line Total (number) — “Quantity × Unit Cost or line amount”
  • Shipping Cost (number) — “Shipping fee if present”
  • Grand Total (number) — “Total amount on the document”

2) Upload the packing slip or supplier PDF/image

Just upload the file for that structure. The AI extracts values according to your column prompts and types.

3) Get perfectly aligned rows in Google Sheets

The extracted results are inserted into your sheet exactly following your structure, so your spreadsheet stays consistent across suppliers.

What you can automate immediately (real store workflows)

Inventory & receiving

  • Extract SKU + quantity from packing slips
  • Compare to expected purchase orders
  • Update received stock in Google Sheets

Margin tracking

  • Extract unit cost and totals from supplier invoices
  • Track cost changes per SKU over time
  • Build a “supplier cost history” sheet

Order reconciliation

  • Extract order IDs, tracking numbers, and line items
  • Match supplier shipments to Shopify/WooCommerce orders

Returns & discrepancies

  • Keep a clean record of what was shipped vs what was ordered
  • Spot missing items or incorrect quantities faster

Why AI beats “OCR-only” for ecommerce docs

Packing slips and supplier PDFs are full of traps:

  • tables where headings move
  • fields that appear in different places
  • multiple totals (subtotal, tax, total, paid)
  • combined cells and messy line items

OCR-only tools usually return a blob of text or a semi-table.

img2sheet uses AI, guided by your prompts, so you get structured, typed data that maps to your sheet columns reliably.

Privacy note (important)

We do not store your files.

All uploaded documents are removed immediately after extraction (so there are no permanent file links or retained copies).

Quick start: a simple structure to begin with

If you want to start in 5 minutes, create a structure like:

  • Supplier Name (text) — “Vendor name”
  • Document Number (text) — “Invoice/packing slip number”
  • SKU (text) — “Product SKU”
  • Quantity (number) — “Quantity shipped”
  • Unit Cost (number) — “Unit price/cost”
  • Total (number) — “Document total”

Upload one document and confirm it maps well. Then expand the structure as needed.

Final thought

If you’re already using Google Sheets to run operations — receiving, costs, inventory, or reconciliation — then supplier PDFs shouldn’t slow you down.

With img2sheet, you define the structure once and let AI do the extraction consistently, document after document.