Stephen Harris

This plug-in allows to import events from a CSV file into Event Organiser. You can also export events from 
Event Organiser into a CSV file.
Please note that this plug-in still in beta. I welcome feedback, issues and pull-requests.
<h4>Aim</h4>
To allow users to export / import events in CSV format between various calendar applications, and to do this flexiably 
so as to limit the number of requirements on the CSV file before it can be read correctly. To allow users to move events 
between installations of Event Organiser while preserving data that is not suported by iCal.
In the vein of flexibility columns do not have to be in any prescribed order: you tell the plug-in which columns pertain to what (start date, end date etc) 
after importing the file.
<h4>How to use this plug-in</h4>
Once installed, go to Tools > Import Events. Here you can export a CSV file or select a file to import one. To import an file:
<ul>
<li>Select browse and select the file, click “Upload file and import”</li>
<li>All being well you should now see a preview of the CSV file, along with a drop-down option at the base of each column. If the preview looks wrong, try 
selecting a different delimiter type (comma, tab, space) at the top.</li>
<li>If the first row of the CSV file is a header, select the option indicating this. The first row will then be ignored.</li>
<li>At the bottom of each column select what the column represents. The options are (not all are required):
<ul>
<li>Title</li>
<li>Start (formatted in Y-m-d format, and also indicating time only if the event is not all-day) </li>
<li>End (formatted as above)</li>
<li>Recur until (if the event recurs, the date of its last occurrence)</li>
<li>Recurrence Schedule (if the event recurs, how it repeats: once|daily|weekly|monthly|yearly|custom).</li>
<li>Recurrence Frequency (if the event recurs, an integer indicating with what frequency)</li>
<li>Schedule Meta (See documentation for <a href="http://codex.wp-event-organiser.com/function-eo_insert_event.html" rel="nofollow ugc">eo_insert_post()</a>, e.g. “MO,TU,THR” (weekly), “BYDAY=2MO” or “BYMONTHDAY=16” (monthly)</li>
<li>Content (HTML post content)</li>
<li>Venue (Venue slug)</li>
<li>Categories (comma seperated list of category slugs) </li>
<li>Tags (comma seperated list of tag slugs)</li>
<li>[Any custom event taxonomies registered] (comma seperated list of slugs)</li>
<li>Include dates (comma seperated list of Y-m-d dates to include from the event’s schedule)</li>
<li>Exclude dates (as above, but added to the event’s schedule)</li>
<li>Post Meta (an option will appear to provide the meta-key)</li>
<li>Click import.</li>
</ul>
</li>
</ul>
<h4>Importing new venues, categories and tags</h4>
By default the plug-in will only import venues, categories and tags that already exist. 
To allow the plug-in to create new venues, categories and tags you can add the following 
code (to a seperate plug-in or your theme’s <code>functions.php</code>).
<pre><code> function my_set_import_imports( $args, $file ){
 $args['import_new_event-category'] = true; //create category if it doesn't exist
 $args['import_new_event-venue'] = true; //create venue if it doesn't exist.
 $args['import_new_event-tag'] = true; //create tag if it doesn't exist. 

 return $args;
 }
 add_filter( 'eventorganiser_csv_import_args', 'my_set_import_imports', 10, 2 );
</code></pre>
Please note the limitations on importing venues discussed below.
<h4>Limitations</h4>
Current limitations apply. See the examples folder for an archetypal CSV file
<ul>
<li>All dates are read using PHP’s DateTime. While various formats are supported, Y-m-d (e.g. 2013-12-31) formats are strongly recommended</li>
<li>Starts dates must be provided in Y-m-d (e.g. 2013-12-31) for all day events and also include a time-component (e.g. 2013-12-31 11:30pm) for non-all-day events. There is no 
prescribed format for the time but 24-hour time is recommended. You do not need to specify seconds.</li>
<li>Include/exclude dates should be given as comma-seperated list of dates in Y-m-d format.</li>
<li>Categories and tags must be given as comma-seperated list of names</li>
<li>It does not support venue meta-data (yet)</li>
</ul>
Please note that in theory all dates (other than the start date) can be given in any format, however, to 
ensure dates are interpreted correctly it is strongly recommended to give dates in Y-m-d (or Y-m-d H:i for non-all day events) format. The start 
date must be in that format so that the importer can differentriate between all-day and non-all-day events.
<h4>Future Features</h4>
<ul>
<li>An “import preview” or “dry-run” so users can view how events will be imported.</li>
<li>Support venue meta data</li>
<li>Support category colours</li>
<li>Add filters for developers</li>
<li>Add support for UID to prevent importing an event twice (perhaps, update the event?)</li>
<li>Add support ‘maps’ for importing from other applications (where format of exported CSV file is prescribed).</li>
<li>Support generic date formatting (try to ‘guess’ / ask for format )</li>
</ul>

Event Organiser CSV

Import & export events from/to CSV format

WebToffee

<h4>Introduction – Order/Coupon Export Import Plugin</h4>
The Order Export Import Plugin for WooCommerce makes it easy to move order data between stores or from another platform to WooCommerce. Instead of manually transferring orders, you can quickly export and import orders in bulk, saving time and avoiding errors. The plugin safely handles thousands of orders including subscription orders (in the premium version), so you can keep your order history and customer details intact during migrations or store updates.
The plugin also works as a coupon export and import tool, making it easy to move all your coupons from another store or marketing campaign. If you manage a large number of coupons, this feature helps you bulk import coupon CSV files or export coupon data. It’s a simple way to keep your discount codes organized and consistent across different platforms.
<h4>Key Features of Order Import Export Plugin</h4>
The following are functionalities offered by the basic version of the WooCommerce order import and order export plugin.
🔸 Export Orders: WooCommerce export orders to CSV. 
 🔸 Import Orders: Import orders from CSV to WooCommerce. 
 🔸 Export Coupons: Export coupons to CSV. 
 🔸 Import Coupon CSV: Import coupons from CSV to WooCommerce. 
 🔸 Selective Column Import: Supports importing selected columns from the order import CSV file. 
 🔸 Bulk Updates: Bulk update WooCommerce orders and coupons. 
 🔸 YITH Compatibility: Compatible with YITH WooCommerce Order Tracking plugin. 
 🔸 Export Filters: Supports various export orders filters (order status, product, coupon, customer, date range) for order export to CSV. 
 ✅ Tested OK with WooCommerce 10.3.4 
 ✅ Tested OK with WordPress 6.8 
 ✅ Tested OK with PHP 8.3
<h4>Advanced Features for Seamless CSV Export and Import</h4>
Additional features of the order import and WooCommerce order export plugin that will help you in the CSV export and import process:
🔸 Import and export WooCommerce orders in batches. 
 🔸 Import coupons from CSV and export coupons to CSV. 
 🔸 Create a pre-saved template for quick and easy export of orders and coupons. 
 🔸 Mapping and re-ordering of export columns. 
 🔸 Export orders starting after an offset value. 
 🔸 Skip or update existing orders/coupons while importing. 
 🔸 Create and maintain import and export history with options to re-run, view logs, and delete an entry. 
 🔸 Log of the import and export will help in identifying what went wrong for debugging purposes. 
 🔸 Auto-suggestion of coupon codes making coupon-based filtering easier. 
 🔸 Export Subscription orders to a CSV file. 
 🔸 Import Subscription orders from a CSV file.
More information about the setup of the plugin and a sample CSV that is taken as input by the plugin are given in the <a href="https://www.webtoffee.com/order-coupon-subscription-export-import-plugin-woocommerce-user-guide/" rel="nofollow ugc">free order export import plugin</a> setup guide.
<h4>Compatible Plugins</h4>
<ul>
<li><a href="https://wordpress.org/plugins/wt-woocommerce-sequential-order-numbers/" rel="ugc">Sequential Order Number for WooCommerce by WebToffee</a></li>
<li><a href="https://wordpress.org/plugins/print-invoices-packing-slip-labels-for-woocommerce/" rel="ugc">WooCommerce PDF Invoices, Packing Slips, Delivery Notes & Shipping Labels by WebToffee</a></li>
<li><a href="https://wordpress.org/plugins/woo-advanced-shipment-tracking/" rel="ugc">Advanced Shipment Tracking for WooCommerce</a></li>
<li><a href="https://woocommerce.com/products/shipment-tracking/" rel="nofollow ugc">WooCommerce Shipment Tracking</a></li>
<li><a href="https://wordpress.org/plugins/woocommerce-pdf-invoices-packing-slips/" rel="ugc">WooCommerce PDF Invoices & Packing Slips</a></li>
<li><a href="https://wpovernight.com/downloads/woocommerce-order-proposal/" rel="nofollow ugc">WooCommerce Order Proposal plugin</a></li>
</ul>
<h4>Premium Version Features: Order Export & Order Import for WooCommerce</h4>
✅ Flexible Export Formats: Export WooCommerce orders, subscriptions and coupons to CSV/XML/Excel (XLS/XLSX) file formats. 
 ✅ Versatile Import Formats: Import WooCommerce orders, subscriptions and coupons using CSV/XML/Excel (XLS/XLSX) file formats. 
 ✅ Subscription Order Management: Import and export subscription orders to streamline recurring order handling and save time. 
 ✅ Custom Field Support: Import and export custom fields, including data from third-party plugins, for complete and flexible order management. 
 ✅ Third-Party Plugin Compatibility: Works with popular <a href="https://www.webtoffee.com/order-import-export-plugin-for-woocommerce-third-party-compatibility/" rel="nofollow ugc"> third-party plugins </a> to ensure smooth import and export across your store setup. 
 ✅ Column Mapping: Map columns to WooCommerce order or coupon fields, allowing imports from any CSV format. 
 ✅ FTP Integration: Import and export orders directly via FTP for easy remote file transfers and automated workflows. 
 ✅ Automated Imports & Exports: Use Cron Jobs to automatically import and export on a set schedule, without manual work. 
 ✅ Dedicated Support: Get expert assistance to help you set up and manage imports and exports with ease.
For complete list of features and details, please visit <a href="https://www.webtoffee.com/product/order-import-export-plugin-for-woocommerce/?utm_source=free_plugin_readme&utm_medium=order_import_export&utm_campaign=Order_Import_Export" rel="nofollow ugc">Order Export Import Plugin for WooCommerce</a>.
Note: Please note that the below section applies to our free version and premium version. While the flow is the same, some of the features are only available in the premium version.
<h4>How to Export Orders from WooCommerce?</h4>
The Order Export & Order Import for WooCommerce Plugin’s simple interface makes it extremely easy to map the data in your CSV file to the appropriate fields in WooCommerce. The order import export plugin supports custom fields, dates, and pretty much every other WooCommerce Order / WooCommerce Subscription / WooCommerce coupon field.
Our order export plugin helps you to export WooCommerce bulk order data in XML format prescribed by other Service Providers. Using exported XML, you can import the orders to the Service Provider. The WooCommerce order export plugin also provides an option to export XML using WooCommerce format, using which you will be able to import the orders to another WooCommerce website.
Export WooCommerce Orders
Exporting orders from your WooCommerce store is quick and straightforward with the plugin.
<ul>
<li>Select the specific order statuses, subscription statuses, and coupon types you want to include in the export.</li>
<li>Customize the fields and data you wish to include in the exported file.</li>
<li>Ensure all required export options are configured for a smooth WooCommerce order export.</li>
<li>For order export to CSV, simply click the Export Orders button from the plugin page. </li>
</ul>
The plugin will generate an export orders CSV file containing all the selected order data.
<h4>How to Import Orders to WooCommerce?</h4>
The Order Export & Order Import for WooCommerce Plugin’s simple interface makes it extremely easy to map the data in your CSV file to the appropriate fields in WooCommerce. Whether you’re importing orders or handling a coupon CSV import, the plugin provides a user-friendly experience that simplifies the entire process. The import WooCommerce orders plugin supports custom fields, dates, and pretty much every other WooCommerce Order / WooCommerce Subscription / WooCommerce Coupon field.
Our order import plugin is designed to be efficient with large imports as it splits large import files into smaller chunks, making it possible to import large files with thousands of data and records, even on slow hosting providers. All the data in the import file CSV will be automatically added to your WooCommerce store upon successful import.
Import WooCommerce Orders
Importing WooCommerce orders using a CSV file is simple and efficient with the plugin.
<ul>
<li>To Import WooCommerce Orders, select Order as post type from the plugin page. </li>
<li>Upload the order import CSV file using a preferred import method. </li>
<li>Manually map columns to the correct WooCommerce field to ensure accurate data import.</li>
<li>Set batch count, enable order updates, and save settings as a reusable template for later imports.</li>
<li>Click Import to begin the WooCommerce import orders process. </li>
</ul>
Please refer to the <a href="https://www.webtoffee.com/setting-up-order-import-export-plugin-for-woocommerce/" rel="nofollow ugc">order export import plugin</a> documentation for more detailed help.
Highlights: Simply Export Orders, Customer Order CSV Export, Export Orders to Excel, Export Coupons, Import Coupons, Export Subscriptions, Import Subscriptions. Best WooCommerce Order Export Plugin in Market.
<h3>RELATED PLUGINS FROM WEBTOFFEE</h3>
🔸 <a href="https://wordpress.org/plugins/wt-woocommerce-sequential-order-numbers/" rel="nofollow ugc">Sequential Order Number for WooCommerce</a>: Easily manage orders with all the order numbers sorted sequentially. 
🔸 <a href="https://wordpress.org/plugins/product-import-export-for-woo/" rel="nofollow ugc">Product Import Export for WooCommerce</a>: This free plugin will help you import and export products from your store using a CSV file. 
🔸 <a href="https://wordpress.org/plugins/users-customers-import-export-for-wp-woocommerce/" rel="nofollow ugc">Import Export WordPress Users</a>: Import and export the users in your WordPress store using a CSV file with the help of this plugin. 
🔸 <a href="https://wordpress.org/plugins/wp-migration-duplicator/" rel="nofollow ugc">WordPress Backup & Migration</a>: Quickly migrate and backup entire WordPress site or selected files from one location to another. Backup to FTP, Google Drive, Amazon S3, or local storage and easily restore them back. 
🔸 <a href="https://wordpress.org/plugins/webtoffee-product-feed/" rel="ugc">WebToffee WooCommerce Product Feed & Sync Manager</a>: Generate WooCommerce product feed for Google, Facebook and Instagram Shops and sync WooCommerce products with Facebook catalog. 
🔸 <a href="https://wordpress.org/plugins/wt-gift-cards-woocommerce/" rel="ugc">WebToffee Gift Cards for WooCommerce</a>: Create and sell gift card in your WooCommerce store. Allow your customers to buy, redeem, and share gift card. 
🔸 <a href="https://www.webtoffee.com/product/gdpr-cookie-consent/?utm_source=free_plugin_readme&utm_medium=order_import_export&utm_campaign=GDPR" rel="nofollow ugc">GDPR Cookie Consent</a>: This plugin helps websites comply with GDPR, CCPA, and other privacy regulations by displaying a customizable cookie consent banner. Manage cookie categories, log consents, and implement prior consent for cookies.
<h4>About WebToffee.com</h4>
<a href="https://www.webtoffee.com/" rel="nofollow ugc">WebToffee</a> creates quality WordPress/WooCommerce plugins that are easy to use and customize. We are proud to have millions of customers actively using our plugins across the globe.

Order Export & Order Import for WooCommerce

Tank you; your plugin is great and works perfectly

Work perfect


Added it. Then went to use it and could not find the interface. Checked the description and faq. Still couldnt find where to start so I moved on to another solution. Super annoying. If this does work really well, add a clear description of where to find it on admin menu.


Couldn't find the interface, moved on to another solution


Fácil usar. Acho q faltou uma opção de exportar logs no formato csv. Mas é muito bom o plugin


Muito bom


Not overly intrusive and provides a truly great function for a free plugin!


Does what it says


just wasted an hour and half with everything else, this did it in less than 5 mins



10/10


SAVE YOURSELF TIME & USE THIS FIRST

The best order export import plugin for WooCommerce. Easily import and export WooCommerce orders and WooCommerce coupons using CSV.

Event Organiser CSV vs Order Export & Order Import for WooCommerce