# Bulk update Little Hotelier rates with an AI agent

> Apply a whole pricing plan to Little Hotelier room rates across dates and weekdays, with derived rates and the minimum rate checked first.

Source: https://cotlet.dev/integrations/little-hotelier-api-mcp-server/bulk-update-hotel-rates

Setting next season's prices in Little Hotelier means one Bulk Update per price: Double weekends at one figure, Twin weekdays at another, the Family Room somewhere else. A pricing plan in a spreadsheet turns into many trips through the same form.

Cotlet does it in your own Little Hotelier account with list\_room\_rates, get\_inventory and update\_rates, called by your AI agent, an n8n workflow or a script.

[Request access](https://cotlet.dev/app/signup?app=little-hotelier) [All Little Hotelier tools](https://cotlet.dev/integrations/little-hotelier-api-mcp-server)

Hosted · nothing to install or maintain

Official options

## Can Little Hotelier do this on its own?

Little Hotelier has no API for properties (checked 11 Oct 2026). Bulk Update in Front Desk > Inventory applies one set of changes to the dates, weekdays and room rates you select, and channel rate derivations add a fixed amount or percentage per channel. The help centre describes no way to load a pricing table in one go, and the Lifecycle Audit Tool does not record rate values, so it cannot tell you what a price was before a change (help centre checked 12 Oct 2026).

By hand

## How you do it in Little Hotelier today

1. Open My Apps > Front Desk > Inventory and click the orange Bulk Update button in the grid header.
2. Under When? pick the dates, under Which days? tick only the weekdays you want, and under Which room rates? select the rates that get this price.
3. Under What changes? type the new rate and click Update, then open the form again for every room rate that needs a different price.
4. Leave the greyed-out derived rates alone: Little Hotelier changes them through the base rate or the channel rate's Rate config tab in My Apps > Channel Manager > Channels.
5. Step back through the grid with the week arrows to check each price landed, because a rate below the property minimum does not save.
6. Every extra price is another pass through the form, and once a price is overwritten the grid no longer shows what it was.

With an agent

## How to bulk update Little Hotelier rates with an AI agent

Prompt

```
Raise the Double Room rate to 140 and the Twin to 130 for every Friday and Saturday in December, and show me what each night was before.
```

1. 01  
### Map the plan to room rates  
The agent calls list\_room\_rates and matches each line of your plan ("Double weekends 140") to a room rate ID. Derived rates are kept off the edit list and named in the report with the base rate they follow.
2. 02  
### Snapshot the current prices  
get\_inventory over the whole range gives the price of every night before anything changes. The agent keeps that snapshot as the before column, since Little Hotelier does not keep one.
3. 03  
### Group nights that share a price  
Nights with the same new price, room rates and weekdays go into one update\_rates call, so a plan with three prices becomes three calls. Nights already at the target price are dropped.
4. 04  
### Hold back prices that look wrong  
A price below the floor you gave, or a jump bigger than you allowed, is not sent; the agent asks about it first. Little Hotelier's own minimum rate check still applies on top.
5. 05  
### Approve, apply, verify  
You approve each grouped change. Afterwards the agent reads get\_inventory again, compares every night with the plan and lists any night that did not save by date.

### What you get back

Example data

```
Plan: December weekends and Christmas week, 3 room rates
Double Room, Standard Rate: 8 Fri/Sat nights 120.00 to 140.00
Twin Room, Standard Rate: 8 Fri/Sat nights 110.00 to 130.00
Family Room, Standard Rate: 24 to 31 Dec, 8 nights 165.00 to 195.00
Not edited: Double Room, Non-refundable (derived from Standard Rate, follows it)
Checked in the grid: 24 of 24 nights at the new price
```

### Other ways to ask

- Raise every Standard Rate by 10% for the Easter weekend and show me the before and after.
- Set January weekday rates from this table: Double 95, Twin 90, Family 140.
- Make every Friday in March match that week's Saturday price for the Double Room.
- Every Monday, lower any night in the next 14 days that is still above 150 with 2 or more rooms free to 135.

Before you automate it

## What Little Hotelier allows, and what to know first

- Little Hotelier checks a minimum rate in three places (Front Desk Setup > Property details, Channel Manager Property settings and Direct Booking rate settings), and a rate below it does not save.
- A Little Hotelier channel rate can only be derived from its own room rate, by an amount, a percentage or both, and derived rates show greyed out in the inventory grid.
- The Little Hotelier inventory grid shows future dates only, and the Lifecycle Audit Tool tracks which settings changed but not the rate values sent to channels.
- Little Hotelier Front Desk has a fixed 716-day update period for manual bookings, while each channel receives rate updates only inside its own update period, listed under My Apps > Channel Manager > Channels.
- When a discount is set directly on Booking.com, Little Hotelier shows the discounted price the channel sends on the reservation, not the inventory rate.

update\_rates asks for your OK by default. To run it on a schedule without you, switch confirmation off for that tool in your dashboard.

Sources: [Little Hotelier Help: inventory grid and Bulk Update](https://helpcentre.littlehotelier.com/en/articles/8673827-front-desk-manage-rates-availability-and-restrictions-in-the-inventory-grid) · [Little Hotelier Help: Derive a channel rate](https://helpcentre.littlehotelier.com/en/articles/8674052-derive-a-channel-rate) · [Little Hotelier Help: Check rate history](https://helpcentre.littlehotelier.com/en/articles/13282832-check-rate-history-and-investigate-discrepancies) · [Little Hotelier Help: Inventory not syncing to channels](https://helpcentre.littlehotelier.com/en/articles/8673925-troubleshoot-inventory-not-syncing-or-displaying-correctly-on-channels)

REST

## Call update\_rates from a script

curl

```
curl https://cotlet.dev/api/v1/little-hotelier/update_rates \
  -H "Authorization: Bearer $COTLET_API_KEY" \
  -H "Content-Type: application/json" \
  -d '{"room_rate_ids":["rr_20417"],"from":"2026-12-01","to":"2026-12-31","rate":"140.00","days_of_week":["fri","sat"]}'
```

Example response

```
{
"status": "updated",
"room_rates": 1,
"dates": 8,
"rate": "140.00",
"currency": "EUR",
"skipped": []
}
```

MCP: add https://cotlet.dev/mcp/v1 with the same key; the tool is little-hotelier\_update\_rates. Example data.

[Schedule it in n8n, Make, Zapier or cron](https://cotlet.dev/integrations/little-hotelier-api-mcp-server#automations)

Tools

## Little Hotelier tools this automation uses

__Cotlet Little Hotelier tools used to bulk update Little Hotelier rates with an AI agent__
| Tool | Parameters |
| ----------------- | ----------------------------------------------- |
| list\_room\_rates | none |
| get\_inventory | from, to, room\_rate\_ids |
| update\_rates | room\_rate\_ids, from, to, rate, days\_of\_week |

[All 15 Little Hotelier tools with descriptions](https://cotlet.dev/integrations/little-hotelier-api-mcp-server#tools)

## Frequently asked questions

### Can the agent change a derived Booking.com rate?

Not with update\_rates. A derived channel rate follows its room rate by a set amount or percentage, configured under My Apps > Channel Manager > Channels > channel rate > Configure > Rate config. Change the base rate and the derived one follows.

## More Little Hotelier automations

- [Check Little Hotelier arrivals and unpaid balances daily](https://cotlet.dev/integrations/little-hotelier-api-mcp-server/daily-arrivals-and-balances)
- [Set Little Hotelier minimum stay and CTA with an AI agent](https://cotlet.dev/integrations/little-hotelier-api-mcp-server/set-minimum-stay-and-restrictions)
- [Reply to Little Hotelier guest messages with an AI agent](https://cotlet.dev/integrations/little-hotelier-api-mcp-server/reply-to-guest-messages)
- [Little Hotelier API and MCP server: every tool](https://cotlet.dev/integrations/little-hotelier-api-mcp-server)
- [All use cases](https://cotlet.dev/use-cases)

## Give your agent access to Little Hotelier.

Free 7-day trial with 5,000 credits, no card needed. Cotlet is independent and not affiliated with Little Hotelier.

[Request access](https://cotlet.dev/app/signup?app=little-hotelier)