Support

Home Forums Event Espresso Premium Tracking total sales

Tracking total sales

Posted: March 23, 2017 at 5:25 am


Oguzhan Altun

March 23, 2017 at 5:25 am

Hello,

I used to depend on the registrations CSV report – Amount Paid column – to track my total sales. As we are closing 2016, there was a quite big gap vs what my accounting told me. When I checked, I found out that all the registrations that have been moved to another event using the EE4 attendee mover had amount paid repeated.

So when I look at user A originally registered to Event 1 and paid $100, then moved to Event 2: I see $100 in the Amount Paid column in both lines in the CSV report. Transaction status is also “complete” in all lines. So the report makes it look like the user paid multiple times for the same registration.

I also looked at REG_final_price column, which handles this case correctly, but then the pending payment registrations are reported there.

So my question is how do I report the actual total sales?

Also is this a bug with how the Attendee mover works? I don’t understand why it duplicates transactions while only the registration is moving.


Josh

  • Support Staff

March 24, 2017 at 12:15 pm

Hi Oguzhan,

I checked and the Attendee mover does not actually duplicate transactions. Are you looking at the registrations instead? There should be an original, cancelled registration and also a new registration for the moved attendee. You can use the “Registration’s share of the transaction total[REG_final_price]” to get an accurate total. The other columns shouldn’t really be used for getting total amounts of money via the registrations CSV.


Oguzhan Altun

March 25, 2017 at 11:55 am

Hello Josh,

The [REG_final_price] column gives the correct result in this case, however that one has a major flaw: It also includes those who selected “payment by bank transfer” but did not pay at the end…. This is why I have been using the “Amount Paid” column.


Josh

  • Support Staff

March 27, 2017 at 2:27 pm

I get that you don’t like that it reports an amount there if they didn’t pay, but it’s not a flaw that it reports an amount there. When you track total sales with the registrations report, regardless of the column you’re looking at, you’ll need to factor in the Registration Status column. So for example if the column values have “Cancelled” or “Pending Payment”, then those rows shouldn’t be counted as sales.

The support post ‘Tracking total sales’ is closed to new replies.

Have a question about this support post? Create a new support post in our support forums and include a link to this existing support post so we can help you.

Support forum for Event Espresso 3 and Event Espresso 4.
Documentation for EE3 and EE4
Documentation for Event Espresso 3

Documentation for Event Espresso 4

Status: closed

Updated by  Josh 2 years, 7 months ago ago

Topic Tags

Notifications

This topic is: not resolved
Do NOT follow this link or you will be banned from the site!
[for="input_96_5_3"]
[for="input_96_5_3"]
[gravityform id=96 title=false description=false]
  • This field is for validation purposes and should be left unchanged.
[i]
[i]
[gravityform id=69 title=false description=false]
  • This field is for validation purposes and should be left unchanged.