Importing Store Details in Xilnex Portal
Overview
The Import Store Details in Xilnex Portal is a function that allows users to import store data in bulk using CSV files.
Users have the option to import the store details either With updating the existing records or Without updating the existing records.
Why do we create this function?
This function allows users to import the updated of existing or newly created store details in bulk. While the Store Management module allows user to manually create and manage store information, the process can be time-consuming when handling a large number of stores.
By using the import function, users can efficiently create new stores or update existing ones in bulk, saving time and reducing manual effort.
What is the difference?
The differences between importing store details with and without updating existing records are outlined below:
Import Option | Behavior | Status |
With Updating Existing Records | Update existing store details if changes are detected. | Success if any changes in the record are applied. |
Without Updating Existing Records | Skips the row if the store already exists. | Success if new store added. Failed if no changes applied and store already exist. |
How to Import Store Details?
- Go to [System Configuration] in the menu bar.
https://portal.xilnex.com/SystemConfiguration - Select [Store Management Import and Log].
- Click the green [IMPORT] button located at the top-right of the screen.
- An import form will appear where you can upload a file to import.
Important: Make sure your CSV file follows the provided template format; otherwise, the import process may fail. - Your CSV file should include the information based on the template. The fields that can be updated include:
- Store Name
- Mark as loyalty app default store
0 = Do not set as default store1 = Set as default store
- Printed Name
- Printed Address
- Owners Name
- Owners Contact Number
- Owners Email Address
- Owners Fax
- Company Registration Number
- Tax Identification Number
- Store Entity
- Store Ownership
- Store Location
- Store Code
- Store Group
- Store Type
- Location Latitude
- Location Longitude
- Delivery Address
- Delivery City
- Delivery State
- Delivery Postcode
- Delivery Country
- Delivery Notes
You are not required to update all fields. You may update only the necessary fields, or update store details directly in Store Management. Refer to “Updating Store Details in Xilnex Portal” for more information, or click the provided link.
https://support.xilnex.com/portal/en/kb/articles/updating-store-details-in-xilnex-portal#How_to_Update_Store_Details_in_Xilnex_Portal - There are two ways to upload your file:
- Drag and drop the file into highlighted section, or
- Click on the section to browse and select the file from your device.If you do not have the Template, click on the [Sample Store Management CSV Template]
- The uploaded file will appear in the highlighted section.
- Use the [Show Preview] feature to review the uploaded file before importing.
- Once confirmed, you may click on the [IMPORT] button.
Option 1: Import Store Details WITHOUT Update Existing Store Details
1. click the [NO] button to skip updating existing records.
2. After the file is successfully imported, the record will be listed in the log with the status "Processing", indicating that the system is handling the import.
3. click the [REFRESH] button to update the log and latest import status.
4. Once refreshed, the record status will change to "Processed". Click [MORE] and navigate to [Preview] to view the details and status of each imported record.
5. The preview will show the status of each imported record.
Status will display Failed when a store already exists and the user chooses to import the details without updating the existing records.
If the store does not exist in the system and the user includes it in the CSV file, the store will be created as a new record, and the status will display Success.
Option 2: Import Store Details WITH Update Existing Store Details
1. Click the [YES] button to update existing records.
2. After the file is successfully imported, the record will be listed in the log with the status "Processing", indicating that the system is handling the import.
3. Click the [REFRESH] button to update the log and latest import status.
4. Once refreshed, the record status will change to "Processed". Click [More] and navigate to [Preview] to view the details and status of each imported record.
5. The preview shows the status of each record:
Success→ Existing store details are updated, or new stores are added.
Failed→ Occurs only if there is an issue with CSV file reader.
How to verify Imported Store Updates?
Users can navigate to [Store Management] in [System Configuration] to check if the store is updated.
Related Articles
Downloading Store Sample CSV Template File in Xilnex Portal
Overview The Download Store Sample CSV Template File feature in Store Management Import and Log allows staff to download a sample template, containing all necessary fields and proper format for importing data into the system. Preparing imported files ...Updating Store Details in Xilnex Portal
How to Update Store Details in Xilnex Portal 1. To update store details, go to [System Configuration] in the menu bar and select [Store Management]. 2. Double-click the store or select more and click [EDIT]. 3. The existing store information will ...Importing Usernames in Xilnex Portal
What is User Import? User Import allows you to add, update, or manage multiple users in bulk rather than handling them one by one. This feature is especially useful for onboarding new employees, migrating data, or making large-scale updates to user ...Deleting a Store in Xilnex Portal
How to Delete a Store in Xilnex Portal 1. To delete a store, go to [System Configuration] in the menu bar and select [Store Management]. 2. Select the store you want to delete. 3. Select [DELETE]. Important Note: Once a store is deleted, this action ...Creating a New Store in Xilnex Portal
How to Create a New Store in Xilnex Portal To create, edit, or delete a store, go to [System Configuration] in the menu bar and select [Store Management]. The system will display a list of stores accessible to your account. Create a New Store 1. ...
Recent Articles
Downloading Store Sample CSV Template File in Xilnex Portal
Overview The Download Store Sample CSV Template File feature in Store Management Import and Log allows staff to download a sample template, containing all necessary fields and proper format for importing data into the system. Preparing imported files ...Importing Store Details in Xilnex Portal
Overview The Import Store Details in Xilnex Portal is a function that allows users to import store data in bulk using CSV files. Users have the option to import the store details either With updating the existing records or Without updating the ...Centralized Secondary Screen Media
Secondary Screen Guidelines Current Setup (Local Media) Currently, the secondary screen relies on a local folder to display media on the POS. Xilnex POS automatically creates a folder named "SecondaryMonitorMedia" on the desktop, or users can ...LiveOrder Dynamic QR - Setup Guide
What is Dynamic QR? Dynamic QR generates a unique, per-session QR code at point of order — typically printed when a table is opened. The customer scans it to place or continues an order tied to that specific table session. Unlike Static QR ...LiveKiosk Enablement - User Guide
Overview LiveKiosk is a web-based self-ordering kiosk that runs on the same engine as LiveOrder. It allows customers to place orders independently via a kiosk device — available on Windows (via Classic POS) or Android (via the LiveKiosk APK). All ...
Popular Articles
Basic - How to create a voucher-coupon
Voucher and coupon definition Voucher can be generated in bulk and can be used once Coupon can only be created one at a time (reusable code) and can be use multiple times Pre-voucher / coupon setup There are 2 things need to be prepared before we can ...Understanding DuitNow QR Payment in ClassicPOS
Introduction This document introduces the DuitNow QR payment feature available in the Xilnex Retail POS, enabling merchants to accept payments conveniently through Malaysia's national QR payment standard. The integration of DuitNowQR simplifies the ...Basic - How to change custom cost to another branch that don’t have custom cost
Change custom cost to another branch that don’t have custom cost 1. Get the item list from the location with custom cost (Item Code, Name, Custom Cost) 2. Make sure the Show Location Price are selected 3. Export the item list in Excel 4. The file ...Intermediate - How to Bill & Post to Sales from Transfer Note
1.0 Purpose A bill is required from transfer note when an inventory transfer involves financial transactions, cost allocation, or compliance with tax and accounting regulations. It is used when stock is moved between outlets that operate as separate ...Basic - How to enable E-Receipt Portal and QR Code Setup on Printing format in Xilnex
Enable E-Receipt Portal Enable the E-receipt functionality Once Enabled, you will be getting the E-Receipt portal link Continue under Theme & Styling, enabled for the E-Invoice (LHDN) You can customize the look and feel of the E-Receipt portal ...