Weekly Prices — A Guide for the Tea Room
Prepared by Altrium for Empire Teas (Pvt) Ltd DRAFT — the first chapter of the user guide that comes with the CRM. It explains how weekly prices work in the CRM today. It is written for the Tea Room and the sales team. Revised 16 November 2026: added sending the week’s prices to every customer at once, from the Pricing page.
In short
Each week, the Tea Room does three things in the CRM:
- Loads the new prices for each customer’s buying standards.
- Checks them.
- Publishes them.
A published price stays in force until the next Colombo auction sale starts. Once the prices are published, a sales rep can email a customer the prices for that customer’s own standards.
Customers see only the final price in US dollars. They never see costs, rupee figures or prices that are not yet published.
Words used on the screens
| Word | What it means |
|---|---|
| Auction sale | One weekly Colombo auction, with its number and dates. Example: sale 42, 13–15 October. In the CRM, “this week” means the current auction sale, not the calendar week. |
| Current sale | The latest sale that has already started. |
| Buying standard | One customer’s tea specification. Each standard has its own number. Prices are set for each standard. |
| Round | All the prices for one auction sale. |
| Draft | A price that is loaded but not yet published. Only the Tea Room sees drafts. Reps cannot quote or email them. |
| Published | A price that is in force. Reps can quote it and email it to customers. |
Each week, step by step
Step 1. Add the sale
- Open the Pricing page and go to the Auction Sales tab.
- Choose New Sale.
- Enter the Year, the Sale Number, the day it Starts and the day it Ends.
- Choose Create Sale.
If the sale starts today or earlier, the form warns you before you create it. The warning says two things:
- The sale becomes the current sale straight away.
- Prices from earlier sales end that night, unless this sale’s round replaces them.
If you make a mistake, use Edit Sale or Delete Sale in the sale’s ⋯ menu. See Fixing a sale below.
The top of the Pricing page can show three notes:
- No next sale has been entered. A price ends when the next sale starts, so the CRM needs the next sale before any price can end. Choose New Sale in the note to add it.
- A sale’s prices are not published yet. See Step 4.
- The daily price update may not be running. The overnight update (see Good to know) has not run on time. Tell the delivery team.
Step 2. Load the workbook
- Choose Import Weekly Prices.
- Choose the Auction Sale the prices are for. If no sale is coming up, choose New Sale here to add one.
- Pick this week’s Excel workbook.
- The CRM reads the workbook and shows you a check screen. Nothing is saved yet.
- For each tab of the workbook, confirm which column holds which figure. The CRM remembers your choice for that tab next week.
- Choose Create N Draft Prices (N is the number of prices). If the sale already has drafts, the button says Replace and Create, and the new drafts replace the old ones.
If one standard appears in two tabs, the CRM flags it. It does not pick one of the two for you.
The CRM does not keep the workbook file.
Step 3. Check the round
Go to the Weekly Prices tab. Each draft shows how much it changed from the previous price. Here you can:
- change any figure (Edit in the row’s ⋯ menu);
- add a price by hand;
- remove a draft (Remove in the row’s ⋯ menu).
Only the final USD price is required.
Some drafts are marked Can’t be published, with the reason:
- Standard archived — the standard was archived after the draft was loaded.
- Priced per quote — a private-label standard, which is priced in each deal.
- Later price published — a price for a later sale is already published.
These drafts stay as drafts when you publish the rest of the round.
Step 4. Publish
- Choose Publish N Prices. N is the number of prices that will be published.
- Check the summary in the Publish the Round window, and choose Publish.
- The new prices apply from the sale’s first day. If the sale has already started, they apply from today.
- Each new price replaces that standard’s previous price.
A reminder on the page. From the day before a sale starts until its round is published, the page shows a note. The note says that the sale’s prices are not published yet. It also says how many standards will have no current price, and from which day. The note has a Review the Round button. It is a reminder, not an error. If the Tea Room sets prices after the auction, the note stays until the round is published.
Publish before the sale starts if you can. On a sale’s first day, every price from an earlier sale ends, unless this sale’s round replaces it. So if you publish later, some standards have no price for a few days.
Example: sale 42 starts on Tuesday 20 October. You publish its round on Thursday 22 October. A standard whose only price came from sale 41 has no price from Tuesday until you publish on Thursday. During those days, price emails list it as No current price.
If the round is not ready in time:
- Open N standards not in this round in the round’s summary, choose Carry Forward All, and publish before the sale starts. This keeps the current prices in force for the new sale.
- When the new prices are ready, use Correct on each price that changes.
Taking back a whole round. If a whole round was published by mistake, Withdraw This Round in the round’s summary takes back every price in it that starts today or later. You give one reason for all of them.
Step 5. Send prices to customers
There are two ways to send prices:
- To every customer at once: on the Pricing page, choose Send Prices to Customers. See Sending prices to every customer below.
- To one customer: on the customer’s account, choose Send This Week’s Prices. See Sending prices to a customer below.
Auction sales
Each sale has a year, a number, a first day and a last day (Starts and Ends on the screen). It has no separate name. The CRM shows a sale like this: 2026 / sale 42 · Tue 20 Oct–Wed 21 Oct. Each year and number can be used only once.
Sale state
The State column shows where each sale is:
| State | When | What changes it |
|---|---|---|
| Upcoming | Before its first day | Nothing. It follows the dates. |
| In progress | From its first day to its last day | It starts by itself on its first day. There is no Start button. |
| Held | After its last day | The CRM’s overnight update. |
The current sale
- The current sale is the latest sale that has started. If two sales start on the same day, the one with the higher number is the current sale.
- “This week’s prices” and the price emails always use the current sale.
- The current sale changes by itself on the next sale’s first day.
You can enter several sales ahead of time. Their dates can overlap, so more than one sale can show In progress at the same time. Only one of them is the current sale. Each sale has its own round of prices.
Fixing a sale
Open the ⋯ menu at the end of the sale’s row, and choose Edit Sale or Delete Sale. Each time you save, give a Reason. What you can do depends on the sale:
| If the sale… | You can… |
|---|---|
| has no published prices (whether it has started or not) | Change its year, number, start and end. Or use Delete Sale to remove it and its draft prices. |
| has published prices, or had them and they were withdrawn | Change only its end. To fix wrong prices, withdraw or correct them. See Changing a price after it is published. |
| is held | Change nothing. If it never had a published price, you can still delete it. |
Some limits:
- You cannot delete a sale once a price email has been sent for it. Correct its number or dates instead.
- A new end must be today or later. It cannot be before the start.
- A sale cannot start on or before the start of a later sale whose prices are already published.
- Fixing or deleting a wrong sale does not bring back prices it has already ended. If the CRM ended prices on a wrong sale’s first day, they stay ended. To price those standards again, load them into the right sale’s round and publish it. (Carry Forward All can bring them back only when the right sale starts on the same day as the wrong one did.)
Standards that are not in this week’s workbook
If a standard has no price in this week’s round, it keeps its current price until the new sale starts. After that, it has no price.
To keep it priced for another week:
- In the round’s summary on the Weekly Prices tab, choose N standards not in this round.
- In the window that opens, choose Carry Forward for that standard.
Carry Forward All, in the same window, does this for every standard that has a current price but is missing from the round. Carried prices go into the round as drafts. They take effect when you publish the round.
So the CRM works whichever way the Tea Room fills in the workbook:
- If a blank cell means “not offered this week”, leave it. The price ends when the next sale starts.
- If a blank cell means “same as last week”, choose Carry Forward All before you publish.
Either way, publish before the sale starts (Step 4), so that no standard is left without a price.
Changing a price after it is published
Open the ⋯ menu at the end of the price’s row on the Weekly Prices tab. The menu offers only the actions that fit the price:
| If the price… | You see | What happens |
|---|---|---|
| starts today or later | Withdraw | You give a reason, and the price is taken back. The standard has no price from that date until a new price is published. The earlier price does not come back. |
| started before today | Correct | You enter the corrected figures, the date they apply from, and a reason. Earlier days keep the old price, so what was quoted before stays true. |
| is missing from this week’s round | Carry Forward | The current price is copied into the round as a draft. See the section above. |
About Correct:
- The date must be today or later, and before the next sale starts. If no next sale has been entered yet, the only date allowed is today.
- If a correction is wrong, you can correct it again. A correction that starts today or later shows both Withdraw and Correct.
The CRM records who made each change, when, and why. History, in the same ⋯ menu, shows a standard’s published prices sale by sale.
Sending prices to a customer
- On the customer’s account page, choose Send This Week’s Prices.
- The CRM lists the customer’s standards with this sale’s published USD prices.
- Choose the contact to send the email to. The main contact is chosen for you, and you can change it. You can also choose people to copy.
- The email opens, filled in from the weekly-prices template. You can edit it.
- Send it. It goes from your own Outlook mailbox.
Some standards may be left out of the email. The CRM lists them under Not in This Email, each with its reason:
- No current price — no published price is in force today, for example because it was withdrawn or ended.
- Priced per quote — a private-label standard. Its price is agreed in each deal.
- Price from sale 41 — this week’s not published yet — the standard’s only price is from an earlier sale.
After you send, the account’s history records the email. The account shows Prices sent, with the date, the contact and who sent it.
If the current sale changes while you are writing the email, the CRM does not send it. This happens if the Tea Room deletes the sale, changes its dates so that another sale becomes the current one, or if the next sale starts. A message asks you to close the email and choose Send This Week’s Prices again. The new email then lists the current sale’s prices.
To send every customer their prices at once, see the next section.
Sending prices to every customer
This was planned for Phase 2. It was built early and is now part of Phase 1 (18 November 2026; Product Requirements, Section 3.2). This section describes it as built.
Once the week’s prices are published, you can send each customer their own prices in one go, instead of one account at a time.
Choosing who to send to
On the Pricing page, choose Send Prices to Customers. You see this button if your role lets you send email from the CRM. The window that opens shows three things.
The week, and the mailbox the emails go from. The emails go from your own Outlook mailbox. If your mailbox is not connected, or needs connecting again, the window says so and links to the mailbox settings. Nothing can be sent until it is connected.
The customers that can be sent their prices. These are the customers you look after that have a published price this week and a main contact with an email address.
- Each email goes to the customer’s main contact, and copies the customer’s other contacts. To send to the main contact only, untick Copy Each Customer’s Other Contacts.
- Each customer receives only their own standards and prices. Nobody sees another customer’s prices or contacts.
- The Search Customers box narrows the list by name. Select All and Select None tick or untick the customers shown.
- The counts above the list show how many customers, emails and priced standards you have ticked.
Not Sent To. These are the customers that cannot be sent to. Each shows its reason and a link to the account, so you can put it right, or send from the account page instead. The reasons are:
- No published price this week
- No primary contact with an email address
- More than 50 recipients (with copies on; untick the copies to send to the main contact alone)
- No value for: and the details missing from the email, such as a contact’s first name
- The email is too long
Some customers are not ticked at first:
- A customer already sent this week’s prices shows Sent with the date. This covers a send from their account page or an earlier send. Tick it to send again.
- A customer whose earlier email may or may not have gone out shows Not known — check your Sent Items. Check your Outlook Sent Items before you tick it.
Checking and sending
- Choose Preview on a customer to see their email as it will go. Every email is the weekly-prices email template, filled in for that customer. You cannot edit it here:
- to change the wording for everyone, change the template under Email templates in Settings;
- to change one customer’s email, send it from their account page.
- Track Opens and Clicks is ticked at first, as it is for any email.
- Choose Send to
Customers . The window asks once more. It says how many emails go to how many customers, from which mailbox, and about how many minutes they will take. - Choose Send Now, or Back to return to the list.
If any chosen customer can no longer be sent their prices by then, nothing is sent. For example, their price may have been withdrawn in the meantime. The window names them, and Refresh the List reads the list again, keeping your ticks.
If the connection fails as you choose Send Now, the window cannot tell whether sending started, and says so. Choose Send Now again. If sending did start, it is not started twice.
While the emails go out
The emails go from your mailbox at no more than 20 a minute, so 300 customers take about 15 minutes. This keeps within Microsoft’s limits for one mailbox, and leaves room for your own email.
You can close the window and carry on working; sending continues. Beside the button, the Pricing page shows Sending prices and how many have gone. Choose it, or the button, to open the results again.
The results show how many customers are sent, waiting, not sent and skipped. Each customer shows one of these:
- Waiting, Sending, or Sent with the time;
- Not sent, with the reason;
- Skipped, with the reason. For example, the customer was sent this week’s prices from their account page in the meantime;
- Not known — check your Sent Items, when Microsoft did not confirm whether the email went;
- Sent — not marked as sent, when the email went but the account could not be marked;
- Stopped.
Stop Sending asks first: Stop sending? Emails already sent stay sent. Choose Stop Sending again to stop the customers not yet sent, or Keep Sending. An email already on its way still goes.
Each email sent is recorded on the customer’s account, as one sent from the account page is. The account shows Prices sent with the date, and the email is in its history.
When sending finishes, the Pricing page shows Prices sent to and how many customers. It also shows how many were not sent, if any were not sent or are not known, or Stopped after Stop Sending.
Sending again to those not sent
Choose Send Prices to Customers again. The customers still without this week’s prices are ticked, and those already sent are not. There is no separate retry button.
Limits
- One send at a time for each person. While yours is sending, the button opens its results.
- Up to 1,000 customers and 5,000 recipients in one send. That is half of what Microsoft lets one mailbox send in a day.
- A send can stop part-way: your role may lose the right to send email, or your mailbox may need connecting again. Then the customers not yet sent show Not sent with the reason.
Who can do what
What each person can do depends on their role. Empire’s administrator sets each person’s role. Usually:
- The Tea Room adds sales, loads workbooks, edits drafts, and publishes, withdraws and corrects prices.
- Sales reps see published prices, and send a customer’s prices from the account page to the customers they look after.
- Sending prices to every customer is done from the Pricing page. It needs a role that can see the Pricing page and send email from the CRM. The list shows only the customers the person can see, so whoever sends to every customer needs a role that sees every customer’s account.
Good to know
- Enter each sale once. The CRM does not stop two sales from having the same or overlapping dates, so enter each sale only once, with its own number. If a sale was entered twice, or with the wrong number or dates, fix it with Edit Sale or remove it with Delete Sale. You can do this while no prices are published for it. See Fixing a sale.
- A sale’s end only decides when it shows as Held. It does not end any price. So you can change it even after prices are published.
- Units. The CRM reads the workbook’s figures as rupees per kilogram, and the import screen shows this unit. Published prices are in US dollars per kilogram, FOB Colombo.
- The overnight update. Every night, after midnight Colombo time, the CRM:
- ends the prices that no new round replaced;
- marks a finished sale as Held.
- A sale entered on its first day, or later, is fine. It becomes the current sale at once, and you can publish its round the same day. Publish it, or use Carry Forward All, on that day. That night’s update ends the earlier prices that the round does not replace.
- Every week’s prices are kept. A new price ends the previous one. It does not overwrite it. A withdrawn price stays in the CRM, marked as withdrawn. A correction starts from its date, and earlier days do not change. History, in a price’s ⋯ menu on the Weekly Prices tab, shows that standard’s published prices, sale by sale. Only drafts are replaced, when you load a week’s workbook again.