CSV export of products & customers

[smarta]

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

[GJC Web Design]

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?

[fires3as0n]

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

[Studio 42]

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.

[fires3as0n]

Unfortunately, that one costs money, the guys I am helping with their site are not going to pay, thats a problem.

[fires3as0n]

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.

[Studio 42]

@fires3as0n
Price, atributes, alias ... you loose many thing if you have a complex shop.

[jenkinhill]

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.

[Studio 42]

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.