I am looking to create a tool written in PHP, stand-alone & portable, though if needed I have a hacked together Os-commerce system available to work within. The tool will allow loading of a CSV (comma delimited) file, and/or paste a list of UPCs or Titles to lookup. The tool would go out to a website ideally [url removed, login to view] and retrieve data about the products if available, namely title, description, images, prices, category, whatever is available and store this in a MySQL database all neat and easy to sort & organize and read through, displayed within the Tool itself. The tool would ideally be able to handle a database being installed on a localhost server or a remote server.
I would prefer this to be done in the old Amazon API, but if the developer is confident in Amazon Web Services development and feels it would be better suited to the project, I am open to suggestions.