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 21 Next »

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 we have collected for you.

Click the section to expand its content.

Scan codes for parts. You can add up to 3 scan codes for a single part. This number comes from the fact that a part may have the following scan codes:

  • a scan code from the manufacturer
  • a scan code from the supplier
  • a scan code from your organization's internal inventory team

Adding all the 3 decoded scan codes to a part ensures that when a provider scans any of these codes on a part, the part will be identified by the SC Provider mobile app, and the provider will get the corresponding part information.

NOT TO BE CONFUSED WITH THE UPC (UNIVERSAL PRODUCT CODE)

Universal Product Codes (UPCs). If you have a UPC for a part, feel free to add it to the UPC code field when uploading parts via the template. Note that the entered UPC will NOT be used as a part scan code or as a part number in ServiceChannel.

To be able to scan parts, you should enter the scan codes (from the manufacturer, supplier, and/or your internal inventory team) to the Scan Code field for a part.

Equivalent parts. You can fill out the Equivalent Parts field for a part if this part can be replaced by another part in your inventory from another manufacturer.

Is Non Catalog. You might have parts that are stored at your inventory, but you don't want them to appear in the reports or anywhere throughout the app. If you do have such parts, enter True for these parts in the template.

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. Manual: Price will always be taken from the location stock records template.
      3. Average: Price will always be calculated as an average taken from the location stock records template (Current price*Current QTY) + (New Price * added QTY) / (Total QTY).
    • 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.


⦿ 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