Anchanto Support

Submit a ticket My Tickets
Welcome
Login

OMS: Sales Report

How to generate the report:

Login into your SelluSeller account -> Go to Reports tab from the Left Pane -> Click on Generate Reports -> Click on New Report -> on the pop-up, select the Report Type -> Select whether you wish to generate the report as per the Order Date or In Transit Date and select the date range -> Click on Generate Report to start generating the report.






Header Details and Definitions:


Sales Tab:

 

HeaderDefinition
DateDate for which data is shown
Marketplace NameMarketplace which had status connected on that date
Data shown under MPTotal price of goods sold for that MP (Price based on forex rates at time of order received


Order List Tab:


 

HeaderDefinitionCalculations
Order created dateDate on which order was placed
Order numberOrder number
MarketplaceOrder Marketplace
Marketplace short nameSMP name
Unique productsNumber of different products in order
Total UnitsTotal number of units in an order
Shipping feeShipping and handling cost
Tip

Order total valueTotal Order AmountSub Total + Shipping Cost + Tip + Tax
Total Price paidPrice Paid by CustomerOrder total value - Total Channel Discount - Shipping Cost
Total channel discountDiscount offered
Order CurrencyMarketplace Currency
Payment methodMode of Payment
Order type

Fulfilled by marketplaceOrder delivery will be processed by Marketplace or no
Shipping carrierDelivery Carrier linked to the order
Tracking numberTracking Number assigned to order once dispatched
StatusCurrent Order Status
Order completion dateDate when the order is Completed/Delivered
Customer first nameDetails filled by customer at the time of order placement
Customer last nameDetails filled by customer at the time of order placement
AddressDetails filled by customer at the time of order placement
Address 2Details filled by customer at the time of order placement
Address 3Details filled by customer at the time of order placement
SuburbDetails filled by customer at the time of order placement
CityDetails filled by customer at the time of order placement
ZipcodeDetails filled by customer at the time of order placement
StateDetails filled by customer at the time of order placement
CountryDetails filled by customer at the time of order placement
Email IDDetails filled by customer at the time of order placement
Contact numberDetails filled by customer at the time of order placement
Alternate contact numberDetails filled by customer at the time of order placement
Special instructionsDetails filled by customer at the time of order placement



Order Details Tab:


 

HeaderDefinitionCalculations
Order Created DateDate on which order was placed
Order NumberOrder number
Suborder Number (Item ID)Shipment ID
MarketplaceOrder Marketplace
Marketplace Short NameSMP name
Product NameName of the product
Channel SKUCSKU
Inventory SKUISKU
UPCUnique Product Code
Product TypeType of the Product (Product/Group/Kit)
Product CategoryProduct category the SKU is listed on marketplace
BrandProduct Brand
QuantityQuantity purchased
SelluSeller Retail PriceRetail price of the product on OMS
SelluSeller Selling PricePrice set as selling price on OMS
Discount (Retail Price - Selling Price)Discount Offered Retail price - Selling Price
Channel Selling PriceProduct Price on MP
Price PaidPrice Paid by Customer
Channel Vouchers(Discount)Discount offered by Marketplace
Seller Vouchers(Discount)Discount offered by Seller
Wallet AmountAmount if payment is done using the marketplace wallet
Voucher CodeVoucher number applied for the discount
Order CurrencyMarketplace Currenccy
Retail Price in Base Currency (INR)Retails Price as per the rate conversion in Base amount set in OMS account
Selling Price in Base Currency (INR)Selling Price as per the rate conversion in Base amount set in OMS account
Discount in INR (Retail Price - Selling Price)Discount applied as per the rate conversion in Base amount set in OMS accountRetail price - Selling Price
StatusCurrent Order Status
Order Completion DateDate on which order was completed/delivered
Shipping TypeWhether the shipment is standard or express or any other
Shipping CarrierTracking Number assigned to order once dispatched
Tracking NoTracking Number assigned to order once dispatched
Fulfilment By MarketplaceOrder delivery will be processed by Marketplace or no
Shipping FeeShipping and handling cost
Tip

Shipping Business NameName of Carrier assigned for Delivery
Customer First NameDetails filled by customer at the time of order placement
 Customer Last NameDetails filled by customer at the time of order placement
 Address 1Details filled by customer at the time of order placement
 Address 2Details filled by customer at the time of order placement
Address 3Details filled by customer at the time of order placement
SuburbDetails filled by customer at the time of order placement
CityDetails filled by customer at the time of order placement
ZipcodeDetails filled by customer at the time of order placement
StateDetails filled by customer at the time of order placement
CountryDetails filled by customer at the time of order placement
What3Words

 Email IdDetails filled by customer at the time of order placement
 Contact NumberDetails filled by customer at the time of order placement
Alternate Contact NumberDetails filled by customer at the time of order placement
Special InstructionsDetails filled by customer at the time of order placement
SAP Invoice No.Invoice number in SAP 
SRP

Rebate

Store Voucher

Coins

Payment OptionMethod of Payment
Platform Order StatusOrder Status on Marketplace
Billing Business NameDetails filled by customer at the time of order placement
Billing NameDetails filled by customer at the time of order placement
Billing Contact NoDetails filled by customer at the time of order placement
Billing Address 1Details filled by customer at the time of order placement
Billing Address 2Details filled by customer at the time of order placement
Billing Address 3Details filled by customer at the time of order placement
Billing SuburbDetails filled by customer at the time of order placement
Billing CityDetails filled by customer at the time of order placement
Billing PostCodeDetails filled by customer at the time of order placement
Billing What3WordsDetails filled by customer at the time of order placement
TaxID NumberDetails filled by customer at the time of order placement
In-transit DateDetails filled by customer at the time of order placement
Shipping Tax IDDetails filled by customer at the time of order placement
Shipping Tax TypeDetails filled by customer at the time of order placement
Billing Tax IDDetails filled by customer at the time of order placement
Billing Tax TypeDetails filled by customer at the time of order placement
Warehouse NameWarehouse through which the order fulfilment will be processed
Shipment State

Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.