Wednesday, February 28, 2018

Generate City Name from Pincode for Bulk Upload

While uploading "Domestic Bulk mail/Prepaid mail/bulk M.O." Excel templates in CSI POS, "City PIN not matched" error is often thrown for many articles, if name of the City does not exactly match with Pincode of articles.

To manage the issue, this Excel sheet has been prepared in which if PIN CODES are pasted (To be copied from Excel template), City names and P.O. names will be populated automatically. 
Just copy the data populated in those two columns and paste them in CITY , ADDRESS columns of Excel templates.
Because of this, hereafter no need to type City names and P.O. names in Excel templates for large volume of bulk articles going to be uploaded in CSI Point of sale. 

Note: 

However, other mandatory fields like Name, PIN, weight, Sl. No. etc., are to be entered in Excel templates carefully as usual. 

Always use the .xls template format available in POS for uploading data. Please do not save the Excel template file as .xlsx file type. 

Please ensure that only the valid data rows are maintained in the file and remaining unnecessary rows are deleted.
Click below link to download

No comments:

Post a Comment