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 readersCan I 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!PopularWhat Timezone is Used by DataChamp?
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 readersHow can I Quickly Test an Export with many Lines?
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 readersCan I Merge Multiple Columns to One Column?
If you need to merge multiple columns into a single column, you can use the mapping function Example: to combine "Address first line" and "Address second line", you can create a mapping rule that merges these fields into one. First - click on "Browse" and select both fields: (https://storage.crisp.chat/users/helpdesk/website/d00f556Few readersRepeated Lines Are Empty: How Can I Fill Them?
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 readersCan I Calculate a Combined Product Field for 'Packages'?
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 readersCan I Set Consecutive Numbering for My Export Lines?
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.Few readersCan I Export Images?
Yes, you can export images using Google Sheets. 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 readersCan I Add a Column in a Google Sheet that is Not Overwritten by Datachamp?
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 Export Mode to → "Incremental" Set " How to write data to Google Sheet" to → "Append".Few readersHow to Change the Exported 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 readersHow to Generate a Running Number Within Exports?
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. If you want to generate a number within the orders, select the field "Position": (https://storage.crisp.chat/users/helpFew readersWhy Can’t I Export to 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 readersWhat Permissions Does DataChamp Use for Google Drive?
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: Restricted Access to DataChamp’s Folder DataChamp creates its own folder in your Google Drive, and its access is limited to this folder and the files created by DataChamp. No Access to Manually Created Files or FolFew readersTransferring Reports from One Shopify Shop to Another
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 ( ) → "Export Report configuration" ( ) Import the Report Configuration into the New Shop In your new store, go to "New Report"Few readersCan I Export Metafields using DataChamp?
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. Preview Your Report: Click "Preview" to see the keys and results of the metafields being exported.Few readersHow Does DataChamp Ensure Compliance with 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 readersHow to Allow DataChamp to Connect to My 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. Obtain DataChamp’sFew readersHow to Export a Specific Part of a Field
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 readersCan Japanese Prefectures Be Translated 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" ( ). At the bottom of the page, as shown in the screenshot below, the predefined mappings appear ( ): (https://storage.crisp.chat/users/helpdesFew readersHow Do I Export Selected Variant Options for My 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 readersCan I Export Only Orders with a Specific 'Transaction Status'?
Yes, you can! Simply configure your filter: You can filter by ‘Transaction Status’ with the option ‘Refunds.’ Additionally, you can select the option to ‘Exclude orders with no matching refund.’Few readersCan I Add Consecutive Row Numbers in Excel?
Yes you can! Add a custom column Name it The value must be: "=ROW()-1" Set "Lines" to "Fill" The "Type" must be "Excel" Can I add consecutive numbering in Excel?Few readersHow to Uninstall Our App/Cancel Subscription?
If you wish to uninstall our app, there are two options: First Navigate to Settings: Click on "Apps and Sales Channels" ( ). Find DataChamp and click on the three dots ( ), then select "Uninstall" ( ): (https://storaFew readers