This is a repost of the following project:
1) I need a simple .vbs script debugged. There are no error messages but it doesn't write to the MySQL db through localhost. The problem appears to be with the script and not table permissions. I also need a few variable added and the $ sign removed from the source txt file the script reads and then writes to the db.
2) I need a script written for MySQL db to run in a web browser in Windows to change pricing information. So it should probably be asp. It should open in a web browser. I click a button and it will display all product and sub product categories from the db. So it will automatically detect all from 2 columns in db. Next to each category and sub category I want a text box where I can enter a constant to multiply the wholesale price in the db by and then write the new price to a different column in db. So each product sub category can have a different price markup. I need a check box in front of each product category and sub category. If checked, the script will apply changes to those products, when I run this to update prices. And the script should read a column in the db with a 0 or 1 toggle, to permanently skip those products. Next to each category and sub category there should be a text box where I can enter the last number in the price. So you take the wholesale price, multiply it by the constant amount I enter, then in the text box I can enter the last digit of the price, after the constant was applied to the wholesale price. So I should be able to enter a 0 - 9. So if I enter 9, I want the final price after markup to end in a 9. For example, $10.99. If I enter a 7, then the final price should be $10.97. But I want all of the final prices rounded DOWN and not to nearest digit. For instance, if I enter a 9, and the price after markup is $10.98, then it should round down to $10.89 and NOT $10.99. So all prices are rounded down and never up.
I need for everything I enter to be saved, so I don't have to reenter all of this again, every time I open the script. So when I put some thing into a text box or check a box, it should be there when I reopen the program. There should be 2 check boxes at the top for check all or check none for the check boxes that appear to the left of the categories and sub categories that apply the pricing change, when I run the script. And there should be a button to redetect the categories and sub categories, if new ones are added to the db. When redetect categories is run, all of the old info should be retained. Only the new categories or sub categories should appear with blank check and text boxes.
Please give me a price estimate and a time estimate.
5 freelanceria on tarjonnut keskimäärin 82 $ tähän työhön
I can do this project for you after Christmas Day. Part 1 is a relatively simple fix. Part 2 would be written as a php script. Contact me via PMB for more details.