News:

Looking for documentation? Take a look on our wiki

Main Menu

Faster way to export products with SQL?

Started by EvanGR, August 06, 2020, 14:38:37 PM

Previous topic - Next topic

EvanGR

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

QuoteFor the fastest transfers between development-->production sites.

We use

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

QuoteIs 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 for FB, GMC,.. from products, categories, orders, users, articles, acymailing subscribers and database table
Virtuemart Email Manager - customs email templates
Import products for Virtuemart - from CSV and XML
Rich Snippets - Google Structured Data
VirtueMart Products Extended - Slider with products, show Others bought, Products by CF ID and others filtering products