Inventory Admin Functions

District Inventory Overview

Modify Inventory Item

Add Item

Upload District Inventory

Obsolete Instruments

Instrument Locations (Physical Inventory)

  1. Download the Excel File Template from the Upload Inventory page of DaCapoInventory.com
  2. Do not change the order of the columns in the Template. Do not delete row 1 or 2 of the template. Your data will begin on Row 3.
  3. Either type in your inventory assets by hand, or copy them over from any other data source that you might have.
    1. District Bar Code Number (Optional) This number must be unique throughout your district. If your district has given you specific numbered labels, you should enter those

numbers here.  Otherwise, you may leave this column blank.

  1. Instrument Name (Required) – The import function is rather forgiving. For example, if you type in Small Bass for all of the ¾ basses in your inventory, the system will allow you to choose ¾ bass or 4/4 bass. List of currently recognized instruments is below.
  2. Instrument Case Number (Recommended, Optional)
  3. Serial Number (Recommended, Optional) – Must be unique among all items in your school district
  4. Brand (ie. Bach, Gemeinhardt)
  5. Model (ie. TR200s)
  6. Date Purchased (9/1/2017 – OR Year Only – 2017)
  7. Replacement Cost
  8. Condition (Recommended, Optional) (New, Excellent, Good, Fair, Poor, Obsolete)
  9. Navigate to the Upload Inventory screen in Da Capo Inventory
  10. Select ‘Choose File’ and choose the Excel file that you have been compiling. Click ‘Upload Excel File’. You will be shown a preview of a couple of columns of inventory data. If this data looks correct, click the ‘Step 2’ button to proceed to Step 2.
  11. If there are no apparent errors, please choose a Building from the list of buildings and click the “Import Inventory to Da Capo” button. If there are any errors after this step, please read them carefully, as some inventory items may have to be manually added.
  12. You may now view and manage your inventory through the various functions in Da Capo Inventory!

The instrument names that Da Capo Inventory uses is available on the website.  However, you do not need to use those Exact Names in your uploaded file!

For example, Da Capo uses: Alto Sax.