Think Build Implement Repeat
London, UK +44 7367 067226
WhatsApp FOLLOW f in X
  1. Home
  2. Blog
  3. How Do We Update Shelf Prices When Every Pet Wholesaler Sends Its Price Changes in a Different Format?
Problems We Solve

How Do We Update Shelf Prices When Every Pet Wholesaler Sends Its Price Changes in a Different Format?

Pet shop wholesalers send price changes as PDFs and spreadsheets, and shelf prices lag. We build a price update tool that reads them and proposes new prices.

Updated 3 min readBy SpiderHunts Technologies

Free estimateNo obligation

Get a free estimate

Tell us what you need. A senior engineer reads every enquiry.

Takes under a minute. We never share your details.

  • Free consultation
  • No commitment
  • NDA on request

Prefer to talk? Book a free 30-minute call →

Quick answer — TL;DR

Pet shops buy from several wholesalers and direct brand accounts, each sending price changes in its own format: spreadsheets, PDFs, emails and portal notices. Updating hundreds of till prices by hand is slow, so shelf prices lag behind costs and margins shrink quietly. We build a price update tool that reads each supplier's file, matches lines to your products, proposes new retail prices from your rules and updates the till and shelf labels together.

Three price files in one week

In the same week, your main wholesaler emails a spreadsheet of cost changes across its range, a dry food brand sends a PDF announcing a price rise from next month, and the aquatics supplier updates prices on its portal without saying which lines changed. The owner prints the PDF, highlights the lines you stock and plans to go through the till on Sunday.

Sunday gets busy. Two weeks later, invoices arrive at the new costs while the till still sells at the old prices. Some shelf labels were updated, some were not, and one popular food is now earning very little per bag because its cost went up and its price did not.

Why prices fall behind costs

Pet shops carry thousands of lines from many suppliers, and each supplier's product codes and file formats are different. Matching a supplier's line to your till product is the hard part, and doing it by hand for a price change of hundreds of lines is a job nobody can finish in an evening.

  • Supplier files arrive in different formats, including PDFs.
  • Supplier codes do not match your till codes directly.
  • Price rises are announced ahead but applied late in the till.
  • Shelf labels are updated separately, by hand.
  • Nobody sees margin by line until a stock or margin review, if ever.

What lagging prices cost

Every day a line sells at an old price after its cost has risen, you lose margin, and on fast selling food lines that adds up quickly. When prices are finally updated in a rush, some go up by more than necessary and shelf labels do not match the till, which confuses customers.

The owner's time is spent on data entry rather than deciding prices, and the decisions that matter, such as absorbing a rise on a key line to keep regulars, are made in a hurry or not at all.

A price update tool for every supplier file

  1. Supplier price files are sent to a shared inbox or uploaded, whatever the format. Spreadsheets are read directly; PDFs are extracted with an AI step and checked by a person.
  2. Each supplier line is matched to your till product by barcode, supplier code or a mapping we build once and keep.
  3. New costs are compared with current prices, and your pricing rules, such as a target margin by category and rounding to your price points, propose new retail prices.
  4. The owner reviews proposed changes on one screen, sorted by impact, and accepts, adjusts or holds each one.
  5. Approved changes are sent to the till on the effective date, and a batch of shelf labels is printed for the lines that changed.
  6. A margin report shows lines where cost has risen but price was held, so those decisions stay visible.
StepBy handWith the price tool
Reading the filePrinted and highlightedRead or extracted automatically
Matching linesSearching the tillMapped once, reused
New pricesWorked out line by lineProposed from your rules
Till updateTyped in, often lateApplied on the effective date
Shelf labelsSome updatedPrinted for every change

Pricing decisions stay with you. The tool proposes; you approve. Extracted PDF data is always checked before it is used.

Price changes handled in an hour, not a weekend

When the wholesaler's spreadsheet arrives, the owner opens the tool, sees the lines that affect you and the proposed prices, and approves most of them in one go. A handful of key foods are held at their current price on purpose. The labels print, and the changes go live on the date the new costs apply.

Invoices and till prices move together, and the owner can see at any time which lines are earning less than the target, and why.

Are supplier price rises getting ahead of you?

  • Supplier price files arrive as PDFs and spreadsheets.
  • Till prices are updated weeks after costs change.
  • Shelf labels and till prices disagree after a price change.
  • Some lines earn far less than you thought.
  • Price updates take a whole evening or weekend.

FAQ

Frequently asked questions

The questions readers ask us after this guide.

Still have a question?

Ask us directly — a senior engineer will get back to you.

Ask about your project

Can it read PDFs from suppliers?

Yes, with an AI extraction step. Every extracted line is shown for checking before any price changes.

Does it update our till directly?

If your till has an API or import, yes. Otherwise it produces an import file in the format your till accepts.

Can it work with the shelf labels we already use?

Usually. We check your label printer and templates first.

What drives the cost?

The number of suppliers and formats, till integration and label printing.

Keep reading

More on Problems We Solve

Start here

Tell us where your pet shop admin gets stuck

Describe how stock, prices and customers move through your pet shop or aquatics centre today, which till, website and suppliers you use, and where the spreadsheets and paper take over. We will tell you what we would build and what we would leave alone, and if your current system already does it with a setting you have not switched on, we will say so.

  1. You tell us what you needTwo minutes on the form, or a message on WhatsApp.
  2. A senior engineer reviews itAnd comes back with questions, a realistic range and an honest view on fit.
  3. Free 30-minute scoping callWe talk through scope, options and a realistic estimate — with no obligation.
Free estimateNo obligation

Talk to someone who builds this

Send a short brief and we will come back with an honest view and a realistic range.

Takes under a minute. We never share your details.

  • Free consultation
  • No commitment
  • NDA on request

Prefer to talk? Book a free 30-minute call →