How do I import items into Paradigm?

The inventory import/export feature also allows you to add new items to your inventory using an existing product as a template. (See also: Updating Existing Inventory)

Choose or create an item to be used as a template item (Creating an Inventory Item).

Create a spreadsheet that contains a list of the new product IDs. Specify any additional information that needs to be different from the template; i.e. description, cost, etc. Any fields that are not specified will be copied from the template, with limited exceptions. Save the file where Paradigm can access it.

Open Inventory import, select ‘Import’, then the Inventory table (Why this table?), then specify the file format for your data and whether or not it contains column headers.

Specify the file directory for your data, and select ‘Update Existing Inventory and add New Items’ as well as ‘Update all Price Levels’. Select the template item from the drop-down.

Map the fields, being sure that all of the columns from your spreadsheet are mapped correctly (Which fields do I want to use?). After verifying that all fields have been mapped, click ‘Finish’. Any items that failed will appear in an excel spreadsheet when the import finishes. The new items have been added.