---
schema_version: "1"
id: 657858035f4fcde9fe7d828e9f1b60e7cdd9a1d7ce3c3ae374e212aab68cf718
title: Import Active Data .csv Files
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/cc/264-0-0/b2c_importing_active_data_csv_files.md
canonical_url: https://help.salesforce.com/s/articleView?id=cc.b2c_importing_active_data_csv_files.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: 3be9b78fcc1a5e6d3ef2878b27e80c2599f41050aa17c4157244e05147ffc9a9
description: Import Active Data .csv files to use production active data on your B2C Commerce Sandbox instance or to test active data sorting rules. Download the daily active data feed from your Production instance and import it into your Sandbox.
products:
  - Commerce
  - B2C Commerce
release: "264"
---
# Import Active Data .csv Files

Import Active Data .csv files to use production active data on your B2C Commerce Sandbox instance or to test active data sorting rules. Download the daily active data feed from your Production instance and import it into your Sandbox.

Before importing Active Data, make sure that:

- **Active Data tracking is enabled.** Make sure products exist in the Product Active Data database (PalDB) before importing custom attributes for them. B2C Commerce creates PalDB entries when tracking is enabled and customers view or purchase products on your storefront.
- **Products exist in PalDB.** If tracking was recently enabled, allow time for customer activity to populate PalDB entries. To verify PalDB entries, view Active Data attributes in Business Manager.
- **Your CSV file contains all required data.** Active Data imports use REPLACE mode, which means any attributes not included in your CSV file are deleted. See the following warning.

You can't import active merchandising data exported through Site Import & Export or Active Data > Export.

![Warning](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-cc-b2c_merchandiser_administrator-264-0-0-production-enus/ea76f372-6cfa-42a6-8e7c-05c6df7abed8/images/icon_warning.png)

Warning

**Data Loss Risk:** Active Data imports always use REPLACE mode. This means:

- Existing attribute values not included in the CSV file are **permanently deleted**.
- Importing a partial or sparse CSV file overwrites all existing Active Data for the products in the file.
- Products not included in the CSV file are unaffected, but any product in the file has its Active Data completely replaced.

Always export your current Active Data as a backup before importing. Verify that your CSV file contains all attributes you want to retain.

For more information about import modes, see [Import Modes in B2C Commerce](https://help.salesforce.com/s/articleView?id=cc.b2c_import_modes.htm&release=264.0.0&type=5 "For import processes, specify an import mode to define how to interpret the data within a feed. Some modes aren’t supported for some object types. The import mode, defined for the import process, applies to all objects within the feed. Import modes apply to all import files defined by B2C Commerce schemas.").

1. Click App Launcher ![App Launcher](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-cc-b2c_merchandiser_administrator-264-0-0-production-enus/ea76f372-6cfa-42a6-8e7c-05c6df7abed8/cc/b2c_merchandiser_administrator/images/appLauncher.png), and then select **Merchant Tools** | **Online Marketing** | **Active Data** | **Import & Export**.
2. On the Active Data Import & Export page, click **Upload**.
    
    You can't import a file into the Salesforce B2C Commerce database without first uploading it.
3. On the Manage Import Files page, click **Browse**.
4. On the upload window, select the .csv file to import and click **Open**.
    
    Select the .csv file that you downloaded from the Production instance or a test data file you created. If you modified a test file, make sure to use the correct naming convention.
    
    The active data feed name has the following format:
    
    ```
    activedata-product-sitename-YYYYMMDD.csv
    ```
    
    _For example: activedata-product-MySite-20250115.csv_
    
    ![Note](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-cc-b2c_merchandiser_administrator-264-0-0-production-enus/ea76f372-6cfa-42a6-8e7c-05c6df7abed8/images/icon_note.png)
    
    Note When importing data, follow the naming convention exactly.
5. Click **Upload**.
    
    The file you uploaded appears in the list of import files.
6. On the Manage Import Files page, click **<< Back**.
7. Click **Import**.
8. On the Active Data Import Step 1 - Select File page, select the file you want to import and click **Next**.
9. On the Active Data Import Step 2 - Validate File page, if the validation finishes successfully, the Import File Content section appears beneath the Validation Status section.
    
    If you have errors or your file doesn't validate correctly, the page shows logging information to help you fix your file. If you need additional information, select **Administration** | **Site Development** | **Development Setup** | **Log Files** link to view log files.
10. Click **Import**.
    
    When your file has imported, the Import page opens, showing the import results.

Your file can import with data errors, as indicated in the Status column of the window. To view these errors, click the file name link.

To confirm that your data has imported successfully, check your active data attributes.