Bulk Uploads & Imports
This article describes how to submit data to be imported into your EZSCRIPTRx account.
Here is the step to step:
After logging in, click on your username located at the top right of the screen and select: “Dashboard”
2. Then select “Imports” menu and click select: “New Import”.
3. Select what kind of import you want to do. The difference is the purpose behind it:
At any time, the user can upload Patients including insurance information. The user may want to do this to increase the account’s pre-loaded Patients in order to work faster by being able to pre-select them, instead of having to enter them.
Adding insurance information will also save the need to enter insurance information manually, or use the Eligibility service. Furthermore, if you upload this file format, you can run Bulk NDC Coverage Checks against this patient list.
The user can upload Patients without specifying insurance too. For example, when that information is not at hand. Then it can be enter it manually during coverage check or use EZSCRIPTRx Eligibility service to find it. This file format is NOT suitable for Bulk NDC Coverage Check.
Using the Provider option the user can upload a quantity of providers in one time.
Submit Remit data file for 90 days of prescription history to help us better serve and optimize your portal search results.
Combined Patient-Provider-Remit, get the fastest way to populate your patient information (with insurance), provider list and remit data.
Uploading the Cost of goods (COGS) then It will be shown along any NDC you are checking.
Finally, If there is any doubt about what kind of file to be uploaded, the user can use the option “Unknown” and the Administration will refine the data
Depending on the option chosen, you will be presented with a list of fields that the CSV file must contain. All fields are mandatory.
It is very important that you export the data from the Pharmacy Management System in CSV (comma separated) format.
If the user PMS exports in Excel format only, should open the Excel file and make sure that:
BIN Numbers have six digits, including leading zeros if any
PCN, Group and Cardholder IDs do not contain any punctuation or contain all leading zeros if any.
PCN, Group and Cardholder IDs do not contain e+. This means that Excel transformed the values and NDC Coverage checks will fail.
Patient First, Last Name, Provider First, Last Name fields do not contain punctuation like asterisks, commas, dashes, parentheses, etc. Just letters. Otherwise, Eligibility and Coverage checks will fail.
After reviewing this, save the file as comma-separated CSV file, and it will be ready to upload.
How to know the status and progress of Imports:
Click on Imports menu and select: “General Imports”
After selecting “General Imports”, the following screen will be displayed.
From here you can download the CSV file, view it, check the import status and its progress.
Related Articles