Virtuemart Data Import/Export with CSV

[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

[jenkinhill]

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

[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

[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