Pulsar PSR logo
Features
Sales
Android POS Device Desktop POS Cloud Based POS Android POS Mobile App Bill Payment Card Acceptance P2P Payments
Business Process Automation
POS E-invoicing(Egypt Tax Authority) E-receipt(Egypt Tax Authority) Tecards, weighing goods Customer Display POS Software Kitchen Display Software Barcode Price Checker Software QR Menu SDK/API For Enterprise
Clients
Clients Relationship Management(CRM) Online Ordering-Delivery System Offers & Promotions
Management
Management Application(IOS, Android) (soon) Charts Analytics HRM (Soon) Loyalty Programs
Inventory
Suppliers & Purchases Inventory Management
Solutions
Retail
Grocery Store Online Store Supermarket Bakery Shop Eye wear shop Gift Shop Jewelry Store Furniture Store Clothes Shop Butcher Shop Perfume Store Tourists Products Shop
Food Service
Fast Food Restaurants Candy Shops Café & Restaurants Restaurants' Kitchen Food Delivery
Electronics
Mobile Shop Computer Shop Home Appliances
Medicine
Pharmacy Beauty Centers Laboratories Dentistry Doctors Clinics
Others
Cleaning Services Travel And Tourism Agencies Real Estate Agencies Training Centers Fitness & Gym Financial Services Air Conditioner Services Maintenance
Pricing Guides Blog Contacts
Call me
EGYPT
UAE
EN
AR
Features
Sales
Android POS Device Desktop POS Cloud Based POS Android POS Mobile App Bill Payment Card Acceptance P2P Payments
Business Process Automation
POS E-invoicing(Egypt Tax Authority) E-receipt(Egypt Tax Authority) Tecards, weighing goods Customer Display POS Software Kitchen Display Software Barcode Price Checker Software QR Menu SDK/API For Enterprise
Clients
Clients Relationship Management(CRM) Online Ordering-Delivery System Offers & Promotions
Management
Management Application(IOS, Android) (soon) Charts Analytics HRM (Soon) Loyalty Programs
Inventory
Suppliers & Purchases Inventory Management
Solutions
Retail
Grocery Store Online Store Supermarket Bakery Shop Eye wear shop Gift Shop Jewelry Store Furniture Store Clothes Shop Butcher Shop Perfume Store Tourists Products Shop
Food Service
Fast Food Restaurants Candy Shops Café & Restaurants Restaurants' Kitchen Food Delivery
Electronics
Mobile Shop Computer Shop Home Appliances
Medicine
Pharmacy Beauty Centers Laboratories Dentistry Doctors Clinics
Others
Cleaning Services Travel And Tourism Agencies Real Estate Agencies Training Centers Fitness & Gym Financial Services Air Conditioner Services Maintenance
Pricing Guides Blog Contacts
Call me
Log in
By using this site, you accept Cookies Policy
Accept
Help & Support Center
Goods & Services
Import and export products
Getting started with Pulsar program and its features
How to start working with Pulsar?
Goods & Services
Create a new product
Editing а product
Deleting a product from the products catalog
Import and export products
Price tags and labels
Working with products groups
Configure the products catalog
Minimum quantity
Inventory Control
Record the products sale via Personal Account "Sale"
Record the sales returns via Personal Account "Sale Return"
Record the products acceptance "Purchase"
Returning purchased products to the supplier “Purchase Return”
Inventory of products in the store "Inventory Checking"
Accounting write-off of products “Write-Off”
Move the products between stores "Transfer"
Assembling the products into a set "Assemble"
Disassembling a product set intngo sile items "Disassemble"
Change the products retail prices "Revaluation"
Catering & Production
Product components card
The Produce Operation
Recalculation of the dish's purchase price
Reports & Analytics
Product Movement Report
Clients / Suppliers Balance report
The Inclusive Tax Report
Expiration Period Report
Analytics in the product card
The Online Store
Online Store Creation
CRM/SRM/Customers & Suppliers
Creating a customer or a supplier card
Payments: Exploring customers & suppliers payments
Settlements with customers & suppliers
Integration with ETA to submit the e-invoices & e-receipts
E-invoices & E-receipts exchange with ETA
Fill in the organization’s information
Prepare to send the electronic invoices (e-invoices)
Send the electronic invoice (e-invoice) to ETA
Prepare to send the electronic receipts (e-receipts)
Send the electronic receipt (e-receipt) to ETA
CashReg cashier software and its features from A to Z
What is a CashReg program ?
Initial connection to work with the cashier software CashReg
Getting started with the cashier software CashReg
Install the cashier software CashReg
Connect a scale for products that need to be weighed
Sales settings for the cashier software CashReg
Device settings to work with the cashier software CashReg
Sales rules settings in the cashier software CashReg
Point of sale (shop) settings
Employees settings
Operations in the CashReg program
Open the shift in the cashier software CashReg
Add a product to the products catalog
Record the sales in the cashier software CashReg
Record the sales returns in the cashier software CashReg
Deferred receipt in the cashier software CashReg
Closing shift (Z report)
Reminder about working with the CashReg program
PULSAR POS-Device
Adding new goods & services on the Pulsar POS device
Purchase goods & services "Goods Acceptance" by the Pulsar POS device
Sale goods and services "Sale" by the Pulsar POS device
Record the goods & services returns by the Pulsar POS device
Products write-off on the Pulsar POS device
Return purchased goods to suppliers by the Pulsar POS device
Conducting inventory of products by the Pulsar POS device
Purchasing & changing retail prices by the Pulsar POS device
products price tags Excel point of sale

