# Uploading Products, Updating Prices, Stock Quantity in Batch

{% tabs %}
{% tab title="Upload Products" %}
Upload an excel file of your products with the upload tool for faster product creation in Imonggo.

### Step 1:

#### File Format <a href="#h_e35c70551c" id="h_e35c70551c"></a>

First, you have to create the CSV file that you will upload. You can do this by using Excel or any other spreadsheet program or [download this sample CSV file](https://drive.google.com/file/d/1jDSCT-DKI-cTt5uBuEvSawLw_Znw21I0/view?usp=sharing).

The required column headers are stock\_number, name, cost, and retail\_price (highlighted in yellow below).

<figure><img src="https://downloads.intercomcdn.com/i/o/39843091/9fdc9997afb5227525af999f/Screen+Shot+2017-11-17+at+1.49.38+PM.png" alt=""><figcaption></figcaption></figure>

The other headers, like barcodes, tags, description are optional and you may to delete them from the file.

***

### Step 2:

#### Upload File <a href="#h_a7ed85dabb" id="h_a7ed85dabb"></a>

Once you have saved the spreadsheet in CSV format, you can already upload it.

Go to the Data Manager

### Step 3:

Select Products from the Data to Upload dropdown

### Step 4:

Choose your file then Imonggo will display the products

### Step 5:

Click the Upload button

<figure><img src="https://downloads.intercomcdn.com/i/o/453078999/db49d2b7c8a203d86c6d3508/Data+Manager+1.png" alt=""><figcaption></figcaption></figure>

Once the file is successfully uploaded, you should be able to find your uploaded products in the Stockroom.

<br>
{% endtab %}

{% tab title="Update Stock Count" %}
Imonggo allows you to update your inventory by uploading a CSV file. Here's how:

###

### Step 1:

#### File Format

First, you have to prepare the file that you want to upload. The easiest way to do this is to create a list of items first in Microsoft Excel or any other spreadsheet program then save it as a CSV file. You can also [download this sample file](https://drive.google.com/file/d/1ZxOkNrAmCc04HZTBUNjT7szXWMvVVUss/view?usp=sharing).

There are only two required columns for this upload: stock\_number and quantity.

***

### Step 2:

#### Upload File <a href="#h_fabace16a3" id="h_fabace16a3"></a>

Once you have saved the spreadsheet in CSV format, you can already upload it.

Go to the Data Manager

### Step 3:

Select Stock Count from the Data to Upload dropdown and a Branch from the Branch dropdown.

### Step 4:

Choose your file then Imonggo will display the products

### Step 5:

Click the Upload button

<figure><img src="https://downloads.intercomcdn.com/i/o/453728624/d3662107fbdf4d2ed6b45d2d/Data+Manager+3.png" alt=""><figcaption></figcaption></figure>

Once the file is successfully uploaded, you should be able to find your products stock count updated in your stockroom.

<br>
{% endtab %}

{% tab title="Update Prices" %}
Imonggo allows you to change the retail prices of your items by uploading a CSV file. Here's how:

### Step 1:

#### File Format <a href="#h_c13303a880" id="h_c13303a880"></a>

First, you have to prepare the file that you want to upload. The easiest way to do this is to download your list of items first, then edit it in Excel or anyspreadsheetdsheets program. You can also [download this sample file](https://drive.google.com/file/d/1cJs-zoUJZUU4gd4ZYoVknckIreCl_r7f/view?usp=sharing).

There are only two required columns for this upload: stock\_number and retail\_price.

***

### Step 2:

#### Upload File <a href="#h_d48fdbc960" id="h_d48fdbc960"></a>

Once you have saved the spreadsheet in CSV format, you can already upload it.

Go to the Data Manager

### Step 3:

Select Price from the Data to Upload dropdown.

### Step 4:

Choose your file then Imonggo will display the products

### Step 5:

Click the Upload button

<figure><img src="https://downloads.intercomcdn.com/i/o/453736076/b4fe9599feb838bae215fc65/Data+Manager+4.png" alt=""><figcaption></figcaption></figure>

Once the file is successfully uploaded, you should be able to find your products prices updated in your stockroom.
{% endtab %}
{% endtabs %}
