• Export Custom Attributes and Metafields

  Columns for Custom Attributes and Metafields In this tutorial, we’ll demonstrate how to use metafields in DataChamp. The tutorial below shows how to modify the layout. It serves as an example illustrating that any metafield or custom attribute works in a consistent way. First, setup up your report Create a new report and choose a product report. Include the columns you need. In this example, we included the Product Handle, Title, DescSome readers

• Product Feed

  Provide a Product Feed In this tutorial, we’ll show you how to easily create a product feed: A product feed is primarily used to send or synchronize product data with external platforms or merchants, ensuring that prices and product information are always up to date. DataChamp will generate a download link containing the latest products from your Shopify store. Example Feed URL: https://app.datachamp.io/feed/43b366e99157602d934027e0 ProdFew readers

• Add a Row for Refunded Quantity

  Add a Row for Refunded Quantity In this tutorial we will show you how to add an extra line that displays the refund quantity directly below the order quantity. We will create a new column that automatically displays the word "Refund" to highlight any order that has been refunded. These features are especially important for improving clarity and providing a better overview for your accounting and warehouse management teams. **Create an OrderFew readers

• Export Orders as Excel/CSV from Shopify

  Export Orders as Excel/CSV from Shopify Exporting Shopify orders with all details is essential for custom reporting and backup purposes. With DataChamp, you can easily export full order data from the Shopify database. Create a new report by clicking on the "New Report" button and select the "Basic report" in Orders. Design the report the way you need it: click on Browse and add fields, use filters, mappings, etc. Select the file type & file name Choose whetSome readers

