osCommerce reports

It's important to stay up to date with the overall performance of the business. In osCommerce Reports section allows a store owner to view information about customers' behavior on the website.

All reports in Store Manager for osCommerce can be customized, you can change report layout, insert pictures (logos), add and remove fields etc. Every report consists of two major parts:

• Report template
• Report queries

Report templates stored in .fr3 files they contain report layout information. Report queries stored in .sql files, they contain SQL queries to retrieve data required for osCommerce report.

You can find report files under "Application Data" directory shortcut:
Start -> All Programs -> MagneticOne -> Store Manager for ... -> Application Data.

Report section helps by automatically calculating hourly, daily, weekly, monthly and yearly data for your store.

Program has two types of reports:

1. Default reports
2. Custom reports

These two types are almost identical, the only difference is that custom reports can be modified within osCommerce Store Manager, you can add new custom reports or remove existing, whereas default reports should be modified with external program called Report Tool (rptviewer). You can find osCommerce Report tool in application program group along with other program shortcuts:

To edit one of report templates run Report Tool and open appropriate file.  Default report templates are stored in Start -> All Programs -> MagneticOne -> Store Manager for ... -> Application Data -> Reports, English sub-directory in .fr3 files.

Remember that every report besides of its template needs some data to be displayed. To customize data for an osCommerce report you have to modify its .sql files. SQL files are stored in Reports\SQL sub-folder.

Download User's Manual to learn more about editing reports.

By each report name you can identify its purpose and information it contains. Comparing reports' data allows you to see if you need to make any changes in pricing or description.

For some reports you need to specify the report dates before the report is generated.

Once you open the report, the following options are available: print, save, see the report outline, thumbnails, choose page settings and edit page (report).

There are also numerous export options available. You can save current report as an image file, PDF file or a table and open it later using some application. This can be a big help when it comes time to fill out your tax report, since you can import it directly into an Excel spreadsheet.

There are many ways to customize a specific Report. Just go to Edit page by clicking corresponding icon. There you'll see "Designer's" toolbar, “Standard” toolbar, “Text” toolbar, “Frame” toolbar, “Align” toolbar. Download User's Manual to get a complete description of this page.

If you have any suggestions on osCommerce Reports, you're welcome to our support team.