Flipkart Order Issue Resolution

Error1: If Order is not Created in Auperator:
Steps to check if order should be created on Auperator :

1. Check first if the shipment of the order is created or not

   1. if created then raise to auperator team (Raunaq sharma) and share the facility and shipment creation time.

   2. if shipment is not created then:

      1. Check if order is present in “orders_unfulfillable“ table or not using order_id. If it is present then reply to the ops team that order is unfulfillable.

      2. if order is not present in “orders_unfulfillable“ table then check if we do have the inventory for that itemID against which order is placed at the given channel_id and warehouse_id.
         Use query to find out inventory

         SELECT listings.id,listings.sku,listings.channel_id, listings.itemID, inventories.inventory,inventories.warehouse_id,inventories.updated_at ,listings.sellerSku,listings.status FROM listings LEFT JOIN inventories ON listings.id = inventories.listing_id WHERE listings.itemID IN ("TROFZ3VV7TXN2NYX")

         IF we have inventory then create its shipment else skip

         1. CREATE SHIPMENT API:

            https://wms.eshopbox.com/api/order/shipment

            Request body:

            { "customerOrderNumber": "53205782-cbff-4276-9d5f-5f8e41867d03", "externalShipmentID": "OD124791349305612000-1238-001", "externalWarehouseID": "Gurgaon_FC", "externalChannelID":"CH1238", "items": [ { "lineItemSequenceNumber": 12479134930561200, "itemID": "TROFZ3VV7TXN2NYX", "quantity": 1 } ] }

Error2: If the order is having some label issues:

1. If Packaging In Progress is not done completed: in this case generate a label from flipkart portal by updating the dimensions and then run the packed order.

2. We have implemented a real-time POST API with endpoint “get/label“. This endpoint receives a request to generate a label for the given order from warehouse. Check its log for the given order.
   REAL TIME GET LABEL API: Using

   1. Picked event for auperator

   2. Created event for unicommerce make a post request on the below API

      https://flipkart-integration-prod.el.r.appspot.com/_ah/api/esb/v1/get/label

3. if Packaging in progress is successfully completed and getting error while download label. : in this case click on reprint labrl and upload the URL in the cloud and save data in DB. follow below steps to complete this step.

   1. log in to the Flipkart Seller account of the brand of which the order is created.Use the below sheet to find the login details of the Flipkart Seller account of the brand
      https://docs.google.com/spreadsheets/d/1TTI1jIOfpHjMI6h8l114sBMLjcQz9LNgTIEhzoO5l2o/edit#gid=690397856

   2. https://seller.flipkart.com/index.html#dashboard/home-page

   3. Search the order using “orderId“
      
      

      Open

      

   4. Check Dispatch after Date and order status. We can not generate label now if

      1. Current date is lesser then the Dispatch after Date

      2. Order status is not moved to Packed.

   5. If both of the above conditions are false then Reprint the label from the dashboard which will download the label in pdf in your system

      1. Go to GCP “flipkart-integration-prod“

      2. Go to cloud storage and select bucket “label_invoice_file_uploads“.

      3. Select “UPLOAD FILES” and choose the downloaded label and upload it.

      4. Once the label is uploaded Open the uploaded file and go to “EDIT ACCESS” and make it public.
         
         

         Open

         

      5. Copy the Public URL and Save the below details in “shipments“ table DB

Errors in Flipkart API:

Error 1: If we try to download the label before its dispatched after the date Or its status is not moved to PACKED

1. API on which we can receive this error

   1. Generate Label PDF from Flipkart:

      https://api.flipkart.net/sellers/v3/shipments/{{shipmentID}}/labels

   2. Error:

      { "errors": [ { "type": "ERROR", "code": "INVALID_SHIPMENTS", "message": "Invalid shipment Ids passed", "params": { "transaction_id": "TXN-6b3d53ec-ce40-40ac-9efa-d01731ef070b", "logging_id": "fa36c8a838356967", "uri": "/v3/shipments/35473933-e717-4d3b-bbe5-627ed9a1a4da/labels", "request_id": "REQ-91bf2976-65ed-421c-a0a7-10c66bda4ec0" } } ] }

How to Check Dispatched After Date: See Point 2 in Error 2

Error 2: 500 Internal Server Error
Resolution for this error needs to be discussed

Error 3: If we try to do Packaging in progress for an already PACKED Order then we will get the below error:
API on which we can receive this error:

Resolution: If we have received this error from Flipkart and the label is also not present in DB then we have to manually update the label and tracking details in DB. See Point 2 in Error 2 on how to do it.

Error4: In case we try to do PACKAGING_IN_PROGRESS before Dispatch after date.

Error 5: Package Dimensions too big
Update the dimensions from the seller panel.

Label Generation Real-Time API:

1. We have implemented a real-time POST API with endpoint “get/label“. This endpoint receives a request to generate a label for the given order.
   DOC LINK: Generate Label Real Time API

Error in Refresh Access Token:

POSTMAN DOC LINK:

Errors Reported:

1. Issue in label generation due to package dimensions being too large: We are using correct dimensions but still getting this error from flipkart

Temporary fix: Go to flipkart panel and manually update smaller dimensions

1. Shipment is not created: see point 1 at the top

2. Why shipment got rejected after being marked accepted: it happens becuase of Not found case.