-
Notifications
You must be signed in to change notification settings - Fork 4
Frequently Asked Questions
That happens when the data is too big for the current column width. Just widen the column and the data will "automagically" appear. Now be thankful you didn't post that question in the forums. ;)
The CSV export option is designed to move Zen Cart sales data into another system. In order to import from a CSV file, the importing program must know what format the data will be in, and that format must remain consistent. The timeframe total line breaks the data's consistency and therefore it is not displayed. If you want timeframe lines, run the same report again in CSV export mode, choosing just the timeframe totals.
The rationale is the same as that provided in the previous answer. It's assumed that you're importing to a program that has some ability to perform math calculations. Your dollar/pound/yen symbol would likely prevent that program from reading the value properly.
As one look at the class file will tell you, Sales Report II is not merely reporting back data stored in the database; it runs calculations, sometimes very complicated ones.
I've already optimized the number of database queries as much as I can without sacrificing data (maximum of 6 in "Timeframe Statistics" display).
You might have to resort to adjusting your search settings. Break your report into several smaller runs, or limit the returned data to the timeframe total lines (i.e. drop order or product line items). The "Timeframe Statistics" option is the most complicated report, pulling all the data for both product and order line items, then running additional calculations on all of it. I strongly recommend against running it for more than a month's worth of data at a time; you **can **bring your server to its knees by doing so, no matter how awesome it is.
Report performance will also depend heavily on the power of your server. If you bought that shared hosting package because it cost $5/month, don't expect to get any processor priority. Remember, you get what you pay for.
Finally, you may have to just accept the lag and wait for the report. In this case, be sure to ramp up the timeout period on your browser, to ensure the report can complete and return the results.
Starting with v4.0.2 of the report, there's now a definition within the report's language file to enable this data to display: DISPLAY_COUNTRY_AND_STATE. Your site can override the setting's default ((bool)false) to enable that display via the creation of a .php file present in the admin's /includes/extra_datafiles subdirectory; that file should contain:
define('DISPLAY_COUNTRY_AND_STATE', true); //- Enable Sales Report II to display the country/state columnsNote that the country and state fields are displayed only when the Displayed Information is selected as + Order Line Items.