Turning a supplier PDF price grid into online prices: checks before you publish
Checks before you publish a supplier PDF or Excel grid: units, rounding, min and max sizes, POA, surcharges, tax and currency.
11 November 2026
A supplier price list is a working document. It has bands rather than a price for every millimetre, notes in the margins, cells marked POA, and sometimes a surcharge that lives in a different table. A website calculator has to turn that into a single figure, or into an honest "price on request", for the size a customer types. The work is in the check before you publish. The steps below apply to a digital PDF or an Excel grid, and they are the same checks we ask you to do in Glasstally before a list can go live. The examples use made-up numbers, not a real supplier list.
First check: can you select the text?
Open the PDF and try to highlight a price. If you can select the numbers, you have a text-based file, which is the kind that can be read and then checked. If the page behaves like a photograph, it is a scan. Scans and photos are a poor source for a website price, and many tools, including ours, will not read them. Ask the supplier for the Excel file, or for a PDF exported from their system rather than a photocopy.
Excel is cleaner when you have the choice. A modern .xlsx or .xlsm file keeps the cells as cells; in Glasstally the older .xls format is not accepted. An Excel file is limited to 4 MB, and a PDF may be up to 50 MB. If the list has several product tabs, do not assume every tab is in the same unit or the same tax state.
Confirm the unit before anything else
A grid in inches published as millimetres will under-price every size. Confirm the unit on the list itself: millimetres, centimetres or inches. UK lists are usually millimetres and talk about drop. US and Canadian lists are usually inches and talk about height. Customers have to type sizes in that same unit. If you serve both markets, you need a list or a calculator set up for each convention, not a silent conversion you have not checked. Do not publish until the unit is confirmed.
How width and drop actually round
Supplier lists almost never price every millimetre. They price bands. A width and a drop that fall between two bands are charged at the next band up, not the one below, and each axis rounds on its own.
Here is a made-up millimetre grid, trade prices, width across the top:
| Drop (mm) | 600 | 900 | 1200 |
|---|---|---|---|
| 800 | 40 | 48 | 56 |
| 1200 | 46 | 55 | 64 |
| 1600 | 52 | 62 | 72 |
A customer types 850 mm wide by 1100 mm drop. 850 is above 600 and not above 900, so the width band is 900. 1100 is above 800 and not above 1200, so the drop band is 1200. The cell is 55.
Two fine points are easy to miss:
- On a millimetre list, half a millimetre of slack still counts as the band it just passed. 900.4 mm prices as 900. 901 mm rounds up to 1200 on this grid.
- Rounding the size is not the same as rounding the money. Once you have the cell, you apply your markup and then, separately, any price rounding you use (to the nearest 1, up to 0.50, ending in .95, or none). If those two steps get swapped, or if tax is applied in a different order from your written quotes, the website will not match you.
The customer should see the size they typed and the band it was priced as.
Minimum and maximum sizes
A size above the largest width or the largest drop on the list should not be given a price from that grid. When both measurements are over the maximum, a clear message should name the largest width and drop, in the shop's unit, and offer another fabric, a size in range, or a question to you.
Under the minimum, there are two cases. A size a little under the smallest band is often still priced as that first band. A size more than one band below the smallest is usually outside the list, and should show no price. If your shop calls the drop a height, the message should say height.
Test at least five sizes before you publish: one mid-grid, one exactly on a band, one between bands, one just under the smallest, and one over the largest.
POA, blank and n/a cells
Some cells say POA, P.O.A., n/a or "on request", or they are blank because that size is not offered. Decide whether the size is "price on request" or "not offered". "Price on request" should show that phrase and no amount, then a way to ask or to book a measure. Do not let a blank cell be treated as zero, or let software fill POA with a guessed figure. Until those cells are resolved, they should block publishing.
Surcharges, motors and extras
The main grid is often only the fabric and the size. A motor, a cassette, a chain side or a non-standard bracket may live in a note at the foot of the page, or in a separate table. Read those notes before you put the grid online. If a "price" on the website is only the fabric cell, say so, or keep that product on a price-guide calculator and confirm extras after the enquiry.
We should be direct about our own product here. In Glasstally, motors, cassettes and chain side are not on the customer calculator yet, and a surcharge stored on the list is not applied. No extra charge is added for them. Use Instant price only where the cell really is the price you will stand behind.
Currency, VAT and sales tax
Check the currency on the list against the currency on the shop. Then check tax, in the same state as the list. If the list is ex VAT and you sell in the UK, a marked-up price still needs VAT shown the way you usually quote. The standard VAT rate is 20%. Many UK shops show prices including VAT. If you are not VAT registered, do not print a VAT number on the quote. If the list already includes VAT and you apply VAT again, every price will be too high.
In the US and Canada, the usual public wording is a price before sales tax, plus a line that either names the shop's rate or says sales tax is excluded. There is no single national rate to copy. The calculator should not add and collect sales tax unless it is actually built to do that.
Write down the order you already use on paper quotes (cell, markup, tax, rounding) and make the website follow it. Then price one size by hand and compare it with the calculator. When the supplier sends a new book, upload the new file, look at old against new, and approve the changes. Keep the previous version.
Upload and check one list free on Glasstally. Publishing a calculator needs a plan (Standard is £59 a month plus VAT, Founder is £117 plus VAT every three months), and there is a 30-day refund if we cannot load your lists. Each calculator prices one price list. If that list has several products, customers pick the style and get that product's price. For several suppliers, publish a calculator for each one, up to 3 at once.
Frequently asked questions
Can I put a scanned price list on my website?
Not reliably. If you cannot select the text in the PDF, treat it as a picture, not a price file, and ask the supplier for Excel or for a digital PDF.
Why is a size between two columns more expensive than I expected?
Because trade grids charge the next band up, on width and on drop separately. The calculator should show the band it used.
What should a customer see for a size bigger than the list?
No price from that grid, and a short message that names the largest width and drop you can price, in the unit the shop uses.
Does an online price include motors or cassettes?
Only if the tool actually applies those extras. In our own calculator they are not applied yet, so the published figure is the marked-up cell, not a fully specified job.
Should I include VAT in the figure on the site?
In the UK, customers often expect a price including VAT, at the standard rate of 20% unless a relief applies. In the US and Canada, the usual pattern is a price before sales tax, with that fact stated next to the number.