Purpose -The purpose of this screen is to allow mapping of columns from External POS applications CSV or xls files to the respective migration master fields in our POS system.
There are two steps in this process :
1.Create an External POS in the External POS Master.
2.In the External POS migration sheet mapping screen, there are two processes:
Sheet Mapping
Sheet Upload.
In the External POS Master screen, follow the below-mentioned steps to create as POS name.
Steps to create an External POS Master
1. Go to Tools --> More--> External POS Master
2. Select Add new button.
3.Enter the name and set the status as Active, and click on the Save button, and you will get a message as "POS details saved successfully".
Under the Status column, you can view All, Active, and Inactive POS Add-ons. Using the Edit option, you can modify the POS Name or Status to update it as Active or Inactive.
In External POS Sheet Mapping:
This process is used to import the sheet and map the CSV fields with the corresponding migration master fields in TruePOS. Kindly follow the below mentioned steps to complete the sheet mapping:
Step 1:Select the Product name, Migration name .
Step 2: Click on the Import button and upload the sheet.
Note: Please check the master migration screen under the Tools menu to ensure that the respective migration fields are enabled and set mandatory as requirement.
Step 3: Map the External Csv fields correspondingly to the fields of master migration in TruePOS and verify whether fields are mapped correctly and click on Save button.
Note: If the mandatory fields are not mapped, a warning message will appear: "The following mandatory fields are not mapped. Kindly map them." Please ensure the mandatory fields are mapped correctly and proceed.
In the Sheet upload screen:
After successfully mapping the CSV columns with the respective migration master fields, navigate to the Sheet Upload screen, select the corresponding master, and upload the external POS sheet.
Step 1: Select the Product Name and Migration name.
Step 2: Click on Choose a file or drag it here to upload the sheet and click on Save button. You will get a message as "File has been uploaded successfully".
If there is any error in the uploaded sheet you will get message as "Invalid record exists ,Please check the error in the downloaded file" and the file will be downloaded .
In the file, the reason for upload failure will be shown in the 'Reason' column. Correct the data and upload the sheet again after removing the 'Reason' column, to complete the process.
,