How to Bulk Upload Inventory Items?

If you want to migrate your inventory data to Refrens from any platform, OR if you want to add multiple inventory items at once, you can do that easily with our “Bulk Upload” feature.

Let’s see how!

Step 1: Navigate to the Inventory Dashboard

Go to Inventory >  under the “Add Item” dropdown, and go to “Bulk Upload Inventory” as shown below:

Step 2: Download the Sample CSV file

After you click on “Bulk Upload”, a pop-up form will like the one below will open up:

Before uploading your CSV file, we recommend that you download the sample format first to upload your inventory items without any errors.

Your sample CSV file will look like this:

Step 3: Fill up the Sample CSV file

You can remove the test values from the sample file and add the details of the inventory to be added in this sample file only.

But before that, ensure you know what each field means, what fields are mandatory, what restrictions you have to keep in mind, etc.

Let’s learn more about this for each column header:

For Alternate Units

You can add multiple alternate units by continuing the numbering.

For example:

• alternateUnits.0.unitCode – The first alternate unit.
• alternateUnits.0.factor – How many Base Units are equal to 1 Alternate Unit.
• alternateUnits.1.unitCode – The second alternate unit.
• alternateUnits.1.factor – The conversion for the second alternate unit.

Example

Suppose your item's Base Unit is KGS and you sell it in BAGS.

If:
alternateUnits.0.unitCode → BAG
alternateUnits.0.factor → 2

It means:
1 BAG = 2 KGS

So, if you sell 5 BAGS, Refrens can convert it to:
5 BAGS = 10 KGS

You can add more alternate units by continuing the numbering:

• alternateUnits.0 → First alternate unit
• alternateUnits.1 → Second alternate unit
• alternateUnits.2 → Third alternate unit

Want to add UOM details while bulk uploading?

If you're not familiar with Units of Measurement (UOM), check How to manage Units of Measurement & Conversion?

For Warehouses

The warehouse fields follow this format:
warehouse.<Warehouse ID>.<field>

For example:

• warehouse.WH0001.stock
• warehouse.WH0001.reorderPoint
• warehouse.WH0001.overstockPoint

The Warehouse ID in the CSV corresponds to the specific warehouse in your Refrens account. If you have multiple warehouses, separate columns will be available for each warehouse.

While adding items, you will have to mention the item quantity for each of the warehouses. If you have multiple warehouses, and all the stock is going to a single warehouse, you can keep the other warehouse columns as empty.

Custom Fields: If you want to add more details to your inventory items, you can do via custom fields. Follow this article to learn how to add custom fields while bulk uploading inventory items>

Step 4: Upload the CSV file

Once you are done adding all your inventory data to the CSV file, just click on "Choose File" and then hit “Upload File”:

In case your uploaded file contains invalid data, the system will show you an error report:

You can download this report to see what errors are there in your CSV file, and re-upload the same after rectifying the errors.

Once your bulk upload is done, you will also receive a confirmation email.

(Note: Do keep in mind that uploaded items will take several minutes to reflect in the system. So unless you receive an error message while uploading, do not re-upload the CSV file again.)

In case you still have any questions, feel free to reach out to us at care@refrens.com OR drop a message on our chat support for quick assistance!

Unit Codes

Updated on: 04/09/2026