You can link your ERP part number (for example from SAP) to an SDS. Your users can then find the SDS by typing the part number in the search field of their SDS list.
Two ways to store the part number
- External System Id: a field for the id of the product in your ERP system. Use it when you want to export your SDS library and import the SDS links back into your ERP system.
- Synonym: add the part number as a synonym of the product name. Synonyms are shown under the product name in the SDS list.
The search in My SDS and on each location finds both. The SKU is searched too.
Add the part number
- When you import a product list: put the part number in the External system Id column. Read more: How do I import our xls/csv file with all the products we use?
- For an SDS in your library: click ⋮ on the SDS and choose Edit SDS information. In the first section, fill in External System Id (and External System Url if you like), or add the synonym.
- When you upload SDS files: open Advanced options in the upload dialog and choose Import files with tagged filename. Put the part number in the file name between EX— and —, for example EX—ABC123—Acetone.pdf.
You can make the id required: in Settings, switch on Require External System Id to be added on all Safety Data Sheets added to library.
Export with the part numbers
When you export your SDS library to Excel, the file has an external_system_id column and a permanent link to each SDS. You can import it into your ERP system so that each product links to its SDS. Read more: How can I export our SDS library to a Excel/xlsx/csv file?