Patersons Fresh Produce Supplier
Paterson OpsWarehouse intelligence
CLOUD CANDIDATE · SUPABASE
Connecting to central Paterson Ops data…
Show rollout information
Cloud production candidate: signed-in staff share the Supabase database and protected document storage. Keep the existing working app unchanged until this copy has been loaded with a backup and its stock, delivery and ordering checks have passed.

Paterson Ops

Stock, purchasing and daily business operations in one place.

Products in master—
Products counted—
Stock movements—
Prices entered—
Create staff account Administrator only

Create the login first. It will remain blocked until you link it to a staff record, assign its role and approve it under User access.

Change my password Signed-in account

Replace an administrator-created temporary password with one only you know.

Daily tasks

0 of 6 complete

Complete these stock-control steps in order. Posting an actual waste list, delivery, confirmed-sales file, price list, 11 p.m. snapshot or supplier order checks off that step automatically. When there was nothing to enter, tick the current step manually. A fresh set starts each day.

Stock and purchasing status

Operations status

Live stock

Calculated balance = latest physical count + deliveries and returns − confirmed supplied sales, waste and supplier returns.

ProductStock unitCalculated live stockLast physical countNet movement since countCounted atCalculation

Barcode stocktake

Scan a shelf label or choose a product. Only units supported by that product’s master-data description are shown.

Shelf labels use the product ID, e.g. P0001

Quantity
0

Stock movements

Every change after the last physical count is kept here. Import a waste or return list for quick matching, or record one movement manually.

Import a movement list

Paste a list from Notes or choose a text/CSV file. The system suggests the closest product, but nothing changes stock until you confirm the match and verified unit.

or paste the list below

Use product, quantity, unit; product – quantity unit; or quantity unit product. A line without a clear positive quantity stays in review.

Record one movement manually

Movement history

TimeProductSourceReferenceEnteredStock change

Supplier deliveries

Placed orders stay “on order”. Stock increases only when the actual delivery note is confirmed here.

Import an invoice or delivery note

PDF, CSV and Excel files are accepted. The document number and line prices are read automatically from supported PDFs, including Mackie’s FreshMetrics documents, emailed J.R. Holland tickets and scanned Holland documents. A scanned Holland document can take a little longer while each page is read. Each unknown line gets a best-match suggestion which you can accept or replace; accepted matches are remembered for the next delivery.

Show delivery rules
Stock safeguard: review the suggested product and verified unit before posting. Use Mark missing for anything shown on the document that did not physically arrive; missing lines are flagged and never added to stock. Each document price is compared with the supplier price list from the previous calendar day: for example, a delivery dated the 16th checks prices dated the 15th, not a new list dated the 16th. Carron Lodge random-weight cheese lines use the delivered Weight/Qty kilograms; ordinary cases and tubs use their delivered pack quantity. Whole and semi-skimmed milk stay as separate pint, 1L and 2L products.

Record goods received manually

Use this for paper notes or supplier layouts that are not yet supported by the document reader.

Placed supplier orders

The latest saved order is shown below. Earlier orders remain available without filling the page.

Delivery history

The latest posted delivery is shown below. Open the archive only when an earlier document is needed.

Supplier document inbox

Keep invoices and delivery notes together for audit while ensuring the same delivery changes stock only once.

Show document rules
Stock safeguard: invoices are financial records only. Stock increases only from a confirmed delivery receipt. A matching invoice and delivery note are linked, not deleted.

Add a supplier document

One PDF, Excel or CSV file up to 15 MB. Exact duplicate supplier/type/document numbers are blocked. Cross-document matching is limited to the same supplier and verified reference formats.

Automatic email collection

Planned production phase: automatic mailbox collection will use a secure connection, approved supplier senders and a review queue. Unknown senders or uncertain references will be held for review.

Verified rules include Graham’s delivery-note/invoice reference linking. Other suppliers use exact references until their real invoice and delivery-note formats have been checked.

