Stock Count

[aquaessential]

Is there any way that I can download some type of table of what I currently stock onto an Excel spreadsheet?

This would be very useful for accounting purposes

Thanks

[bunyip]

Yes, it's possible to do from phpmyadmin (generally available from your server Cpanel)

From phpMyAdmin, select your database, click on the SQL tab.
Enter the following query into the textarea box (change the prefix zen_ to match your prefix or delete it if you don't use one):

SELECT p.products_id, p.products_model, pd.products_name, p.products_quantity
FROM zen_products p, zen_products_description pd
WHERE p.products_id = pd.products_id

Once the results display, click the Export link at the bottom of the page
Select CSV for Excel as the export format
Check the 'Save as File' checkbox
Click the Go button, and save the result where you can find it to import into Excel.

[Diva]

I typed what you said into the sql search and it came up the error... Please Help


Error
SQL query:

SELECT p.products_id, p.products_model, pd.products_name, p.products_quantity
FROM _products p, _products_description pd
WHERE p.products_id = pd.products_id
LIMIT 0 , 30

MySQL said:

#1146 - Table 'neva_phpbb._products' doesn't exist

[Cath]

Hi - I've added a .zip file to the download area (Other Modules) which exports data from Excel to a .csv file - it may not contain the fields you need, but perhaps you can modify it to do the job?