The Columns the Table Needs

The table carries Order Number, Customer, State, Items, Quantity, Order Total in dollars and Ship By. State means the destination state in the United States, and Qty counts individual candle units or boxes rather than separate product lines. A total row closes the table so the quantity and value can be checked at a glance.

Orders 1041 Through 1043

Order 1041 is Maria Lopez in Austin, Texas, for two Vanilla candles at $18 each, adding up to $36.00 with a requested date of October 20. Order 1042 is James Carter in Denver, Colorado, for one Cedar Gift Box at $45.00 and carries no rush. Order 1043 is Bloom Boutique, a sample wholesale account in Portland, Oregon, for twelve Lavender tins at $9.50 each, worth $114.00 and wanted by October 18.

Orders 1044 Through 1046

Order 1044 comes from Priya Shah in Seattle, Washington, for three Sea Salt candles at $18 each, or $54.00, with no date mentioned. Order 1045 is Tom Nguyen in San Jose, California, for two Cedar Gift Boxes at $45.00, making $90.00, with gift wrap requested and a date of October 22. Order 1046 is Olivia Brown in Chicago, Illinois, for four Vanilla candles at $18 each, or $72.00, needed before October 19.

Orders 1047 Through 1050

Order 1047 is Green Leaf Spa, another sample account, in Miami, Florida, for six Lavender tins at $9.50 each, or $57.00, to ship by October 21. Order 1048 is Daniel Kim in Boston, Massachusetts, for one Holiday Bundle at $72.00, to be delivered by October 25. Order 1049 is Sophie Martin in Nashville, Tennessee, for two Sea Salt candles and one Vanilla candle, all at $18, giving $54.00 with no date stated. Order 1050 is Ethan Wright in Phoenix, Arizona, for one Holiday Bundle at $72.00, requested by October 23 if possible.

How Quantities Add Up

Adding the unit counts across the ten orders gives thirty-five units, not counting the state and customer entries. Two- and four-unit orders dominate, while the single wholesale line of twelve Lavender tins supplies over a third of the total volume. That concentration matters because one order can absorb a large share of a day's packing capacity.

How the Totals Add Up

The order values are $36.00, $45.00, $114.00, $54.00, $90.00, $72.00, $57.00, $72.00, $54.00 and $72.00. Summed together they come to $666.00 across ten orders. The largest single value is the Bloom Boutique wholesale order at $114.00, and the two Holiday Bundle orders and Olivia Brown's Vanilla order each sit at $72.00.

Why a Ship-By Column Is Needed

Not every email states a deadline, so the table records what each customer actually wrote rather than inventing a date. Three orders — 1042, 1044 and 1049 — have no date at all or explicitly say there is no rush. Missing deadlines are a problem because an order without a promised date has no place in a queue ordered by urgency.

Interpreting Vague Deadlines

Olivia Brown wrote that she needs order 1046 before October 19, which is a boundary rather than a shipping day. Treating that as a ship date of October 17 or 18 at the latest builds in a buffer for transit. The other dated orders name a single day, which is simpler but still leaves transit time outside the shop's control.

Treating All Three 'Before' Orders the Same Way

Order 1043 says ship by October 18, order 1046 says before October 19 and order 1041 says needed by October 20. Rather than treating any of them differently, the same rule applies: back up from the stated day by the expected transit time. That keeps the comparison fair when the dates are only a day or two apart.

Ranking by Deadline

Sorting the dated orders from earliest to latest gives October 18 for 1043, October 19 as the boundary for 1046, October 20 for 1041, October 21 for 1047, October 22 for 1045, October 23 for 1050 and October 25 for 1048. The undated orders have no position in this list. The first three dated orders are therefore 1043, 1046 and 1041.

When Two Deadlines Are Close, Size Breaks the Tie

For orders that fall within a day or two of each other, the larger line takes precedence because it needs more packing time. A twelve-unit wholesale order consumes more labor than a two-unit retail order, so leaving it late risks missing the promise even if the calendar date looks comfortable. This is why 1043 leads the queue despite being a wholesale account rather than a single customer.

A General Allocation Framework

Logifrontier describes a four-tier order-management framework for allocation during stockouts: paid rush and promised-delivery orders are protected first, key accounts and distributor replenishment come next, then regular retail orders on proportional allocation, and finally pre-orders, low-margin and deferrable orders. The hardcoded sequence runs reserved first, then those four tiers in order. The tier labels are useful language for explaining why a wholesale account with an early date outranks a browsing retail order.

A Scored Alternative

A second framework from the same site scores each order as channel weight multiplied by margin weight multiplied by delivery-risk weight. It tags five dimensions: channel, margin, delivery promise, account health and customer value. Margin guidance in that framework protects orders above about thirty percent margin and cuts orders below about ten percent first, though that is general guidance rather than a candle-specific rule.

Neither Framework Is Candle-Specific

The searches did not turn up a single candle-specific prioritization table. The tier and scoring frameworks come from order-management systems and apply to allocation generally rather than to wax products. So the ranking of the ten orders still rests on the dates and volumes in the emails themselves.

Candle Production Takes Longer Than Packing

Excellence Candle reports standard production lead times of fifteen to twenty days when packaging already exists, twenty to twenty-five days for custom candles with new packaging or design, and twenty-five to thirty days when both the candle and the packaging are custom. Full order-to-shipment cycles run forty-five to ninety days in that source. Those figures describe making candles, not picking and packing stock that already exists, so they matter for restocking decisions rather than for this week's shipping list.

Seasonal Deadlines Can Sit Far Ahead

For Diwali-related bulk work, a candle-making supplies source puts Diwali on November 8, 2026. Allowing fourteen to twenty-one days for curing, checking and packing, that source estimates the last workable pour at around October 8, 2026. Suggested first-pour dates range from September 29 for a thousand pieces to October 8 for a hundred pieces. These are estimates tied to that season and that market, not to the sample shop's October orders.

The First Order to Ship

Bloom Boutique, order 1043, is the top priority because it carries the earliest stated date, October 18, and the largest line at twelve Lavender tins worth $114.00. Pulling it first keeps the wholesale promise and clears the biggest packing job early. A short note to the account confirming the ship date is worth sending the same day.

The Second and Third Orders to Ship

Olivia Brown, order 1046, is next because before October 19 is effectively a day earlier than the other dated retail orders, and her four Vanilla candles need more picking than a single-item order. Maria Lopez, order 1041, takes third place with a firm October 20 deadline for two Vanilla candles. Shipping both on October 17 or 18 leaves room for transit.

What to Chase Up Before the Next Run

James Carter on order 1042 said there is no rush, so that one can wait. Priya Shah on 1044 and Sophie Martin on 1049 gave no date at all, so a quick email asking when they need the goods prevents them from defaulting to the back of the queue. Batching the rest — 1047 by October 21, 1050 by October 23 and 1048 by October 25 — into a single later run keeps the week's work organised.