Author Topic: PHP myAdmin Product List Export  (Read 3295 times)

jaybird2024

  • Beginner
  • *
  • Posts: 32
PHP myAdmin Product List Export
« 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

osp

  • 3rd party VirtueMart Developer
  • Jr. Member
  • *
  • Posts: 66
Re: PHP myAdmin Product List Export
« Reply #1 on: March 16, 2012, 13:13:51 pm »
You must be able to find it yourself. Otherwise tell someone SQL skilled or you can damage your shop.

jaybird2024

  • Beginner
  • *
  • Posts: 32
Re: PHP myAdmin Product List Export
« Reply #2 on: March 16, 2012, 14:57:47 pm »
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

  • UK Web Developer & Consultant
  • Global Moderator
  • Super Hero
  • *
  • Posts: 27843
  • Always on vacation
    • Jenkin Hill Internet
Re: PHP myAdmin Product List Export
« Reply #3 on: March 16, 2012, 15:14:59 pm »
Why not use CSVI? http://www.csvimproved.com/
Kelvyn

Jenkin Hill Internet,
Lowestoft, Suffolk, UK

Unsolicited PMs/emails will be ignored.

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

Currently using VM 3.8.4.10335 on Joomla 3.9.21 PHP 7.4.9

jaybird2024

  • Beginner
  • *
  • Posts: 32
Re: PHP myAdmin Product List Export
« Reply #4 on: March 16, 2012, 15:22:41 pm »
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

  • Beginner
  • *
  • Posts: 32
Re: PHP myAdmin Product List Export
« Reply #5 on: March 16, 2012, 15:29:30 pm »
Ok the subscription was for something else.
Thanks, downloaded it and trying it.

jaybird2024

  • Beginner
  • *
  • Posts: 32
Re: PHP myAdmin Product List Export
« Reply #6 on: March 16, 2012, 15:31:21 pm »
Arrgh it requires  PHP version 5.3, im running 5.2

PRO

  • Global Moderator
  • Super Hero
  • *
  • Posts: 10420
  • VirtueMart Version: 3+
Re: PHP myAdmin Product List Export
« Reply #7 on: March 16, 2012, 16:46:10 pm »
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.

J3.9+ VM 3.4.2
Slowest Page Speed Score (88) (Category)
Fastest Page Speed Score (94-96) (productdetails)

corymp

  • Jr. Member
  • **
  • Posts: 149
Re: PHP myAdmin Product List Export
« Reply #8 on: March 18, 2012, 17:02:31 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