If you want to make edits (price, name, description, etc.) to your existing inventory items in bulk, you can do so with the “Bulk Update Inventory” Option.

Let’s see how,

Step 1: Navigate to the Inventory Dashboard

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


Step 2: Download the Sample CSV file


Once you click on “Bulk Update Inventory”, a pop-up form will appear:


Before uploading your CSV file, we recommend downloading the sample file format to ensure accurate update of your inventory items.


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 edited details of the inventory item.


As you can see above in the sample file, you can edit details such as:


  • Name (Optional): If you want to keep the item name the same, then leave this field empty or otherwise, add the updated name.

  • SKU ID (Mandatory): Ensure that you mention the correct SKU ID for a successful Bulk Update. You can find the SKU ID of a particular item from your Inventory dashboard:


  • Item Type (Mandatory): Mention whether the item is a product or a service.

  • Description (Optional)

  • HSN code (Optional)

  • GST rate (Optional)

  • Unit (Optional)

  • Currency (Optional)

  • Cost Price (Optional)

  • Selling Price (Optional)

  • In stock Managed (Mandatory): State whether the stock of that particular item should be auto updated by writing TRUE or FALSE in the cell.


For example, for your Product Items, you would want to keep it as TRUE. While for the Service Items OR for product Items that are for one-time use, you can keep this as FALSE.


Important: Ensure that you don't leave the mandatory fields empty. Otherwise, you will face errors while bulk uploading.


Step 4: Upload the CSV file


Once you are done adding all your updated inventory data to the CSV file, go back to the Bulk Update Inventory option, 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 in your CSV file, and re-upload the same after rectifying the errors.


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


(Note: Do keep in mind that updated 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 contact us via live chat support for quick assistance!