Sorry for all the individual questions, I have done searches in the forms looking for answers before asking all of these but did not find the answers. Here are a couple of database questions.
This is regarding the database output when involving discounts. There is a “Price” column of data that displays the actual price paid by the purchaser. This can be misleading as the actual price before discount is different then the amount after discount. Is it possible to have two columns of data, one being price of event, and the other being the amount discounted or the amount after discount?
Also the database doesn’t show the difference between the “cost” before surcharge and the “surcharge” amount as filled in within the event. Shouldn’t the database output both of these pieces of information?
Payment Method column – This column of data doesn’t seem to populate. What is it for?
I might be looking at a different screen because I’m not seeing what you’re seeing, so I’ll post a screenshot with a few notes below that outlines what is available to display on the Attendee Reports screen.
Note that price is not displayed, but the Price Option is displayed by default. The Payment column shows a green check if the payment was complete, a yellow triangle +! if it’s Pending, and a red circle +! if it’s incomplete.
The Type column will display messages like “Added by Admin”, “Check” if pay by check was selected, or the name of the gateway if the payment was made online.
The Coupon column does not display by default, but it can be toggled to display by clicking “Filter: Show/Hide Columns” and checking the box labeled “Coupon”.
Additional columns can not be added without custom development.
Hope that helps!
Viewing 1 reply thread
The support post ‘Database Information Output’ 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.