Page Comparison

ConsignmentNo

Y

Varchar

Order consignment number

OrderNumber

Y

Varchar

Order number

Sku

Y

Varchar

Product sku code

EAN

Y

Varchar

Product sku code

Reason

Y

Varchar

Product return reason

ReturnAction

Y

Varchar

Return Action e.g. REFUND, CREDIT NOTE, CREDIT NOTE PLUS

CommodityInfo

Y

VarcharProduct info

HS Code used for customs clearance

ItemWeight

Y

Float

Item weight

OrderWeight

If Item weight is available, then not mandatory.

Float

Order weight

ItemDescription

Y

Varchar

Item description

ItemValue

Y

Varchar

Product price

CustomerName

Y

Varchar

Customer name

CustomerEmail

Y

Varchar

Customer email

RMA

Y

Varchar

RMA number

CHTComment

N

Varchar

CHT comment on return. Customer Service comment if any.

SubRetailer

N

Text

Name of the Subretailer if any. For example, there will be main retailer setup and under which other sub retailers will be added.

Building

N

Varchar

Sub Retailer’s Building name

Street

N

Varchar

Sub Retailer’s Street name

Suburb

N

Varchar

Sub Retailer’s Suburb/City name

State

N

Varchar

Sub Retailer’s State name

PostCode

N

Varchar

Sub Retailer’s PostCode name

Country

N

Varchar

Sub Retailer’s Country name. Format should be like Australia-AU, New Zealand- NZ, United Kingdom-UK, United States-US, Canada-CA