• General Settings

  General Settings Access the "Settings Page": Modify Defaults The settings configured on the Settings page serve as the default for your reports.. | If you need different settings for your report, check out the Report Settings Notification The app will sendFew readers

• Set the Value of a Column

  Set the Value of a Column Here you can find our YouTube tutorial: The value of a column can be set in the Report Editor: Layout Mappings Rows (only for position "after each new item" and "before each new item") Access Selected Columns and Evaluate Mathematical Expressions Insert a column value Find the field you neSome readers

• Regex for Search and Replace

  Regex for Search and Replace The Search and Replace function allows you to find specific words or character sequences in your data and replace them with alternative values. For more advanced use cases, Regular Expressions (Regex) enable you to define text patterns. This is especially useful for standardizing data formats. For example, you can use regex to identify all phone numbers with an international prefix and convert them into a consistent local format across your reFew readers

• Date Format

  Date Format To change the date format of a field, click on "Format options" located on the right side of the field. To customize the presentation of date values, specify the desired format. Only set this if you need formatted date values, such as for CSV files. || When a format is applied, the column will be treated as text in Excel and will no longer be recognizeSome readers

• Custom Term Filter

  Custom Term Filter This feature allows you to search similarly to Shopify's search bar. It enables advanced filtering for specific content. For example, you can search for orders that include certain products (SKUs, product names) within the order. Orders Use the custom term as shown in this example: The output for this example will be:Few readers

• Excel Formulas

  Using Excel Formulas in Your Export With DataChamp, you can add custom columns with Excel formulas to your Excel exports. 1. Select File Type First, click on “File Type” and choose “Excel”. 2. Add a Custom Column You can now add a custom column. In the Value field, enter an Excel formula, e.g. consecutive numbering: =ROW()-1 ||| The formula must alwaysFew readers

• Export Selected Orders

  Export Selected Orders With DataChamp, you can export selected orders directly from Shopify. To do this, go to the Shopify orders overview ( 1 ) and select the orders you want to export ( 2 ). Then, click on the "three dots" ( 3 ) at the bottom of the orders overview and choose "DataChamp Export" ( 4 ). ![](https://storage.crisp.chat/users/helpdesk/website/d00f55635133d800/export-Few readers

• Incremental Exports

  Incremental Exports Incremental export in DataChamp refers to the process of adding new data to an existing Google Sheets file without overwriting the existing information. This ensures continuous updates while preserving historical data. Finding the Next Free Row: DataChamp searches for the next available row in the existing Google Sheets file. New data is appended starting from this row, ensuring that existing data remains intact. **Checking the Tab NameFew readers

• Metafields

  Metafields Metafields are custom fields that let you store and display specialized information about products, orders, and other objects in your Shopify store—details that aren’t available in the default Shopify admin. You can set up metafields directly in Shopify or by using third-party apps. DataChamp simplifies exporting those metafields. YouTube Tutorial Step by Step Tutorial First, createFew readers

• Date Filter and Date Calculations

  Date Filter and Date Calculations In this tutorial, you will learn how to use special filters and dynamic date calculations in DataChamp. We’ll use a real-world example: an order needs to be shipped tomorrow to arrive at the customer’s address in two days. Scenario: When a new order is placed, we automatically assign a tag containing the planned delivery date, such as 2025-08-02. This tells us the order must be shipped tomorrow to meet the **two-day deliFew readers