How can I download what stock I have onto any Excel spreadsheet so that I can do a stock take?
My programmer used to do it for me but I can't get hold of him anymore
Thanks :)
How can I download what stock I have onto any Excel spreadsheet so that I can do a stock take?
My programmer used to do it for me but I can't get hold of him anymore
Thanks :)
The easiest way for me was to use easypopulate. You can find it at, http://www.easyshopmaker.com/.
But you need some knowledge of excel.
JP
I'm going to suggest you become familiar with phpMyAdmin.
I'm pretty sure you can download a CSV backup of any table you want.
Of course, as long as you don't have commas embedded in your data, you should be able to import any CSV to an EXCEL spreadsheet.
If you know SQL, you should be able to execute a select to a flat file, such as,
SELECT
product_model
, ','
,product_qty
Elliot
The loves of my life are a good white zinfandel and my dog Homer.
Bookmarks