VirtueMart Forum

VirtueMart 1.1.x [ Old version - no longer supported ] => Questions VM 1.1 ( the only active board for the old version) => Topic started by: smarta on September 27, 2017, 10:17:01 am

Title: CSV export of products & customers
Post by: smarta on September 27, 2017, 10:17:01 am
Hi - i've been asked by an elderly couple who have a Orchid hardware supply website to re-vamp their website

it's using "VirtueMart 1.1.4 stable" so I guess it's pretty ancient

what I'd like to do is export a single category of their products list and also export a list of their exisiting customers (pretty sure there are 2 levels of customer)

these does  not seem to be any obvious export functions in the admin

I have no experience with VirtueMart but was hoping someone may be able to tell me if

a. it is possible

and

b. how i can be done

thnks in advance
Title: Re: CSV export of products & customers
Post by: GJC Web Design on September 27, 2017, 17:13:42 pm
ancient: just export it via the Database with what ever interface the host provides .. e.g. phpmyadmin

why not migrate it to VM3 and rebuild it that way?
Title: Re: CSV export of products & customers
Post by: fires3as0n on October 16, 2017, 17:54:15 pm
I have exactly the same problem: the ancient site that is running Joomla: 1.5.26 and VirtueMart 1.1.4, the only option I see here is to completely rebuild it from scratch, but I have a problem migrating over 5000 goods from the store. It would be nice to export it somehow.
VM update just freezes at Checking... status
Title: Re: CSV export of products & customers
Post by: Studio 42 on October 16, 2017, 19:09:36 pm
I have exactly the same problem: the ancient site that is running Joomla: 1.5.26 and VirtueMart 1.1.4, the only option I see here is to completely rebuild it from scratch, but I have a problem migrating over 5000 goods from the store. It would be nice to export it somehow.
VM update just freezes at Checking... status
Use https://www.daycounts.com/migrator, but in all case you loose some information, i used it myself and only recovered 95% of information, but the shop should work.
If you have to readd some missing products information, you can use Vm Be Pro https://shop.st42.fr/en/products/vm-be-pro-batch-product-edit.htm, you have an import tool included.
Title: Re: CSV export of products & customers
Post by: fires3as0n on October 19, 2017, 10:00:38 am
Unfortunately, that one costs money, the guys I am helping with their site are not going to pay, thats a problem.
Title: Re: CSV export of products & customers
Post by: fires3as0n on October 25, 2017, 20:19:17 pm
I have solved the problem, its very easy:

1. Open the old site database via phpMyAdmin
2. Export 'jos_vm_product' table as CSV
3. Import as CSV to new E-commerce plugin/exension

You are done, and someone wants money for perfoming such an easy task? Ridiculous.

Title: Re: CSV export of products & customers
Post by: Studio 42 on October 25, 2017, 21:18:02 pm
@fires3as0n
Price, atributes, alias ... you loose many thing if you have a complex shop.
Title: Re: CSV export of products & customers
Post by: jenkinhill on October 26, 2017, 00:03:27 am
Yup, exporting just ###_vm_product is not enough for a large store, so you spend a lot more time sorting it out. Perhaps not in your world, but in mine, time is money.
Title: Re: CSV export of products & customers
Post by: Studio 42 on October 26, 2017, 03:26:47 am
YOu have alias to redirect for google, all customers info and orders, bt this is only a little part of the full list.
SO yes exporting 'jos_vm_product' have the main product informations, but if i only import this, i loose all my customers.