Jump to content

Query and extraction of data from DB using OpenOffice Base


Recommended Posts

I have used Prestashop for a month or two now and in the process of setting up / configuring my store, I realized that I need to extract and export certain data for further processing, such as accounting and stock-taking. I also found that there is a serious lack of such modules around.

However when I worked with OpenOffice to create and import csv files, I saw that OpenOffice has a database program called Base. Will Base be able to to linked with Prestashop's DB, execute queries, extract and export these for further processing purposes? If so, I can use Base for orders processing and accounting every day, as well as daily/monthly sales and inventory reports.

Has anyone attempted to link Base with DB and done orders query and export before?

Link to comment
Share on other sites

×
×
  • Create New...