Platform E-Commerce Product Sales Quantity and Profit Report

Shows, for a date range, how many of each online-store product were sold on each platform, for how much and with how much profit.

Menu: Reports › Product Reports › Platform E-Commerce Product Sales Quantity and Profit Report

Required permission

Reports › Platform E-Commerce Product Sales Quantity and Profit Report › View

What it's for

Use it if you sell through a connected online store (for example Shopee or Lazada) to see which listings sell and which are profitable after cost. Each row is a platform listing linked to a CIRMS product.

Example

The e-commerce team runs it for last month: the listing Wireless Mouse – Black sold 180 on Shopee at an average of 399.00 with 31% profit, while the same product on Lazada sold 20. They move ad spending to Shopee.

Options on the screen

• From / To: the period.
• The platforms and branches to include.

Filters

Click Filters to narrow the report. You can filter by:

Platform Product Name, Platform SKU, Platform Variation ID, Platform Product Status, Platform Product ID, E-Commerce API, Stock No., Unit Barcode, Name, Chinese Name, Status, Supplier, Category Tag, Parent Category, Category, Brand, Date Created, Deleted, Last PI Date.

Columns

Column	What it shows
Platform	The online store platform.
E-Commerce API	Your connection to that store.
Platform Product ID	The listing's ID on the platform.
Platform Variation ID	The variation's ID (size, colour…) on the platform.
Platform Product Status	The listing's status on the platform.
CIRMS Product Stock No.	The linked CIRMS product's stock number.
Parent Category	The category one level above the product's category.
Supplier	The product's default supplier.
Status	The product's status: Active, Inactive or Discontinued.
Current Product Cost	The product's purchase price today (not at the time of sale).
Current Wholesale Price	The product's wholesale price today.
Current Retail Price	The product's retail price today.
Qty	Quantity on the line.
Total Cost	Quantity × cost.
Total Amount	Total sales or transaction amount.
Total Profit	Total amount minus total cost.
Total Profit Percentage	Total profit as a percentage of the total amount.
Avg Cost	Total cost ÷ quantity.
Avg Price	Total amount ÷ quantity.
Avg Profit	Total profit ÷ quantity.
Inventory	Current stock, in the product's default unit.
Last PI Date	Date of the last purchase inbound of the product.
Last PI Qty	Quantity of the last purchase inbound.

Also shows: Branch, Platform SKU, Platform Product Name, Platform Product Price, CIRMS Product Barcode, CIRMS Product Name, Chinese Name, Description, Category, Brand, Date Created.

For searching, express filters, sorting, column settings, exporting and printing, see About reports.