For the custom product report at admin/store/reports/products/custom I can choose a start date and end date, how would I go about adding the option to choose a starting order number and ending order number?

Even the SQL query that I need would be a great help.

Comments

TR’s picture

TR CreditAttribution: TR commented
Status: Active » Fixed

The built-in Ubercart reports are not really customizable like that. You can look into uc_reports.module if you want to see how reports queries are constructed.

The best solution, if you want control over the reports, is to use Views to generate your reports. Eventually the uc_reports module will be replaced by Views. See #568854: Replace uc_reports with Views - perhaps you can help with this ...

Problue Solutions’s picture

Problue Solutions
Location Northern Ireland
CreditAttribution: Problue Solutions commented

Unfortunately I spent quite a while trying to do this with views but it just wasn't possible to create the product sales report in the same way its done in uc_reports.

I decided to just connect directly to the Drupal database tables using Crystal Reports and was able to create the report i needed within 5 minutes. My client just has to run a small program called datalink viewer on their local machine but its much quicker and much more powerful than any web based reports.

Status: Fixed » Closed (fixed)

Automatically closed - issue fixed for 2 weeks with no activity.