=== WooCommerce - Store Exporter ===
Contributors: visser, visser.labs
Donate link: https://www.visser.com.au/donations/
Tags: e-commerce, woocommerce, shop, cart, ecommerce, export, csv, xml, xls, xlsx, excel, customers, products, sales, orders, coupons, users, attributes, subscriptions
Requires at least: 2.9.2
Tested up to: 4.7.5
Stable tag: 1.8.6
License: GPLv2 or later
Export store details out of WooCommerce into simple formatted files (e.g. CSV, XML, Excel 2007, XLS, etc.).
== Description ==
Screen-loads of options and filters let you design advanced exports to suit your store requirements, or simply go with the default and click Export to produce concise, ready to use exports.
Store Exporter maintains compatibility with the latest WooCommerce updates receiving regular feature updates trusted by 20,000+ active users. Happy exporting!
= Features =
Features include:
* Export Products (*)
* Export Products by Product Category
* Export Products by Product Status
* Export Products by Type including Variations
* Export Categories
* Export Tags
* Export Brands (*)
* Export Orders (*)
* Export Orders by Order Status (*)
* Export Orders by Order Date (*)
* Export Orders by Customers (*)
* Export Orders by Coupon Code (*)
* Export Customers (*)
* Export Customers by Order Status (*)
* Export Users
* Export Coupons (*)
* Export Subscriptions (*)
* Export Commissions (*)
* Export Product Vendors (*)
* Export Shipping Classes (*)
* Export Attributes (*)
* Toggle and save export fields
* Field label editor (*)
* Works with WordPress Multisite
* Export to CSV file
* Export to TSV file (*)
* Export to XML file (*)
* Export to Excel 2007 (XLS) file (*)
* Export to Excel 2013 (XLSX) file (*)
* Export to WordPress Media
* Export to e-mail addresses (*)
* Export to remote POST (*)
* Export to remote FTP (*)
* Supports external CRON commands (*)
* Supports scheduled exports (*)
(*) Requires the Pro upgrade to enable additional store export functionality.
> ** Go Pro **
>
> Unlock the business focused e-commerce features within Store Exporter such as scheduled exporting from [this link](http://www.visser.com.au/plugins/store-exporter-deluxe/).
>
> Full documentation and usage of Store Exporter Deluxe is available from the [support section for Store Exporter Deluxe](http://www.visser.com.au/documentation/store-exporter-deluxe/).
= Native integration with 50+ WooCommerce Plugins =
Just a few of the features unlocked in the Pro upgrade of Store Exporter include:
- Export All in One SEO Pack
- Export Advanced Google Product Feed
- Export Product Addons
- Export Sequential Order Number Pro
- Export Checkout Manager
- Export Checkout Manager Pro
- Export Checkout Field Editor
- Export Cost of Goods
- Export Per-Product Shipping
- Export Print Invoice & Delivery Note
- Export Local Pickups Plus
- Export WooCommerce Subscriptions
- Export Checkout Field Manager
- Export Currency Switcher
- Export WooCommerce PDF Invoices & Packing Slips
- Export WooCommerce Checkout Add-ons
- Export Product Vendors
- Export WooCommerce Jetpack
- Import fields for Product Importer Deluxe
... and more free and Premium extensions for WooCommerce.
Want regular updates? Become a fan on Facebook!
http://www.facebook.com/visser.labs/
For more information visit: http://www.visser.com.au/woocommerce/
== Installation ==
1. Upload the folder 'woocommerce-exporter' to the '/wp-content/plugins/' directory
2. Activate 'WooCommerce - Store Exporter' through the 'Plugins' menu in WordPress
See Usage section before for instructions on how to generate export files.
== Usage ==
1. Open WooCommerce > Store Export from the WordPress Administration
2. Select the Export tab on the Store Exporter screen
3. Select which export type and WooCommerce details you would like to export
4. Click Export
5. Download archived copies of previous exports from the Archives tab
Done!
== Support ==
If you have any problems, questions or suggestions please join the members discussion on our WooCommerce dedicated forum.
http://www.visser.com.au/woocommerce/forums/
== Screenshots ==
1. The overview screen for Store Exporter.
2. Select the data fields to be included in the export, selections are remembered for next export.
3. Each dataset (e.g. Products, Orders, etc.) include filter options to filter by date, status, type, customer and more.
4. A range of export options can be adjusted to suit different languages and file formatting requirements.
5. Export a list of WooCommerce Product Categories into a CSV file.
6. Export a list of WooCommerce Product Tags into a CSV file.
7. Download archived copies of previous exports
8. Use the Field Editor to relabel export fields to your preferred names
9. Drag-and-drop export fields to your preferred ordering, sorting is saved between screen refreshes.
== Disclaimer ==
It is not responsible for any harm or wrong doing this Plugin may cause. Users are fully responsible for their own use. This Plugin is to be used WITHOUT warranty.
Hey! Does this plugin work on a multisite site? I installed the lite version and it comes up with an error when I click “export” from the plugins page. The error is “You do not have administrator privileges for this dashboard” even though I am logged in as super admin. I also tried to create an admin for the site and log in and do it but same error message. Any Ideas?
Hi james, thanks for raising this. Store Exporter is not compatible with multisite environments, if you can get in touch via Contact I would be happy to work with you directly to add support for this in a future Plugin update.
I bought this plugin expecting that it would give me a list of exported products and product quantities. I really need this so that I can adjust inventory levels in our accounting software automatically. Is there any chance this could be added? I believe I would need the addition of at least SKU, variation description (and perhaps ID), qty ordered, and perhaps cost. I know this is more difficult being an undefined number of products, but it could be done either with multiple rows per order or with a character-separated list per entry.
Also, I use Spanish characters and your present Store exporter plugin does not render the accents– instead, it gives gibberish.
Hi nbruley, can you please confirm what e-Commerce platform you’re using.
For some reason the categories are not pulling in to the export, I’m running the latest versions of everything if that helps.
Hi Ryan, can you please confirm what platform you’re using.
Hi I can’t get permissions to work.
uploaded pdf set permissions to subscriber.
when logged out of wordpress can still download document.
Is there something I’m supposed to add to the generated shortcode?
also I reset a whole category to subscriber but it didn’t go through and change all the documents.
opps sorry pasted the wrong text, ignore above message!
Was wondering if you could give some pointers as to where in the code I could add additional fields to export?
Hi cassandra, I’ve added some new hooks/filters to the latest Plugin update and will add a sample to the Usage document for this Plugin demonstrating this. I expect this to be ready by Monday.
I purchased Jigoshop Product Importer Deluxe and then installed Exporter 1.2.4 so I could have a template to use to start importing everything.
Unfortunately I am getting the following error when trying to start the export in wordpress. Not sure what is wrong or what URL that is trying to refer to.
Any idea how to fix this?
“This webpage is not found
No webpage was found for the web address: http://photos.goldeditions.com/wp-admin/admin.php?page=jigo_ce
Error 6 (net::ERR_FILE_NOT_FOUND): The file or directory could not be found. “
Hi scott, please update to the latest release from WordPress.org, I’ve released a major Plugin update to resolve some export issues.
http://wordpress.org/extend/plugins/jigoshop-exporter/
I have same problem with woocomerce export
“This webpage is not found http://site.com/wp-admin/admin.php?page=woo_ce&tab=export#export-products
Error 6 (net::ERR_FILE_NOT_FOUND): The file or directory could not be found. “
Hi bagow, this is a common error that can look like this error too:
“PHP Fatal error: Maximum execution time of 30 seconds exceeded…”
Your WordPress site is either hosted on a server with Safe Mode enabled for PHP or a server timeout is being imposed; which we already do our very best to override.
safe_mode outdated and it is recommended not to use the latest versions of php. And I do not use it on my server.
I increased the limits in your script
$ timeout = 60000;
Removed the check for safe_mode. I increased the limit execution of scripts on the server. And it does not help.
I have in store 6000 items. When I export categories and customers, all right.
What else could be the problem?
Sorry for my English.
Hi bagow, setting $timeout to 100000 won’t make a difference if the server is not allowing us to override the default timeout limits.
Due to the large volume of SQL queries made when exporting Products it is common to get the above errors where we can’t override those server timeouts.
What I will do however is add partial Product exporting as an option (e.g. export Products 0 – 500, then export 501 – 1000, etc.) as individual CSV files, this way we can get under the timeout limits by limiting the number of Products exported. I’ve added this to my Job queue and will get it into the next Plugin update. 🙂
When do you plan to update?
Hi bagow, recent Plugin updates include support for offset and limit volume options as explained above.
I just tried to export products form jigshop which is still in staging environment, but got an fatal error, see below??
Regards, stephen
Fatal error: Cannot use object of type stdClass as array in /home/hamel21/domains/opjacht-test.nl/public_html/mnu/wp-content/plugins/jigoshop-exporter/includes/functions.php on line 442
Hi Stephen, please download the 1.2.5 Plugin update I released this morning.
I just installed the Jigo – Exporter, and I can’t seem to find where I initiate the exporting process. The instructions says go to “Open Jigoshop > Store Export from the WordPress Administration”. I don’t see where this menu is.
Thanks!
Hi Nesha, I’ll check this over and release a patch if required.
Installed 1.3.3, when I click on STORE EXPORT i get:
Fatal error: Call to undefined function wpsc_ce_template_header() in /home/headsets/public_html/wp-content/plugins/wp-e-commerce-exporter/exporter.php on line 101
Hi Ray, thanks for raising that, patching now.
Update: Please update to 1.3.7 from WordPress.org, I’ve updated the link above.
Thanks for your reply Mike – different line now:
Fatal error: Call to undefined function wpsc_ce_template_header() in /home/headsets/public_html/wp-content/plugins/wp-e-commerce-exporter/exporter.php on line 124
WP Version: 3.4.2
Store Export: 1.3.7
WP-Commerce: 3.8.9.2
I noticed when I extracted the ZIP that the archive: wp-e-commerce-exporter packaged: Mon, 12 Nov 2012 21:47:53 +0000 – which is prior to your reply on the 19th.
Hi Ray, I’ve e-mailed you the latest early release. If this does not work I recommend removing the Plugin, deleting the files and re-installing the Plugin.
Michael;
Thanks for all your support and insight on this issue which actually turned out to be MY problem. 5 stars.
I have the same problem as well..it’s not showing product weight.
Cheers…
Hi Mrlamzz, as below, I’ll confirm that we’re linking to the right Product details as there have been significant structure changes in WooCommerce.
Same issue here — weight isn’t showing up, and nor is “excerpt” or “variations.”
The “excerpt” doesn’t seem to export. I have data in the excerpt field but nothing exports.
Hi Jason, thanks for raising this, I’ll look into this once our urgent work is out of the way. It’s likely we’re linking to a wrong Product detail. I’ll patch this in the next Plugin update.
I love this plugin!
Is there any way to get it to export product attribute date? I populate an attribute field that I use to generate picking reports from.
Thanks,
Jason
Hi Jason, just to confirm, are you referring to a Product Attribute you’ve created called ‘Date’ or is this the Post Date?
Hi Michael,
Any chance to also export the product image links please?
I’m trying to use this plugin to import products into Google Merchant.
Cheers,
Hi Ivan, I’ll cook this into the next Plugin update. Were you thinking the original image size or a specific WordPress image thumbnail size?
When is this going to happen?
Hello i have payd for exporter deluxe but still not have image url! i did 4 support and nobody answer me.
Hi lododicesimo, we’ll follow this up via your Premium Support ticket. I’m looking at this now.
Did the new GoldCart ever come out?
Hi Jeremy, I cannot see from the GetShopped.org that a new release has been made. I’ll make an enquiry into this.
I installed this plugin to export the product from our store to a CSV but the plugin is not showing that we have any products?
Hi Mike, please ensure you have enabled WP e-Commerce and Store Exporter, the Store Export menu item is found under Products > Store Export.
Hey.
I have had a few WooCommerce project over recent months and I am rather baffled at the lack of a comprehensive Exporter extension.
From hours on the ol’ interwebs I can find Exporter (your plugin), Smart Manager and Order/Customer CSV Export from Woo themselves.
All of these have positives but none do what I find clients want time and time again and that is real granular control over what data is either exported or exportable.
Take for example I have a store selling t-shirts. I have a few hundred orders and want to export some of that data for whatever shopkeeping reason. Let’s say I want First Name, Last Name, Order id, T-shirt purchased and it’s corresponding variations e.g. large and blue.
In this scenario the exported csv file would look something like this in Excel:
First Name Last Name Order id Product Variation (size) Variation (color)
Bob Smith #123 Retro T-shirt Large Blue
And in addition, it would be great to be able to, for example, search for ‘Retro T-shirt’, ‘Blue’ and be able to export orders containing those variables.
The closest I’ve found out of the available plugins is Smart Manager but it won’t let you choose which columns to export and even worse, doesn’t include any variation data, which is a disaster.
I don’t know if you have used Gravity Forms but it has a fantastic export feature where you can choose exactly the form fields you want to export.
http://www.gravityhelp.com/documentation/page/Import/Export http://www.gravityhelp.com/documentation/page/File:Export-entries.png
I wish I had the developer skills to create something like this myself, as I think it would make a lot of people very happy.
Anyway, I’d love to hear your thoughts on this as you’ve actually created an exporter plugin.
Cheers,
David
Hi David, thanks for your comment, I’ve added initial column export support for Products and plan to extend this feature to include Sales and other store details (e.g. Shipping rules, Tax rules, Discounts, etc.).
I’ll be releasing the next Plugin update in a few days to update Products support and would be happy to work with you to lock down the requirements and formatting for Sales CSV exports.
Not sure if this is what you’re describing, but I’m looking to be able to export a list of customer names listed with the products they bought. Is this what you’re describing?
We need to be able to export + print the list so that we can look up customers as they come in and give them the items they purchased.
Hi Lauren, this is one of the CSV templates I’ll be putting together, as below, happy to collaborate with you to lock down the table columns, etc. 🙂
Hi Michael – thanks for being so accommodating and interested in what your users want. I think that’s great!
The table columns I’m looking to have in one exported file are:
Customer Name | Products Purchased (from all of their transactions within a specified date range – if possible) | Product Add-ons (this is another plugin/extension I’m using, and it adds info into the order)
So if a customer had multiple transactions within a date range it would be something like this:
customer A | product 1 | product add-ons
customer A | product 2 |
customer A | product 3 |
customer B | product 1 | product add-ons
(only some of my products have add-ons)
My explanations above might be totally unclear – just let me know if you need any clarifications or if you want to talk further about this. I’m subscribed to the replies on this page, but you can also email me at lauren[at]byoconsulting[dot]com
Hi Lauren, I’ve marked this feature for inclusion in the 1.0.6 Plugin update to match your guidelines (without the date period selection).
Hi Michael.
I’d be happy to work with you on this.
Feel free to email me david[at]sunstarcreative.com and let me know how I can help and how you want to move forward.
Hi David, please download the 1.0.5 Plugin update from WordPress.org, happy to extend available features via e-mail.
Any idea of when you’ll be releasing the next update?
Any chance of exporting orders too?
Thanks!
Hi Orlando, I’ve added Sales/Orders support in the 1.0.5 Plugin update available now, it’s pretty basic but I’d like to work with WooCommerce store owners to extend the available Sale/Order fields. Feel free to get in touch if you have any ideas of additional export columns for Sales/Orders.