Exporting Data
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.
In this article
Video
Immediate exports
This allows you to export right there and then. If the size of the export is larger than 2,500 items, the immediate download option will not be available and the export will be emailed to you.
Recurring exports
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.
Creating
To start, hit the export button on any resource page. You should then click the 'recurring automatic export' button (see image above). It's now time to configure the recurring export:
Export name: This is just a name for personal reference and that will be used to describe the export when it's sent.
Export method: You can currently choose between Email and Slack.
Export to: If email, which email(s) should the export be sent to? If Slack, you can choose one channel/group for the exports to be sent to.
Frequency: Choose how often you want the export to happen (daily/weekly/monthly) and the date/time to send it.
Include summary: When enabled, exports will include a brief summary of the data in them. For example:
This export contains 500 orders. The total gross sales for these 500 orders was $4000. The average order was for $8 and contained 2 items.
Attach the CSV: if you'd like the recurring export to be attached to the email sent. It will only be possible if the exported file is under 8mb in size.
Dates
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'.
Managing
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 edit/pause/activate/delete any exports or force exports to happen immediately.
Editing export filters
By clicking on the edit icon on the right and then clicking on the Filters tab it will show the exact filters that are currently being used for the export.
You can simply edit any of these filter conditions and save. The export will now run using the newly saved filters.
Recent Exports
Metorik keeps a log of all exports created by you and by your team members.
You can find this on the Recent Exports page (under Exports on the left):
This can be quite useful, as it allows you to;
- See all recent exports made within the past 7 days.
- See information about recent exports, like what was exported, who by, and even how large the export was.
- For export, you can download it again instantly.
- See all exports currently in progress and the percent that has been exported.
Settings
In the export popup, you'll find a tab for the export settings:
Click it to find all available settings, which will differ based on what you're exporting:
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: ','.
Customising columns
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):
Load settings from a saved export.
If you would like to apply the same export settings as any of your Saved Exports you can do this by clicking on the button
And then selecting from any of your saved exports.
This will then apply all the export settings from that saved export to your new export.
At the moment, all dates in exports are the dates in your store's timezone. This is the timezone is defined in your store's 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.
Notes
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).