Think Build Implement Repeat
London, UK +44 7367 067226
WhatsApp FOLLOW f in X
  1. Home
  2. Blog
  3. How Can We Load Next Season's Tour Dates, Prices and Allocations Once Instead of Typing Them Into Every System?
Problems We Solve

How Can We Load Next Season's Tour Dates, Prices and Allocations Once Instead of Typing Them Into Every System?

Tour operators type next season's departures, prices and hotels into the booking system, website and brochure separately. We build one programme source for all.

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

Each autumn, small tour operators build next season's programme in a planning spreadsheet, then type the same departures, prices and supplements into the booking system, the website and the brochure copy, and each copy picks up its own mistakes. We build a single programme source that holds every departure once, checks it, and feeds the booking system, website and brochure pages from the same data.

Programme week: the same dates typed three times

Next season's programme is agreed. Forty-odd departures across fourteen tours, each with a start date, price, single supplement, minimum numbers and a set of hotels. The product manager has it all in a planning spreadsheet. Now it has to exist everywhere else.

Someone creates each departure in the booking system, one screen at a time. Someone else updates the website tour pages. The brochure designer receives a Word document of dates and prices for the printed brochure. A fortnight after launch, a customer points out that the brochure says the second Tuscany departure is on the 14th, and the website says the 21st. Both were typed from the same spreadsheet.

One plan, many copies

The programme is designed once but has to be entered in several systems, each with its own screens and formats. Every manual copy is a chance for a typo, and later changes have to be made in every copy.

  • Departures are created in the booking system one by one.
  • Website dates and prices are edited by hand, page by page.
  • Brochure copy is typed from the spreadsheet by a designer.
  • Price changes after launch are made in some places and not others.
  • Nobody checks all the copies against each other before launch.

Errors at launch are the most visible kind

A new programme is when regular travellers look most closely, and many book in the first weeks. Differences between brochure, website and booking system mean awkward calls, bookings made at the wrong price, and questions about which one is right. Correcting them costs time just when the office is busiest with early bookings.

Loading a season by hand also takes days of skilled staff time every year, and the planning spreadsheet is often full of useful structure that is thrown away once the typing is done.

A single programme source with automatic checks

We build a programme loader that turns your planning into structured data used by every channel.

  1. The season's programme is held in one place, either a structured spreadsheet template or a simple planning screen: tour, departure date, price, supplements, minimum and maximum, tour leader requirement, and the hotels per night.
  2. Checks run before anything is published: dates on the right weekday for the tour, hotels with an allocation for those nights, prices within the range you expect, supplements present, no two departures of a tour on overlapping dates unless intended.
  3. Once approved, departures are created in your booking system through its API or a bulk import, instead of one screen at a time.
  4. The website's tour pages read their dates and prices from the same data, so they appear at launch without editing pages.
  5. A brochure export gives the designer dates and prices in a structured file that can be placed into the layout directly, avoiding retyping.
  6. Later changes are made in the programme source and pushed to every channel, with a change log showing what changed and when.
ChannelBeforeWith one source
Booking systemDepartures entered one by oneBulk created from the source
WebsitePages edited by handReads dates and prices from the source
Printed brochureDates typed by the designerStructured export placed in the layout
Price change after launchChanged in some placesChanged once, pushed everywhere
Checking consistencyProofreadingAutomatic checks before publishing

Launch day with one source

The product manager finishes the season plan and runs the checks. Three problems are flagged: a hotel with no allocation for two nights, a price without its single supplement, and a Saturday tour starting on a Sunday. Each is fixed in the source. The programme is approved, the booking system gets its departures, the website shows the new season, and the designer gets the brochure file.

When a price changes in March, it changes once. The booking system and website update, and the change log tells the designer which reprint or digital brochure page needs updating.

The allocation tracker, rooming and document tools can also read the new departures from the same source, so the whole season starts consistent.

Does season loading look like this?

  • New departures are typed into the booking system one at a time.
  • Website dates and prices are edited by hand for each tour.
  • Brochure dates are typed by a designer from a spreadsheet.
  • Customers have found differences between the brochure and the website.
  • Price changes after launch are not made everywhere.

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 our booking system accept bulk departures?

Many can, through an API or an import file. We check what yours supports before planning the rest.

Do we have to stop using our planning spreadsheet?

Not necessarily. We can turn it into a structured template that the loader reads, so the product manager keeps a familiar tool.

Can the brochure be produced automatically?

The dates and prices can be placed into the layout from a structured file. Design and editorial decisions stay with your designer.

What if the checks flag something that is intentional?

Checks can be overridden with a note, so unusual departures are allowed but deliberate.

Keep reading

More on Problems We Solve

Start here

Tell us how your tour programme is run today

Describe your tours, how bookings come in and what you use to hold them today, whether a reservations system, spreadsheets or both. We will tell you what we would build, and if your current system can already do it with better setup, 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 →