Excel templates are available inward CSI Point of Sale software (POS>> Business Services >> Upload Bulk/Upload Prepaid Bulk >> Click "?" assist epitome on the elevation correct >> Click link inward Web page) which tin endure copied in addition to used for uploading of Bulk articles received from BNPL customers in addition to Prepaid articles (affixed amongst PS, FM, SS) received from diverse mass customers/Bulk Postal Service letters
Most of the Data similar Name, Address 1, Address 2, Destination City, PIN codes, Mobile numbers are provided past times the well-nigh of the mass BNPL customers/ prepaid mass senders inward Excel files through email/CD every bit these basic information are already available amongst them inward their system/database.
Few mass customers also include Article Barcode numbers inward the Excel canvas provided past times them, if barcode serial already supplied to them.
Using those basic data, nosotros may convey to deport out certainly COPY, PASTE, EDIT, FORMAT industrial plant exclusively inward prescribed Excel templates for making the file ready for uploading.
Only rattling few customers who are non using organisation to a greater extent than ofttimes than non spend upwards to render inward a higher house said basic information inward Excel file. For those articles exclusively nosotros may endure supposed to develop Excel template.
In such cases,
Doing Data entry of Articles information inward Excel template itself is the easier ane comparison to using diverse information entry tools meant for creating mass templates.
Advantages of doing Data entry inward Excel template itself:
1) Sl.No., Reference number, weight, Prepaid mode, FM license ID, SOM Numbers all tin endure easily filled inward Excel past times using simply drag downward (fill series/ re-create cells) selection inward Excel every bit the illustration may be.
2) Barcode numbers tin endure scanned continuously every bit afterward scanning each in addition to every article, cursor automatically movement to adjacent jail cellphone inward lower row. Scanning of articles tin endure easily done inward Excel file (Sequence of articles should non endure shuffled till successful upload of articles).
3) Moving from ane jail cellphone to or in addition to hence other is rattling tardily (by using locomote into / navigation arrows) piece doing Data entry inward Excel template when comparison to dull information entry procedure inward Point of sale / Any other Data entry tool similar to holler for of sale booking screen.
Caution :
1) Sequence of articles piece doing Data entry in addition to scanning articles should endure same. Should non endure shuffled at whatsoever terms till uploading inward POS mass upload.
2) PIN code champaign has to endure uniformely changed to position out format (using format cells).
3) Always relieve the Excel inward ".xls" file format. Please don't relieve inward ".xlsx" file format.
4) Tally full position out of articles earlier uploading.
5) Delete whatsoever other additional rows/columns (with whatsoever data) unknowingly available below actual rows to endure uploaded.
6) Please don't type name/address to a greater extent than than twoscore characters every bit prescribed.
7) All mandatory fields should endure filled inward the template (SL.No, Ref No., Barcode no., Name, Address 1, Address 3, City, PIN, weight). For prepaid bulk, vogue of prepaid, Prepaid sum should endure entered. For FM prepaid bulk, FM license ID in addition to SOM should endure additionally entered.
