×
Menu
Index
Search
 
   
   
   
 
  (c) Profile Systems Design Group, Inc. 2025  Build: 4.008.782  Help ID: 7514
If you do not see the expected content, press CTRL + F5 to clear your Browser's cache.

Mass Changing a Secondary Vendor

If you need to add or change a secondary vendor on multiple items, you can edit them in mass using the Import/Export function. 
 

1. Export the item data or data template.

Go to IC | Maintenance | Import/Export.
Mass Changing a Secondary Vendor
1

Export Item Data

1. Export Item Data
You can export an item list to add or change a secondary vendor to a set of items within any of the groupings in the Export Items form.  Enter the group of items to export, and click Export.
 
Choose a location to which to save the export file, and rename it as desired.  Click Save.
 
The export file looks as follows.  You can edit your items to include the secondary vendor by changing cvendpart and cvendid to the correct values for the secondary vendor.
If you wanted to add Orgill as the secondary vendor for the items in the spreadsheet, you would enter the vendor part number and vendor ID for Orgill for each item.  For example, Orgill's part number for the item 5M Veri-Green Lawn Food is 7973761, and Orgill's vendor ID is ORGILL.  Cvendpart and cvendid should be changed accordingly.
Mass Changing a Secondary Vendor
 
Once you have made all the necessary changes, save the file.
2

Export Data Template

2. Export Data Template
You can also build a custom item list if all the items to be changed cannot be captured with one of the options available through Export Items.  It is helpful to start with the Data Template to ensure proper formatting.  After clicking Data Templates, check the files you wish to create.
Mass Changing a Secondary Vendor
1

XLS/DDBF

1. XLS/DDBF
This file is the actual template into which you can enter your item data.  Choose a location to which to save the export file, and rename it as desired.  Click Save.
 
You should receive the following message if the template was created properly.
 
The blank item import template looks as follows.  For adding a secondary vendor, only citemid, cvendpart, and cvendid must be filled in. 
For example, if you wish to add Orgill as a secondary vendor for the item 5M Veri-Green Lawn Food, you must enter the item ID, 117854, (the primary vendor's part number in this case); Orgill's part number, 7973761; and Orgill's vendor ID, ORGILL.
Mass Changing a Secondary Vendor
Once you have entered all the item information, save the file.
2

Template Structure Report

2. Template Structure Report
This file in report format provides the description and parameters of the data required in the import template.
3

Template Structure

3. Template Structure
This text file provides the same information as the Template Structure Report in text file format.
 

2. Change the vendor to Secondary.

Open the vendor file of the vendor you wish to become secondary vendor for the items in your list.  Select Secondary as the type, and click Save.
Mass Changing a Secondary Vendor

3. Import the item list.

Go to IC | Maintenance | Import/Export | Import Items.
Mass Changing a Secondary Vendor
1

File Location

1. File Location
Click the ellipsis to locate the correct file, and click Select.
2

Fields to Update

2. Fields to Update
Uncheck all fields except Vendor Part.  This ensures that all other item information remains the same through the import.
3

Validate cItemID

3. Validate cItemID
Check this to validate the item ID in case it has changed.
4

Import

4. Import
Click Import to proceed with the import process.  You are presented with a review form; you can click through the items in the import list to verify the data to be imported.
If you are satisfied with the data, click Accept Import.
You are unable to make changes from within the review form.  Rather, you must click Cancel Import, make changes in the import file, and reprocess the import.