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.