Fees And Net Amount Based On Gross Calculations
We have a fully functional eccomerce website. When an order is placed, one record is submitted into the orders table. The "total" field, of course, is the grand total amount of the sale and many times referred as gross.
I need two calculations based off of the "total" field. First, the "fee" field will be .05% of the "total" field. Second, the "netamount" field will be .95% of the "total" field. I want a PHP script or some SQL statement to create these calculations when the order is submitted at the verify page.
Product: Baldor Inverter Duty Gearmotor $250 + $50 shipping + $0 tax = $300 total
See sample image of orders table fields.
ORDER SUBMITTED LOCATION
[url removed, login to view]
Scripting Language: PHP with MySQL Database
Shopping Cart: WebAssist eCart 4.1
Send me a private message regarding... whether you plan on using a PHP script or some SQL statement and the results of the work in completing this project here. I'm trying to understand the best approach to this.
Above, I have provided what I believe is all the information regarding this project with exception to login information to the FTP & database. Please base your bid on this but I will be happy to answer questions and exchange correspondence through this website's personal message board during the development of this work. Try to keep in mind of time zones differences if responses aren't immediate.
Correction: It is 5% rather .05% and 95% rather than .95%
Bu iş için 16 freelancer ortalamada $45 teklif veriyor
Dear Sir/Madam, Please check my private message. Thanks Shome.
Hi Marty,I am back to work again..would you like to display the changes on frontend or only [login to view URL],Bryce
Hi, I'm an independent/hobbyist web developer. I could easily provide this functionality for you in just minutes using a simple PHP script. I am looking forward to hearing from you.
Samarthsol is an established Software Solution Company based in India,started by a group of dedicated professionals, who have more than seven years of extensive experience in the Software field. Our mission is to cons Daha Fazla
Some of our work : [login to view URL] [login to view URL] [login to view URL]
We have a fully functional eccomerce website. When an order is placed, one record is submitted into the orders table. The "total" field, of course, is the grand total amount of the sale and many times referred as gross Daha Fazla
Please let me know when I have to start the work for u , I could even show u my latest website I am available on skype add me as sankalpsaxena7
I am java an SQL developer. I have around 4 year experience. I would like to know in more depth about your requirement.
I have a few solutions that could work well for you. Please check the PMB.