We have an existing system and DB with these tables:
claims
config
config_category
config_manufacture
config_products
config_products_bk_2
rma_clients
We need to manually import a csv or txt file into the DB, across a few tables.
CSV file will be in this format:
recipient-name
ship-address-1
ship-address-2
ship-city
ship-zip
Also needs to input random date within last 6 months, weekdays only and also has to exclude bank holidays (Can supply these dates in another table if required)
Needs to select a random product from the config_products table
Needs to select a random quantity, 90% of the time it is 1, 9% of the time it is 2, 1% of the time it is 3.
Need to input random number into Order ID field, 8 characters.
We need a form to upload the file and a confirmation of the number of records which have been inserted successfully.
If you are able to complete this project please feel free to enter a bid.
Thanks