Very clever! Please keep us informed about this as I imagine other clubs may want to consider something similar.
Did you create NEW Inventory Item records, thus having your own Inventory Item Number values that are different from those in the Awana Supply Catalog? (the existing records in the Inventory List grid have been entered directly from the Awana supply catalog)
Basically, if you have different Item Numbers, then those records will NOT be affected by any update(s) that are relevant to the Inventory records. If you have edited existing records with a valid Awana Item Number, here is how they may/may not be affected by future updates, such as the big annual update I send out each Summer once the new supply catalog is available from Awana HQ:
New catalog items will be added, and matching items (based on Item Number) will be updated to reflect relevant changes to the following fields:
Short Description, Detailed Description, Cost, Sell_Price*, Status, Pkg_Qty, Multipack_Availability, Multipack_Item_Number, Multipack_Description, Multipack_Qty, Multipack_Cost, Is_Fee, Is_Award, Obsolete, Base_Club, Vendor_ID, Category, Base Club, and Photo.
* Note: Your Sell_Price will only be changed if the Cost has changed and your Sell_Price is currently > 0.01 (implying you would have a charge for the item) and the new Cost is higher than your old Sell Price, in which case your Sell_Price will be set = the new Cost. Values in the following fields will NOT be changed: Qty_InStock, Order_Level, In_Use, and Notes.