How To Import Data in RetailGraph through CSV File?

Import Data in SwilERP (RetailGraph) through CSV

How to Import Data in SwilERP (RetailGraph) Software through CSV File                 




In SwilERP, we can import a purchase invoice through a CSV file. An Example of a CSV file is given below.


RetailGraph

We need to Check Barcode Field And other Columns In excel Sheet after that we need to save it as CSV File

As Following Images:


CSV File


After that, we need to go to Start-->Option-> Export import Data -> Others- CSV Format Definition.

Over here, we need to map fields of CSV file to SwilField as shown the below image.


CSV Format Definition.


As can be seen in the above image, Format Name has been set as‘REDTAPE’ and Import File Path has been set as well. After saving this file, one needs to come to the transaction In Export Import Data.

Over here in Import Transactions, one needs to check the ‘CSV Others’ field and in the Transaction field,’Purchase Invoice’  needs to be selected. There is one more field called ‘Range’, series of the purchase invoice must be selected in this. The vendor must be selected and ‘Add Master’ and ‘Import Barcode’ fields are needed to be checked as shown in the below image.


Export Import Data
We need to click on Ok
 and select the CSV file from the path.
​
Ok and select the CSV file


We need to check out that product and color are being mapped properly.

Retailgraph

After clicking on ok, the file gets imported successfully and in the purchase invoice, one can see the invoice which has been imported as shown the below image.


purchase invoice






      • Related Articles

      • Export Tally Data from SwilERP (RetailGraph) & Import it into Tally

        How to Export Tally Data from SwilERP (RetailGraph) & Import it into Tally This article explains how to export tally data from SwilERP and import data in Tally. Basic Information In SwilERP, there is a feature to export master & voucher data for the ...

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

      • Import/Export Data

        How To Import/Export Data In SwilERP (RetailGraph) Software What is Import/Export Process? The Export Transaction feature in SwilERP allows users to generate transaction details in various formats for sharing or uploading purposes. Users can choose ...

      • How to Allow PharmaRack Integration Process In SwilERP (RetailGraph)

        Integration of PharmaRack in SwilERP (RetailGraph) Software PharmaRack is India's largest integrated B2B Healthcare platform. Seamlessly connecting pharma retailers with their distributors. Retailers use PharmaRack to order products from distributors ...

      • Export/Import all Customers (Debtors) party list

        How to Export/Import all Customers (Debtors) party list in Excel format in SwilERP (RetailGraph) Customer's or Debtor’s Ledgers Option in SwilERP Software facilitates the user to easily view the ledger account and balances of the Customers/debtors ...