Document history

Only the latest document is shown until you open the archive. Search still checks every stored document.

Supplier prices and setup

Add suppliers once, then enter or import prices and match their descriptions to the Paterson Ops product master.

Add a supplier

After adding a supplier, tick its normal delivery days in Tomorrow’s order. A product becomes available from that supplier only after a price has been entered or imported and matched.

Enter a price manually

This is suitable for suppliers such as Carron Lodge when there is no regular price-list file.

*Suggested shows the lowest saved current price from active suppliers. Tomorrow’s order separately applies delivery timing and stock-cover rules for the selected delivery date.

Fresho demand imports

Keep the late-night current-orders snapshot separate from confirmed sales after the vans have left.

Current orders snapshot (around 11pm)

Use a Fresho line-items CSV containing the current orders. Every positive line in this snapshot is shown for review; it is used for purchasing only and is never deducted from stock. Product Group, customer, quantity type and customer/supplier notes are retained. Each Group A1 line remains separate for the Sharrocks PDF.

Latest current-order import

No current orders imported yet.

Confirmed sales history (morning)

Expected Fresho columns include Product Code, Product Name, Qty Type, Quantity, Delivery Date, Order State and Product Status. Only invoiced or paid lines marked supplied are added to sales history.

Latest confirmed-sales import

No sales history imported yet.

The latest record now checks the actual stock ledger, not only the import label. A repair button appears if stored sales have not been deducted. Forecast demand keeps a rolling 35-day window; the separate stock-movement audit is retained.

Purchase plan

Before 11pm it produces an exportable forecast for every protected sales day. The 11pm current orders then replace the first forecast day with exact demand while the following-day forecasts remain.

Supplier delivery days

Tick each supplier’s normal delivery days. Carron Lodge, Hovis and North Lakes also use the confirmed timing and cover rules shown beside their names. New suppliers use the normal next-delivery rule.

Maximum stock cover

These freshness caps still protect produce. Carron Lodge’s confirmed weekly cheese rule deliberately covers Thursday through Wednesday.

Show purchasing rules
North Lakes customer exclusion: Cumberland Infirmary demand for 1L whole milk, 1L semi-skimmed milk, 2L semi-skimmed milk and 2L skimmed milk is removed from North Lakes calculations because that demand is supplied by Graham’s Dairies. Whole 2L and pint milk remain separate and are not part of this exclusion. Re-import earlier Fresho sales once to add customer-level history.
Produce supplier routes: Carrots - Scottish 10kg bags are Sharrocks-only. Iceberg is bought from Sharrocks unless another scheduled supplier is at least £2.00 cheaper per box. The named 100g herb bags are bought from Carmichael’s on Wednesday, are usable from Thursday and cover through the following Tuesday; Sharrocks or Hollands remain available for top-ups on their other delivery days.
Saving an order records what was requested but does not add it to stock. Actual delivered quantities are posted from Supplier deliveries.

ProductFreshnessPlanning demandCurrent ordersCurrent stockSuggested purchaseSupplierPriceEst. costStatus

Carron Lodge’s Wednesday-afternoon delivery starts covering Thursday and runs through the following Wednesday. Hovis normally covers two days, except Saturday deliveries cover Saturday only. North Lakes follows its Monday, Wednesday and Friday rules; the small Monday buffer after Friday remains a manual review because no exact quantity was supplied.

Group A1 remains an exact Sharrocks order and ignores physical stock. Any 11pm current-order product without a saved supplier price remains visible and uses its known regular supplier or Sharrocks as the produce fallback.

Staff time and absence

Clock in and out, record booked holiday or sickness, amend missed times and download weekly hours.

Show staff login note
Account-linked: clock-in, clock-out, holiday and sickness automatically use the signed-in member of staff. Other staff remain visible only in management and reporting.
Clock-in location safeguard Administrator only

