> ## Documentation Index
> Fetch the complete documentation index at: https://docs.neuroncx.in/llms.txt
> Use this file to discover all available pages before exploring further.

# SKU Import (Type 5)

> Bulk-import SKU records into NeuronCx from a Google Sheet using a simple Id and Value format.

## Overview

SKU Import loads SKU records into NeuronCx in bulk from a Google Sheet. It's a legacy import type that uses a fixed two-column format — `Id` and `Value` — and writes directly against records in the `SchoolSKUMaster` table for your institution.

Use this import when you need to populate or refresh SKU values in bulk, without touching any other entity type.

> [!NOTE]
>
> This is a legacy import type. It supports the `Id | Value` format only and does not support attribute columns. If you need to import entity records with additional attribute data, use Trx Attribute Entity Import (Type 11) instead.

***

## Prerequisites

* Your Google Sheet must be shared with edit access so NeuronCx can read from it.
* The sheet must contain exactly two columns: `Id` and `Value`.
* The `Id` values in your sheet must match existing records in the `SchoolSKUMaster` table for your institution. This import does not create new SKU definitions — it only writes values against ones already set up.

***

## Preparing Your Sheet

Your sheet must follow this exact format. NeuronCx will reject or skip rows that don't conform.

| Column | Required | Notes |
| - | - | - |
| `Id` | ✅ Yes | Must match a valid `SchoolSKUMaster` ID for your institution |
| `Value` | ✅ Yes | The value to set against that SKU record |

![Capture1 JPG](https://mintcdn.com/neuroncx/_AQBgdbbCYYHf24I/images/Capture1.JPG.jpg?fit=max\&auto=format\&n=_AQBgdbbCYYHf24I\&q=85\&s=9b5a9d503d9001daa076aac0634b6311)

> [!TIP]
>
> To find the correct IDs for your institution, check the `SchoolSKUMaster` table filtered by your `InstitutionId`. Use only IDs that already exist — unrecognised IDs will be skipped.

***

## Running the Import

### Setting up a new import

**1. Open Imports**

Navigate to **Home > Ontology > Attribute Settings & Bulk Edit**, then click the **Imports** tab.

![Imports Tab](https://mintlify.s3.us-west-1.amazonaws.com/neuroncx/images/imports_tab.png)

**2. Click + Import**

Click the **+ Import** button in the top right to open the New Import modal.

![Import Button 4](https://mintcdn.com/neuroncx/_AQBgdbbCYYHf24I/images/import_button-4.png?fit=max\&auto=format\&n=_AQBgdbbCYYHf24I\&q=85\&s=d432d3e482fde103a80e115631f36b84)

**3. Give it a label**

Enter a name that describes this import — for example, "SKU Bulk Import."

![Label 3](https://mintcdn.com/neuroncx/_AQBgdbbCYYHf24I/images/label-3.png?fit=max\&auto=format\&n=_AQBgdbbCYYHf24I\&q=85\&s=5fe8c8fde645fd2aa1acb205e46bb5d1)

**4. Add the Google Sheet ID**

Paste the sheet ID or the full Google Sheets URL — NeuronCx will extract the ID automatically.

![Sheet Id 3](https://mintcdn.com/neuroncx/_AQBgdbbCYYHf24I/images/sheet_id-3.png?fit=max\&auto=format\&n=_AQBgdbbCYYHf24I\&q=85\&s=c2ed5d87f5cc71d4bf9ec5c70216f8c8)

**5. Verify**

Click **Verify**. NeuronCx confirms it can read the sheet and shows you the row and column count — use this to catch an empty or wrong sheet before continuing.

![Verify 5](https://mintcdn.com/neuroncx/_AQBgdbbCYYHf24I/images/verify-5.png?fit=max\&auto=format\&n=_AQBgdbbCYYHf24I\&q=85\&s=1c6b27cceaba086ff1ff45b9e63070e5)

**6. Select the import type**

In the Import type panel on the left, select **Legacy**. Then choose **SKU** (`#5`) from the list on the right.

![Category Type](https://mintcdn.com/neuroncx/_AQBgdbbCYYHf24I/images/category-type.png?fit=max\&auto=format\&n=_AQBgdbbCYYHf24I\&q=85\&s=55378d986cf3ae69dbdcb26e7b463cd8)

**7. Create the import**

Click **Create import**. The import now appears in your list under the Legacy category, ready to run.

![Create Import 4](https://mintcdn.com/neuroncx/_AQBgdbbCYYHf24I/images/create_import-4.png?fit=max\&auto=format\&n=_AQBgdbbCYYHf24I\&q=85\&s=0ab7a8c7a09dfa2cac76c3ae3a59dbe8)

### Running the import

**1. Find the import**

From the Data Import list, locate the import you just created. You can filter by the **Legacy** tag to narrow the list.

**2. Click Import**

Click the arrow icon on the import row to open it, then click **Import** to run it.

***

## Checking the Result

Once the run completes, the history table shows how many rows were read and how many records were updated. Click a run's **Status** to open a detailed breakdown showing which rows succeeded, failed, or were skipped.

> [!TIP]
>
> Re-running the same sheet is safe — it will re-apply values without creating duplicates.

***

## Limits to Keep in Mind

* This import supports the `Id | Value` format only. No additional columns are read or imported.
* The `Id` in each row must match an existing record in `SchoolSKUMaster` for your institution — rows with unrecognised IDs are skipped.
* This import does not create new SKU definitions. All IDs must be set up in the platform before running the import.
* Only one import runs at a time. If another import is already running, this one will queue and wait its turn.


This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.