The process is simple. A file is uploaded to the server via a separate command. File name is [login to view URL]
From there it moves the values from columns A and G to MySQL table rsrsalepricetable into the first two columns. Column 1 is rsr_item_num and Column 2 is rsrprice.
It then multiplies rsrprice by the profitpercent in column 3 and outputs the result into column 4: newprice.
It pulls the value from column 5 (product_id) from the oc_product table by searching for the matching rsr_item_num from column 3 in oc_product table.
Then finally it matches the product_id with the product_id in table oc_product_special and updates the price column in it with the one from newprice in the first table.
Problem with this is that I am on a shared host and this process takes a while for the server to finish and always ends up crashing my site and giving me a 500 error.
Solution: Recreate my php file so that it will do this without crashing.
Please see the files for the php file and an image file with examples from the database and excel file.
Hello, I am expert with php, I can help you recode php file for you. Please contact with me to discuss. I will complete good and fast for you. Kind regard.
42 freelanceria on tarjonnut keskimäärin $166 tähän työhön
Hi there, I am interested in your project. Please let me know if we can discuss this [login to view URL] you running update script in browser or command line? Thank you
Hello, I can fix this issue with your script, I'm PHP expert with 8+ years of experience. You can check my reviews here: https://www.freelancer.com/u/MaximSky Let's discuss details in chat. Regards, Max