Author Topic: Where are all products info saved to? which subfolder?  (Read 2431 times)

jiapei100

  • Beginner
  • *
  • Posts: 40
Where are all products info saved to? which subfolder?
« on: September 20, 2012, 11:10:54 am »

Hi, all:

I'm using Joomla 2.5.7 + VirtueMart 2.0.10.

My question is where is all products info saved to? under which folder?


Cheers
Pei
Welcome Vision Misc
http://www.visionmisc.com

bytelord

  • Nikos
  • Global Moderator
  • Full Member
  • *
  • Posts: 2369
Re: Where are all products info saved to? which subfolder?
« Reply #1 on: September 20, 2012, 11:18:11 am »
Hello,

All product information stored under joomla mysql Database. Use phpMyAdmin to access the database.
Product images saved under your_joomla_site\images\stories\virtuemart\product

What exactly you wanna do?
Production: Joomla 2.5.8 | VM 2.0.14 | PHP 5.3.13
Testing     : Joomla 2.5.8 | VM 2.0.16 | PHP 5.3.8
Testing     : Joomla 2.5.8 |    VM 2.1   | PHP 5.3.8

- Don't Forget to mark thread as solved when it is solved!
- Please do not PM with support questions, use the forum!

jiapei100

  • Beginner
  • *
  • Posts: 40
Re: Where are all products info saved to? which subfolder?
« Reply #2 on: September 20, 2012, 11:24:04 am »

Hi, in fact, I was considering to import "the already input products record from my old VM to a new one", I'm just lazy and don't want to input the record again.
However, now, I see there seems to be some progress of VM 2.0.10 !! It's now able to permit me select different children product !! That's perfect.
I don't mind to type the records again...

Thanks ^_^
Pei

Hello,

All product information stored under joomla mysql Database. Use phpMyAdmin to access the database.
Product images saved under your_joomla_site\images\stories\virtuemart\product

What exactly you wanna do?
Welcome Vision Misc
http://www.visionmisc.com

bytelord

  • Nikos
  • Global Moderator
  • Full Member
  • *
  • Posts: 2369
Re: Where are all products info saved to? which subfolder?
« Reply #3 on: September 20, 2012, 11:32:54 am »
Hello,

There are not only products but other tables too. You could use phpmyadmin to export the ___virtuemart_xxx tables you need and import them to your new installation. After that copy the your_joomla_site\images\stories\virtuemart\  images to your new joomla installation.
Production: Joomla 2.5.8 | VM 2.0.14 | PHP 5.3.13
Testing     : Joomla 2.5.8 | VM 2.0.16 | PHP 5.3.8
Testing     : Joomla 2.5.8 |    VM 2.1   | PHP 5.3.8

- Don't Forget to mark thread as solved when it is solved!
- Please do not PM with support questions, use the forum!

Dakota09

  • Beginner
  • *
  • Posts: 1
Re: Where are all products info saved to? which subfolder?
« Reply #4 on: November 16, 2012, 22:56:25 pm »
I have managed very small shops in the past by adding products manually.  Now I have a shop that has 1,000's of products. 
So I have a question but not sure if it is silly or l!  I am trying to import csv into the DB, and I see the following:
  • jml_virtuemart_products
  • jos_virtuemart_products
  • w16mo_virtuemart_products
It looks like they all contain the same data.  So where do I import my new data into?  Just one, all 3?  Thanks!

Using VM 2.0.6 and Joomla 2.5.4

bytelord

  • Nikos
  • Global Moderator
  • Full Member
  • *
  • Posts: 2369
Re: Where are all products info saved to? which subfolder?
« Reply #5 on: November 17, 2012, 00:32:03 am »
Hello,

The tables are the same but the prefixes xxx_ says that you have 3 different installation tables, xxx_ is the prefix from joomla configuration. There are many other tables you should import also.
I suggest you to try csv improved for that, has a free version that to can export and import products (csvimproved.com)
Production: Joomla 2.5.8 | VM 2.0.14 | PHP 5.3.13
Testing     : Joomla 2.5.8 | VM 2.0.16 | PHP 5.3.8
Testing     : Joomla 2.5.8 |    VM 2.1   | PHP 5.3.8

- Don't Forget to mark thread as solved when it is solved!
- Please do not PM with support questions, use the forum!

Milbo

  • Virtuemart Projectleader
  • Administrator
  • Super Hero
  • *
  • Posts: 9856
  • VM3.2 Cached and Optimized
    • VM3 Extensions
  • VirtueMart Version: VirtueMart 3 on joomla 3
Re: Where are all products info saved to? which subfolder?
« Reply #6 on: November 17, 2012, 12:48:38 pm »
and if you migrate from vm1, use the migrator, read the wiki and FAQs https://dev.virtuemart.net/projects/virtuemart/wiki/Upgrading_VM1_to_VM2_with_provided_packages
I should fix your bug, please support the VirtueMart project and become a member
______________________________________
Extensions approved by the core team: http://extensions.virtuemart.net/