Data Extraction and Reporting
Export any data.
In any format.
Build custom reports to gain valuable insights, boost productivity, feed other systems, and more!Start free trial
Xporter, recommended by Annie Glass.
Xporter, recommended by Edie Parker.
Xporter, recommended by Goop.
Pull customized reports quickly and easily.
Rally everyone around a unified data set
Generate business insights that will help you make the right decisions.
Save time, money and energy and add value to your organization.
CSV spreadsheet, Excel Spreadsheet, text file, HTML file, XML file, PDF File.
Export any data accessible through Shopify’s API: customers, orders, transactions, refunds, checkouts and more.
Lay out the data to reflect your specific reporting needs.
Create and manage customizable email notifications and updates when a new report is available.
Get automatic emails and transfers to various servers (FTP, SFTP, FTPS, SCP).
Calculate extra fields that Shopify doesn't provide in their regular exports and enjoy greater access to your store information.
Take a look into customizing your report using "Top-Level Items" and "Join Separators.”
You'll be billed monthly as part of your regular Shopify invoice. The charge for Xporter will appear under the heading Xporter by modd, followed by the name of the plan that you've chosen.
Depending on the fields and the size of the dataset, some reports take more time to process. Those above a certain threshold get placed into a queue so that you don't time out and hit a white screen when trying to make a report.
Please contact us at firstname.lastname@example.org. We'd be happy to discuss your needs and will look into including your export request in the next version of Xporter.
A. Oddly enough, Excel doesn't read CSVs properly out of the box. You actually can't just open a CSV with Excel and expect it to work properly. You have to "import" it though other office suites like LibreOffice will open it up just fine. To fix this, read more on the subject here.
provide apps with information about line item level discounts or refunds. So we have to guess. We take the total amount discounted, or the total amount refunded, and we amortize it over the line items and their actual amounts paid. So the amounts, when added up over the line items of an order, will work out to the total discount/refund, but the individual line item totals may or may not be accurate. We do tricks like back-calculating taxes to determine the actual price of an item, but there's only so much we can do when Shopify simply doesn't give us the information.
We've recently added a new filter to Xporter's liquid processor. The date_math filter can now be used to add quantities of time to a date/time field. For example, let's say you wanted to filter out all line items that were purchased at least three months ago. To do this, you must choose to filter orders by "Liquid", and then enter the following: order.created_at < now | date_math: -3, 'months' This will filter out all orders created more than 3 months ago.
When we say dataset, we're talking about all of the information we need to export your report in the format that you've specified. In this context, the word size is hard to define. By clicking a single checkbox you can vary the size of your dataset hugely. A small dataset is classified as anything under 10,000 units. A large dataset is anything between 10,000 and 100,000 units. A unit is a measurement of work that the server has to do to fill in your report. Three separate elements of your report contribute to the final unit count.
Currently, there is no limit to the amount of reports that you can generate, but keep in mind that you can only ever generate two reports at the same time.
Send us an email at email@example.com. We'd love to answer any questions you have. We'll even set up your first report for you if you like!
Reports will be stored indefinitely on our servers for your convenience. If we decide to remove old reports from our servers, we’ll send you an email at least a month in advance detailing exactly what will be deleted and when. That will give you plenty of time to back up and save your old reports.Get help