News:

You may pay someone to create your store, or you visit our seminar and become a professional yourself with the silver certification

Main Menu

PHP myAdmin Product List Export

Started by jaybird2024, March 16, 2012, 07:56:22 AM

Previous topic - Next topic

jaybird2024

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

osp

You must be able to find it yourself. Otherwise tell someone SQL skilled or you can damage your shop.

jaybird2024

#2
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.

jenkinhill

Kelvyn
Lowestoft, Suffolk, UK

Retired from forum life November 2023

Please mention your VirtueMart, Joomla and PHP versions when asking a question in this forum

jaybird2024

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.

jaybird2024

Ok the subscription was for something else.
Thanks, downloaded it and trying it.

jaybird2024

Arrgh it requires  PHP version 5.3, im running 5.2

PRO

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.


corymp

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.
VM 2.0.4 Stable
J2.5.4