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
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
Detailed sizing for each solves Consol OC (0.0539 factor)
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
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)
total 12213 sellers
active in last 90 days : 9068
Cohort: 28th March’24: 5021 ,8th Aug’24 : 3985
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
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