|
pcogsadministrator
|
August 19, 2019 at 8:25 am
Hello,
I am using the Price Modifier Plugin with Event Espresso. My client is looking for an easy way to have a report that shows only the charges for items captured by this plugin.
When I use the Excel CSV export option the total amount shows these charges lumped in with the registration costs. I thought about making a simple formula to minus the registration cost from the total paid to give me the balance, which would be the modifier costs. The problem is each attendee has a guest so items are broken out over multiple lines.
What would be the best/easiest way for them to see this information?
https://snipboard.io/a0zxdO.jpg
Thank you!
|
|
Tony
|
August 20, 2019 at 6:49 am
Hi there,
It’s been a while since I had a look at the Price Modifier add-on by Aparna which I assume is what you are referring to above.
Is the value of the selected modifier not already included in the CSV?
|
|
pcogsadministrator
|
August 20, 2019 at 7:14 am
No it is not.
|
|
Tony
|
August 20, 2019 at 9:55 am
Ok, so what is in included in the CSV?
In fact, do you have a copy of the add-on I can take a look at? I can contact Aparna and ask for one but it will likely be quicker if you can upload the .zip file for me to take a look.
|
|
pcogsadministrator
|
August 21, 2019 at 7:43 am
This reply has been marked as private.
|
|
Tony
|
August 26, 2019 at 2:01 pm
After my reply above, I found an older copy of the Price Modifier Add-on I had on one of my test sites and figured a way to replace the values in the CSV (which in my copy show the price modifier ID rather than the description) with the price options selected, so that snippet is what I came up with.
Rather than passing that straight onto you I sent it to Aparna to see if it (or something similar) may be included in the add-on itself. The reasons I did that is it is less complicated further down the line if the add-on does the functionality rather than a snippet, if the add-on is updated to do something similar it can conflict… but anyway, just a quick explanation as to where the above snippet come from.
I believe I added the php code correctly in the functions page, but I did not see any difference when I exported the CSV.
Where exactly have you placed the code in that snippet? The theme’s functions.php file?
If so that may not be loading on the request for the CSV’s, the best place to place snippets of code is into a custom functions plugin and we have documentation on creating one here:
https://eventespresso.com/wiki/create-site-specific-plugin-wordpress-site/
A quick explanation of that snippet is that it will replace the CSV value so it no longer shows, as an example from your CSV, in column AE, {date}, {date}, {date} but 10, 20, 10 (if the values for modifiers selected where 10, 20, 10 obviously).
**Note, there is a breakout near the bottom rows…
My apologies, I guess I’m missing something obvious here but I don’t follow this, what am I looking at in the CSV?
|
|
pcogsadministrator
|
August 27, 2019 at 7:19 am
I had placed it in the theme functions, so yes that was part of the issue. After reading your explanation of the snippet though, I’m not sure that is what I need. I was looking for a way to have the price of the addon item exported to the CSV.
For example, if the addon item was $55 in addition to the registration fee, then the csv export would break out that $55 in a column separately.
|
|
Tony
|
August 27, 2019 at 7:31 am
That’s exactly what my snippet should do.
If they have selected a value for a modifier it will show the value, if they selected multiple values for a single modifier they will be separated with ‘, ‘.
|
