icc97

theantichris

This plugin is aimed at developers that need to migrate their databases from 
production to test or local domains.
This is the simplest way I’ve found to migrate databases quickly.
You only have to set the <code>WP_HOME</code> 
(<a href="https://codex.wordpress.org/Editing_wp-config.php#WordPress_address_.28URL.29" rel="nofollow ugc">WordPress address URL</a>) 
and <code>WP_SITEURL</code> 
(<a href="https://codex.wordpress.org/Editing_wp-config.php#Blog_address_.28URL.29" rel="nofollow ugc">Blog address URL</a>) 
constants once for each environment and then the database is automatically 
upgraded when you import a database and login to the admin area.
This stands on the shoulders of the constants and fills the hole for when 
plugins don’t follow the rules and use the database directly.
This plugin is designed to be the most lightweight way to migrate your database 
and stay out the way of your own processes.
It works with WordPress to use WordPress’ own constants to update the database 
using the 
<a href="https://codex.wordpress.org/Class_Reference/wpdb" rel="nofollow ugc">WordPress Database Object</a>. 
It avoids search and replaces in text files. It uses database queries to update 
the database as should be done.
Most developers have their own methods for exporting/importing the database – 
if you can use <code>mysqldump</code> then you probably don’t want a WordPress plugin to 
do it for you.
It makes no assumptions about your database and it’s cross platform.
P.S. Pitta is taken from the start of an <a href="http://wordpress.stackexchange.com/a/182/5433" rel="nofollow ugc">answer from WordPress SE</a>:
<blockquote>
Deployment of a WordPress site from one box to another has been a PITA since 
 day one I started working with WordPress. (Truth-be-told it was a PITA with 
 Drupal for 2 years before I started with WordPress so the problem is 
 certainly not exclusively with WordPress.)
</blockquote>
So this plugin aims to make things less PITA and more yummy Pitta (pedants will 
mention that Pitta can also be spelled pita).
Its inspiration actually comes from the <a href="http://wordpress.stackexchange.com/q/119/5433" rel="nofollow ugc">second answer</a> 
from the same <a href="http://wordpress.stackexchange.com/q/119/5433" rel="nofollow ugc">WordPress SE question</a>.
Coincidentally there is a migratory bird called a <a href="https://en.wikipedia.org/wiki/Pitta" rel="nofollow ugc">Pitta</a>:
<blockquote>
The fairy pitta migrates from Korea, Japan, Taiwan and coastal China to Borneo.
</blockquote>
P.P.S. This plugin is based off the excellent <a href="https://github.com/theantichris/WordPress-Plugin-Boilerplate" rel="nofollow ugc">WordPress Plugin Boilerplate</a> from antichris on Github

Pitta Migration

Migrate WordPress databases using WP_HOME and WP_SITEURL constants.

Soflyy

WP All Import

