# Import Data

**Import all data from all of your connected data sources**

*Before you engage in any FP\&A tasks for the day we recommend to import all data to make sure your model is up to date.* 

1. Click on "Import Data"
2. Click on "Import All Data"
3. Success - your model is updated with fresh data🎉

**Import source-specific data**

*When assessing how you are pacing mid-month with DTC or Amazon data, we recommend to import only Shopify or Amazon data.* 

1. Click on "Import Data"
2. Click on ⬇️ for Shopify
3. Success - your model is updated with fresh Shopify data

<figure><img src="/files/nsp1mGF0apq5xWp9YV9d" alt="" width="347"><figcaption></figcaption></figure>

## FAQ Data Import

<details>

<summary>My QBO was skipped. Why?</summary>

This likely happened because some of your accounts are not mapped to Drivepoint categories. In order to map Drivepoint categories, click on the side arrow next to QBO in data import and map the accounts to the Drivepoint categories.&#x20;

If the issue persists, please contact Drivepoint Support via <support@drivepoint.io>.

<br>

</details>

<details>

<summary>My data was only imported partially. What should I do?!</summary>

Sometimes it can happen. Don't worry! There is a way to import specific tables that might have failed in the "All Data Import" or specific data import per source. Here's how you can import a specific table that might have failed:

1. Click on the Info button to see which table did not import (e.g. R - DTC Retention)
2. Click on the **>** arrow next to specific data source that failed to import a table&#x20;
3. Select the table in the drop-down that failed to import
4. Change or keep the defaults of the table settings *(if you are unsure, stick with the defaults)*
5. Click on import
6. Success - it should have worked! If you are still experiencing issues please contact <support@drivepoint.io>

</details>

<details>

<summary>What tables are imported when I import "All Shopify Data"?</summary>

We will import the following tables when importing all Shopify data:&#x20;

1. Product Sales Mix
2. DTC Retention Predictions
3. Cohorted Sales
4. Monthly Shopify Data Pivot

All of these options can also be selected individually when clicking the ">" next to the Shopify option in the Data Import screen.&#x20;

</details>

<details>

<summary>What tables are imported when I import "All Amazon Data"?</summary>

For Amazon data, we import the following tables:&#x20;

1. Amazon Monthly
2. Amazon Product Sales Mix&#x20;
3. Amazon Retention Predictions

All of these options can also be selected individually when clicking the ">" next to the Amazon option in the Data Import screen.&#x20;

</details>

<details>

<summary>Where does the imported data live?</summary>

Newly imported data lives in the "R-" tabs in your Excel files. For example:&#x20;

* R-GL: is the general ledger and therefore the raw data import sheet for your financial information that maps throughout the file
* R- DTC Product Sales Mix: is the import tab for Shopify product sales mix actuals and information.&#x20;

If you import fresh data, the model should automatically update with the fresh data BUT it is always good to double check. [Reach out to our team](/help-1/contact-us.md) if you want to learn more.&#x20;

</details>


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.drivepoint.io/navigating-the-excel-add-in/core-functions-of-the-drivepoint-add-in/import-data.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.