I need to round all prices of my website done by opencart with .09 final, for example. The price like 5.50 will become 5.49, the price like 20 will become 19.99, the price like 21.56, will become 21.59 With this query
update oc_product set price = ceil(price) - 0.01
i'm able to make it, but the problem is that the price stored in DB is wihout tax, so the query have to SUM the product price + tax, then round it, then substract the tax
In attachment you can see the tables (products + taxs).
hi I am having good knowledge in MySQL. i can able to write query for your criteria. i will complete the task on time as per your requirement thanks
Bu iş için 25 freelancer ortalamada €25 teklif veriyor
***Hello! It can be done as required. Please revert back so that we can discuss and start working on the project as per your requirement. In most of the cases, it suffices my requirement
Hi, I have reviewed your requirement and I can do this job as per your requirement. We have huge expertise in WORDPRESS ,Payment gateway, Laravel, Node.Js , React.Js, CakePHP, Codeigniter, Angular.js, Bootstrap, AP Daha Fazla
hi , i am waiting for your message to discuss in some detail . hoping to get some good response from you regards [login to view URL]
Hello sir/ma'am, I am a computer engineer and I have been working with MySQL for near about 3 years. I read the project description and I can complete this task successfully. I am unable to find the attachments m Daha Fazla
SATISFACTION GUARANTEED OR YOUR MONEY BACK. “Trial 30% your work progress before, pay later” is my working principle. We have a production warranty in 12 months if there are errors from what we made Can you please hav Daha Fazla
Yes, I can surely help you out with your project. I have read your requirements and understand what exactly you want to do. I'm ready to start the work. Please inbox me for discussion. Looking forward for Daha Fazla
Hi, I am very strong in opencart with 10 years of professinal experience and finished many issues surrender by top ranked freelancers. can I do number round to .09 by php script? Thanks & Regards, Ramesh Shar Daha Fazla
Hi, I am glad to see your job posting on "Make a Mysql query for round all price with .99 at the end".I'm a "Professional Web Developer". I've five years experience in this [login to view URL] more information will you please Daha Fazla
Hi, I am opencart specialist and i can fix prices issue in two ways.i can write direct query in mysql Database and will subtract 0.01 in all [login to view URL] tax issue will occur if we use this method.2) i need to write Daha Fazla
I can complete the task quick. I also will double check everything is right and make sure to meet what you want.