Hello, thank for reading details of my project and submitting bids. I am looking for a reliable contractor.
Software type: Either prestashop module, or custom php pages and SQL code that can be integrated into Prestashop version 1.4.6 or higher (Current production version is 1.4.7.). Ideally compatible with upcoming 1.5 release.
Similar to "CSV Import" page (which you can use as a template), I need to be able to upload Excel/CSV files's data (i.e. 5-8 columns of data) into Prestashop MYSQL database.
Each Excel/CSV file contains certain data that constitutes a Prestashop "product" that can be downloaded similar to MP3 (digital file download).
Back Office Functionality:
The following operations are performed with Excel / CSV file:
(A) A user navigates to "File Upload" page
(B) Selects the Excel/CSV file to upload
(C) The webpage parses the file, so that a user can map Excel/CSV file column name to column names in the MYSQL databases.
(D) Once mapping has been done and data has been uploaded, a user is being taken to the "New Product" page where he/she can create a new product that containes data from the uploaded Excel/CSV data list. The uploaded data is linked to the new product.
Front Office Functionality:
A user selects the product, pays for it, and is able to download the product data in the form of CSV file generated from the Prestashop MYSQL database. (After he/she has paid for it).
I might upload a project schema, in case if there further questions.
Additional Front Office Functionality:
If a user selected two or more products, there should be business logic that would allow a user to check how many rows in common two file have between each other by a column name present in both files: i.e.
a user buys product A, B, and C.
Before a checkout, there is a link to a webpage where a user can select products A and B, or A and C, or B and C, and see how much data match there is between those 2 data lists, i.e. A and B have 15% same matching data in column XYZ present in both lists.
Attention: There will be 8-12 column names and they are fixed. That should make business logic fairly easy.