I want to export 4 items to a CSV spreadsheet file.
products, sku, price, category
Please, someone tell me the SQL statement to use in PHP myAdmin?
Thanks
You must be able to find it yourself. Otherwise tell someone SQL skilled or you can damage your shop.
Hogwash, nobody has access to the PHPmyAdmin but me.
If you meant to say be careful or find an expert, well that is why I am here.
All we need to export to a spread sheet is a couple of MySQL statements.
Why not use CSVI? http://www.csvimproved.com/
Thanks but I looked into that.
I don't want to spend $50.00 to get information off an open-source database.
Unless they have a free version I don't know about...
I was hoping the people who wrote VM could help.
Ok the subscription was for something else.
Thanks, downloaded it and trying it.
Arrgh it requires PHP version 5.3, im running 5.2
Quote from: jaybird2024 on March 16, 2012, 07:56:22 AM
I want to export 4 items to a CSV spreadsheet file.
products, sku, price, category
Please, someone tell me the SQL statement to use in PHP myAdmin?
Thanks
These are in different tables.
You are WAAAAY better off using csv improved.
Quote from: jaybird2024 on March 16, 2012, 15:31:21 PM
Arrgh it requires PHP version 5.3, im running 5.2
add this as the last line of your .htaccess
AddType x-mapp-php6 .php
then do what you need to do with CSVI 4. When done, remove that line from your .htaccess. Your site may look funky while its in there but it will make CSVI 4 work.