VendSoft allows you to import your inventory data from an Excel file.
Import Process
Download the template Excel file from here.
Fill in the required product data
Save the file
Go to the Inventory screen
Click Import
Select your file and click Import
Required Fields
Product Code
Unique identifier for the product (text, numeric, or alphanumeric)
Example: MM-PEA, Coke, 1, 2, 3
Product Name
Full product name
Example: Coca-Cola 12 oz cans
Enter one of the predefined types or a custom type:
Beverage
Food
Hot drink
Ingredient
If the type does not exist, it will be created automatically.
Optional Fields
Units per Case
Number of items per case or box
Used in purchase records
Reorder Point
Minimum stock level (in single units)
Product appears in Reorder screen when below this level
In Warehouse
Initial stock quantity (in single units)
Last Cost
Purchase price per unit
Barcode
Product barcode
Important Notes
Only .xlsx files are supported (not .xls)
Product Code, Product Name, and Product Type are required
Product Codes must be unique
If duplicates exist, only the last record will be imported
If a product already exists, its data will be updated based on the Product Code
Tip
To update stock levels in bulk:
Export your inventory from the Inventory screen
Keep only:
Product Code
In Warehouse
Update quantities
Import the file back
This updates stock levels without changing other product details.