- 1. About Data Export Reports
- 1.0.1. Automate, Customize, Summarize and Analyze any Data (2000 data fields) in your Store!!
- 1.0.2. Here is how Shopify Owners are using Data Export:
- 1.0.3. Sales Reports
- 1.0.4. Tax reports
- 1.0.5. Cost of sales report
- 1.0.6. POS Reports
- 1.0.7. Shopify Payout reports.
- 1.0.8. Custom fields
- 1.0.9. Customer Reports
- 1.0.10. Fulfillment Reports
- 1.0.11. Shopify Reports
- 1.0.12. Discount Reports
- 1.0.13. Refund Reports
- 1.0.14. Product Reports
- 1.0.15. Other Reports
- 1.1. Integrates
About Data Export Reports
Automate, Customize, Summarize and Analyze any Data (2000 data fields) in your Store!!
Each Shopify store is unique and its reporting needs are different. Data Export team of reporting experts will create the right custom report or dashboard. Our team has created more than 10,000 custom reports for Shopify merchants.
We also believe a reporting app should not cost more than the Shopify plan itself.
- Data Export provides line level detail and summary of the data. Summary of the data is through Pivot table in Excel. For example, sort and summarize order detail for any date range.
- Google Sheet Export – “Overwrite” function will overwrite the daily export. “Add” function will add new tabs (sheets) in the same Google Sheet file. “Append” function will add new rows at the bottom of the data set. Connect to Google Data Studio to create custom dashboards.
- Import data into reports through Google Sheets – Data Export can retrieve data from Google Sheets.
- Export reports through Email, FTP/SFTP and Google Drive.
Here is how Shopify Owners are using Data Export:
Sales Reports
- Sales By – Country, Draft Orders, Product Type, Product, UTM source, Referring site, Vendor, Order Source, Gift card, Discount Code, Month, Week, Year, Year to date, Month to date and custom range
Tax reports
- Based on customer location. Sales tax collected by state and county. GST, VAT reports and Germany Tax reports
- Tax Reports By – Country, State, County, Product, Tax Rate, Tax refunds
Cost of sales report
- Product profitability reports. Enter product cost in Google Sheets to import into Data Export to calculate profitability
POS Reports
- Transaction, POS Location and employee sales reports
Shopify Payout reports.
- Accountants can now automate manual Bank reconciliations
Custom fields
- Metafields, Line Item properties and Cart/Note attributes
- Fetch data from Shopify apps like Metafields Manager, Infinite Options, Product Options, Local pickup and Delivery and many more apps
- Data Export can work with drop ship or fulfillment vendor API’s
Customer Reports
- First time customer vs. returning customers, High value customers, Customer purchase frequency, Customer using Discount codes
Fulfillment Reports
- Partial or Full Fulfillment, Pending Fulfillment
Shopify Reports
- Automate Shopify's Order, Product & Finance summary reports
Discount Reports
- Discount Code Reports By – Discount start date, end date
Refund Reports
- Refunds By – Product, Country, Shipping Refunds, Refund adjustments
Product Reports
- Product sold by SKU, Units, Dollars, Inventory value and count. Inventory threshold.
Other Reports
- Shipping Label and Shipping Profit reports
- Google Shopping and Bing Feeds
- Industry specific custom reports
- Match Paypal and Stripe Payment gateway transaction IDs
Integrates
- Google Sheets,
- Google Drive,
- Email,
- Google Data Studio,
- FTP,
- SFTP
Pricing
15-day free trial
All charges are billed in USD. Recurring charges, including monthly or usage-based charges, are billed every 30 days.