Import duplicate record update options for Parts

<< Click to Display Table of Contents >>

Navigation:  PlugIns > Part Import Export >

Import duplicate record update options for Parts

The no charge ImportExport.csv utility provides the ability to import and export part records into and out of AyaNova

If you have purchased the Importexport.csv duplicate option license, then you will also have the ability to update existing AyaNova part records with this utility.

Only if you have purchased a license for the Importexport.csv duplicate option will the Duplicate import options menu show on the initial drop down list and in the importexport.csv screen

duplicateimportoption1   duplicateimportoption2part

1. Select the Duplicate import options menu from either of the two locations as per above.

This will open the Import duplicate record update options window

duplicateimportoption4

2. If you want an existing Part record's Cost field to be updated if an existing AyaNova part record already exists, then set to True. If you want an existing Parts record's Retail price field updated, then set to True; and so on.

3. Click on the green OK OK1 button to save any True False settings, and then import your data into AyaNova.

ImportParts5

A message will display identifying the following:

 

how many new parts were imported (in screenshot above, this is 16)

how many existing parts were updated (in screenshot above, this is 8)

how many parts were not imported because they were exact duplicates having no changes from existing AyaNova parts; or because they did not follow the format rules. (in screenshot above, 344 parts were not imported because they were exact duplicates - no changes from existing).