Author Topic: CSV export of products & customers  (Read 599 times)

smarta

  • Beginner
  • *
  • Posts: 1
  • A beginner
CSV export of products & customers
« 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

GJC Web Design

  • 3rd party VirtueMart Developer
  • Super Hero
  • *
  • Posts: 7596
  • Virtuemart, Joomla & php developer
    • GJC Web Design
  • VirtueMart Version: 2.6.22 & 3.2.2
Re: CSV export of products & customers
« Reply #1 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?
GJC Web Design
VirtueMart and Joomla Developers - php developers http://www.gjcwebdesign.com
VM3 AusPost Shipping Plugin - e-go Shipping Plugin - VM3 Postcode Shipping Plugin - Radius Shipping Plugin - VM3 NZ Post Shipping Plugin - AusPost Estimator
Samport Payment Plugin - EcomMerchant Payment Plugin - ccBill payment Plugin
VM2 Product Lock Extension - VM2 Preconfig Adresses Extension - TaxCloud USA Taxes Plugin - Virtuemart  Product Review Component
http://extensions.joomla.org/profile/profile/details/67210
Contact for any VirtueMart or Joomla development & customisation

fires3as0n

  • Beginner
  • *
  • Posts: 3
  • A beginner
Re: CSV export of products & customers
« Reply #2 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

Studio 42

  • Contributing Developer
  • Full Member
  • *
  • Posts: 2333
  • Joomla & Virtuemart addon developper
    • Studio 42 - Virtuemart & Joomla extentions
  • VirtueMart Version: 2.6 & 3.0.x.y
Re: CSV export of products & customers
« Reply #3 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.

fires3as0n

  • Beginner
  • *
  • Posts: 3
  • A beginner
Re: CSV export of products & customers
« Reply #4 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.

fires3as0n

  • Beginner
  • *
  • Posts: 3
  • A beginner
Re: CSV export of products & customers
« Reply #5 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.


Studio 42

  • Contributing Developer
  • Full Member
  • *
  • Posts: 2333
  • Joomla & Virtuemart addon developper
    • Studio 42 - Virtuemart & Joomla extentions
  • VirtueMart Version: 2.6 & 3.0.x.y
Re: CSV export of products & customers
« Reply #6 on: October 25, 2017, 21:18:02 pm »
@fires3as0n
Price, atributes, alias ... you loose many thing if you have a complex shop.

jenkinhill

  • UK Web Developer & Consultant
  • Global Moderator
  • Super Hero
  • *
  • Posts: 26358
  • Always on vacation
    • Jenkin Hill Internet
Re: CSV export of products & customers
« Reply #7 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.
Kelvyn

Jenkin Hill Internet,
Keswick, Lake District

Unsolicited PMs/emails will be ignored.

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

Currently using VM3.2.4 on Joomla 3.8.1 PHP 7.0.23

Testing VM3.2.5 on J!3.8.1

Studio 42

  • Contributing Developer
  • Full Member
  • *
  • Posts: 2333
  • Joomla & Virtuemart addon developper
    • Studio 42 - Virtuemart & Joomla extentions
  • VirtueMart Version: 2.6 & 3.0.x.y
Re: CSV export of products & customers
« Reply #8 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.