/
Column map

Column map

Owned by Manas Singh (Unlicensed)
Apr 08, 2022
2 min read

 

{ "Order": [ "Channel order ID", "Customer order ID", "Order item ID", "Shipment ID", "Invoice number", "Sales channel", "Portal", "Fulfilment center", "Customer code", "Payment mode", "Sold by", "Shipment Zone", "Replacement", "Replacement order item ID", "Sold as virtual kit", "Virtual kit ESIN" ], "Customer": [ "Shipping customer name", "Shipping contact number", "Shipping email id", "Shipping address", "Shipping city", "Shipping state", "Shipping country", "Billing customer Name", "Billing contact number", "Billing email id", "Billing address", "Billing pin code", "Billing city", "Billing state", "Billing country" ], "Product": [ "ESIN", "SKU", "EAN", "Product group code", "Title", "Brand", "Category", "Product weight", "HSN code", "MRP" ], "Pricing": [ "Invoice total", "Selling price", "Discount", "Discount percentage", "Shipping charges", "Other charges", "Tax amount", "IGST rate", "IGST amount", "CGST rate", "CGST amount", "SGST rate", "SGST amount", "UTGST rate", "UTGST amount" ], "Shipping provider": [ "Forward shipping provider", "Forward tracking ID", "Return shipping provider", "Return tracking ID" ], "Timeline": [ "Order placed on channel", "Order created in Eshopbox", "Order invoiced on", "Expected order ready to ship on", "Order ready to ship (RTS) on", "Time taken for order to ready to ship (RTS)", "Is order ready to ship on time", "Reason for order ready to ship (RTS) delay", "Is order ready to ship (RTS) SLA breached", "Order handover done on", "Expected order delivery date", "Order delivered on", "Time taken for order delivery", "Is order delivered on time", "Is order delivery SLA breached", "Number of delivery attempts done", "1st out for delivery attempt", "Latest out for delivery attempt", "Order cancelled on", "Return created on", "Expected return pickup date", "Return picked on", "Number of attempt taken to pickup", "1st out for pickup attempt", "Latest out for pickup attempt", "Is return pickup done on time", "Is return pickup SLA breached", "Return delivered on", "Return received on", "Return completed on" ], "Status": [ "Current status", "Current status remark" ], "Return": [ "Return ID", "Return type", "Return reason", "Return sub reason", "Return resolution", "Return resolution details", "Action taken on return item", "Return item condition", "Return rejection reason", "Incorrect return items in the shipment", "Incorrect return items details" ], "Cancellation": [ "Cancellation type", "Cancellation reason", "Cancellation sub reason", "Cancel item resolution", "Cancel resolution details" ], "Failed delivery": [ "Order Failed to deliver on", "Reason for failed delivery", "Courier partner remark for failed delivery", "Number of failed delivery attempts done", "Failed delivery action status", "Failed delivery action", "Failed delivery action taken by" ], "Failed pickup": [ "Return failed to pick on", "Reason for failed pickup", "Courier partner remark for failed pickup", "Number of failed delivery attempts done", "Failed pickup action status", "Failed pickup action", "Failed pickup action taken by" ] }
Add label

Related content