TV Rate Card Import — Guide

Module tss_tv_rate_import · screen /tv-rate-import

1. What this does

Converts a customer rate card spreadsheet (a "customer copy" pricing file) into the flat, row-per-price-title format TransVirtual expects for a zone-rate import, checking every zone short code and long name against a stored Master Zone list along the way.

2. First-time setup: load the Master Zone list

Before converting anything, the Master Zone List card needs data. Drag or browse to the current Master Zone spreadsheet (columns: Zone Long Name, Zone Short Code, Suburb, State, Postcode — no header row).

Uploading a new Master Zone file deletes the current list and replaces it completely. There's a confirmation step before this happens, but there's no undo after you confirm.

Only do this again when TSS gets a new zone version from TransVirtual (e.g. a "V1.16" replacing "V1.15").

3. Converting a rate card

Drag or browse to the customer's rate card file in the Convert Rate Card card. The tool automatically detects two known layouts:

Miele-style — a sheet named something like "KG Rates" with separate Basic / KG Rate / Cubic / Minimum columns.
Combined-style — a sheet named "KG Pricing" or "TSS Rates" with Flat Rate and Weight Rate combined on one row, no per-lane minimum charge.

If neither is detected, a manual mapping form appears — pick the sheet, then match each required field (Zone From/To short code, Flat Rate, Weight Rate, Cubic, and optionally Service Level / Minimum Charge) to the right column, then convert.

4. Reading the result

Every conversion produces two downloads:

Clean Import File — ready to import into TV as-is.
Exceptions File — rows held back because a zone short code wasn't found in the Master Zone list, or a rate/weight/cubic value was missing in the source file. Nothing in here gets silently dropped or guessed at.

Zone From / Zone To long names in the clean file always come from the stored Master Zone list by short code, never from whatever text happens to be in the source file's own long-name column. Source files have been proven to carry corrupted long names (a copy-paste/drag-fill error) even when the short code next to them is correct.

5. Admin reference

Models: tss.master.zone, tss.tv.rate.import.log. Every conversion run is logged with its source filename, detected format, lane/ exception counts, and the two generated files — browse them under Settings → Technical → Actions → Window Actions if you want to audit past runs outside this page.