VirtueMart Forum

VirtueMart 2 + 3 + 4 => General Questions => Topic started by: jiapei100 on September 20, 2012, 11:10:54 AM

Title: Where are all products info saved to? which subfolder?
Post by: jiapei100 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
Title: Re: Where are all products info saved to? which subfolder?
Post by: bytelord 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?
Title: Re: Where are all products info saved to? which subfolder?
Post by: jiapei100 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

Quote from: bytelord 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?
Title: Re: Where are all products info saved to? which subfolder?
Post by: bytelord 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.
Title: Re: Where are all products info saved to? which subfolder?
Post by: Dakota09 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:
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
Title: Re: Where are all products info saved to? which subfolder?
Post by: bytelord 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)
Title: Re: Where are all products info saved to? which subfolder?
Post by: Milbo 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