How to Import Vendor Part Numbers Into PartsManager

Derek Torres
Derek Torres
  • Updated

Important Note: PartsLedger is now PartsManager. PartsManager retains all of the parts purchasing and warehouse management automation benefits of its predecessor. To read more about this exciting change, click here.

 

A Vendor Part Number is a code used by the Vendor to uniquely identify the part. This article will walk you through how to import your Vendor-specific Part Numbers for Parts in your Items List into PartsManager, formerly known as PartsLedger.

For more information on Vendor Part Number use the following article:
Adding Vendor Part Numbers to PartsManager Items

Note: Importing in PartsManager requires an Account Admin user role.

 

How to Input Vendor Part Number Information into the Part Numbers Template

  1. Download the Parts Number .csv Template
  2. Input your Vendor Part Number Information into the relevant fields.
    • The Vendor Part Number Import Template has 3 required fields. The table below will define the required field names in each column.
  3. After filling out the template, save it as a .csv file type.
Field Name Description
Vendor.id

*required The Vendor ID of the Vendor you are creating a Vendor Part Number for.

Where to Find the Vendor ID

Item.number

*required The Item Number of the Item you want to create a Vendor Part Number for.

Where to Find the Part Number

partnumber *required The Vendor Part Number for the specific Item and Vendor on the row.

 

Where to Find the Vendor ID

On the Nav Bar click Accounts Payable, then click Vendors. 

This will take you to Vendors List Page. The ID column lists your Vendor's ID numbers. See the below image:

Part_Number_ID.png

 

Where to Find the Item Number

On the Nav Bar click Inventory, then click Items.

This will take you to Items List Page. The Number column lists your Item's Number. See the below image:
Number_Part_Number.png

 

Importing Vendor Part Numbers into PartsManager

  1. In PartsManager, on the Nav Bar, click Admin
  2. Click Dimension Upload, to navigate to the Dimension Upload Menu
  3. Click the Dimension Drop-down Menu, and select Part Numbers
  4. Click the blue Upload button
    Dimension_Part_Number.png
  5. Click Choose File and select the .csv Vendor Part Numbers Import file you just created.
  6. Click the blue Upload button to import your Vendor Part Numbers.
    • If successful, a record of the completed upload will now be present on the Dimensions Upload list.
      Clicking the blue Upload icon under the Actions column of that record will allow you to download the import file you uploaded.
      Upload_Button.png
    • If unsuccessful, a record of the failed upload will now be present on the Dimensions Upload list.

Part Numbers Import Template File

Import this template file into your spreadsheet software. After entering your Vendor Part Numbers, this file should be saved as a .csv file.

Download the following file:

Was this article helpful?

/

Comments

0 comments

Please sign in to leave a comment.