• Custom Fulfillment Services

  Custom Fulfillment Service - Send Overview of New Orders In this tutorial, I’ll show you how to create a custom fulfillment service in Shopify and automate daily order reports using DataChamp. This setup is perfect for sending new unfulfilled orders directly to external warehouses — like our example warehouse in Vienna. If your Shopify store uses custom fulfillment locations ( Settings → Shipping and Delivery → Accounts and Integrations → CarrFew readers

• Additional Line from Column Value

  Additional Line from Column Value In this tutorial, we'll show you how to add extra rows using any data field: For example, if you want the "SKU" to appear as an additional line before each order line, follow these steps: Create a new report Click on the "New Report" button and select "Orders". Choose the necessary columns Don’t forget to select "Line Item: SKU". ![](https://storage.crisp.chat/users/helpdesk/website/-/d/0/0/f/d00f556Few readers

• Header Lines CSV

  Customize a report with both header and line items in a single CSV file. If you need a CSV file that includes: Header details Line item details you can create this structure using DataChamp. Line Identifier Order Number Details HEADER #01 Header details LINE #01 Line details Step-by-Step Guide to Configuring a CSV Export in DataChamp: Create a new report Click "New Report",Few readers

• Combine Two Fields

  Combine Two Fields Into One In this tutorial, we'll walk you through a simple example on how to combine two fields into one: Combine Address First Line and Second Line If you want to export only one address line column without losing the second line's information, you can combine both columns as follows: Select both address fields Use the search field (e.g., type "address" to quickly find the relevant fields. ![]Few readers

• Separate a Column into Two

  Separate a Column into Two In this tutorial, we’ll show you how to separate street name and street number into two distinct columns using the Shopify field "Address First Line". Steps to Split Address First Line: Create an Order Report Select the "Address First Line" field Use the search field (e.g., type "address") to quickly locate the relevant field. ![](https://storage.crisp.chat/users/helpdesk/website/-/d/0Few readers

• Append Rows in Google Sheets with Custom Columns

  Append Rows in Google Sheets with Custom Columns In this tutorial, we’ll show you how to append rows to a Google Sheet while keeping a custom column for manual notes or other details. This is useful if you want to export new orders to the same Google Sheet file daily, without overwriting existing data. Steps to Append Data in Google Sheets: Set Export Mode to "[Incremental](https://help.datachamp.io/en/article/increFew readers

• Replace a Single Row with Multiple Rows

  Replace a Single Row with Multiple Rows (e. g. for creating an Order Picking list) This tutorial explains how to break down a set product (= a product created as a single item in Shopify without using a bundle app) into its individual components. For example, if you sell a PC-Set that includes a pc, a keyboard, and a monitor, you may want to separate these items for reporting or order picking. This guide shows you how to do exactly that. If you are using a bundle appSome readers

• Export from Shopify to FTP

  Export to FTP In this tutorial, we'll walk you through the process of connecting DataChamp to an FTP server for report exporting. With FTP integration, you can transfer your Shopify data to an external server, ensuring easy access to information. Open DataChamp Settings ( 1 ) Start by accessing the Settings option in the App Menu of DataChamp. Configure FTP Server ( 2 ) Navigate to the "Storage" section and set up your FTPFew readers

• Export Products as Excel/CSV from Shopify

  Export Products as Excel/CSV Exporting product data from Shopify is crucial for inventory management, analysis, and backup purposes. DataChamp offers a efficient way to export detailed product information directly from the Shopify database. This guide will walk you through the steps to export products and highlight what sets DataChamp apart. Also take a look at our YouTube video on Export Options, where we explain how to export as Excel, CSV, or TXT, export a separate fFew readers

• Export a Seperate File per Item

  Export a Seperate File per Item Sometimes, there's a need to export a separate file for each item, either for integrating with another system or just for organizational purposes. DataChamp provides a solution for this specific requirement. In this tutorial, we'll guide you through the process of configuring a report with these settings. ||| This feature isn't included in DataChamp by default. Reach out to our Support team at hello@datachamp.io, and we'll enable it for yoFew readers

• Incremental Exports Feature

  Incremental Exports Feature DataChamp offers incremental exports, allowing you to export only new data since the last report run. This feature simplifies data management and ensures that you don’t duplicate previously exported records. Steps to Set Up an Incremental Export Configure Your Report Select the data fields you need ( e.g., order number, fulfillment status). Apply Filters Set the date filter: SelecFew readers

• Calculate Inventory Value

  Export Inventory and Calculate Inventory Value In this tutorial, you’ll learn how to calculate the inventory value of your stock using DataChamp. Inventory value refers to the total cost of all products currently in stock. It’s calculated using the formula: Inventory Value = Available Quantity × Unit Cost Step 1: Create a New Report Create a new report in Datachamp and select "Locations" as the rFew readers

• How to Export Bundle Orders from Shopify with Datachamp

  Export Bundles In this tutorial, we will show you how to export bundles with Datachamp. What is a Bundle? A bundle in Shopify is a product that combines multiple individual items into one offer. Instead of buying products separately, customers can purchase them together as a single product. Bundles are often offered at a discounted price compared to buying each item individually. For example, a T-shirt, pants, and a capFew readers

• Post Filters in Datachamp: What They Are and What Makes Them Different

  Post Filters Post Filters are applied after the data has already been loaded into the report. Post Filters are especially useful when working with custom columns, calculated fields, or conditions that cannot be applied at the data source level. They support conditions such as is empty, is not empty, contains, <, > and =. Example Post Filters: Bundle SKU is not empty → Shows only bundle orders ![](https://storage.crisp.chat/users/helpdesk/website/-/d/Few readers

• How to View and Filter Orders by Delivery Method

  Delivery Method Learn how to view and filter orders by delivery method in Shopify using DataChamp: This tutorial shows you how to quickly find and export orders based on the delivery method, such as shipping, local delivery, or pickup. Create an Order Report Create a new Order Report and select either a template or the "Basic Report." Add the Columns You Need Add the columns required for your report. By adding the column “Few readers

• How Can I See Whether My Products Are Tracked?

  Products Tracked Inventory tracking means Shopify keeps track of how many units of a product you have in stock. The video and article below explain how to identify which of your products have inventory tracking enabled in Shopify with DataChamp and how to filter them to export only the products you need. Inventory tracking can be turned on or off when creating or editing a product in the Inventory section. ![](https://storage.crisp.chat/Few readers

• How to Set Up Automated Exports with Shopify Flow

  Shopify Flow Integration Shopify Flow is an automation tool that allows you to automate recurring tasks and processes in your online store. Now, it can also help you create automated reports in DataChamp. It works with simple if-then logic: for example, if a new order comes in, then create an order report. That is exactly what we will set up in this article, but you can select all kinds of triggers. Shopify Flow is a free app and available on all paid Shopify plans (BasicFew readers