First you need to download the CSV File from Profitario. To do So go to Reports -> AliExpress and select teh timeframe you want to download on the top right of the page. (https://app.profitario.com/reports/aliexpress)

Next click on 'Download CSV'

Once the download has finished follow this guide to get the csv download into format you can use to make you on calculations.

Edit CSV File using Microsoft Excel

Once you have finished the import continue bellow

Remove Duplicates

You might have noticed thatz there are mutliple lines for orders that include multiple different products. So every line does not represent an order but rather an order item.

If we want to calculate the total of all payments we have to first remove the duplicate souce_order_id from the file.

  1. Click on the column A label.

  2. Select Data in the menu bar.

  3. Click on Remove Duplicates

  4. Select 'Expand the collection'

  5. Click 'Remove Duplicates'

An new window will open where you have to select which rows have to be used to filter for the unique value.

  1. Click on Unselect All

  2. Select Column A ( or the column that contains the aliexpress order if you did make changes to the file)

  3. Click OK

You file will now only contain individual orders and not all order items.

It is now possible to calcualte the sum of all your payments.

To do that you first need to find the column 'payment_total_target'. This column contains the total payment converted to you target currency.

You now have to caluclate the sum by using the follwing formular.

=SUM(AC2:AC100)

You have to replace AC100 by the last cell of you sheet

Filter by order state

To filter by order state you have to add a filter to you sheet.

  1. Click on the triangle in the top right of your excel sheet

  2. Click on Home in the menu bar

  3. Click on Sort&Filter

  4. Select Filter

Every column header will now show a little triangle indicating this cxolumn ahs a filter.

Click on the triangle in the orderstatus column.

A menu will open where you have the option to select the orderstatus you want to filter for.

Did this answer your question?