Php backend program to mass upload data via xls
Budget: ₹1,500 – ₹12,500 INR
n php code do following
1. Upload a xls file with multiple fields including product code and product name lets call them variables A and B
2. Lookup the product name A in our sql database to find the nearest matching Product name in our existing table which we will call C
3. If match is found add A, B and C into a table called Supplier master table in sql along with all remaining fields in the xls file corresponding to variable A
4. If match not found then display in a 2 column table the values of A and B and all the remaining fields of the xls in left column. While in right column give a search box and a display of similar product names from our existing product table
5. Use can choose the best fit product name in which case step 3 is repeated with the data so got for A, B and C and all remaining fields of the uploaded xls
6. Program ends when all row of xls are read and put into our sql table called Supplier Master Table
1. Upload a xls file with multiple fields including product code and product name lets call them variables A and B
2. Lookup the product name A in our sql database to find the nearest matching Product name in our existing table which we will call C
3. If match is found add A, B and C into a table called Supplier master table in sql along with all remaining fields in the xls file corresponding to variable A
4. If match not found then display in a 2 column table the values of A and B and all the remaining fields of the xls in left column. While in right column give a search box and a display of similar product names from our existing product table
5. Use can choose the best fit product name in which case step 3 is repeated with the data so got for A, B and C and all remaining fields of the uploaded xls
6. Program ends when all row of xls are read and put into our sql table called Supplier Master Table