Orders Export from the System

In order to export orders from the system, you need to go to the «Orders» menu item, select a ready-made order segment or create a new one according to a set of conditions, and then export via the «Actions» button.

A new page will open with the conditions of the selected segment and the «Run» button, which you must click on.

The file will be saved to your device.

A .CSV file with UTF-8 encoding is exported.

You can work with the file using OpenOffice, you can also use Google Docs and other analogues of programs for working with spreadsheet documents.

More on this: «How to work with .CSV files?»

When exporting orders, the following fields and their values are exported:

1. Order ID
   

2. Order number
   

3. User

4. Email

5. Phone

6. Date of creation

7. Date of payment

8. Title (name of the purchased offer)

9. Status

10. Price

11. Paid

12. Payment system fee

13. Received

14. Tax

15. Left after deduction of payment system fee and tax

16. Other fees

17. Currency
    

18. Earned

19. Manager

20. City

21. Payment system

22. Order partner ID

23. Order partner email

24. Order partner full name

25. User partner ID

26. User partner email

27. User partner full name

28. utm_source (order source fields)

29. utm_medium

30. utm_campaign

31. utm_content

32. utm_term

33. utm_group

34. Affiliate source

35. Affiliate code

36. Partner (session)

37. user_utm_source (user source fields)

38. user_utm_medium

39. user_utm_campaign

40. user_utm_content

41. user_utm_term

42. user_utm_group

43. user_gcpc

44. All additional order fields

45. Order tags (they will be listed in the exported file using the «|» symbol as a separator)

46. Offer tags included in the order (listed using the «|» symbol as a separator)