Set the warehouse position while standing at the warehouse, then choose how close staff must be. Paterson Ops checks location only when Clock in or Clock out is pressed; it does not track anyone continuously.

Clock in or out

Add an active staff member first.

Manage staff

Names stay on completed time records even if a staff member is later made inactive.

Open shifts needing attention

Old open shifts stay here until they are corrected. Use Amend to add a forgotten clock-out time and a reason for the change.

Record holiday or sickness

Enter the exact booked hours for this Monday-to-Sunday payroll week. Longer absences should be split into one record per week so weekly totals remain accurate.

Weekly hours

The week runs Monday to Sunday. Worked, holiday and sick hours are kept separate; open shifts are excluded.

Staff memberCompleted shiftsWorkedHolidaySickTotal recordedStatus

Shift details

DateStaff memberClocked inClocked outHoursAuditAction

Holiday and sickness records

Staff memberTypeFromToHoursNoteAuditAction

Driver cash collections

Replace the paper cash-in sheet with a dated, searchable record against each customer invoice.

Record cash collected

The driver name is temporary in this local pilot. When staff accounts are added, the signed-in person’s name will be recorded automatically.

No attachment selected (optional)

One JPG, PNG or PDF up to 10 MB can be stored against the collection. In this staging version, new files are kept in protected central storage.

Cash collection history

Search by customer, invoice number, driver or date.

Date collectedCustomerInvoiceCollected byAmountInvoice fileAction

Warehouse operations

Record routine activity alongside stock and purchasing. Tasks and checks stay available until an authorised user removes them.

Fridge temperature readings

Big Fridge and Small Dairy Fridge are active. Milk Fridge is available when it comes into use.

TimeFridgeTemperatureRecorded byNote

Warehouse cleaning

Create the real warehouse tasks once. Staff can check them off repeatedly; the task remains until you select Remove.

Temporary in this pilot; a signed-in staff account will supply the name automatically.

Recent cleaning completions

TimeTaskCompleted by

Driver and van checks

Drivers select their van and record each check as passed or report a problem that prevented completion. Checks remain available until you remove them.

Driver name is temporary in this local pilot. When staff accounts are added, the signed-in person’s name will be recorded automatically.

Open van issues

Reported problems stay here until they are marked resolved. Their full history is retained.

Temporary until staff accounts are enabled.
TimeVanCheckReported byProblemAction

Recent vehicle-check history

TimeVanCheckDriverResultDetails

User access

Approve staff accounts, link each login to the correct staff record and control which areas they can use.

Administrator only

Access profiles

Manager / buyer has all operational areas except user administration. Warehouse has stock, deliveries, warehouse checks and their own staff time. Driver has their own staff time, cash collections and vehicle checks. General staff has their own staff time and warehouse checklists. Individual page access can be changed below.

Loading staff accounts…

Imports & backup

Import the unchanged weekly stock sheet or a supplier price file, review every match, then save.

Weekly stock sheet import

Uses the supplied Patersons Stock Sheet layout. Each quantity beside a product is read in that product’s main stock unit. The full product roster in this sheet defines which products may receive historical carry-over in purchasing. Blank quantity cells are ignored and do not clear existing counts.

Latest stock-sheet import

No stock sheets imported yet.

Supplier price import

Excel and CSV files are accepted. Selecting the supplier means their name and internal product IDs do not need to appear in the file. Add new suppliers on the Supplier prices page first.

Latest supplier-price import

No supplier price files imported yet.

Back up local data

Backup contains supplier setup, stock-sheet imports, counts, movements, dated prices, customer-level Fresho demand, purchase settings, cash collection details, fridge readings, schedules, checklists and remembered matches. Large invoice photos and PDFs are stored separately in the browser; download the cash archive ZIP from Cash collections to back up those files.

Product master

Loading…

The supplied master contains product names, product IDs, preliminary stock units and pack notes. Conversions in this pilot are enabled only where the pack text states an unambiguous weight, volume or item count.