How to Generate a Shopify Price Sheet

A price sheet is the quick-reference version of your range — a tidy table of products and prices a buyer or rep can scan in seconds. The trick isn't making one; it's making one that's still accurate next month. Here's how to generate a price sheet from your Shopify data and keep it current.

What goes on a price sheet

• Product and variant — name plus a SKU or style code.
• Price — retail, wholesale, or both, depending on who it's for.
• Availability — whether you show in-stock status helps buyers prioritise.
• Order details — minimums and how to buy.

A price sheet is leaner than a full catalogue. Images are optional; clarity is not.

How to generate one

1. Select the products. Choose the collection or list the sheet should cover.
2. Choose your columns. Show only the fields the reader needs — extra columns just create noise.
3. Pull from live store data. The whole point of generating (rather than typing) a price sheet is that it matches your store exactly.
4. Export PDF and CSV. PDF to read and share, CSV for buyers who import into their own systems.

Keep it from going stale

The moment you change a price in Shopify, every price sheet you've sent is out of date. Two things fix this: regenerate on demand whenever prices move, or share a live link that always reflects current data instead of a static file. Either way, you stop emailing prices you no longer charge.