WooCommerce Subscriptions - include CSV export of active subscriptions
For digital subscriptions WooCommerce subscriptions works great. But for offline physical subscriptions like magazines there is some functionality lacking.
It would be nice to have some sort of CSV export available for active subscriptions so we can easily print shipping labels. Or alternatively integrate this into the CSV export plugin (which we also have).
Brent Shepherd commented
There are two options here:
1. Use the WooCommerce Customer/Order CSV exporter to export renewal orders for a given date range. This works if using Subscriptions as it is intended to be work, with aligned payment/shipping dates.
2. Use the Subscriptions CSV exporter available on Code Canyon: http://codecanyon.net/item/woocommerce-subscription-exporter/6569668 (this product is not supported via WooThemes, for support, please contact the author on Code Canyon).
Subscriptions expects billing dates to align with shipping dates (e.g. a $10 / month subscription should also ship monthly, not weekly). This is done so that renewal orders are generated for each shipment and therefore, it should be possible to use any extension that uses orders to manage shipping (for exporting shipping labels etc.).
If you have a different shipping schedule to the payment schedule (e.g. $100 / year subscription shipped monthly), then the Subscriptions CSV exporter plugin will help; however, there are other issues when this method, like the potential of mis-aligned expiration dates after suspension etc.
If selling subscriptions to physical products, please align the payment and shipping dates.
I agree - this is really needed. We need a button to print (or export to cvs) all active subscription addresses to product X.
thanks for the link on codecanyon, i'll check it out as well
I too came across WooCommerce Subscription Exporter (http://codecanyon.net/item/woocommerce-subscription-exporter/6569668). I just bought it and it certainly does do the job! Check the first comment on the CodeCanyon site to see all the fields that are included in the export.
Another thought is that there could be a shipping label export for this. So that we can easily print the shipping labels for physical item subscriptions, with reminders.
However I suppose that could be done easily with a mail merge if the subscription details were all exported to a CSV file or similar
+1, having export functionality for subscriber details would be a big help to us too.
Really need this.
We have a community/volunteer magazine for the Raspberry Pi that is published 11 months of the year (we are all volunteers so we take a break over Christmas to spend with family so don't do a January issue). Would be incredible if we could set months of the year where it will charge. For instance our ideal would be to set people up on a monthly subscription, but not charge anyone in December.
They have recently added the bulk suspend function (which I suggested somewhere below) which is helpful but still not ideal.
Anyway, definitley need a better way to export the live subscriptions. Currently we use the CSV export, and then manually delete all the cancelled/suspended ones out of that list and do a mail merge with MS Word. Very time consuming process and could be much improved.
For general sales in our shop, we use the Linnworks Woocommerce plugin (available outside of WooThemes site) and we export all orders through there and it generates the shipping labels for us. Ideally we would be able to export them to Linnworks each month, but that seems like a long shot at this point, so just a CSV export of the active subscriptions to start with would be a massive help!
Ramon Rivas commented
I would also add the following information to the list: Subscription Status, Number of renewals, Next Payment Date
It is so hard to be able to understand how our subscribers are behaving due to the lack of reporting with the subscriptions extension.
This is a big issue right now for us. There's no simple way to prepare our shipping labels every month.
Should also add that this should include expiry date so that we can include a printed reminder for those who need to renew.
In fact this sort of functionality might really benefit from Subscriptions being aware of the product publishing schedule - ie if a magazine is published every two months on the 1st, the system would be able to adjust for early payments and even sync payment dates so that a sub starts and ends in time with this