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:
| Header | Definition |
| Date | Date for which data is shown |
| Marketplace Name | Marketplace which had status connected on that date |
| Data shown under MP | Total price of goods sold for that MP (Price based on forex rates at time of order received |
Order List Tab:
| Header | Definition | Calculations |
| Order created date | Date on which order was placed | |
| Order number | Order number | |
| Marketplace | Order Marketplace | |
| Marketplace short name | SMP name | |
| Unique products | Number of different products in order | |
| Total Units | Total number of units in an order | |
| Shipping fee | Shipping and handling cost | |
| Tip | ||
| Order total value | Total Order Amount | Sub Total + Shipping Cost + Tip + Tax |
| Total Price paid | Price Paid by Customer | Order total value - Total Channel Discount - Shipping Cost |
| Total channel discount | Discount offered | |
| Order Currency | Marketplace Currency | |
| Payment method | Mode of Payment | |
| Order type | ||
| Fulfilled by marketplace | Order delivery will be processed by Marketplace or no | |
| Shipping carrier | Delivery Carrier linked to the order | |
| Tracking number | Tracking Number assigned to order once dispatched | |
| Status | Current Order Status | |
| Order completion date | Date when the order is Completed/Delivered | |
| Customer first name | Details filled by customer at the time of order placement | |
| Customer last name | Details filled by customer at the time of order placement | |
| Address | Details filled by customer at the time of order placement | |
| Address 2 | Details filled by customer at the time of order placement | |
| Address 3 | Details filled by customer at the time of order placement | |
| Suburb | Details filled by customer at the time of order placement | |
| City | Details filled by customer at the time of order placement | |
| Zipcode | Details filled by customer at the time of order placement | |
| State | Details filled by customer at the time of order placement | |
| Country | Details filled by customer at the time of order placement | |
| Email ID | Details filled by customer at the time of order placement | |
| Contact number | Details filled by customer at the time of order placement | |
| Alternate contact number | Details filled by customer at the time of order placement | |
| Special instructions | Details filled by customer at the time of order placement |
Order Details Tab:
| Header | Definition | Calculations |
| Order Created Date | Date on which order was placed | |
| Order Number | Order number | |
| Suborder Number (Item ID) | Shipment ID | |
| Marketplace | Order Marketplace | |
| Marketplace Short Name | SMP name | |
| Product Name | Name of the product | |
| Channel SKU | CSKU | |
| Inventory SKU | ISKU | |
| UPC | Unique Product Code | |
| Product Type | Type of the Product (Product/Group/Kit) | |
| Product Category | Product category the SKU is listed on marketplace | |
| Brand | Product Brand | |
| Quantity | Quantity purchased | |
| SelluSeller Retail Price | Retail price of the product on OMS | |
| SelluSeller Selling Price | Price set as selling price on OMS | |
| Discount (Retail Price - Selling Price) | Discount Offered | Retail price - Selling Price |
| Channel Selling Price | Product Price on MP | |
| Price Paid | Price Paid by Customer | |
| Channel Vouchers(Discount) | Discount offered by Marketplace | |
| Seller Vouchers(Discount) | Discount offered by Seller | |
| Wallet Amount | Amount if payment is done using the marketplace wallet | |
| Voucher Code | Voucher number applied for the discount | |
| Order Currency | Marketplace 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 account | Retail price - Selling Price |
| Status | Current Order Status | |
| Order Completion Date | Date on which order was completed/delivered | |
| Shipping Type | Whether the shipment is standard or express or any other | |
| Shipping Carrier | Tracking Number assigned to order once dispatched | |
| Tracking No | Tracking Number assigned to order once dispatched | |
| Fulfilment By Marketplace | Order delivery will be processed by Marketplace or no | |
| Shipping Fee | Shipping and handling cost | |
| Tip | ||
| Shipping Business Name | Name of Carrier assigned for Delivery | |
| Customer First Name | Details filled by customer at the time of order placement | |
| Customer Last Name | Details filled by customer at the time of order placement | |
| Address 1 | Details filled by customer at the time of order placement | |
| Address 2 | Details filled by customer at the time of order placement | |
| Address 3 | Details filled by customer at the time of order placement | |
| Suburb | Details filled by customer at the time of order placement | |
| City | Details filled by customer at the time of order placement | |
| Zipcode | Details filled by customer at the time of order placement | |
| State | Details filled by customer at the time of order placement | |
| Country | Details filled by customer at the time of order placement | |
| What3Words | ||
| Email Id | Details filled by customer at the time of order placement | |
| Contact Number | Details filled by customer at the time of order placement | |
| Alternate Contact Number | Details filled by customer at the time of order placement | |
| Special Instructions | Details filled by customer at the time of order placement | |
| SAP Invoice No. | Invoice number in SAP | |
| SRP | ||
| Rebate | ||
| Store Voucher | ||
| Coins | ||
| Payment Option | Method of Payment | |
| Platform Order Status | Order Status on Marketplace | |
| Billing Business Name | Details filled by customer at the time of order placement | |
| Billing Name | Details filled by customer at the time of order placement | |
| Billing Contact No | Details filled by customer at the time of order placement | |
| Billing Address 1 | Details filled by customer at the time of order placement | |
| Billing Address 2 | Details filled by customer at the time of order placement | |
| Billing Address 3 | Details filled by customer at the time of order placement | |
| Billing Suburb | Details filled by customer at the time of order placement | |
| Billing City | Details filled by customer at the time of order placement | |
| Billing PostCode | Details filled by customer at the time of order placement | |
| Billing What3Words | Details filled by customer at the time of order placement | |
| TaxID Number | Details filled by customer at the time of order placement | |
| In-transit Date | Details filled by customer at the time of order placement | |
| Shipping Tax ID | Details filled by customer at the time of order placement | |
| Shipping Tax Type | Details filled by customer at the time of order placement | |
| Billing Tax ID | Details filled by customer at the time of order placement | |
| Billing Tax Type | Details filled by customer at the time of order placement | |
| Warehouse Name | Warehouse through which the order fulfilment will be processed | |
| Shipment State |
Comments
0 comments
Please sign in to leave a comment.