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

      • Importing Purchase Invoices in SwilERP through CSV File

        How to Set CSV Format & Import Data in SwilERP What is a CSV File? A CSV (Comma-Separated Values) file is a simple format used to store table-like data, such as spreadsheets. It can be opened in programs like Microsoft Excel. Many companies now share ...

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

      • How to Import Master Data in Swil Admin

        Import Master Data from Other CRMs to Swil Admin In Swil Admin, you can smoothly import the master data from other CRMs in just four simple steps: upload the file, select the header row, match your table, and validate your data. Swil Admin is ...

      • Import PRN File & Print Barcode

        How to Import PRN File & Print Barcode in SwilERP 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 printers, such ...

      • Export GSTR-2 Excel File

        How to Export GSTR-2 Excel File Through SwilERP Software What is GSTR-2? GSTR-2 is a monthly tax return that contains details of all purchases (inward supplies) made during a particular month. When you make purchases from registered vendors, their ...