WHAT COLUMNS ARE MANDATORY?


Category (A), Section (B), and Item (C) are the only mandatory columns in the Cut Time inventory import template.


WHAT DOES INVENTORY CATEGORY, SECTION, AND ITEM MEAN?


Category, Section, and Item all refer to different levels for sorting your inventory.  Category is the broadest label to sort your inventory by and usually belongs to either “Instruments” or “Miscellaneous.”  Section is a more specific label to sort by and often can be the instrument family like “Strings” or “Brass” or the type of equipment like “Furniture.”  Item is the most specific label for sorting your inventory and should describe what the item is.  These are normally labels like “Violin,” “Percussion Cart,” or “PA System.”



WHAT DO I DO WITH ASSIGNMENT COLUMNS (O-P)?


Use the inventory assignment columns when you are importing items that are already signed out to members.  To import inventory assignments you must already have profiles in your account for the people the inventory is being assigned to.  Assigned Date (P) is the day that you signed out the inventory, and if not filled in will default to the day we upload your import file.


IMPORTANT: The name in column O “Assigned to” must match the spelling of the name on the person’s profile in your account.


HOW TO I USE INVENTORY REPAIR HISTORY COLUMNS (Q-V)?


Inventory repair history is optional and can be imported in different ways, but only one repair history line can be imported per item.  You may use these columns to import current open repair requests that need to be made to an item, or to import a historical repair record.


To indicate repair history, the *Repair History (Q) cell must be filled in with a “Y” in the row of the correct item.  If the repair was requested by a specific individual you may enter their name under Repair Requested by (R).  The name must match how the individual’s name appears in your account in order to link to them.  To indicate an open repair that still needs to be completed, you may fill in Date Repair Requested (S) and Issue (T) but leave Date Repaired (U) blank.  To indicate historical repair data, you would fill in Date Repaired (U) and have the option of including any details about the repair work done under Repair Notes (V).