/
Runbook For Support Team

Runbook For Support Team

Owned by Sudip Das (Unlicensed)
Last updated: Jun 28, 2023
3 min read

Issue: Order Not Created For Different Channels


Eg: Escalation Order Not Created for orderId : bdfee6eb-a847-4659-9cdc-76b322238acb

Step 1: Go to Database - Eshopbox_wms_production, table: orders, check customerOrderNumber Exists or not.
Case 1: If exists in Database means order has been created in System, It will look like this:

  • After that Cross Check in Workspace if Order Created or not in workspace ( make sure you have access of particular workspace for which escalation arrived)

  • Case1.1 : If found created in workspace than raise this as False Escalation

  •  

     

  • Case1.2: If found Not created in workspace than raise this to Platform team ( Sourav, Rohit )

     

Case 2: If Not Found in Data Base it means order Not created in System, it will look like this-> Follow Step 2

Step 2: Go to GCP logger console Search with the given CustomerOrderNumber:

Case 1 : You might found Item Id Invalid issue

  • Copy the Item Id, Go to Workspace ->All Products, check If Item Id exists or not, If not Exists Raise it Catalogue Team

  • If item_Id exists in workspace then check for proper Mapping of SKU(ESIN) ,

  • In the details section check Seller SKU Properly Mapped with Eshopbox SKU For the particular Channel Is created or Not ( toggle should be on )

  • If not mapped properly, Raise it to catalogue team.

Case 2 : After proper Mapping Of SKU / Or In case of Other Error Create Order In System Manually

Curl :

curl --location 'https://wms.eshopbox.com/api/order' \ --header 'Authorization: Bearer eyJhbGciOiJSUzI1NiIsInR5cCI6IkpXVCIsImtpZCI6IlJVVXdSREZCUVRSRFFqQkdORFUxTVVZeE16ZEdPRFJHTnpORk5EaEJSVEU0TVVORk5qVTJOdyJ9.eyJodHRwczovL2FwcERhdGEiOnt9LCJodHRwczovL3VzZXJEZXRhaWxzIjp7ImlkIjoyNjQ0LCJ1c2VyVHlwZSI6ImRlZmF1bHQiLCJlbWFpbCI6InN1ZGlwLmRhc0Blc2hvcGJveC5jb20ifSwiaHR0cHM6Ly9hY2NvdW50cyI6WyJ0ZXN0X3Rlc3RfYWplZXQiLCJ0YWIiXSwiaHR0cHM6Ly93YXJlaG91c2VXb3Jrc3BhY2VzIjpbXSwiaHR0cHM6Ly93YXJlaG91c2VzIjpbXSwiaHR0cHM6Ly9wYXJ0bmVycyI6W10sImlzcyI6Imh0dHBzOi8vZXNob3Bib3gtcGF5bWVudC1yZWNvLmF1dGgwLmNvbS8iLCJzdWIiOiJlbWFpbHw2MzYxMTEzZTY0MzY5YTViZDQwNTg3MWMiLCJhdWQiOlsiaHR0cHM6Ly9lc2hvcGJveC1wb3J0YWwtZGV2LmFwcHNwb3QuY29tIiwiaHR0cHM6Ly9lc2hvcGJveC1wYXltZW50LXJlY28uYXV0aDAuY29tL3VzZXJpbmZvIl0sImlhdCI6MTY3OTY0OTc0NywiZXhwIjoxNjc5NzM2MTQ3LCJhenAiOiJUU0gyVFh4N1d2Zng2aHBwSUZmemw1Y2IxTUdxdjlWcCIsInNjb3BlIjoib3BlbmlkIHByb2ZpbGUgZW1haWwifQ.oEQ9Xjl8CFtt-KBqyfvzRBp4xIEMAzgTtjrF0s94klpSxMiMgYkl2U5_yyu3k6t5xoNEsSt5SuMoeA_4iMwFdSL0_hyr_n7GbeQwCKUevUttiep0Q1MmFCfiybzCiFbhjh8A2ceEpwB43N59tpg5jxVJ3LrH36c26A-oKNDExAHBtLrCnFlOPCx5YAf9WA7yvVNUb_iyoR2kCwLuDgpjeA0qQMr1571DX17msbeGbol4IFHClMBgjbJdc68s7QgaaC4G9jdy0Emv0iTzOg3CMeJunfIt9wgP36XeMunN9Adf6QGRI4ouyyGR_WF3-s9GBQezLiq3jZiByopQm4GRbg' \ --header 'Content-Type: application/json' \ --data-raw '{ "externalChannelID": "CH2305", "customerOrderNumber": "bdfee6eb-a847-4659-9cdc-76b322238acb", "shipMethod": "STD", "orderDate": "2023-06-24 13:57:36", "expectedShipDate": "2023-06-26T14:00:00.000+05:30", "promiseDeliveryDate": "2023-06-26 13:57:36", "isCOD": "1", "paymentType": "COD", "taxAmount": 0, "shipChargeAmount": 5, "subtotal": 994.0, "orderTotal": 999.0, "balanceDue": 999.0, "thirdPartyShipping": true, "onHold": "1", "vendorOrderNumber": "OD328445057185402100", "orderStatus": "onhold", "dimension_length": null, "dimension_width": null, "dimension_height": null, "weight": null, "packageID": "SS-1", "externalWarehouseID": "Bangalore_FC", "dispatchAfterDate": "2023-06-24T16:01:00.000+05:30", "suggestedTrackingNumber": null, "suggestedCourierName": null, "shippingAddress": { "customerName": "Devi", "addressLine1": "Panchayat office", "addressLine2": "Near water tank, pandithavilluru", "city": "Maruteru", "postalCode": "534122", "countryCode": "IN", "countryName": "India", "contactPhone": "9999999999", "email": "xyz@gmail.com", "state": "Andhra Pradesh" }, "billingAddress": { "customerName": "Devi", "addressLine1": "Panchayat office", "addressLine2": "Near water tank, pandithavilluru", "city": "Maruteru", "postalCode": "534122", "countryCode": "IN", "countryName": "India", "contactPhone": "9999999999", "email": "xyz@gmail.com", "state": "Andhra Pradesh" }, "items": [ { "lineItemSequenceNumber": "328445057185402100", "status": "ONHOLD", "quantity": 1, "asin": null, "sku": null, "itemID": "RNCGFPQ6EEJY2RZD", "productName": "YOUTH ROBE Solid Women Raincoat XL B1", "dispatchAfterDate": "2023-06-24T16:01:00.000+05:30", "lineItemOrderStatus": "CREATED", "productAdditionalInfo": { "breadth": 5.0, "length": 5.0, "weight": 0.35, "height": 2.0 }, "mrp": 994.0, "lineItemTotal": 994.0, "shippingCharges": 5.0, "customerPrice": 994.0, "discount": 0.0, "externalWarehouseID": "Bangalore_FC" } ] }'


Note: fetch Requst Body from GCP Console for different Channels

Step 3: In case order details not found in GCP Console, Reach out to Apps team.

Related content