<h4>WP All Export – Simple & Powerful XML / CSV Export Plugin</h4>
WP All Export features a three-step export process and an intuitive drag-and-drop interface that makes complicated export tasks simple and fast.
With WP All Export you can: export data for easy editing, migrate content from WordPress to another site, create a WooCommerce affiliate feed, generate filtered lists of WooCommerce orders, export the email addresses of new customers, create and publish customized WordPress RSS feeds – and much more.
<a href="https://www.wpallimport.com/try-export-free/" rel="nofollow ugc">Click here to try WP All Export right now</a>.
<iframe loading="lazy" class="youtube-player" width="750" height="422" src="https://www.youtube.com/embed/a-z0R-Ldkqo?version=3&rel=1&showsearch=0&showinfo=1&iv_load_policy=1&fs=1&hl=en-US&autohide=2&wmode=transparent" allowfullscreen="true" style="border:0;" sandbox="allow-scripts allow-same-origin allow-popups allow-presentation allow-popups-to-escape-sandbox"></iframe>
<ul>
<li>
Turn your WordPress data into a customized CSV or XML Perfect for using your WordPress data in Google Sheets or Excel.
</li>
<li>
Choose which data to export: WP All Export’s drag-and-drop interface makes it easy to select exactly which data you’d like to export.
</li>
<li>
Structure your export file however you like: Rename CSV columns and XML elements, rearrange them, or do whatever you want to do.
</li>
<li>
Export any custom post type, any custom field: Lots of plugins and themes store custom data in WordPress. You can export all of it with WP All Export.
</li>
<li>
Easy integration with WP All Import: WP All Export will generate your WP All Import settings for you so importing your data back into WordPress is easy, simple, and fast.
</li>
</ul>
Wish you could edit your WordPress data in Excel or Google Sheets? Now you can – export it with WP All Export, edit it, and then import it again with WP All Import.
For technical support from the developers, please consider purchasing WP All Export Pro.
<h4>WP All Export Pro Version</h4>
WP All Export Pro is a paid upgrade that includes premium support and adds the following features:
<ul>
<li>
Send your data to 500+ apps: Full integration with Zapier allows you to send your exported WordPress data to services like Dropbox and Google Drive, to create and update reports in Google Sheets, send email updates, or anything else you can think of. This is especially useful when you export WooCommerce orders to CSV.
<a href="https://zapier.com/zapbook/wp-all-export-pro/" rel="nofollow ugc">Read more about WP All Export Pro and Zapier.</a>
</li>
<li>
WordPress Excel Export: Have a third-party service that only accepts Excel format? WP All Export has you covered. In addition to CSV and XML, you can easily export your WordPress data in true Excel formats (both .XLS and .XLSX)
</li>
<li>
Schedule exports to run automatically: Exports can be configured to run on any schedule you like. You can export new sales every week, recent user sign ups, new affiliate products added to your site, daily product stock reports, etc. Scheduled exports are very powerful when combined with Zapier.
</li>
<li>
Add rules to filter data: WP All Export Pro makes it easy to export the exact posts/products/orders you need. Want to export all WooCommerce orders over $100? Want to export all of the green shirts from your WooCommerce store? Want to export all new posts from 2014, except the ones added by Steve?
You can with a simple to use interface on the ‘New Export’ page in WP All Export Pro.
</li>
<li>
Export WordPress users: WP All Export Pro adds the ability to export WordPress users and all custom data associated with them. Available data is organized and cleaned up so you don’t need to know anything about how WordPress stores users in order to export them.
</li>
<li>
Export WooCommerce orders: Export WooCommerce Order item data with WP All Export Pro. Just as with any other custom post type, you can export WooCommerce orders with the free version of WP All Export. However, the order item data is stored by WooCommerce in several custom database tables and this custom data is only accessible with WP All Export Pro.
</li>
<li>
Pass data through custom PHP functions: With WP All Export Pro you can pass your data through a custom function before it is added to your export file. This will allow you to manipulate your data any way you see fit.
</li>
<li>
Guaranteed technical support via e-mail.
</li>
</ul>
<a href="http://www.wpallimport.com/upgrade-to-wp-all-export-pro/?utm_source=export-plugin-free&utm_medium=readme&utm_campaign=premium-support" rel="nofollow ugc">Upgrade to the Pro edition of WP All Export.</a>
<h4>Automatic Scheduling</h4>
A new service from Soflyy, Automatic Scheduling provides a simple interface for setting exports to run on a schedule. The service will make sure that your exports start on time and that they successfully complete without the need to set up individual cron jobs.
It can be used with WP All Export and WP All Import Pro. You can set up as many exports and imports as you like.
What information is shared with Soflyy? If you set an export to run on a schedule, WP All Export will open an encrypted connection to Soflyy servers. It will send the license key, site URL, ID of the export you want to run, export security key, and times that you want the export to run.
<h4>WordPress CSV Exports</h4>
A CSV is a very simple type of spreadsheet file where each column is separated by a comma. With WP All Export, you can very easily set up a WordPress CSV export and control the order and title of the columns.
Very often you’ll want to edit your data with Microsoft Excel, Google Sheets, Numbers, or maybe something else. This is why a CSV export is so powerful – all spreadsheet software can read, edit, and save CSV files. WP All Export allows you to edit your WordPress data using whatever spreadsheet software you are most comfortable with.
<h4>WordPress CSV Exports</h4>
A CSV is a very simple type of spreadsheet file where each column is separated by a comma. With WP All Export, you can very easily set up a WordPress CSV export and control the order and title of the columns.
Very often you’ll want to edit your data with Microsoft Excel, Google Sheets, Numbers, or maybe something else. This is why a CSV export is so powerful – all spreadsheet software can read, edit, and save CSV files. WP All Export allows you to edit your WordPress data using whatever spreadsheet software you are most comfortable with.
<h4>WordPress XML Exports</h4>
Sometimes you’ll want to export your data so that some other tool, software, or service can use it. Very often they will require your data to be formatted as an XML file. XML is very similar to HTML, but you don’t need to know anything about that in order to set up an XML export with WP All Export.
If you want to set up a WordPress XML export all you need to do is select ‘XML’ when configuring your export template. And just like a CSV export, an XML export will allow you to customize the element names and put them in any order you wish.
<h4>Related Plugins</h4>
<a href="https://wordpress.org/plugins/wp-all-import/" rel="ugc">Import any XML or CSV File to WordPress</a> 
<a href="https://wordpress.org/plugins/woocommerce-xml-csv-product-import/" rel="ugc">Import Products from any XML or CSV to WooCommerce</a> 
<a href="https://wordpress.org/plugins/product-export-for-woocommerce/" rel="ugc">Export Products to CSV/XML for WooCommerce</a> 
<a href="https://wordpress.org/plugins/custom-product-tabs-wp-all-import-add-on/" rel="ugc">Custom Product Tabs for WooCommerce WP All Import Add-on</a> 
<a href="https://wordpress.org/plugins/order-export-for-woocommerce/" rel="ugc">Export Orders to CSV/XML for WooCommerce</a> 
<a href="https://wordpress.org/plugins/export-wp-users-xml-csv/" rel="ugc">Export WordPress Users to CSV/XML</a>
<h4>Related Tutorials</h4>
<a href="https://www.wpallimport.com/documentation/how-to-export-woocommerce-products-to-google-merchant-center/" rel="nofollow ugc">How to Export WooCommerce Products to Google Merchant Center (Google Shopping)</a> 
<a href="https://www.wpallimport.com/documentation/how-to-export-gravity-form-entries-to-csv-or-xml/" rel="nofollow ugc">How to Export Gravity Forms Entries</a> 
<a href="https://www.wpallimport.com/toolset-types-export-csv-xml/" rel="nofollow ugc">Export Toolset Types to CSV, XML, or Excel</a> 
<a href="https://www.wpallimport.com/documentation/how-to-export-woocommerce-variable-products/" rel="nofollow ugc">How to Export WooCommerce Variable Products</a> 
<a href="https://www.wpallimport.com/documentation/export-wordpress-posts/" rel="nofollow ugc">How to Export Blogs, Articles, Posts, Standard Post Data, Permalinks, Excerpts, Captions, Menus, Subscriptions, and Other Details From Your Websites</a> 
<a href="https://www.wpallimport.com/documentation/export-wordpress-comments-csv-xml/" rel="nofollow ugc">How To Export WordPress Comments</a> 
<a href="https://www.wpallimport.com/documentation/how-to-export-woocommerce-coupons-to-csv-or-xml/" rel="nofollow ugc">How To Export WooCommerce Coupons</a> 
<a href="https://www.wpallimport.com/documentation/how-to-export-woocommerce-reviews-to-csv-or-xml/" rel="nofollow ugc">How To Export WooCommerce Reviews</a> 
<a href="https://www.wpallimport.com/documentation/how-to-schedule-wordpress-exports/" rel="nofollow ugc">How to Schedule Your Exports to Run Automatically</a> 
<a href="https://www.wpallimport.com/documentation/how-to-migrate-woocommerce-and-wordpress-data/" rel="nofollow ugc">How to Migrate WooCommerce and WordPress From One Host to Another</a>
<h3>Premium Support</h3>
You can submit the <a href="https://www.wpallimport.com/support/" rel="nofollow ugc">support form on our website</a> or email us at <a href="mailto:support@wpallimport.com" rel="nofollow ugc">support@wpallimport.com</a>. While we try to assist users of our free version, please note that support is not guaranteed and will depend on our capacity. For premium support, purchase <a href="https://www.wpallimport.com/upgrade-to-wp-all-export-pro/?utm_source=dotorg&utm_medium=readme&utm_campaign=premium-support" rel="nofollow ugc">WP All Export Pro</a>.

Export any WordPress data to XML/CSV

The plugin is very powerful, almost everything is possible if you are a developer.

The support team is also a great resource if you get stuck.

We use the plugin for export/import when doing many changes to the products and also for our product feeds. -- NOTE: We do use the pro version.

Most powerfull export plugin that I know of

Easily export any data from WordPress. Drag & drop to create a completely custom spreadsheet, CSV, or XML file.

Pitta Migration vs Export any WordPress data to XML/CSV