Activity
Mon
Wed
Fri
Sun
Nov
Dec
Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep
What is this?
Less
More

Memberships

The Fulfillment Files

5 members • Free

1 contribution to The Fulfillment Files
Smart batching SQL
This identifies batchable low-SKU orders—a great starting point for a smart batching run SELECT order_id, COUNT(DISTINCT sku) AS sku_count, COUNT(*) AS total_lines FROM order_items WHERE order_date = CURRENT_DATE GROUP BY order_id HAVING sku_count <= 2;
1 like • Jun 7
Here's the downside; if you should batch is often dependent on a ton of factors. As a silly and simple example, this SQL would return all skus, including those with 2 orders, even if it's 5 minutes before cutoff. This is where a tool like Lully comes in; automatically decides with context of the warehouse and equipment state what your best methods are- then provides grouping and routing to optimize not just the an individual trip, but the entire operation
1 like • Jun 8
@Cedric Corbett Lully looks at all of the orders in the pool, available resources, and available methods/equipment- optionally in a continuous way- to construct real time operating plans that the WMS consume. Even in the simplistic deployment scenario, we'll prevent you from "over batching", not just through the lens of SLA adherence, but also efficiency. In a continous deployment, the scenario you described is one we can help operations mitigate.
1-1 of 1
Mike Myers
1
3points to level up
@mike-myers-8771
Founder of Lully; We make your warehouse better without changing anything

Active 103d ago
Joined Jun 4, 2025