Create bulk Stock items in Suvit
The Suvit is providing a feature where you can create stock items in bulk. Simply prepare you excel sheet accordingly and proceed in the option of "Item" in bulk upload.
Create bulk Stock items in Suvit
Step 1: Sign in to Suvit
![1image.png](https://strapi.suvit.io/uploads/1image_c833a4040b.png)
- After clicking on the dashboard, click on "Explore Now" for Data Entry Automation, which will open the Data Entry Automation page.
![-01.png-20_103234.png](https://strapi.suvit.io/uploads/01_png_20_103234_3dd7267062.png)
Step 2: Click on Bulk Upload
- Click on Bulk Upload from the left menu.
![2image.png](https://strapi.suvit.io/uploads/2image_d772a76c0c.png)
Step 3: Download the Sample Excel Sheet
- In the Item Excel page, you will get the option to download a sample or upload any excel format. Click on "Download Sample," and an excel sheet will be downloaded.
![3image.png](https://strapi.suvit.io/uploads/3image_85ced92794.png)
Step 4: Fill in the Required Details
- Open the excel sheet, fill in the required details, and save it. "Name", "Under", and "Unit" are mandatory fields to be filled in.
![4image.png](https://strapi.suvit.io/uploads/4image_8462eb76f1.png)
Step 5: Upload the Excel Sheet
- Go back to the Item Excel page, click on "Upload," select the company, browse your ledger excel, and upload it. During the upload, you will get an error log if any ledger has failed, with the reason.
![6image.png](https://strapi.suvit.io/uploads/6image_bf2a1d79ca.png)
Step 6: Map the Fields
- After the upload, you will be redirected to the Mapping field page where you map the data. Once the mapping is done, click on Save & Proceed.
![7image.png](https://strapi.suvit.io/uploads/7image_95f3a2270c.png)
- After Save & Proceed, you will get an error popup if there's a mistake in the sheet. You can see the error in the popup or Download excel error ledger log.
- On the item transaction screen, you will get the remark "failed reason".
![8image.png](https://strapi.suvit.io/uploads/8image_101e8fa4ce.png)
Step 8: Save the Transaction
- Go back to the ledger transaction page, find the record you want to import, select the record, and click on Save.
![10image.png](https://strapi.suvit.io/uploads/10image_18c0d3c01b.png)
Step 9: Send the Transaction to Tally
- Click on the right-side corner of the drawer and click on Send the transaction to tally. After that, you will get a popup. Click OK to continue or Cancel to stop.
![12image.png](https://strapi.suvit.io/uploads/12image_3069065318.png)
![13image.png](https://strapi.suvit.io/uploads/13image_a34d447377.png)
Step 10: Verify in Tally
- Check those item ledgers in Tally. You will find that the stock item masters are created in your Tally.