Import and export products

Exchanging via Excel is convenient if you need to quickly create many new products. For example, if you open a new point of sale (store) or a new goods collection has arrived. When you receive an excel invoice from your supplier, new product cards will appear in your terminal in just half an hour. And it will take you a few more minutes to print the price tags for those products in the application.

You can upload your products catalog to the application or select the products, that you sell from prepared catalogs.

Both import from Excel and export data to Excel or CSV are available. If you already have a point of sale (store) with products and want to expand the network - upload the items from the first store, clear the field with Quantity and upload the file to the new store. In just a few minutes you will receive all items with prices, units of measure and product groups.

Products catalogs

If you don't have yet a products catalog, select one that suits you from the following:

متجر المنتجات الغذائية

متجر المستلزمات والأدوات المنزلية

متجر لتقديم خدمات العناية بالصحة

متجر الإكسسوارات والساعات

متجر الاتصالات والخدمات التقنية

متجر منتجات الصيدليات

متجر الكحوليات والدخان

متجر لتقديم خدمات التوصيل

متجر مستلزمات الحيوان والمبيدات الحشرية

Mobile phone and accessories store

Upload products

You can use the import to create and edit a wide range of goods.

  1. Go to menu Import from Excel.
  2. Download the temple, enter your goods there.
  3. Transfer the completed file to the upload area.
  4. Check that the fields match and confirm the upload.
Your browser does not support the video tag.

Learn more about the features below.

Data preparation

To import, you can use the attached template on the Import from Excel to complete with an example of how to complete the data. You can delete unnecessary columns for which you have no data (for example, if the product has no barcode or commodity group). You can also use a different Excel file.

The data in the file must meet several requirements

  • The table must be on the first sheet of the file and start with cell A1.
  • The table must not contain empty hidden rows and columns.
  • The format of cells containing only numbers (e.g: code) must be numerical.
  • Each column must have a title (name).

Please note!

If you add new goods, enter at least one column in the table - Name, but it is more convenient to immediately load the units, price and barcode (if they are found).

If you are updating an existing item, the table must contain a column that will be used to compare goods in the file and in the application. This can be uuid (Universally Unique Identifier in the application) or Barcode. Such fields as Name, Сode or Article are usually not unique and cannot be compared by them.

We do not recommend uploading files with more than 1000 lines. If there is more data to upload, split the product list into several files.

The import of products is available, taking into account the hierarchy of goods groups. It is convenient for transferring the group structure between stores.

File Upload

To upload the products:

  1. Go to the Products section → Import from Excel.
1

2. Select the file prepared for upload.

2

3. Specify the store, to which you want to upload the products. If you want to upload the products to several stores, repeat the operation for each store separately.

3

4. Specify the settings:

When adding new goods in the Unique key window, leave the value Do not update.

When changing data on an existing item, in the Unique key window, specify which field to search for a good match in the file and in the application (UUID or Barcode).

4

5. For each column, specify the match - in which field of the goods card to add the columns from the file.

5

6. Click Next. Upload the file may take some time, usually depending on the amount of data.

6

7. Wait for a notification that the data upload has successfully completed.

7

8. Switch to the Products tab and continue to work with them.

Please note! When updating the items, goods identification by name and code is undesirable. The value to be searched for must be unique for each item to avoid errors.

Download products

To download the products to Excel:

  1. Go to the Products tab and click on the Cloud icon located in the top left corner.

8.max-800x600


2. In the window that opens, click Download as Excel. The table will contain all product data available in the application, including the Universally Unique Identifier UUID.

9.max-800x600

If you want to copy only part of the products to excel, set the necessary filters (group and others) on the Products tab, then right-click in any cell of the table and choose Export → Excel Export in the menu that appears.

10

In the article
Products catalogs Upload products Download products
Pulsar PSR логотип
info@psr.com.eg
Resources
Guides Blog License Agreement
Company
About PSR Contact Careers
info@psr.com.eg Privacy Policy
Privacy Policy
© Pulsar for Information technology L.L.C, 2023

All details will be sent to
you via email

By sending your details you agree to the privacy policy

Сall you back

Enter your phone number and we will call you back
By sending your details you agree to the privacy policy
Your request has been
submitted successfully