**This job is for an adult site: you must be 21 or over to view attachments and participate in the bidding process**
We'd like an interface to scan adult DVD UPC's and that data is passed to a site via a URL to find the product. If that product is found, we'd like the the path (with our affiliate code) to be written to our database, in parallel we'd like that title to be used to search another site and scrape the information and saved to our database (along with the product id). There will be 2 other affiliates' information for VOD titles. This info will be available as a CSV file. The process should scan and match for titles as well.
If the UPC does not match, we'd like the interface to provide entering a title that will just search the second site noted above and perform the scrape. If no match is found on either site, we'd like an option to either enter the data manually or skip.
This solution can be an online or client-based application. There must be a configuration setting for affiliate codes/paths that are written to the db, paths for photos being written, etc. Offline app. (Intel/PC) must be fault proof, meaning when end of scanning is completed and an upload of the data is performed, it can't choke on one record or entry being mal-formed. (we are not committed to any specific solution-just an example).
UPC reader compatibility is a must and we can chat about the logistics. I think "catscan"ers are around $10.
Once this automated system is in place for new product entry, we have some data (~6,000 records) that already exists in our database that needs to be updated with affiliate links & product ids. This will be a one-time update only. We will provide a CSV file of that data and once updated, we will then reimport the data into our database.
This information will not have UPCs available.
For this matching, the contractor is to use the DVD name and the Studio name for finding the right updated record. Other logic needs to be considered for differences in DVD titles between our data and the new/updated data. For example, titles using "vol.", "#", "volume" or just a number or DVDs in a series. "&" versus "and", etc.)