Hi all [was tempted to say skunks [?]] Im in sort of dilemma here and I need advice/input on this. Im working on this application, there is a product list with over 200 items currently. This list is reviewed every few months, every review will introduce quite a number of new products or drop certain products. Good things is, the product coding is progressive, however with the frequent reviews adding the new items and marking others as deactivated becomes quite a task. Things to consider 1. The list is submitted as a ms spreadsheet with all products new, existing or otherwise deactivated. 2. The application is php/mysql hosted on a linux server 3. Deactivated products cannot be deleted as they are used with the app for trend monitoring 4. There is the possibility of having this list shared with other external applications[read websites] Currently the list is in a database, as indicated earlier maintaining it is becoming hectic, your thoughts?
