National Standard Pricing Guide (NSPG) is one of the many inventory price book providers that ESC allows you to directly import into your database. Having your NSPG price books in ESC gives you the ability to use those items and their prices on Quotes, Invoices and Purchase Orders.
- To get started, head to File → Import/Export → Import Flat Rate Items.
- Select National Standard Pricing Guide from the list of providers. Click Next.
- Click the search button to the right of the Select location... field and navigate to the folder where your files are stored. These files are provided by the company that you bought your price book from. They should be able to tell you where those files are or you can do a search on your computer to find them. Click Next.
Note: You only need to select the directory the files are stored in. You will not see the individual files and therefore will not be able to select them.
- NSPG allows you to change the names of your rates. Change the column names to match the headings in your price books, then click Next.
- If you check the Import inventory items as assembly sub-items box, each flat rate task will be imported as an assembly. The parts required to perform that task will be attached to it as stock items and will automatically appear on the invoice when the task/assembly is added. This is great if you plan on using the provider's part numbers. If you would rather manually put the inventory items you used for each task on the invoice, leave this box unchecked. This can be beneficial if you already have an established inventory.
- The last screen that will appear before the import begins is a summary screen. Confirm the data here reflects the choices you made on the previous screens the click Next to start the import. Remember, this can take several hours to complete.
After the import has been completed you will see a screen showing you the results of the import. Simply click Finish here to complete the process.