Bulk Products
- check_circle Download the product import template.
- check_circle Fill in the data as per the required fields below:
- check_circle Fields Description
- check_circle Product Name (Required): Name of the product
- check_circle Brand (Required): Name of the brand
- check_circle (If not found, a new brand with the given name will be created)
- check_circle Unit (Required): Name of the unit
- check_circle Category (Optional): Name of the category
- check_circle (If not found, a new category will be created)
- check_circle Sub Category (Optional): Name of the sub-category
- check_circle (If not found, a new sub-category will be created under the parent category)
- check_circle SKU (Optional): Product SKU (If left blank, it will be auto-generated)
- check_circle Manage Stock? (Optional):
- check_circle 1 = Yes
- check_circle 0 = No
- check_circle Alert Quantity (Optional): Required only if Manage Stock = 1
- check_circle Variant Type (Required): Options: single, variable, materials
- check_circle Variation Name (Required if Variable): Example: Size, Color
- check_circle Variation Values (Required if Variable): Example: RED|GREEN|PINK
- check_circle Purchase Price (Required): Numbers only
- check_circle (For variable: e.g., 10|12|15)
- check_circle Selling Price (Required): Numbers only
- check_circle (For variable: e.g., 12|15|17)
- check_circle Product Description (Optional)
- check_circle Not for Selling (Optional):
- check_circle 1 = Yes
- check_circle 0 = No
- check_circle Barcode (Optional): (If blank, auto-generated)
- check_circle Tax (Optional): Example: VAT 5%, VAT 0%
- check_circle Tax Type (Optional): Options: inclusive, exclusive
- check_circle Product Type (Required): Options: goods, services, materials
Ø Bulk Stock Update
You
can download the bulk stock update template and update stock for existing
items.
Ø
Stock
Update Types
1.
Add
Stock: Adds
quantity to existing stock
2.
Replace
Stock: Replaces
existing stock with new quantity
Ø
Required
Fields
1.
Product
Name
2.
Barcode
3.
Quantity
Ø
Validation
Rules
1.
Product
name should not be empty
2.
Barcode
must not be empty and must exist in the system
3.
Quantity
must be numeric
Bulk price change
1. Download the template.
2. Enter
the required details such as Selling Price and Wholesale Price (if applicable),
then import the file.
Ø
Fields
Description
- Product Name (Required): Name of the product
- Barcode (Required): Product barcode
- Sale Price (With Tax)
(Required):
Selling price including tax
- Wholesale Price(Without
Tax) (Required):
Wholesale price
Ø
Validation
Rules
1.
Product
name should not be empty
2.
Barcode
must not be empty and should exist in the system
3.
Selling
price and wholesale price must be numeric