News:

Looking for documentation? Take a look on our wiki

Main Menu

Virtuemart Data Import/Export with CSV

Started by mckater, July 05, 2021, 10:58:45 AM

Previous topic - Next topic

mckater

Hello,

I have a question about importing and exporting data for customer management and products. Is it possible to export data from Virtuemart and then edit it in Excel? Then save it as CSV and upload it back to Virtuemart. I would like to create the product list, pictures .... with all the relevant data in Excel and only then insert it into Virtuemart. There are programs because? I'm currently working with the free version. Has someone already done something like this and which tool can you recommend that works properly. Is in the PRO Virtuemart this integratet?

Thanks in advance for the help

Regards,
Reinhard

sirius

Hi
You can use RO CSVI
I use it and it's very convenient for import/export and it reads both xlsx and csv.
You can define fields for each import/export templates.
There's a complete bunch of templates already set as example.

Just give it a try
J3.10.12 | PHP 7.4.33 + APC + memcached + Opcode
VM Prod : 3.8.6 | VM Test : 4.0.12.10777

jenkinhill

Quote from: mckater on July 05, 2021, 10:58:45 AM

Is in the PRO Virtuemart this integratet?


There is no "Pro VirtueMart". VirtueMart is free software released under the GNU General Public License.
See http://virtuemart.net/features/what-is-virtuemart
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

Andrew Smith

I've got a similar situation with migrating a customer base over from a different shopping cart solution.  Would it be best to do this direct into VirtueMart or to migrate into Joomla as users (and this be presumably auto-synched across to VirtueMart)?

Andrew

Jörgen

When you migrate users you have database entries in both Joomla tables and in VM tables. Synchronising users is best done via some migration tool.

This is a good tool:
https://www.daycounts.com/migrator

This is preferably done to a "empty" site, user id can be tricky since these are keys for VM orders and more data.

There may be other migration tools, but I trust this, long time, 8 years, sice I used this last time.

Jörgen
Joomla 3.9.18
Virtuemart 3.4.x
Olympiantheme Hera (customized)
This reflects current status when viewing old post.

Studio 42

You can use vm be pro to import products.
SEE https://shop.st42.fr/en/products/vm-be-pro-batch-product-edit.htm
Export is limited to a quick CSV list of products

Andrew Smith

FWIW, existing customer numbers were just a few hundred-ish, so they'll just get loaded into a bulk email component.  Keepin' it simple.

Andrew