››

V8 - Bulk editing vendors

View or download Vendors_3 as a reference for character limits and notes about specific data fields.

Go to Company menu > Data tools > Export data.
Select Vendors.
On the export page:
1. Go to the Columns section and select Add all columns required for import. (Ignore the Filters and Options sections.)
2. Under the Actions section:
  1. Choose the desired file type (Excel or CSV) from the Format dropdown.
  2. Choose either Save as Excel/CSV (to download the export directly) or Send via email (to download the exported file as an email attachment).
If opening the spreadsheet in Excel and the exported format was also in Excel, you must unprotect the sheet prior to editing.
Add your data to the spreadsheet.
1. Do not change any column headings.
2. Do not change the VendorId for existing items, and leave the VendorId cell blank for new items.
Import your data.
1. Go to Company menu > Data tools > Import data.
2. Under the Importing dropdown, choose Vendors.
3. Under the File field, choose the file you wish to import.
4. Select Preview. SOS will display the first 10 lines of data, so that you can ensure the correct file of data is being uploaded.
5. If the Preview looks correct, select Import.

SOS Inventory will send a notification indicating whether the import was successful or failed.

Was this information helpful?

Thank you Your feedback helps us to continually improve our content.