File Formats | Increff Docs

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

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

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

Table sample format

QC_LINE_ITEM_ID
10001
11040
11002

How can we help?