Turning Ten Candle Shop Order Emails Into One Workable Table
Ten incoming order emails from a fictional candle shop can be consolidated into a single table with the columns Order number, Customer, State, Items, Quantity, Order total in dollars, and Ship-by date. The table's purpose is to give whoever packs and ships the orders one place to see everything at once. A TOTAL row at the bottom sums the whole batch, and the orders are then ranked so the most time-critical ones go out first.
The Ten Orders and Their Basic Details
The batch covers orders 1041 through 1050 and ten different customers spread across ten states, from Texas and Colorado to Oregon, Washington, California, Illinois, Florida, Massachusetts, Tennessee and Arizona. Two of the buyers are wholesale accounts rather than individuals: Bloom Boutique in Oregon and Green Leaf Spa in Florida. The rest are individual customers ordering for themselves or as gifts.
Building the Table From Unstructured Emails
The order emails arrive in mixed formats: some have clear subject lines, one has no subject at all, and one is a forwarded message. Extracting the fields means reading each message for the order number, the buyer's name and state, the product, the quantity and any deadline mentioned in the text. Anything the email does not state stays blank instead of being guessed, which is why the ship-by column is empty for three rows.
The Order Number Column
Each email carries a four-digit order number between 1041 and 1050, and these numbers anchor the whole table. Order 1041 belongs to Maria Lopez and 1050 to Ethan Wright, so the range spans the full batch. Order numbers are the safest key to sort and reference by, because names and email subject lines vary in style.
The Customer and State Columns
The customer column mixes individuals and businesses: Maria Lopez, James Carter, Priya Shah, Tom Nguyen, Olivia Brown, Daniel Kim, Sophie Martin and Ethan Wright are individuals, while Bloom Boutique and Green Leaf Spa are wholesale buyers. The state column records where each order ships, which matters because it drives shipping cost and transit time. States in this batch are TX, CO, OR, WA, CA, IL, FL, MA, TN and AZ.
The Items and Quantity Columns
The product mix includes Vanilla candles, Sea Salt candles, Lavender tins, Cedar Gift Boxes and Holiday Bundles. Quantities range from a single Cedar Gift Box to twelve Lavender tins, which means the batch is not uniform in size or packing effort. Separating item type from quantity keeps the table readable and makes it easy to pick and pack from one list.
The Order Total Column
Order totals are calculated by multiplying the unit price by the quantity in each row. Vanilla and Sea Salt candles are $18 each, Lavender tins are $9.50 each, Cedar Gift Boxes are $45 each, and Holiday Bundles are $72 each. For example, twelve Lavender tins at $9.50 come to $114.00, and four Vanilla candles at $18 come to $72.00.
The Ship-By Column and Its Gaps
Seven of the ten emails state a deadline, ranging from October 18 to October 25. Three orders — 1042 for James Carter, 1044 for Priya Shah, and 1049 for Sophie Martin — include no date at all, and one of them explicitly says there is no rush. Those rows stay blank in the table until a date is confirmed with the customer, because guessing a deadline would risk shipping at the wrong time.
Reading the Total Row
The TOTAL row sums ten orders, 35 units and $666.00 in revenue across the batch. The unit count is the more useful figure for packing because it tells you how many items physically leave the shelf. The dollar total is a simple check that no line was missed when the table was assembled.
Why Ship-By Dates Drive the Priority Order
When several orders are waiting, the ship-by date is the clearest signal of what to work on next. An order due October 18 has to be picked, packed and handed to a carrier sooner than one due October 25, because transit time is the same constraint for everyone. Sorting by deadline first, and by size second, produces a queue that respects every customer's stated need.
Order 1043 Goes First
Bloom Boutique's wholesale order in Oregon has the earliest deadline in the batch at October 18. It also contains the largest single line: twelve Lavender tins, which takes longer to count, pack and label than a two-item order. That combination of earliest date and largest volume makes it the top of the queue.
Order 1046 Is Next
Olivia Brown in Illinois needs four Vanilla candles before October 19, the second-earliest date in the table. Her order is larger than a typical single-item purchase, so it also benefits from being started early. Putting it second keeps every order due within the same week on schedule.
Order 1041 Completes the Top Three
Maria Lopez in Texas needs two Vanilla candles by October 20, the third-earliest deadline. It is a small order, but treating it third keeps the deadline order intact rather than jumping ahead to later dates. Shipping these three first clears every order due within the next week.
What Comes After the First Three
Once the October 18, 19 and 20 deadlines are handled, the next orders in line are 1047 for Green Leaf Spa with an October 21 deadline, followed by 1045 for Tom Nguyen due October 22. Order 1050 for Ethan Wright is due October 23, and 1048 for Daniel Kim is the last dated order at October 25. Working down the date list keeps the schedule predictable.
Order 1045 Needs Gift Wrapping
Tom Nguyen's order of two Cedar Gift Boxes includes a request for gift wrap. That is a packing instruction rather than a shipping constraint, so it does not change the queue position. It does mean the packer should pull the wrapping materials before starting the order.
Handling the Three Orders Without a Deadline
Orders 1042, 1044 and 1049 have no ship-by date, which means they cannot be scheduled against the others. The correct step is to contact each customer to confirm a date before assigning a slot. Leaving the column blank in the meantime keeps the table honest and avoids shipping something earlier or later than the buyer expects.
Wholesale Orders Need Different Handling
The two wholesale accounts, Bloom Boutique and Green Leaf Spa, order in larger quantities of a single product. Wholesale volume often needs different packaging and can involve invoicing separate from a consumer order. Treating them as their own category in the table helps separate them from individual retail shipments.
How Real Candle Shops Handle Processing and Shipping
Published policies from several candle retailers show a range of processing and transit practices. Silver Dollar Candleworks, which ships from Knoxville, Tennessee via USPS First Class, Priority or Priority Mail Express, quotes typical delivery at one to three business days according to its shipping policy. Shortie's Candle Company states that orders normally ship within 24 to 48 hours from the first business day after ordering, with processing Monday to Friday, 9am to 5pm Pacific.
Free Shipping Thresholds and How They Vary
Free shipping minimums differ widely between shops, which matters when planning fulfilment costs. Black Culture Candles offers free USPS Priority shipping on orders of $150 or more, while Sensual Candle Co. offers free shipping over $100, per those companies' shipping pages. Shortie's Candle Company sets its free economy ground shipping threshold at $49 for continental U.S. orders.
Why a Single Table Matters for Fulfilment
Consolidating order emails into one table turns scattered messages into a single queue that can be sorted by deadline, customer or order number. It also exposes gaps, such as missing ship-by dates, that would otherwise be buried inside individual emails. For a small shop, that one view is often the difference between shipping on time and missing a promised date.

