Skip to end of banner
Go to start of banner

Uploading, Downloading, and Transferring Parts

Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 29 Current »

On the Parts Catalog page, use the Download button to export one of the following:

  • Parts catalog. The downloaded file contains detailed information on your parts.
  • Parts catalog template. This is a blank template for uploading multiple parts to your catalog.
  • Inventory transfer template. Use this blank template to transfer parts from one location to another.

Button for downloading the parts catalog, parts catalog template, or inventory transfer template

Use the Upload button to do the following:

Parts catalog in Inventory Manager

Uploading Parts to Your Catalog

Tips and Best Practices

Before you start building your parts catalog in Inventory Manager, study the tips and best practices (tick) we have collected for you.

Click the plus icon to expand the section content.

Whether you need to create your inventory catalog from the ground up or update the existing one, check the instruction below.

When you configure Inventory Manager, adding parts to your catalog is the next step you need to take after creating inventory locations.

⦿ How to Upload Parts
  1. On the Parts Catalog page, click Download, and select Parts Catalog Template from the drop-down list. A blank template gets downloaded to your device.
  2. Open the template, and fill it out.

     Expand this section to learn how to complete the template.

    1. Fill out or update the mandatory columns:

    Completed Excel template for uploading parts to the general catalog

    • Part number
    • Part type
    • Part group
    • Part name
    • Description
    • Unit of measure. The field accepts any unit of measurement, including EA (each), lbs (pounds), gal (gallon), ton, case, pack, box, FT (foot), quart.
    • Price valuation. There are three price valuation options; each option has an effect on how inventory is priced.
      1. Standard: The part price is always taken from the parts catalog. Prices specified in the location stock records template will not be used if different from the main catalog.
      2. Average: Calculate the most average price for a part by summing the total cost of the part for all parts purchased in Service Automation dividing by the total number of parts ever purchased. 
      3. Price: The market value of an item at sale
      4. Replacement Cost: The amount it will cost to replace an item in inventory 
    • Price. The market value of a part.
    • Is standard. Enter either True or False. A standard part is a part that has not been modified, augmented, or specially combined with another part to make a new part type. For example, a non-standard part would include a special blend of paint, combined refrigerants, or a combination of two component parts that make a new part.
    • Is regulated. Enter either True or False. A regulated part is a part that has to comply with special regulations for its use and disposal. For example, ozone depleting refrigerants, fluorescent light bulbs, or mercury vapor light bulbs — all have the EPA guidelines for their use and disposal.

    2. (Optional) Based on your company’s business needs, specify the following information:

    • UPC code. Universal Product Code of a part
    • Equivalent parts. Parts that are available in your inventory and can be used to replace the part to which they serve as equivalents
    • Brand
    • Inventory catalog ID
    • Average price. The average purchase price of a part
    • Replacement price. The last purchase price of a part
    • Asset type ID
    • Is non catalog. Enter either True or False. A non-catalog part is a part that can appear at a location but is not an item that your company keeps in inventory.
    • Supplier
    • Scan code. Enter the QR code, barcode, or another code that should be used to allow your technicians to scan codes on parts to quickly identify the required parts and associate them with work orders in SC Provider.
  3. When ready, save the file.

  4. Click Upload, and pick the Parts Catalog option.
  5. In the overlay that appears, either drag and drop the file, or browse to choose the file from your device.
  6. If no errors upon processing the file are found, click DoneIn case there are errors in the file, download the results file, and check the last column in the file. Correct the errors, and reupload the file.

Transferring Parts

There may be times when the parts stored at location A will be needed at location B. With Inventory Manager, you can easily transfer parts from one location to another via template, for example from a warehouse to a truck.


Take advantage of our new feature that allows you to create transfers of inventory parts from one location to another and keep track of each transfer lifecycle without the need to use MS Excel templates! Learn more about Inventory Transfers.

⦿ How to Transfer Parts Between Locations
  1. On the Parts Catalog page, click Download, and select Inventory Transfer Template from the drop-down list. A blank template gets downloaded to your device.
  2. Open the template, and provide the following information:
    1. Part number: Enter the number of the part you need to transfer.
    2. Source location ID (optional): Indicate the ID of the location from which the part should be transferred.
    3. Source is truck: Tell whether or not the source location is a truck. Enter either True or False.
    4. Destination location ID: Specify the ID of the location to which the part should be transferred.
    5. Quantity: Enter the part quantity that should be transferred.
    6. Cost/Unit: Type in the part cost per unit.
  3. When ready, save the file. 
  4. Click Upload on the Parts Catalog page, and pick the Inventory Parts Transfer option.
  5. In the overlay that appears, either drag and drop the file, or browse to choose the file from your device.
  6. If no errors upon processing the file are found, click Done.
    In case there are errors in the file, download the results file, and check the last column in the file. Correct the errors, and reupload the file.
  • No labels