Author Topic: Faster way to export products with SQL?  (Read 199 times)

EvanGR

  • Jr. Member
  • **
  • Posts: 355
Faster way to export products with SQL?
« on: August 06, 2020, 14:38:37 pm »
The goal:
Export products from selected categories, in SQL format.
We want all the related tables that describe those products, and only containing the wanted products.

How I would do it (the hard way):
Perform a SELECT statement on each table, to gather the wanted products, and export the results. One table at a time.

Is there a better way?

Thank you

PS. Yes, it has to be SQL data. For the fastest transfers between development-->production sites.

Thanks

pinochico

  • 3rd party VirtueMart Developer
  • Full Member
  • *
  • Posts: 643
    • MiniJoomla
  • Skype Name: support-easysoftware
  • VirtueMart Version: 3
Re: Faster way to export products with SQL?
« Reply #1 on: August 06, 2020, 20:00:39 pm »
Quote
For the fastest transfers between development-->production sites.

We use

1. component Jmigrator
or
2. own script for transfer increments only

Quote
Is there a better way?

No, use custom mysql scripts or custom php scripts only for increments from old production to develop version and then new production.

If we create update eshop from VM2, then sure use JMigrator.
After first migration we can connect to production mysql again (in mysql are history for imports) and import only increments.
www.minijoomla.org  - new portal for Joomla!, Virtuemart and other extensions
XML Easy Feeder - feeds from products, orders and database table
Virtuemart Email Manager - customs email templates