I want some one write a program or use any existing module to do the following:
a. Extract the main attribute (If possible all the fields /tables etc ) from oscommerce data and feed to a Visual Basic program
b. Write a simple VB program to to accept the above data and generate some simple query like:
1. Total # sale by month by product
2. Most bought product
3. Most bought product by region by customer etc
If you are going to use any existing data export module weather it is open source or not, I will need to know ahead of time.
Also the vb program should be able to export certain customer fields to csv format. I will tell you what those fields will be..
I however don't want the export to extract ant payment info like cc etc.
If you suggest any other way of the same functionality or any program that can already do what I need, please suggest and I will accept it too.