Business intelligence or reporting is needed for all businesses – small, medium and large. Traditionally, large businesses have an IT department who run specialized database queries to produce reports. Now trends have changed and business whether small, medium or large want  answers to their questions from a wide variety of sources instantly.

Zen Cart and osCommerce users can now run sophisticated reports with Apsona ShopAdmin. Reports which can enable them to focus on targeting their customers with sharp, focused marketing messages. Some reports they can run are:

• Where do customers live by zip/area codes, city, state and country
• When did they last buy
• Who are the power buyers (repeat customers who also refer other new customers)
• Identify the top fifty customers
• What have customers last bought
• Identify the top 5 best selling products
• Weekly, monthly and quarterly sales
• Classify customer interests based on the purchases they made
• What times of the year do they buy
• Orders by region

With ShopAdmin, you can create reports such as those above with no effort. Get creative and run reports with the simple drag-and-drop interface provided in ShopAdmin. Include any fields you want, from any of your data records. Visualize data in graphs, matrices and charts and even publish reports on the web. Set up and customize the dashboard with any of the created reports from all tables.

ShopAdmin reports do much more than just pretty graphics, however. Quite frequently, you would want to extract a specific piece of the data in your shopping cart for operational use. For example, you might want to list the names, email addresses and products bought by all those customers who visited your store during last year’s Christmas season, so that you can send them a custom promotional email. With ShopAdmin, you can create exactly this report, run it a few times to make sure it has what you need, and then export its results in CSV format for use with your favorite mailing program.

With a  free Apsona ShopAdmin account,  Zen Cart and osCommerce users now have the power to analyze their eCommerce data in some very interesting and exciting ways.

Sign up for a free ShopAdmin account and see for yourself.

Apsona ShopAdmin has a powerful search feature. The application makes heavy use of JavaScript and dynamic HTML in the browser, leveraging the latest AJAX technologies to full effect. Whether it is a simple search or a multiple criteria search, results are obtained instantly. A simple search can be for example, a search for all your Customers with the last name beginning with S. To get this data set all you have to do is click on the arrow next to Search box.

A few fields from the table drop down. Check the field Last name and enter S in the search box. Click the lens icon or hit enter. Instantly you will see all your customers with the last name beginning with S.

Quickly find data records of your orders, customers,  products, product attributes or  manufacturers by multiple criteria. For example you can get data of all the order totals (Order table), of all orders which have been delivered (status – Order table) for customers whose last name (customer table) begins with S living in the state (customer table)of California. To get this data set click the arrow next to Search and select  More options. A filter editor opens up from where you can add terms for the search. Select Last name and State from the customer table as fields from the Customer table and Status and order total as fields from the Order table. Choose the relevant filter criteria for each term and click  Search. Results show up instantly. This data can be saved as a filter(with an appropriate name) and can be invoked any time in the future when required.

Try out Apsona Shop Admin’s Search & filtering. As one of our users said – Incredible and easy. Get your free account from apsona.com.