VirtueMart Forum

VirtueMart 2 + 3 + 4 => Administration & Configuration => Topic started by: mckater on July 05, 2021, 10:58:45 AM

Title: Virtuemart Data Import/Export with CSV
Post by: mckater on July 05, 2021, 10:58:45 AM
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
Title: Re: Virtuemart Data Import/Export with CSV
Post by: sirius on July 05, 2021, 11:32:02 AM
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
Title: Re: Virtuemart Data Import/Export with CSV
Post by: jenkinhill on July 05, 2021, 12:18:10 PM
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
Title: Re: Virtuemart Data Import/Export with CSV
Post by: Andrew Smith on July 07, 2021, 09:00:50 AM
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
Title: Re: Virtuemart Data Import/Export with CSV
Post by: Jörgen on July 07, 2021, 09:39:27 AM
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 (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
Title: Re: Virtuemart Data Import/Export with CSV
Post by: Studio 42 on July 07, 2021, 19:54:39 PM
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
Title: Re: Virtuemart Data Import/Export with CSV
Post by: Andrew Smith on July 08, 2021, 01:04:50 AM
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