• Can I Export a New File for Each Item?

  Yes, You Can! If you need to export a separate file for each item, we’ve got you covered! When exporting data, a new file can be created for each individual item, such as: • One file per order when exporting orders • One file per product when exporting products • One file per customer when exporting customers Supported File Formats This feature is available for the following file types: ✔ Excel (.xlsx) ✔ CSV (.csv) ✔ Text (.txt) How to Enable This Option This option is availableFew readers

• Can I Import Data with DataChamp?

  Import Data with DataChamp DataChamp is designed for exporting data only. It allows you to easily export data from your Shopify store into customizable reports; however, it does not support importing data back into Shopify or other platforms. If you have any questions or need assistance with your data exports, feel free to contact us. We’re here to help!Some readers

• What Timezone is Used by DataChamp?

  Timezones All exported dates and times are automatically set to the time zone of your Shopify account. To check or update this setting, navigate to General in your Shopify settings. You’ll find the time zone option under the "Standards and formats" section:Few readers

• How can I Quickly Test an Export with many Lines?

  Large Exports Use a filter that decreases your lines to less than 100. For product exports: Include only specific SKUs to limit the number of rows. For order exports: Filter by Fulfillment status or use a date filter, such as Created at, to export only recent or relevant orders. Using these filters ensures you extract only the most relevant data while keeping your export within the desired limit.Few readers

• Can I Merge Multiple Columns to One Column?

  Formating Data If you need to merge multiple columns into a single column, you can do so by adding a custom column and combining the desired columns. First, make sure to click on Browse and select the fields you want to merge. Then, create a custom column and use curly brackets to reference the other column. E.g. merge the Line items: Title and the SKU. IFew readers

• Repeated Lines Are Empty: How Can I Fill Them?

  Repeated lines To ensure each line is filled with the necessary data, such as the shipping address, locate " Export Mode / Lines" in your report settings and change the setting to "Fill".Few readers

