I decided to migrate my collection information from All Aboard Express to Erik Spierenburg's excellent iCollectTrains database. So I can work through a data quality process, I have decided to re-enter the items manually.

Anyway, over time I have purchased multiples of the same item (in my case this is mainly M-track) from different suppliers at different prices. One approach is to enter the number of items and an average price, while another approach is to enter the same item many times so that an invoice number is available for each entry. This means that when the time comes to sell (and I have sold off some things in the last two years) I have a better idea of a minimum price.

How do you keep multiple items your collection databases?

Cheers

For insurance purposes, I keep track of all my items using the highest current price, or if the item is no longer in the catalogue, I use the highest price I can find eg. Koll's for collector items or the price I paid, or the suggested retail price at the time.

Needless to say, I have a replacement value insurance policy on the contents of my home. But even if you don't, the VALUE of the items is much more important than the price actually paid. I don't keep an inventory of track, but perhaps I should, because it can add up pretty fast.