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.
Data
Format
Upload Returns
Upload 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 Header
Row Entry1
Row Entry2
Row Entry3
ChannelSKU
SKU1
SKU2
SKU3
ChannelForwardOrderDate
28-11-2020
29-11-2020
30-11-2020
ChannelForwardOrderId
FWD1
FWD2
FWD3
ChannelParentOrderId
FWD
FWD2
FWD
ChannelReturnOrderId
RET1
RET2
RET3
ChannelReturnLineItemId
CL-INT01
CL-INT02
CL-INT03
ChannelReturnType
CR
RTO
CR
ChannelReason
Size Issue
Wrong Product
Delayed Delivery
ChannelTrackingId
AWB-1
AWB-2
AWB-3
ChannelTransporter
DHL
FEDEX
SHIP ROCKET
ChannelQuantity
2
1
3
ProductBarcode
EAN1
EAN2
EAN3
Attr1
1500
2000
900
Attr2
1300
1800
700
Attr3
900
1200
600
Attr4
RT1
RT2
RT3
Attr5
A5
–
A5
Attr6
A6
–
A6
Attr7
A7
–
A7
ItemAttr1
ItA1
–
ItA1
ItemAttr2
ItA2
–
ItA2
ItemAttr3
ItA3
–
ItA3
ItemAttr4
ItA4
–
ItA4
Upload Master
Upload 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 Header
Row Entry1
Row Entry2
PRODUCT_ BARCODE
EAN234567
EAN123456
COLOR
RED
BLUE
BRAND
DEMO-BRAND
DEMO-BRAND
SUB_BRAND
DEMO-SUB-BRAND
DEMO-SUB-BRAND
STYLE_ID
STYLE1
STYLE2
SIZE
XL
34
MRP
1299
2799
ATTRIBUTE1
Summer Seasoned
Fall Winter Collection
ATTRIBUTE2
SLIM FIT
REGULAR FIT
ATTRIBUTE3
V NECK
DENIM WASH
ATTRIBUTE4
PARTY WEAR
RUGGED
ATTRIBUTE5
HALF SLEEVES
ANKLE LENGTH
IMAGE_URL
https://rj.increff.com/demo/imagesset/STYLE1.JPG
https://rj.increff.com/demo/imagesset/STYLE2.JPG
Upload Processed Item
Upload 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