Q: We are in the process of planning our file conversion as we implement our new catalog management system. Our vendor is telling us that they normally dont write a file conversion program for most files. Whats your recommendation?
A: Todays comprehensive order management system performs integrated functionality for order entry, customer service, order processing, warehousing, marketing and merchandising.
There are literally hundreds of tables and files in these systems that have to be converted or built from scratch manually. These range from promotional tables, shipping tables to the more complex customer files, item masters and purchase order files.
For smaller businesses, the better approach is to minimize the automated file conversion. For larger companies (meaning tens of thousands of customers and products) it will be a blend of build manually and program file conversation.
The reasons are:
Converting years of history often result in many file integrity problems because the data is not consistent over long periods of time. Needless to say it takes many more passes through the data and it may still not be totally...