1. Home
  2. ReturnsJini
  3. File Formats

File Formats

A single Returns input is required by the system as given below. Note that Returns file is crucial for Returns processing. If any of the mandatory details are not present in the Returns upload file, then the system will not upload that data and an error will be shown on the screen

All data must be uploaded in the CSV format (comma-separated values). You can always store your Excel files using CSV format

Important: Please use the proper data type for each of the fields. 

DataFormat
Upload ReturnsUpload all your marketplace/brick & mortar store returns. All returns RTO (Return To Origin) oramp; CR (Customer Returns) oramp; MRTO (Manual Return to Origin) can be uploaded here
  • ChannelSKU represents the unique EAN/SKU code of the product created for that sales channel (There is a one to one mapping between ChannelSKU and ProductBarcode)
  • ChannelForwardOrderDate represents the forward order date to which  the sales channel return belongs. Date must be in dd-mm-yyyy format
  • ChannelForwardOrderId represents the forward order id to which the sales channel return belongs
  • ChannelParentOrderId represents the reference (parent) link to all the items ordered within the sales channel forward order
  • ChannelReturnOrderId represents the return order ID against the sales channel forward order
  • ChannelReturnLineItemId represents the sales channel’s unique Id provided to every line item within that return order
  • ChannelReturnType represents whether the sales channel return is an RTO (Return to Origin) or CR (Customer Return) or MRTO (Manual Return to Origin)
  • ChannelReason represents the customer’s reason for returning to the sales channel. E.g. Delayed delivery, wrong product, broken product, size & fit issue, look & feel issue, bad quality, etc.
  • ChannelTrackingId represents AWB (Air Way Bill) number that provides detailed information about the shipment and allows it to be tracked for the sales channel
  • ChannelTransporter represents the courier transporter’s name for the sales channel. E.g. Delhivery, DHL, FedEx, Shiprocket, DTDC, etc.
  • ChannelQuantity represents the aggregated return quantity for the sales channel
  • ProductBarcode represents the unique EAN/SKU code of the product
  • Attr1 represents the additional attribute that the client needs to add at the ChannelReturnOrderId level. This can be selling price, mrp, COGS, internal ERP/system order id, etc.
  • Attr2 represents the additional attribute that the client needs to add at the ChannelReturnOrderId level. This can be selling price, mrp, COGS, internal ERP/system order id, etc.
  • Attr3 represents the additional attribute that the client needs to add at the ChannelReturnOrderId level. This can be selling price, mrp, COGS, internal ERP/system order id, etc.
  • Attr4 represents the additional attribute that the client needs to add at the ChannelReturnOrderId level. This can be selling price, mrp, COGS, internal ERP/system order id, etc.
  • Attr5 represents the additional attribute that the client needs to add at the ChannelReturnOrderId level. This can be selling price, mrp, COGS, internal ERP/system order id, etc.
  • Attr6 represents the additional attribute that the client needs to add at the ChannelReturnOrderId level. This can be selling price, mrp, COGS, internal ERP/system order id, etc.
  • Attr7 represents the additional attribute that the client needs to add at the ChannelReturnOrderId level. This can be selling price, mrp, COGS, internal ERP/system order id, etc.
  • ItemAttr1 represents the additional attribute that the client needs to add at the ChannelReturnLineItemId level
  • ItemAttr2 represents the additional attribute that the client needs to add at the ChannelReturnLineItemId level
  • ItemAttr3 represents the additional attribute that the client needs to add at the ChannelReturnLineItemId level
  • ItemAttr4 represents the additional attribute that the client needs to add at the ChannelReturnLineItemId level

Note – Enter mandatory data in the upload returns file – ClientSKU, ProductBarcode, Quantity and one of (ChannelTrackingId, ChannelForwardOrderId, ChannelReturnOrderId). Rest fields are optional. However, if any of these mandatory fields is missing (or blank) you will get an error message on uploading.

Table sample format

Column HeaderRow Entry1Row Entry2Row Entry3
ChannelSKUSKU1SKU2SKU3
ChannelForwardOrderDate28-11-202029-11-202030-11-2020
ChannelForwardOrderIdFWD1FWD2FWD3
ChannelParentOrderIdFWDFWD2FWD
ChannelReturnOrderIdRET1RET2RET3
ChannelReturnLineItemIdCL-INT01CL-INT02CL-INT03
ChannelReturnTypeCRRTOCR
ChannelReasonSize IssueWrong ProductDelayed Delivery
ChannelTrackingIdAWB-1AWB-2AWB-3
ChannelTransporterDHLFEDEXSHIP ROCKET
ChannelQuantity213
ProductBarcodeEAN1EAN2EAN3
Attr115002000900
Attr213001800700
Attr39001200600
Attr4RT1RT2RT3
Attr5A5A5
Attr6A6A6
Attr7A7A7
ItemAttr1ItA1ItA1
ItemAttr2ItA2ItA2
ItemAttr3ItA3ItA3
ItemAttr4ItA4ItA4
Upload MasterUpload all your product masters with their attributes
  • ProductBarcode represents the unique EAN/SKU code of the product
  • Color represents the color of the product. For e.g Blue, Green, White, etc.
  • Brand represents brand of the product
  • Sub_Brand represents sub-brand of the product
  • Style_Id represents the style parameter that must be an ID (not a name) and must be unique for all styles.
  • Size represents size of the product. For e.g S,M,L,XL,28,30,32,6,7,8, etc.
  • MRP represents the maximum retail price of the product
  • Attribute1 represents the additional attribute that the client needs to add at the product level. This can be season, fit, collar, pattern, neck, occasion, etc. 
  • Attribute2 represents the additional attribute that the client needs to add at the product level. This can be season, fit, collar, pattern, neck, occasion, etc. 
  • Attribute3 represents the additional attribute that the client needs to add at the product level. This can be season, fit, collar, pattern, neck, occasion, etc. 
  • Attribute4 represents the additional attribute that the client needs to add at the product level. This can be season, fit, collar, pattern, neck, occasion, etc.
  • Attribute5 represents the additional attribute that the client needs to add at the product level. This can be season, fit, collar, pattern, neck, occasion, etc.
  •  Image_URL represents the image location for a product

Table sample format

Column HeaderRow Entry1Row Entry2 
PRODUCT_ BARCODEEAN234567EAN123456
COLORREDBLUE
BRANDDEMO-BRANDDEMO-BRAND
SUB_BRANDDEMO-SUB-BRANDDEMO-SUB-BRAND
STYLE_IDSTYLE1STYLE2
SIZEXL34
MRP12992799
ATTRIBUTE1Summer SeasonedFall Winter Collection
ATTRIBUTE2SLIM FITREGULAR FIT
ATTRIBUTE3V NECKDENIM WASH
ATTRIBUTE4PARTY WEARRUGGED
ATTRIBUTE5HALF SLEEVESANKLE LENGTH
IMAGE_URLhttps://rj.increff.com/demo/imagesset/STYLE1.JPGhttps://rj.increff.com/demo/imagesset/STYLE2.JPG
Upload Processed ItemUpload processed excess return Items that have been received physically but returns expectations has not been received
  • QC_LINE_ITEM_ID represents the line Item ids of excess return items received that need to be marked as processed in the ReturnsJini system

Table sample format

QC_LINE_ITEM_ID
10001
11040
11002
Was this article helpful to you? Yes 3 No

How can we help?