# Import Data by CSV

This feature saves time by allowing you to upload hundreds of products simultaneously from a CSV file instead of manual entry.

#### 🔹 Step 1: Select method Import Data

* Click to (+) icon - the top right corner of the interface opens the import options
* Select the method that fits your goal:
  * **Add multiple Products from CSV:** For new products only.
  * **Update multiple Products from CSV:** To update existing product information.
  * **Add or update multiple Products from CSV:** A hybrid mode that adds new items and updates existing ones based on IDs.

<figure><img src="https://2446612760-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F0sjg5GpIPr5HzBTJYqYe%2Fuploads%2Fp38vAySivinWPnaToyFx%2FGroup%20836.png?alt=media&#x26;token=4336f2fa-8ffa-410a-a8cf-8d9baebf7458" alt=""><figcaption></figcaption></figure>

#### 🔹 Step 2: Upload Your CSV File

* In the **Upload CSV File for Products** interface:
  * **Import Mode:** Add Only/ Select your preferred mode
  * **Choose CSV File:** Drag and drop your CSV file into the designated area or click to browse your computer.
* Click Next to proceed.

<figure><img src="https://2446612760-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F0sjg5GpIPr5HzBTJYqYe%2Fuploads%2FZpeCK15P4VM4JyS6qQfr%2FGroup%20847.png?alt=media&#x26;token=ffa89d75-b78c-4460-aa10-13efce98304b" alt=""><figcaption></figcaption></figure>

#### 🔹 Step 3: Map Data Columns

The system needs to know which column in your CSV corresponds to which field in HIVO. In the **Map each CSV column to the corresponding field type** table:

* Review the **CSV Column Name** list (the headers from your file).
* Specifically, for the CSV Column Name of the Product ID, **you must select and map it to the Product ID field**. This field is used as the ID for the Product and must be unique. If there are multiple rows in the CSV with the same value for this field, the data import will fail.
* With another **HIVO Fields**, choose the matching data field (e.g., map "Product Description" to "Metadata - product description").
* For unnecessary columns, set the status to **Ignore.**

<figure><img src="https://2446612760-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F0sjg5GpIPr5HzBTJYqYe%2Fuploads%2FXxQxT9JtqHeftXutKUJb%2FGroup%20839.png?alt=media&#x26;token=214cbb27-8b26-4296-815b-bb0611bbcd28" alt=""><figcaption></figcaption></figure>

👉 Tip: Click **AUTO-MAP COLUMNS** to let the system automatically match fields if your CSV headers already align with system field names.

<figure><img src="https://2446612760-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F0sjg5GpIPr5HzBTJYqYe%2Fuploads%2FMVnkjarr1DTCFLao6VsN%2FGroup%20838.png?alt=media&#x26;token=2c851f25-e06c-40a5-994d-1e23b7514cd6" alt=""><figcaption></figcaption></figure>

* Then, Click Next.

#### 🔹 Step 4: Review and Confirm

Before the data is finalized, a preview will be displayed:

* **Column Mappings Summary:** Shows a summary of columns to be imported (highlighted in orange) and those ignored (grey).
* **Data Preview:** Displays the first 3 rows of your data so you can verify the accuracy of information and formatting.
* If everything is correct, click the **Import** button.

<figure><img src="https://2446612760-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F0sjg5GpIPr5HzBTJYqYe%2Fuploads%2FVJhM069VsohT7gbyUnBc%2Fimage%2018.png?alt=media&#x26;token=b4cd816c-77d5-4bd9-8b32-a9dd3728faba" alt=""><figcaption></figcaption></figure>

#### 🔹 Step 5: Finalize Results

* The system will display a **Successfully imported** message along with a summary:
  * **Total Processed:** The total number of rows handled.
  * **Successful:** The number of products successfully imported.
* To continue with another file, click **Start new import**

<figure><img src="https://2446612760-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F0sjg5GpIPr5HzBTJYqYe%2Fuploads%2FObeJVRcKxktu3YR7bnE2%2Fimage%2012.png?alt=media&#x26;token=35c93739-1b48-4d7d-b762-6ff8901ada95" alt=""><figcaption></figcaption></figure>

**⚠️ Important Note:**

* **CSV Formatting:** The first row of your CSV file must contain column headers.
* **Product ID (SKU):** To update existing products, your CSV must include a column mapped to the internal Product ID so the system can identify the records.

If you have any questions, don't hesitate to ask, we're always here to help!