How to Add Items in Bulk Using myBillBook

Feature Overview

Efficient inventory management is critical for businesses. myBillBook’s bulk item upload feature simplifies the process of adding multiple inventory items to your account. Instead of manually entering details for each product, you can upload an Excel sheet with all the relevant information. This saves time, reduces errors, and ensures a seamless inventory setup.

Business Benefits:

• Time Efficiency: Quickly populate your inventory with multiple items.

• Error Reduction: Minimized manual entry reduces data inaccuracies.

• Scalability: Ideal for businesses with large inventories or frequent item update

Steps to Set Up and Use the ‘Bulk Item Upload’ Feature

Follow these steps to upload items in bulk to your myBillBook account:

1. Access Items Section:

   • Log in to your myBillBook account.

   • From the navigation bar, select Items.

2. Initiate Bulk Upload:

   • Click on the Bulk Upload icon located next to the “Create New Item” button.

3. Select Upload Format:

   • Choose the option Excel (.xlsx) file.

4. Prepare Your Excel File:

   • Create an Excel file with the following columns:

     • Item Name: The name of the product.

     • Sales Price: The price at which the item is sold.

     • Purchase Price: The cost price of the item.

     • Other Details: Include optional columns like HSN/SAC code, GST rates, or stock quantity.

   • You can organize these columns in any order.

5. Upload the Excel File:

   • Select and upload the prepared Excel file.

   • Ensure the data aligns with the required fields to avoid upload errors.

6. Confirm and Save:

   • After uploading, the system processes the file.

   • Review the data summary and confirm the upload to add items to your inventory.

FAQs on the Bulk Upload Feature