Navigate To

Description

Provides Return Orders with their Forward Order details and customer Information at Return Order, SKU level.

Fields

1. RETURN_TO_ORIGIN
2. CUSTOMER_RETURN | 1.When no expectation present 2.When it is an excess return | RETURN_TO_ORIGIN | | 18 | Excess Return | Excess item received than the expected number of items.(Yes/No) | When Return not processed | No | | 19 | Return Processed Without Expectation | Whether the return was processed without expectation.(Yes/No) | When Return not processed | No | | 20 | Channel Return Order Time | Return order created time | 1.When no expectation present 2.When it is an excess return | 05/10/2019 11:43:38 | | 21 | Channel Return Order Delivery Date | Timestamp of the return delivered to the warehouse (as per the channel) | 1. When no expectation present
3. When it is an excess return
4. If channel is not sending us the info | 05/10/2019 11:43:38 | | 22 | Return Order ID | System return order ID | 1.When no expectation present 2.When it is an excess return | 123456 | | 23 | Return Order Status | Status of return order | 1.When no expectation present 2.When it is an excess return | 1. CANCELLED
5. COMPLETED
6. CREATED
7. PROCESSING | | 24 | Channel Return Order Status | Return Order Status from channel | 1.When no expectation present 2.When it is an excess return | Created | | 25 | Return Order Item ID | System Return order line Item ID | When Return not processed | 1234567 | | 26 | Virtual Parent Return Order Item ID | Line item ID of virtual parent if any | 1.When it is not a combo order 2.When it is a virtual SKU in a Virtual Combo Order | 1234568 | | 27 | Return Item Status Updated Time | Last updated time of the return order line Item ID | When Return not processed | 07/10/2019 11:30:04 | | 28 | Return Item Processed Time | Processed time of return order | When Item not processed | 07/10/2019 11:30:04 | | 29 | Return Order Item Status | Line Item status of the return:
8. MISSING
9. RECEIVED
10. PROCESSING
11. PARTIAL_MISSING_COMBO | When Return not processed | RECEIVED | | 30 | Return Order QC | QC status of the return:
12. PASS
13. FAIL | When Return not processed | FAIL | | 31 | QC Reject Reasons | Reason for QC rejection | 1.When Return not processed 2.When Return Order QC is Pass | USED_PRODUCT | | 32 | Sales Channel | Sales channel | NA | Amazon | | 33 | Client SKU ID / EAN | Client SKU ID | NA | 123456789 | | 34 | Virtual SKU | Is this a virtual SKU.(Yes/No) | NA | No | | 35 | Brand | Standard attribute - Brand from the Article Master | When not present in the SKU Master | ABC | | 36 | SKU Description | Standard attribute - SKU Name/Description from the Article Master | When not present in the SKU Master | Men's Fullsleeve Hooded | | 37 | Style | Standard attribute - Style from the Article Master | When not present in the SKU Master | AW18-123 | | 38 | Size | Standard attribute - Size from the Article Master | When not present in the SKU Master | L | | 39 | Color | Standard attribute - Color from the Article Master | When not present in the SKU Master | Green | | 40 | MRP | Standard attribute - MRP from the Article Master | When not present in the SKU Master | 1979 | | 41 | SO Quantity | Ordered Qty(Always 1) | NA | 1 | | 42 | Unit Base Price | Base price per unit for the forward Order SKU combination | When the forward Order is split by OMNI OMS and the returns is processed with a new item id | 1767 | | 43 | Unit Tax | Tax Value per unit for the forward Order SKU combination | When the forward Order is split by OMNI OMS and the returns is processed with a new item id | 212 | | 44 | Unit Sale Price | Sale price per unit for the forward Order SKU combination | When the forward Order is split by OMNI OMS and the returns is processed with a new item id | 1979 | | 45 | IGST Rate (%) | IGST Rate for the forward Order SKU combination | When the forward Order is split by OMNI OMS and the returns is processed with a new item id | 12 | | 46 | CGST Rate (%) | CGST Rate for the forward Order SKU combination | When the forward Order is split by OMNI OMS and the returns is processed with a new item id | 0 | | 47 | SGST Rate (%) | SGST Rate for the forward Order SKU combination | When the forward Order is split by OMNI OMS and the returns is processed with a new item id | 0 | | 48 | HSN Code | Standard attribute - HSN code | When not present in the SKU Master | 61102000 | | 49 | Return Gate Entry No | Gate entry ID of returns | When the Return order is not scanned against a gate entry | 1235 | | 50 | Return Gate Entry Item ID | Item ID of return gate entry. | | 61102000 | | 51 | Return Gate Entry Time | Gate entry creation time of returns | When the Return order is not scanned against a gate entry | 06/10/2019 11:43:38 | | 52 | Tracking ID | Returns tracking ID | 1.When Marketplace is not passing it 2.When data is not uploaded | 8541128454 | | 53 | Return AWB Number | AWB number of returns | When the Return order is not scanned against a gate entry | 854112123 | | 54 | Customer City | City of the Customer | When Marketplace is not passing it | Bengaluru | | 55 | Customer State | State of the Customer | When Marketplace is not passing it | Karnataka | | 56 | Customer Pin | Pin of the Customer | When Marketplace is not passing it | 560095 | | 57 | Reason For Return | Reason for return | | abc123 |

Filters

FAQs