Skip to content
Unserviceable orders
Please follow the SOP before raising concerns where in case panel is not getting stuck and there is partial failure for suppliers.
1) Check for any serviceability failures in Metabase table - silver.msg_manifest_service__manifestation_errors
SELECT *
FROM silver.msg_manifest_service__manifestation_errors
WHERE order_number LIKE '198577892398_1%'
OR order_number LIKE '462550889740_1%'
OR order_number LIKE '479587966570_1%'
ORDER BY row_created_at DESC
In case its unserviceable, Please validate with file upload team regarding capacity and if there is capacity than 3PL must not be blocked via supplier
2) check what 3PL are blocked at supplier level in Metabase. sample for above case ::
select * from silver.shipments__shipment_supplier where id = '112377' (supplier_id)
3) Check if lane level serviceability is enabled via laap. sample for above case ::
SELECT t.supplier_id,t.dest_pin,t.enabled
FROM silver.shipments__supplier_lane_level_preferred_carriers t
INNER JOIN (
SELECT supplier_id,dest_pin,MAX(lastupdatedts) AS latest_timestamp
FROM silver.shipments__supplier_lane_level_preferred_carriers
WHERE supplier_id = '112377'
GROUP BY supplier_id, dest_pin
) AS le
ON t.supplier_id = le.supplier_id AND t.dest_pin = le.dest_pin AND t.lastupdatedts = le.latest_timestamp
If issue is still there lets us know for further debugging for cases.
In case its an marketplace seller please raise the concern to
For meesho panel processing raise to
Want to print your doc?
This is not the way.
This is not the way.
Try clicking the ··· in the right corner or using a keyboard shortcut (
CtrlP
) instead.