You have chosen to sponsor your bid up to a maximum amount of .
We need a PHP file the lets up upload a comma delimited CSV file and import specific fields of data into a different tables in a MySQL database and create the unique ids between the Business table and the deal table.
The following are the fields and what they import into.
CSV_FIELD => TABLE => FIELD
NAME => DEAL => NAME
START_DATE => DEAL => START_DATE
END_DATE => DEAL => END_DATE
IMAGE_URL => DEAL => IMAGE_URL
PRICE => DEAL => PRICE
VALUE => DEAL => VALUE
DISCOUNT => DEAL => DISCOUNT
VOUCHER_EXPIRATION_DATE => DEAL => EXPIRE
DEATAILS_TEXT => DEAL => DESCRIPTION
FINE_PRINT_TEXT => DEAL => FINE_PRINT
The following needs to be checked if its in the table and added if not on each import:
MERCHANT_NAME => COMPANY => NAME
The following needs to be added to database if the above is added:
Table => Field => Value
COMPANY => EMAIL => (MERCHANT_NAME)@ihddeals.com
COMPANY => PASSWORD => password1
COMPANY => COUNTRY => UNITED STATES
COMPANY => STATE => Missouri
COMPANY => CITY => National