Q: Can I Import Data with DataChamp?

<h2 id="dcolor1a63baimportdatawithdatachamp">${color}[#1a63ba](Import Data with DataChamp)</h2> <p><strong>DataChamp is designed for exporting data only.</strong> 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.</p> <p>If you have any questions or need assistance with your data exports, feel free to contact us. We’re here to help!</p>

Q: Storage

<h2 id="dcolor1a63bastorage">${color}<a href="Storage">#1a63ba</a></h2> <p>Choose from various storage options for your exported data. The default storage option is DataChamp, which stores your data for free on our servers. Alternatively, you can connect your own FTP, Google Drive, or Dropbox account.</p> <ul> <li>DataChamp</li> <li>DataChamp - Feed =&gt; a feed URL is provided. Take a look at the tutorial <a href="/en/article/product-feed-1490y1f/">Product Feed</a> for further details.</li> <li>Google Drive / Google Sheets</li> <li>Dropbox</li> <li>FTP</li> <li>FTP 2</li> </ul> <p>You can set your default storage option on the settings page ( <strong>${color}<a href="1">#f44823</a></strong> ). Additionally, you can select different storage options for each report. The first time you choose Google Drive or Dropbox, you will be redirected to the respective platform to select the account where your files should be stored ( <strong>${color}<a href="2">#f44823</a></strong> ).</p> <p>|| If you plan to use Google Drive, FTP, or Dropbox, please configure your storage settings first: <a href="/en/article/why-cant-i-export-to-google-drive-1btkh7w/">Why Can’t I Export to Google Drive?</a></p> <p><img src="https://storage.crisp.chat/users/helpdesk/website/d00f55635133d800/settings_1d2avkz.png" alt="" /></p>

Question 1

Quickstart

Accepted Answer

${color}#1a63ba

${youtube}

${color}#1a63ba

DataChamp provides a set of standard reports that you can use as a foundation for your custom Shopify exports.

To create a new report, click "New Report" ( ${color}#f44823 ) in the Dashboard: Press the "Run" button ( ${color}#f44823 ) to generate a report. Once the process is complete, you can download your Excel or CSV file by clicking "Download" ( ${color}#ff0000 ).

If you need updated results, simply repeat and run the reports again. You can view the history of previous runs by clicking on "Actions/History".

${color}[#1a63ba](Create & Edit)

To create or edit a report, click "New Report". You can either customize your own or use one of the provided templates, such as "Orders from Yesterday". The template applies the filter and selects standard fields from Shopify orders, as shown in the screenshot below.

On the right side, you can find all available settings: ${color}#f44823 Name – Define your report name. ${color}#f44823 Storage Options – Choose where to store the exported data:

DataChamp
DataChamp - Feed
Google Drive / Google Sheets
FTP
Dropbox ${color}#f44823 Export Mode – Select how t

Question 2

Can I Import Data with DataChamp?

Accepted Answer

${color}[#1a63ba](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!

Question 3

Layout

Accepted Answer

${color}#1a63ba

${color}[#1a63ba](Change the column order or column name)

${color}[#1a63ba](Modify the column settings)

Click on the settings icon next to a column to access additional configuration options:

There are different options depending on the type of the column. Here is an example for a text field: | Click "Test settings" at the bottom of the settings page to instantly test your configuration.

|| For advanced topics, please refer to: Regex for Search and Replace, Date Format

${color}[#1a63ba](Add custom columns)

To set fixed values, simply add a column as shown in this example:

| Don't forget to click the "Add" button!

|| If you want to use the values from other columns, do calculations or apply advanced search and replace functions, please refer to (Set the Value of a Column

Example:

${color}

Question 4

Storage

Accepted Answer

${color}#1a63ba

Choose from various storage options for your exported data. The default storage option is DataChamp, which stores your data for free on our servers. Alternatively, you can connect your own FTP, Google Drive, or Dropbox account.

DataChamp
DataChamp - Feed => a feed URL is provided. Take a look at the tutorial Product Feed for further details.
Google Drive / Google Sheets
Dropbox
FTP
FTP 2

You can set your default storage option on the settings page ( ${color}#f44823 ). Additionally, you can select different storage options for each report. The first time you choose Google Drive or Dropbox, you will be redirected to the respective platform to select the account where your files should be stored ( ${color}#f44823 ).

|| If you plan to use Google Drive, FTP, or Dropbox, please configure your storage settings first: Why Can’t I Export to Google Drive?

Question 5

Set the Value of a Column

Accepted Answer

${color}[#1a63ba](Set the Value of a Column)

The value of a column can be set in the Report Editor:

To use the value of other columns the syntax is: {{column name}}.

| Please be careful here. You must write the exact same name of the column as it is written in the tab Layout. Pay attention to the spelling and spaces! The safest way is it, to copy and paste the name from there.

Access any other column you selected in Selection. Then you can use the value by surrounding the name with {{ }}.

${color}[#1a63ba](Evaluate Mathematical Expressions)

You have the flexibility to use all functions listed on the math.js page. Instead of using math.evaluate, simply enclose your expression within double square brackets [[ ]].

For example:

Instead of math.evaluate (( {{item_unit_price}} * 100 ) / (100 + {{item_tax_rate}} ))

use [[ ( {{item_unit_price}} * 100 ) / (100 + {{item_tax_rate}} ) ]]

This format simplifies the usage of mathematical expressions.

Please be aware that math expressions are only functional in mappings or when combined with variables in custom fields. To writ

Question 6

Date Format

Accepted Answer

${color}[#1a63ba](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 recognized as a date. To revert to the default format, simply clear the format field.

Here are some common date formats and their outputs:

YYYY/MM/DD => 2024/06/26
DD.MM.YYYY => 26.06.2024
MM-DD-YYYY => 06-26-2024
YYYY-MM-DD => 2024-06-26
DD/MM/YYYY => 26/06/2024
DD-MM-YYYY => 26-06-2024
YYYY.MM.DD => 2024.06.26
D MMM YYYY => 26 Jun 2024
MMM D, YYYY => Jun 26, 2024
MMMM D, YYYY => June 26, 2024

You can also combine these date formats with text inside brackets, such as "[Today is] dddd". To simplify editing, our app provides an instant "Date Preview" feature:

If you need more complex formats, you can use the following "tokens" to create your own custom date format:

Month

| Token | Output | | ---- | | M | 1 2 … 11 12 | | Mo | 1st 2nd … 11th 12th | | MM | 01 02 … 11 12 | | MMM | Jan Feb … Nov Dec | | MMMM | January February … November December |

Quarter

| Token

Frequently Read Articles

Browse All Categories