Preview
Step 1 · Choose the source

Start with a clean dealer CSV

Upload up to 2,000 rows. Nothing is created until mapping and row validation are complete.

.CSV only2,000 row limitSafe re-run

Upload dealer file

We inspect the headers first, then ask you to confirm the mapping.

Drop your CSV here

or choose a file from your computer

nashik-dealers-jul26.csv
8 rows · 2.1 KB · structure inspected
8rows detected
8columns detected
UTF-8encoding
Ready for column mapping
Step 2 · Confirm the structure

Map your headers to dealer fields

We auto-matched every detected column. Required fields are highlighted in blue; optional fields can be left unmapped.

8/8 matched5 required3 optional
8source columns detected
8fields auto-matched
0unmapped required fields

Column mapping

Source headers and sample values are shown exactly as read from the file.

Source columnDealer fieldRequirement
firm_name“Vitthal Hardware Mart”
→
Required
mobile“9822103847”
→
Required
gst_no“27ADFPV6612L1Z9”
→
Optional
pan_no“ADFPV6612L”
→
Optional
addr“Deolali Camp, Nashik”
→
Optional
credit_limit“350000”
→
Required
terms_days“30”
→
Required
territory“Nashik Rural”
→
Required
Validation does not save anything. The next step checks required values, formats, duplicate GSTINs and negative credit limits row by row.
Step 3 · Review the evidence

Four rows are ready to import

Duplicates will be skipped and rejected rows will remain untouched. Review the reasons before committing the clean records.

4 ready1 duplicate3 rejected
4Will be created as pending
1Will be skipped safely
3Need source-file fixes
#DealerPhoneGSTINCredit limitOutcome
1Vitthal Hardware Mart98221 0384727ADFPV6612L1Z9₹3,00,000✓ Will create
2Sharma Traders98230 1127427ABCFS7291M1Z8₹5,00,000Skipped · duplicate
GSTIN already belongs to an active dealer.
Open existing dealer →
3Deshpande Cement Traders98904 2215627AEFPD8834N1Z2₹4,20,000✓ Will create
4Ashok Iron & Steel Depot—27AGHPA3321P1Z6₹2,80,000Rejected
Phone is required; the mobile cell is blank.
5Kulkarni Steel & Hardware98505 67231—₹3,60,000✓ Will create
6Waghmare Traders98221 7843027AGT9912₹2,50,000Rejected
GSTIN is 9 characters; it must be exactly 15.
7Jadhav Building Supplies98230 9451227AJKPJ5567R1Z4₹5,40,000✓ Will create
8Pawar Enterprises98904 6512027ALKPP7723S1Z8−₹50,000Rejected
Credit limit cannot be negative.

Dealer import completed

nashik-dealers-jul26.csv was processed without duplicating existing records. Four new dealers are ready for approval.

4Created · pending
1Skipped · duplicate
3Rejected · unchanged

Created successfully

These records now appear in the Dealer directory with ordering disabled.

Vitthal Hardware MartDeshpande Cement TradersKulkarni Steel & HardwareJadhav Building Supplies

Still needs repair

Download or fix these rows in the source file before re-running.

Ashok Iron & Steel Depot · phoneWaghmare Traders · GSTINPawar Enterprises · credit limit
Safe to re-run. The four created dealers and Sharma Traders will be recognized and skipped. Only corrected rows can create new records.
Open Dealer directory

Connection lost during validation

Your file and confirmed mapping are preserved. No dealer records were created, so retrying cannot produce a partial duplicate.

CSVpreserved
8/8mapping preserved
0records created