How do I update my inventory via an Excel spreadsheet?

-Updating Existing Inventory (See also: Importing New Items)

Use the Export feature (How do I use the Exporter?) to get the existing information out of Paradigm. Only select the columns that you want to change—this will speed up the process and stave off unnecessary errors. Make your changes to the data and save the file somewhere that is accessible by Paradigm. NOTE: removing any lines that are unchanged will speed up the import.

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 Only’. If you are updating cost or sales price information, select ‘Update all Price Levels’.

After clicking ‘Next’, Paradigm will map the fields from your data to fields in the inventory table. After it has mapped the fields, scroll through the mapping and make sure that all of the fields that are being changed are mapped to the correct field and that any column not being changed is not mapped (Which columns do I want to use?). NOTE: strProductID MUST be mapped every time on this table.

Clicking ‘Finish’ will update the items specified. If any items fail, you will be prompted to open a list of them once the import is complete.