We need a PHP script to retrieve .csv files from various FTP sites and import the data into our MySQL database. This is product data that will change daily. The script will be run manually or by CRON job.
The data fields in each .csv file will need to be translated to the associated field in the MySQL database. We will provide a reference sheet for each .csv file that shows each import file fields' corresponding database field.
New records should be added to the database, existing records updated, but records with data should not be overwritten with no data when there are empty .csv file fields. Existing records should not be deleted. Any new data fields should be ignored if the field does not exist in the database.
The PHP script will also need to move and unpack zipped files containing images from remote FTP servers to our local server.
Once the data import process is completed, two .csv files should be exported from the database that contain new or changed records.
We will then need a simple admin panel to manually view, add, change, and delete product information from this database.
50 freelancer đang chào giá trung bình $544 cho công việc này
We have a team of highly qualified and creative professionals. Give us a chance to show our talents and we assure you quality. To know more about us Please visit our website: [url removed, login to view]
Dear Sir! We are an efficient and dedicated team of professionals. We offer our large experience and professionalism to make all qualitatively. Best Regards, Sales Manager in Gorasoft.