# Inventory Quantities

## To Prepare Inventory CSV file

**(1)** Download the Sample Template CSV File

**(2)** Open the file in Google Sheets and Navigate to the **INVENTORY QUANTITY TAB**

**(3)** You will see some sample entries

**(4)** Replace the examples with your products

* Barcode
* Quantity

**(5)** Click File > Download > Comma-separated values (.csv)

| barcode | quantity |
| ------- | -------- |
| 77777   | 100      |

## To Upload the Inventory Quantities

**(1)** On the Menu Bar, Go to Admin > Uploads > Upload Inventory

**(2)** Press the Choose File button and Navigate to the location of your Inventory CSV file

**(3)** Click Proceed and then OK to Upload your File

**(4)** A Notification will appear indicating that you have successfully Uploaded your Inventory Products

**(5)** Click OK to close the notification

{% embed url="<https://drive.google.com/file/d/1auIyRKgCgK68nfv5-46A9_dxhiVcpXZq/preview>" %}

## To Check Inventory Quantity Application

**(1)** On the Menu Bar, Go to Products > Active Items

**(2)** The Product Page will Appear along with the Available Quantity

{% embed url="<https://drive.google.com/file/d/1Mzw3shrlhf8hWDcLh1Y_5xFUqV5hfsRS/preview>" %}

## To Upload Inventory as Inventory Adjustment

**(1)** On the Menu Bar, Go to Admin > Uploads > Upload Inventory

**(2)** On the Dropdown, Select Inventory Adjustment

**(3)** Enter the Reference number

**(4)** Press the Choose File button and Navigate to the location of your Inventory CSV file

**(5)** Click Proceed and then OK to Upload your File

**(6)** A Notification will appear indicating that you have successfully Uploaded your Inventory Products

**(7)** Click OK to close the notification

{% hint style="info" %}
The vendor can upload a file that has negative value that will subtract the existing quantity to re-uploaded file that has negative value
{% endhint %}

<figure><img src="https://4163731625-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FjANZdCcwJXnHA9psRF0V%2Fuploads%2Fgit-blob-0e2eb8c1868d71988801da276510f8e225330bba%2F1.jpg?alt=media" alt=""><figcaption></figcaption></figure>

### Inventory Adjustment Type

This will allow the vendor to select a behaviour of uploading inventories

#### Count

* if the vendor has Existing Quantity and the vendor Re-upload different quantity, the Quantity of the Re-uploaded file will override the Existing Quantity

#### Adjustment

* if the vendor has Existing Quantity and the vendor Re-upload different quantity, the Quantity of the Re-uploaded file will add/subract to Existing Quantity