How to Import Products in GPOS
This tutorial will guide you through the process of importing multiple products into GPOS using a file upload. This method is useful for quickly adding or updating large product lists.
🛠️ Why You Might Need to Import Products
To add a new product catalog in bulk
To update product details such as prices, categories, or stock levels
To migrate products from another POS or inventory system
To save time compared to adding products manually one by one
📋 Steps to Import Products in GPOS
✅ Step 1: Go to the Import Products Screen
Log in to your GPOS dashboard.
From the side menu, navigate to “Inventory”.
Click on “Import Products”.
✅ Step 2: Choose the File to Import
Click the “Choose File” button.
Select your prepared product list file (in the required format).
Make sure the file contains all necessary columns as per GPOS requirements.
✅ Step 3: Select Product Action for Same Name/Code
If a product with the same Name or Code already exists, choose one of the following:
Update the Product – Existing product details will be updated.
(Other options may be available depending on your GPOS settings.)
✅ Step 4: Follow File Column Requirements
Your file must follow the exact column order and rules below:
| Column # | Column Name | Instruction |
|---|---|---|
| 1 | Product Name | Required – If empty, row will be skipped. If not found, a new product will be created. |
| 2 | Product Code | Optional – If blank, the system will generate automatically. |
| 3 | Unit Name | Required – If empty, row will be skipped. |
| 4 | Category Name | Optional – If not found, a new category will be created. |
| 5 | Subcategory Name | Optional – If not found, a new subcategory will be created. |
| 6 | Brand Name | Optional – If not found, a new brand will be created. |
| 7 | Warranty ID/Name | Optional |
| 8 | Stock Type | Optional – 1=Physical Product, 2=Service/Digital Product (Default: 1) |
| 9 | Alert Quantity | Optional |
| 10 | Tax Percent | Optional – Only enter a numeric value like 5.00 (no %) |
| 11 | Tax Type | Optional – 1=Exclusive (default), 2=Inclusive |
| 12 | Tax Applicable For | Optional – 1=Selling Price (default), 2=Cost & Selling Price |
| 13 | Unit Cost | Optional |
| 14 | Unit Price | Optional |
| 15 | Enable IMEI/SL No. | Optional – YES/NO (Default: NO) |
| 16 | Is For Sale | Optional – YES/NO (Default: YES) |
| 17 | Enable Batch No/Expire Date | Optional – YES/NO (Default: NO) |
| 18 | Opening Stock | Optional – Added to the logged-in user’s store |
| 19 | Expire Date | Optional – Format: 16-08-2025 / 2025-08-16 / 08-16-2025 |
✅ Step 5: Upload and Import
Review your file for accuracy.
Click the “Import” button.
GPOS will process the file and show a success or error report.
🔐 Important Notes
Always back up your product data before bulk importing.
Only authorized users can import products.
Invalid rows will be skipped, but valid rows will still be imported.
🎯 Tips
Download a sample file from GPOS before preparing your import.
Double-check spelling of units, categories, and brands to avoid duplicates.
For bulk price updates, keep the product code (SKU) the same and only change the price columns.
By following these steps, you can quickly add or update hundreds of products in GPOS in just a few minutes.