Need some work done? Post a Project Today
Looking for a programmer to write a CLEAN script that will send an email to a consumer who is requesting pricing via our website (DJDeals.com). Manufacturers do not allow the prices to be displayed online, but they can be emailed in response to a request. We are no longer able to manually reply to 50+ email price requests per day, so we need it to be automated. We will not change our website to be php. We require that this script works with our static HTML pages.
Our pages will say something like "Email us for our Price" and the customer will fill out a form with their contact info. That form needs to query a Google Spreadsheet that has all of our full retial prices in it that is stored in Google Docs (as csv text) BUT it will need to reply to the consumer with an email that offers a percentage discount OFF of the prices in the spreadsheet, plus a link to add it to their shopping cart on our website (we can provide that code). We already have the spreadsheet in Google Docs that publishes our prices to all of the shopping websites (Google Shopping etc) and we will ONLY use this same document for this script, so it needs to be able to reduce the retail price in that spreadsheet by a percentage that we choose.