1 / 20 · 9s

Gallery

Candle order table and shipping priority

Admin4 messages

Oct 14, 2026

Builds a table from ten sample candle shop orders with a total row, picks the first three to ship, and drafts date-request emails to two customers.

Here are 10 order emails from our sample candle shop (fictional data). Turn them into one clean table: Order #, Customer, State, Items, Qty, Order total ($), Ship by. Add a TOTAL row. Then tell me which 3 orders to ship first. 1) Subject: New order #1041 — Hi! Please send 2 Vanilla candles ($18 each) to Maria Lopez, Austin TX. Need them by Oct 20. Thanks! 2) Subject: Order 1042 — 1 x Cedar Gift Box $45. Ship to James Carter, Denver CO. No rush. 3) Subject: Re: wholesale — order #1043, 12 Lavender tins at $9.50. Bill to Bloom Boutique (sample), Portland OR. Ship by Oct 18 please. 4) Subject: quick order — hey it's Priya Shah (Seattle WA), can I get 3 Sea Salt candles, $18 each? #1044 5) Subject: Order #1045 — Two Cedar Gift Boxes ($45) for Tom Nguyen, San Jose CA. Gift wrap please, due Oct 22. 6) Subject: (no subject) — #1046 · Olivia Brown · Chicago IL · 4 x Vanilla @ $18 · need before Oct 19 7) Subject: Order 1047 — 6 Lavender tins, $9.50 each — Green Leaf Spa (sample), Miami FL. Ship by Oct 21. 8) Subject: Fwd: order — Daniel Kim, Boston MA, 1 Holiday Bundle $72, order #1048. Deliver by Oct 25. 9) Subject: #1049 — Sophie Martin here (Nashville TN). 2 Sea Salt + 1 Vanilla, all $18. Thanks so much!! 10) Subject: Order #1050 — 1 x Holiday Bundle ($72) to Ethan Wright, Phoenix AZ. By Oct 23 if possible.

