How To Import Master Excel file in RetailGraph Software?

Import Master Excel file in SwilERP (Retailgraph)

How To Import Master Excel file in SwilERP (RetailGraph)
In RetailGraph, we can import products through an excel. In this article, we will see the steps which need to be taken to import product master. In the below image, an excel sheet containing product details can be seen.


import products through an excel

We need to a  create Demo Data In Retail Graph. And after creating it,we need to create a  Demo Product In Product Master Like in following image. 

Demo Product In Product Master

After that, we need to go to Start-->Option-> Export import Data -> Inventory , to export product master in excel.


Export import Data

When we export the above details in excel, then a standard format comes up with details as can be seen the below image.                  


details in excel

In the exported excel file, we need to put all the details in respective columns to import it into RetailGraph again.

 Before that, we need to Export HSN Master from ReatilGraph and to do the same, we need to go to

Start-->Option-> Export import Data -> Inventory -> HSN


HSN

After putting details in the HSN master, we need to import it in RetailGraph.

HSN maste

After importing HSN Master, we will import the product master file by going Start-->Option-> Export-import Data -> Inventory. We need to click on import and select the file from the path as shown the below image.


After importing HSN Master

After importing it, we can see the products which have been imported in Masters>Inventory>Product.

imported in Masters





      • Related Articles

      • How to Export/ Import Master data

        How do exporting/importing master data in SwilERP (RetailGraph)? In RetailGraph, you have the feature to export the master data to excel sheets. You can export blank template files for master data creation using the Export/Import Master Data option ...

      • SwilERP (RetailGraph) GSTR1 Excel and CSV Export and Upload

        How to Export GSTR-1 Data From SwilERP (RetailGraph) Please Click the following link to see through the video how to Export "GSTR1 through Excel and CSV in SwilERP" Watch Now What is GSTR-1? GSTR-1 form is a monthly Statement of Outward Supplies to ...

      • Navigating SwilERP (RetailGraph)

        Menu Options of SwilERP (RetailGraph) This Article will help you to find the menu and how to navigate the transaction options of SwilERP. When you click the Start button, the menu options are available on SwilERP. Along with the Start button, you can ...

      • Import PRN File & Print Barcode

        How to Import PRN File & Print Barcode in SwilERP (RetailGraph) What is PRN File? The PRN file format represents a print ready document. It is basically used for barcode designing in SwilERP software. PRN file contains data with instruction sets for ...

      • Export GSTR-2 Excel File

        How to Export GSTR2 Excel File Through SwilERP Software What is GSTR-2? The GSTR-2 is a monthly tax return showing the purchases you’ve made for that month. When you make purchases from registered vendors, the information from their sales returns ...