Skip to content

Order consolidation


Context- Currently, if the brand is using an OMS panel to process orders, Meesho generates different AWBs for all orders and doesn't consolidate them. But, in reality, we see that ~3-4% of orders are such orders which are multiple orders of the same customer and could be consolidated together by generating a common AWB.
How this will help?- This has 3 benefits-
For the customer- The customer can receive all orders at the same time, (thus super convenient for the user)
For the seller- Seller has to pack extra items in one packet only (thus saving effort and packing cost)
For Meesho, and thus customer and supplier- Meesho will save shipping costs, which could then be passed as a shipping discount to the customer, which could then possibly increase orders of the supplier.
FYI, we already do this for non-OMS sellers, but in our current OMS integration, this is not supported.
The proposal is to do mutual devs at both parties' end to do consolidation. Broad changes that would be needed -
Meesho would start passing user ID and some user attributes in the order payload
OMS players are expected to club all orders of the same user by this user ID.
OMS players should send manifestation requests of these consolidable orders in the same request/payload.
Meesho will generate and give common AWB for multiple sub_order_nums.



Summary
Same seller consolidation is already happening, leading to 2.7% OC and ~₹1.6 CPDO. Although, there are a couple of leakages which are mentioned
out of these, filter issues – break in consolidation due to seller filters leads to ₹0.18 CPDO loss equivalent to 0.3pp.
Table calling out leakages
OMS based consolidation


WFR blocking





There are no rows in this table

OMS

2.76 % of platform OC is processed through OMS , of which 5.39% is same seller consolidation eligible .~ 0.15 pp OC .
{1pp consol = 50 paise CPDO} CPDO goodness ~ 7.5 paisa
B The savings realised through Consolidation will be passed onto BMSM to. fund discount to create a flywheel effect.
To enable consolidation for these sellers , the following the solutions can be implemented i.e parallel processing
Solve
Solves
OC
Trade Offs
Sizing
Services involved
Get these oms 3pl to build same seller consol infra , their system are granular at One to One mapping for a order id and awb which needs to be changed to One to Many mapping. Bundling logic of orders as a bag needs to be implemented at OMSs end.
0.15
Pro: Max opportunity capture.
Con: Build required across 6 oms 3pls
OMS 3pl: 6
Meesho: OMS service, Ship it
There are no rows in this table
Detailed sizing for each solves

OMS OC distribution
OMS 3pls
OC
Consol OC (0.0539 factor)
CPDO goodness (Paisa)
unicommerce
1.12
0.0602602
3.01
easyecom
0.65
0.0351428
1.76
omsguru
0.63
0.0340648
1.7
evanik
0.14
0.0074921
0.37
vinculum
0.1
0.0051744
0.26
increffwms
0.07
0.003773
0.19
browntape
0.03
0.0016709
0.08
increff
0.02
0.0009163
0.05
omuni
0
0
0
There are no rows in this table


AWB consolidation


Sorting Order of RTA tab
carrier(asc),
IS_SIBLING_SUB_ORDER_PRESENT(asc) ,
PRODUCT_DETAILS_SKU(asc),
PRODUCT_DETAILS_VARIATION_ID(asc),
SHIPMENT_TYPE_ID(desc),
SUPPLIER_DISPATCH_EXPECTED_AT_EPOCH_DAYS(asc),
IDENTIFIER(asc)


WFR blocking

Due PQ(WFR/Missing) 7333 sellers were blocked from AWB consolidation
Currently same seller OC opportunity for these seller
AVG Seller OC as a perc of platform is 7.8% of which 2.8% is avg same seller consol opportunity i.e.0.22 % of platform OC

image.png
Their Next step :
Business alignment to activate same seller consolidation for these sellers

Including these and other seller blocked under different reasons contribute 17% platform OC and consol OC of 0.56% of platform OC (od_count 0 and hold window 24) (need to remove sellers which are waas , mall and other initiative related sellers)







3.4 % of seller oc ()




total 12213 sellers active in last 90 days : 9068 Cohort: 28th March’24: 5021 ,8th Aug’24 : 3985


August eligible :
seller count 2948 out of 3635
contribute avg of 4.25% of platform OC DoD
Same seller Consol OC: avg of 3.3% of 4.25% ~ 0.14008% of platform
{1pp consol = 50 paise CPDO} CPDO goodness ~ 7 paisa



March eligible :
seller count 4232 out of 5021
contribute avg of 4.93% of platform OC DoD
Same seller Consol OC: avg of 2.55% of 4.93% ~ 0.1257% of platform
{1pp consol = 60 paise CPDO} CPDO goodness ~ 6.25 paisa


Overall Opportunity :
eligible seller → 7180 out of 8656
Overall OC→ 9.18
Overall Consol OC→ 0.2657
CPDO → 13.285 Paisa










Want to print your doc?
This is not the way.
Try clicking the ··· in the right corner or using a keyboard shortcut (
CtrlP
) instead.