• Can I Calculate a Combined Product Field for 'Packages'?

  Combined Product Field To calculate an additional field per order based on specific products, follow these steps: Add a Custom Column Set the Export Mode to "Compress" This ensures each order appears as a single line while still including the necessary order details. Select the Identifying Order Line Detail In the Columns tab, choose the field that identifies the product, such as SKU. Apply a [Mapping](/en/article/mappFew readers

• Can I Set Consecutive Numbering for My Export Lines?

  Consecutive Numbering Yes - If you are exporting an Excel file, you can generate consecutive numbering by adding a custom column with the following formula: (=ROW()-1) For order and line exports, set the Export Mode to "Fill" to ensure the numbering remains consistent across all order lines. | Learn more about [Excel Formulas](https://support.microsoft.com/en-auFew readers

• Can I Export Images?

  Images Yes, you can export images using Google Sheets. How to Include Images in Your Export: Use the Google Sheets =IMAGE() Function Add a custom column the Layout section of DataChamp. Use the following formula to insert product images: =IMAGE("{{Featured original image URL}}"; 1) Explore More Options Check the Google Sheets documentation for advanced formatting options. Use the DataChamp Template Try the built-in template "Few readers

• Can I Add a Column in a Google Sheet that is Not Overwritten by Datachamp?

  Google Drive / Google Sheets Yes, you can add a column in your Google Sheet that won’t be overwritten by DataChamp while still allowing daily updates. For example if you want a supplier to manually fill in a column. Set the Storage to Google Drive / Google Sheets. Set the File Type to "Google Sheets" and select "Append".![](https://storage.crisp.chat/users/helpdesk/webFew readers

• How to Change the Exported Currency?

  Currency By default, DataChamp uses "Presentment currency", meaning orders are exported in the customer's currency. For Example: Your shop currency is EUR (€). An American customer pays in USD ($). This order will be exported in USD. If you need orders in your shop’s default currency instead of the customer’s: Go to "Export Mode" settings in DataChamp. Change the currency type to "Shop currency". ![](https://storage.crisp.chat/users/helpdesk/website/d00f5563Few readers

• How to Generate a Running Number Within Exports?

  Running Number In case you want to generate a running number, select the field "Consecutive Numbering": This number is not affected if there are multiple items/rows in the order. Generate a Running Number Within Orders If you want to generate a number within the orders, select the field "Position": ![](https://storage.crisp.chat/users/helpFew readers

• Why Can’t I Export to Google Drive?

  Google Drive Before exporting to Google Drive, you must first connect DataChamp to your Google account. You can then use "Google Drive" as storage and "Google Sheets" as the file type. Therefore open "Settings" in DataChamp: As soon as you click on "Google Drive/Google Sheets", you'll be automatically redirected to the registration page of Google.Few readers

• What Permissions Does DataChamp Use for Google Drive?

  Permissions When you connect DataChamp to your Google Drive, we request access with “File” Permission. This ensures that DataChamp only interacts with the files and folders it creates, keeping your data private and secure. Here’s what this means: **What DataChamp can access: ** DataChamp creates its own folder in your Google Drive It can create and manage files inside that folder This is used to export data to Google Sheets and store DataChamp files **What DataChaFew readers

• Transferring Reports from One Shopify Shop to Another

  Transferring Reports If you are closing your current store and need to transfer your existing reports, follow these steps: Export Your Current Report Configurations Click on the three dots ( 1 ) → "Export Report configuration" ( 2 ) Import the Report Configuration into the New Shop Click on the small arrow next tFew readers

• How Does DataChamp Ensure Compliance with GDPR/DSGVO Regulations?

  GDPR/DSGVO Regulations Our app complies with GDPR/DSGVO regulations by not collecting personal data, using accessed data solely for specified purposes, and ensuring secure, temporary storage. The General Data Protection Regulation (GDPR) and the German equivalent Datenschutz-Grundverordnung (DSGVO) are regulations in EU law on data protection and privacy. They aim to give control to individuals over their personal data and to simplify the regulatory environment for interFew readers

• Can I Export Metafields using DataChamp?

  Yes, DataChamp allows you to export metafields and custom attributes by automatically creating separate columns for each key. How can I export metafields with DataChamp? Set Up Your Report: Include the data you want to export. DataChamp will create columns for all keys of your metafields or custom attributes. Customize Your Export: To export specific metafields, copy and paste the desired keys. Duplicate the metafields column to select different keys. **Preview Your Report:Few readers

• How to Allow DataChamp to Connect to My FTP Server

  Connect to FTP Server When setting up a connection to an FTP or sFTP server using DataChamp, you may encounter situations where the connection is blocked due to security settings. Many FTP servers require whitelisting specific IP addresses to allow secure access. This guide will help you understand how to whitelist DataChamp’s IP addresses to ensure a smooth and secure connection. How to Whitelist DataChamp’s IP Addresses: **Obtain DataChamp’sFew readers

• How to Export a Specific Part of a Field

  Export a Specific Part of a Text Field Using RegEx To extract a specific part of a text field and remove everything else, you can use the "Find and extract character sequence" feature in DataChamp. This feature allows you to apply a RegEx (regular expression) formula to isolate and extract the information you need. Example: Imagine you have a field with the following information: Order Number: 12345, Status: Shipped, Date: 2024-07-19 In this case, you only want toFew readers

• Can Japanese Prefectures Be Translated into English?

  Translated Japanese Prefectures into English Yes, it is possible to translate Japanese provinces to English. We provide a predefined mapping that automatically translates the province names when selected. You can find the predefined mappings by clicking on the "Mappings Layout" ( 1 ). At the bottom of the page, as shown in the screenshot below, the predefined mappings appear ( 2 ): ![](https://storage.crisp.chat/users/helpdesk/websFew readers

• How Do I Export Selected Variant Options for My Product Variants?

  Export Selected Variant Options for Product Variants If you specify an Option Name, only that particular option will be included in the export. If no option name is provided, all available options will be shown. For a step-by-step guide, watch the video below, which includes a detailed example of how this feature works:Some readers

• Can I Export Only Orders with a Specific 'Transaction Status'?

  Export orders with a Specific 'Transaction Status' Yes, you can! Simply configure your filter: Additionally, you can select the option to ‘Exclude orders with no matching refund.’Few readers

• Can I Add Consecutive Row Numbers in Excel?

  Yes you can! Add a custom column Give it a name e.g. consecutive numbering Insert the value: =ROW()-1 Set "Lines" in "Export Mode" to "Fill" The "File Type" must be "Excel" ![](https://storage.crisp.chat/users/helpdesk/website/-/d/0/0/f/d00f55635133d800/file-type-eFew readers

• How to Uninstall Our App/Cancel Subscription?

  Uninstall DataChamp If you wish to uninstall our app, there are two options: Directly in Shopify: First Navigate to Settings: Click on "Apps and Sales Channels" ( 1 ). Find DataChamp and click on the three dots ( 2 ), then select "Uninstall" ( 3 ): ![](https://storage.crisp.Few readers

• What Are the Most Commonly Used Filters and How Do They Work?

  Most Asked Filters Explained: Here you'll find detailed explanations of the most commonly used filters: Fulfillment Filter: You can use different fulfillment filters: Fulfillment Status: Unfulfilled Unfulfilled or Partially fulfilled Partially fulfilled Fulfilled Fulfilled or Partially fulfilled is Fulfillable:Few readers

• Which Mappings Are Most Frequently Used In DataChamp, and What Do They Do?

  Most Asked Mappings Explained: This article explains the mappings that users ask about most often in DataChamp. If the current quantity is zero, display a zero instead of leaving the field empty. If “Shipping Address 2” is available, you can use mappings to combine both fields and create a single complete address by merging “Shipping Address 1” and “Shipping AddreFew readers