Reporting on "Volume Pricing" Price Group

[afiumano]

I am trying to run a report to see all orders that used a "Volume Pricing" Price Group that was setup for some specific products. It is available to "All Customers" so I am unable to find a way to run a report for it.

[Bruce - PhosphorMedia]

by report, what feature are you using?

[afiumano]

I was simply in "Reports" in admin. I tried several 'types' of reports: I think Customer Sales Report and Product Sales Report, but the only way I see to filter by Price Group is where is says "Customers in Price Group" and you select a price group. Since we have no customers assigned to it this doesn't work of course.

[afiumano]

If this isn't available in "Reports" section, is it possible to do with a "Batch Report" or something?

[Brennan]

Yes a batch report would work here but its going to require code template code to get what you want. Here are the high level steps
1. Create a new Order Batch Report
2. The volume pricing discount will show in the following array:

<mvt:foreach iterator="discount" array="item:discounts">

</mvt:foreach>

Here you can test for the name of the price group and if it is present set a flag to use later to output the order to the page or include it in the report.

[afiumano]

Brennan I am not able to figure out how to test for the name of the price group. I have been trying to use:
<mvt:do file="g.Module_Feature_PGR_DB" name="l.ok" value="PriceGroup_Load_Name( 'Corporate Volume Pricing 20%', l.price_group )" />
I found this but it doesn't seem to be what I need: https://docs.miva.com/developer/addi...ed-to-product/