DataChamp: In-Depth Features
Comprehensive Data Export Capabilities
Orders
- Export all order details: financial status, fulfillment status, risk levels, referring site, landing page, order notes, tags, and more.
- Detailed Line Item exports: SKUs, quantities, prices, discounts, taxes, product titles, variant titles, properties, and line item Metafields.
- Fulfillment Data: tracking numbers, carriers, fulfillment dates, locations.
- Refund Data: full and partial refunds, refund reasons, refunded quantities.
- Tax Lines: detailed tax information per line item and shipping.
- Shipping Lines: shipping methods, amounts, addresses.
- Discount Applications & Codes: track discount usage and amounts.
- Transactions & Payments: gateway information, payment methods, amounts, transaction IDs.
- Draft Orders: include or exclude draft orders from your exports.
Products & Inventory
- Full Product Details: titles, descriptions, vendor, type, tags, status, publication dates, SEO fields.
- Variant Information: SKUs, barcodes, options (size, color), prices, compare-at prices, inventory quantities per location, weights, taxable status.
- Inventory Levels: track stock quantities across multiple locations.
- Collections: export product membership in manual and smart collections.
- Product Metafields: access and export all custom data associated with products and variants.
Customers
- Comprehensive Customer Data: names, email addresses, phone numbers, addresses (default and additional).
- Order History Summary: total spent, number of orders.
- Customer Tags & Notes: include segmentation data and internal notes.
- Accepts Marketing Status: track email and SMS marketing consent.
- Customer Metafields: export all custom fields associated with customer profiles.
Payouts & Transactions
- Detailed Shopify Payout reports.
- Individual transaction data associated with payouts.
Other Data Types
- Draft Orders, Gift Cards, Discount Codes, and more as supported.
Unmatched Customization & Report Building
- Intuitive Report Editor: User-friendly interface to build reports from scratch or modify templates.
- Extensive Field Selection: Access hundreds of Shopify fields across all major data entities.
- Custom Columns:
- Add an unlimited number of custom columns to your reports.
- Populate with static text, combine existing fields, or use advanced logic.
- Calculated Fields:
- Perform mathematical operations (+, -, *, /) on numeric fields.
- Manipulate text data (concatenate, extract substrings).
- Format dates and numbers.
- Data Mapping & Transformation:
- Use IF-THEN-ELSE conditional logic to transform data within columns.
- Look up and map values based on other fields.
- Column Management:
- Easily rename column headers to match your exact requirements.
- Drag-and-drop to reorder columns.
- Pre-built Report Templates: Get started quickly with common export scenarios.
- Save & Manage Custom Templates: Create and reuse your own tailored report structures.
Full Metafield & Custom Attribute Support
- Universal Metafield Access: Export Metafields from Orders, Products, Variants, Customers, Collections, Line Items, and more.
- Simple Metafield Selection: Easily find and include Metafields by their namespace and key.
- Metafields as Distinct Columns: Each selected Metafield appears as its own column in the export.
- Support for All Metafield Types: Handles text, numbers, dates, JSON strings, lists, and other Metafield types.
- Filter by Metafields: Use Metafield values as criteria in your report filters.
Powerful Automation & Scheduling
- Flexible Scheduling Options:
- Run exports daily, weekly, or monthly.
- Specify exact days of the week or month.
- Set precise times for export execution (based on your store's timezone).
- Automated Delivery to Multiple Destinations: Configure reports to be sent automatically to your chosen services.
- Incremental Exports: Option to export only new or updated records since the last run.
- Reliable Background Processing: Exports run efficiently in the background.
- Run History & Logs: Track all scheduled and manual export activities.
Versatile Export Destinations & Connectivity
- Google Drive:
- Export directly to specific folders.
- Support for Shared Drives (Team Drives).
- Option to overwrite existing files or create new ones with timestamps.
- FTP / sFTP / FTPs:
- Securely deliver files to your own servers or third-party systems.
- Supports various protocols (FTP, sFTP with SSH Key or Password, Explicit FTP over TLS).
- Specify custom ports and remote paths.
- Email:
- Send exports as attachments to one or multiple email addresses.
- Customize email subject and body.
- Dropbox: Direct integration to send files to your Dropbox folders.
- Direct Download: Manually download any report directly from the DataChamp app interface.
- Google Sheets: Export data in a format easily importable or directly synced to Google Sheets.
Advanced Filtering & Data Segmentation
- Multi-Condition Filtering: Combine multiple filter rules using AND/OR logic.
- Broad Field Availability for Filters: Filter by almost any standard Shopify field.
- Filter by Metafield Values: Narrow down exports based on custom Metafields.
- Dynamic Date Range Filters: Use relative dates or specify fixed date ranges.
- Operator Variety: Use operators like equals, not equals, contains, does not contain, greater than, less than, starts with, ends with, is empty, is not empty.
Flexible Output Formats & Technical Options
- CSV (Comma Separated Values):
- Choose custom delimiters (comma, semicolon, tab, pipe).
- Control text quoting.
- Excel (XLSX): Native Excel format for easy use with spreadsheets.
- Character Encoding:
- UTF-8 (with or without BOM)
- ISO-8859-1 (Latin1)
- Windows-1252 (CP-1252)
- And others for specific language support
- Customizable File Naming: Define patterns for your exported filenames.
- Header Row Control: Option to include or exclude the header row.
- Line Ending Configuration: Specify line endings (CRLF, LF) for cross-platform compatibility.
User Experience & Administration
- User-Friendly Interface: Designed for ease of use.
- Report Preview: Preview a sample of your report data before running a full export.
- Clear Error Reporting & Logs: Easily identify and troubleshoot issues.
- Multi-Language Support: App interface available in English, German, and French.
- Secure & Reliable: Built with Shopify's best practices for security.
- Responsive Support: Access to a knowledgeable support team.