Author Topic: Virtuemart Data Import/Export with CSV  (Read 787 times)

mckater

  • Beginner
  • *
  • Posts: 11
  • A beginner
Virtuemart Data Import/Export with CSV
« 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

sirius

  • Jr. Member
  • **
  • Posts: 128
    • OCTeam
  • VirtueMart Version: 3.8.6
Re: Virtuemart Data Import/Export with CSV
« Reply #1 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
J3.10.2 | PHP 7.4.23 + APC + Opcode
VM Prod : 3.8.6 | VM Test : 3.8.9

jenkinhill

  • UK Web Developer & Consultant
  • Global Moderator
  • Super Hero
  • *
  • Posts: 28181
  • Always on vacation
    • Jenkin Hill Internet
Re: Virtuemart Data Import/Export with CSV
« Reply #2 on: July 05, 2021, 12:18:10 pm »

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

Jenkin Hill Internet,
Lowestoft, Suffolk, UK

Unsolicited PMs/emails will be ignored.

Please mention your VirtueMart, Joomla and PHP versions when asking a question in this forum

Currently using VirtueMart 3.8.9.10473 on Joomla 3.9.28 PHP 7.4.14

Andrew Smith

  • Beginner
  • *
  • Posts: 22
  • A beginner
Re: Virtuemart Data Import/Export with CSV
« Reply #3 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

Jörgen

  • Global Moderator
  • Sr. Member
  • *
  • Posts: 3632
    • Kreativ Fotografi
  • VirtueMart Version: 3.4.x
Re: Virtuemart Data Import/Export with CSV
« Reply #4 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

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

  • Contributing Developer
  • Sr. Member
  • *
  • Posts: 4475
  • Joomla & Virtuemart developper
    • Studio 42 - Virtuemart & Joomla extentions
  • VirtueMart Version: 2.6 & 3
Re: Virtuemart Data Import/Export with CSV
« Reply #5 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

Andrew Smith

  • Beginner
  • *
  • Posts: 22
  • A beginner
Re: Virtuemart Data Import/Export with CSV
« Reply #6 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