Order table

Order #	Customer	State	Items	Qty	Order total ($)	Ship by
1041	Maria Lopez	TX	Vanilla candles	2	36.00	Oct 20
1042	James Carter	CO	Cedar Gift Box	1	45.00	— (no rush)
1043	Bloom Boutique (wholesale)	OR	Lavender tins	12	114.00	Oct 18
1044	Priya Shah	WA	Sea Salt candles	3	54.00	— (none given)
1045	Tom Nguyen	CA	Cedar Gift Box (gift wrap)	2	90.00	Oct 22
1046	Olivia Brown	IL	Vanilla candles	4	72.00	Oct 19
1047	Green Leaf Spa (wholesale)	FL	Lavender tins	6	57.00	Oct 21
1048	Daniel Kim	MA	Holiday Bundle	1	72.00	Oct 25
1049	Sophie Martin	TN	Sea Salt + Vanilla candles	3	54.00	— (none given)
1050	Ethan Wright	AZ	Holiday Bundle	1	72.00	Oct 23
TOTAL	10 orders			35	666.00

Unit prices used: Vanilla / Sea Salt $18, Lavender tin $9.50, Cedar Gift Box $45, Holiday Bundle $72.

Ship these 3 first

#1043 — Bloom Boutique (OR), Oct 18 — earliest deadline and the biggest single line (12 tins), so it needs the most lead time.
#1046 — Olivia Brown (IL), Oct 19 — next deadline up.
#1041 — Maria Lopez (TX), Oct 20 — third earliest.

That clears every order due within the next week (today is Oct 14). After those, the next in line is #1047 (Oct 21), then #1045 (Oct 22).

Two things to flag: #1042, #1044 and #1049 have no ship-by date in the emails, so they can't be scheduled until you confirm one (I left them blank rather than guess). Also #1045 asks for gift wrap — worth noting for packing.

Draft the emails asking Priya Shah and Sophie Martin for their ship-by dates.

Here are both drafts, ready to copy and send.

