@usercan('bulk-uploads.create') @endusercan Download File

Instructions

Note: Please follow the instructions below to upload your file.

1. Download the sample file first and add all your products to it.
2. * Indicates a required field. If you do not provide the required fields, the system will ignore the product.
3. After adding all your products, please save the file and then upload the updated version.

{{ __('SL') }}.	{{ __('Field Name') }}	{{ __('Description') }}
1	Product Name *	The name of the product you are adding (e.g., "Banana").
2	Product Category *	The category under which the product falls (e.g., Beverages, Electronics). If the system does not find this, it will automatically create a new one.
3	Unit Name	The measurement unit used for the product (e.g., Piece, Kg, Litre, Box). If the system does not find this, it will automatically create a new one.
4	Brand Name	The brand or manufacturer associated with the product (e.g., Samsung, Nestlé). If the system does not find this, it will automatically create a new one.
5	Stock Quantity	The available quantity of the product currently in inventory.
6	Product Code *	A unique code for the product, often used for barcodes or easy search. Product codes must be unique. If a code is already in use and you include a non-unique product code in the file, the system will ignore that product.
7	Purchase Price *	The cost price of the product without including VAT.
8	Sale Price(MRP) *	Maximum Retail Price — the highest price allowed to sell the product to customers.
9	Dealer Price	Special discounted price for resellers or dealers who buy in large quantities.
10	Wholesale Price	The price offered for bulk purchases, typically lower than the MRP.
11	VAT Name	The name of the VAT (Value Added Tax) applied to the product. If the system does not find an existing VAT entry, it will automatically create a new one and set the rate based on the VAT (%) value you have provided in the column.
12	VAT (%)	The percentage of VAT (Value Added Tax) applied to the product.
13	Vat Type (exclusive / inclusive)	Whether the VAT is added on top of the price (exclusive) or already included in the price (inclusive).
14	Low Stock Qty	The quantity threshold to alert when stock is low (e.g., if stock drops below 10 units).
15	Manufacturer	The name of the company or entity that produces the product.
16	Expire Date	The expiry date for the product, useful especially for perishable goods.