I am developing small CMS for eCommerce. Fo this I want to create script for pricelist import. I store all data in database so that one goody is a group of records in several database tables joined by some relations. During pricelist import I can encounter such cases "new goody", "updated goody", "deleted goody" which in turn will cause some insert, delete and update operations on database tables (in any combination and relationship).
Now what I need. How to ogranize pricelist import web form more convenient for eCommerce-administrator so that he can approve, decline and edit imported pricelist information (in convenient manner and in several related database tables simultaneously)?
Any screenshots, links, examples, hints and advices would be very helpful.