Email 1 — Priya Shah (#1044)

Subject: Quick question about your order #1044 — when do you need it?

Hi Priya,

Thanks so much for your order! We have your 3 Sea Salt candles ($54 total) for Seattle, WA noted and ready to go.

One thing we're missing: a delivery date. Just let us know the date you'd like it to arrive by and we'll schedule it so it lands on time.

If you don't have a specific date, that's fine too — tell us and we'll ship it with our standard timing.

Thanks again, [Your name] [Shop name]

Email 2 — Sophie Martin (#1049)

Subject: Your order #1049 — what's your ideal delivery date?

Hi Sophie,

Thank you for your order! We have 2 Sea Salt candles and 1 Vanilla candle ($54 total) for Nashville, TN noted.

We just need one detail to get it scheduled: the date you'd like it delivered by. Reply with a date and we'll make sure it arrives in time.

No particular date in mind? Just say so and we'll send it out on our standard schedule.

Thanks so much, [Your name] [Shop name]

Both keep it to a single ask so a one-line reply is enough. Want me to make them shorter, warmer, or add a specific cutoff (e.g. "we need your date by Oct 16 to guarantee it")?

Continue from this conversation

Pick the topic up with your own question: a summary of this conversation becomes the context of your new chat.

How to turn order emails into a table and prioritize shipping

This summary was generated from the chat by AI.

Learn how to organize order emails into a clean table, calculate totals, and decide which orders to ship first by deadline. Includes tips for missing ship-by dates and special packing requirements.

Building the Table

To manage a batch of orders efficiently, a simple table works best. Create columns for Order Number, Customer Name, State, Items, Quantity, Order Total, and Ship-By Date. For each order, list the items, their unit price, and multiply by quantity to get the total. Add a TOTAL row that sums the quantities and order totals. In the sample of ten orders, the total quantity is 35 items and the combined order value is $666.00. This tabular format makes it easy to see deadlines, spot missing dates, and prioritize.

Prioritizing by Deadline

When deciding which orders to ship first, sort by the ship-by date. The order with the earliest deadline should be shipped first, as it requires the most lead time. In the sample data, order #1043 (Bloom Boutique, OR) is due Oct 18, followed by #1046 (Olivia Brown, IL) on Oct 19, and #1041 (Maria Lopez, TX) on Oct 20. These three should be shipped first to meet their deadlines. Orders without a specified date cannot be scheduled and should be confirmed with the customer before shipping.

Handling Missing Ship-By Dates

Three orders in the sample—#1042, #1044, and #1049—do not include a ship-by date. These cannot be prioritized until the customer provides a required date. When a ship-by date is missing, the order remains unscheduled. It is best to contact the customer to confirm when they need the order, rather than making an assumption. Until then, these orders should stay in a pending status and not be shipped alongside the earliest deadlines unless the customer indicates urgency.

Special Packing Requirements

Special instructions, such as gift wrapping or wholesale packaging, should be noted and addressed during picking and packing. In the sample, order #1045 requests gift wrap for two Cedar Gift Boxes. Failing to include this could lead to customer dissatisfaction. When processing a batch, check each order for notes on packaging, inserts, or labeling. Flagging these early prevents delays and ensures the order is correct when it reaches the customer, especially during busy periods when multiple orders are packed together.

Calculating Order Totals

To compute the order total, multiply the unit price by the quantity. For instance, 2 Vanilla candles at $18 each yield $36.00, while 12 Lavender tins at $9.50 each total $114.00. Summing all ten sample orders gives $666.00. This total helps with revenue tracking and inventory reconciliation. When building the table, ensure that wholesale and retail prices are correctly applied, as wholesale rates may differ. Double-check line items to avoid billing errors, as customers expect accurate charges.

Next Steps After Shipping High-Priority Items

After fulfilling the three earliest orders—#1043 (Oct 18), #1046 (Oct 19), and #1041 (Oct 20)—the next in line are #1047 (Green Leaf Spa, Oct 21) and #1045 (Tom Nguyen, Oct 22). Continue working down the list by deadline. For the unscheduled orders, resolve their ship-by dates so they can be integrated into the queue. This approach keeps the workflow orderly and ensures that no customer is overlooked, especially when managing multiple orders with different deadlines.

Reference: Typical Shipping Practices

Many candle shops publish their own shipping policies, which can inform how you set processing times and deadlines. For example, Sensual Candle Co. charges $7 for Priority Flat Rate and offers free shipping over $100, with processing taking 1–3 business days ([sensualcandle.co](https://www.sensualcandle.co/pages/shipping)). Shortie's Candle Company ships within 24–48 hours on business days and provides free economy ground shipping on continental U.S. orders over $49 ([shortiescandles.com](https://shortiescandles.com/help.cgi?f=4)). These examples show that clear cut-off times and transparent rates help customers understand when to expect their orders.

Sources

Web sources used while writing this article.

Reviews

No reviews yet. Be the first to write one.

Ask your own question

Start free with 10 credits a day.

Start chatting

Safety parameters

Safety scorePassed
100/100Threshold 50
ExploreListed
Search engineNot indexed (noindex)
Similar contentNot indexed (noindex)
61%Threshold 60%
Similar to: Candle Shop Orders: Table and Shipping Priority

A page that closely matches an earlier published page is kept out of the search index so it does not compete with it; the page stays readable.