I have a client that has a inventory system that we want to integrate with an Cube Cart ecommerce system. The inventory system exports a zip file that contains a tab delimited text file and images of products. We are looking to create an interface where they can login, upload the zip file, have it unzip, and overwrite onto the database.
There is one other factor. After looking at the field example [url removed, login to view] you will notice "Vendor Code" and "Item Code" a underscore and .jpg needs to be added to the database in order for the photo to be generated in page view. Notice the name of the image that is included. It is a combination of Vendor Code and Item Code.
The final system will be used on multiple licenced copies of CubeCart and we would like to have a long term relationship for future changes.