Help Center
< All Topics
Print

How to Import Products in GPOS

PostedAugust 16, 2025
UpdatedAugust 16, 2025
Byadmin

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

  1. Log in to your GPOS dashboard.

  2. From the side menu, navigate to “Inventory”.

  3. Click on “Import Products”.

✅ Step 2: Choose the File to Import

  1. Click the “Choose File” button.

  2. Select your prepared product list file (in the required format).

  3. Make sure the file contains all necessary columns as per GPOS requirements.

✅ Step 3: Select Product Action for Same Name/Code

  1. 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

  1. Review your file for accuracy.

  2. Click the “Import” button.

  3. 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.

Table of Contents