All about exports
Metorik makes it easy to get the data you need when you need it. You can export from any 'resource page', like orders and customers. When exporting, you can either export immediately or make an export recurring.
At the moment, exports are CSV files.
Watch a video
This allows you to export right there and then. If the size of the export is large (eg. 10,000 orders), the export will be emailed to you. Otherwise, the export will be emailed to you (your account's email) a few minutes later when it's ready.
Alternatively, you can set up an export to be recurring. This takes a few moments to set up but will save you from visiting Metorik every day, week, or month to export your data.
Keep in mind, recurring exports take into account all the filters, ordering, and export settings you've set up.
To start, hit the export button on any resource page. You should then click the 'recurring' button (see image above). It's now time to configure the recurring export:
Enter the email(s) you want to send the export to. You should then set the frequency (daily/weekly/monthly) and the date/time to send it. Finally, give it a name so you and others receiving the export know what it contains. Sometimes you'll see an Export Settings button, allowing you to customise aspects of the export.
When you export products, categories, and coupons, they will automatically include sales numbers for the previous period. That period is decided by the frequency. So a weekly products export would contain sales numbers for the previous week.
For orders, customers, and subscriptions exports, you'll likely want to set up a date-related filter, so each export contains new data. For example, if you set up a monthly orders export, you may only want it to have orders made in the last month too.
First, set up a filter like 'orders created in the past 1 month':
Then when creating the recurring export, simply set the frequency to be 'monthly'.
You can view your saved exports at any time from the Exports page - only exports you created for the current store will be here.
From there, you can pause/activate/delete any exports or force exports to happen immediately.
Sometimes you'll have settings available for customising the export:
Click the link and any settings available will be displayed:
Include meta: Add certain custom meta values if they exist for the order or customer (help doc).
One row per item: Output order line items on their own line with quantity and price information.
Delimiter: The character used to separate each column in the export. By default, it's a comma: ','.
In the export settings, you'll find an option that allows you to customise the columns of the exported file.
You can do this to only include the information you need in an export or change the order of the columns.
If you've checked the one row per item setting, you'll also be able to customise the line item columns (and order of them):
At the moment, all dates in exports are the dates in your store's timezone. This is the timezone normally defined in the WooCommerce store's WordPress general settings and in the Metorik store settings. Would you like to see the dates output in UTC? Let us know and we'll consider adding a setting for it.
Sometimes the columns in exports can be a bit unclear as to what they represent. If you want to clarify what any of them are, please feel free to reach out to our team. We'll also list a few of them here:
- Customers: subscription count - Active Subscription Count (varies based on your store settings).
- Customers: subscription churned count - Churned Subscription Count (varies based on your store settings).