Tamamlanmış

Make a Mysql query for round all price with .99 at the end

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).

Beceriler: MySQL

Daha fazlasını gör: magento price stock update mysql query, make mysql query perl script, php mysql query format table, mysql query php table css, optimize mysql query software, write mysql query, mysql query csv file, mysql query record bash, php mysql query table, global price list mysql, mysql query report, mysql query parent child, 2013 lost connection mysql query, asp mysql query, edit csv mysql query

İşveren Hakkında:
( 191 değerlendirme ) Villanova Mondovì, Italy

Proje NO: #14331700

Seçilen:

vivekaasaithambi

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

1 gün içinde %selectedBids___i_sum_sub_4%%project_currencyDetails_sign_sub_5% EUR
(1 Yorum)
1.5

Bu iş için 25 freelancer ortalamada €25 teklif veriyor

riteshjain009

//** WE CAN DELIVER AS PER YOUR NEED **// Hello Sir / Mam, Greetings, Thank you for giving us opportunity to send our proposal on your project. I have gone through the complete requirement of your posted job. We h Daha Fazla

€28 EUR in 0 gün içinde
(168 Değerlendirme)
7.4
ganeshsharma77

***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

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% EUR
(10 Değerlendirme)
5.6
1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% EUR
(8 Değerlendirme)
4.9
1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% EUR
(42 Değerlendirme)
5.0
artifexonline

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

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% EUR
(10 Değerlendirme)
4.8
TSCreators

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]

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% EUR
(13 Değerlendirme)
4.6
rajenranpara

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

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% EUR
(7 Değerlendirme)
3.7
lalit31parihar

Hi, I have gone through your description and got a pretty much idea of what you want. I can assure you that i can do this task. The skills and resources needed for this project are in my genes. I can assure you f Daha Fazla

€39 EUR in 0 gün içinde
(8 Değerlendirme)
3.8
nivasoftvietnam

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

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% EUR
(6 Değerlendirme)
3.6
srsinfosystems

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

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% EUR
(5 Değerlendirme)
3.6
ankita0389

I am a software developer in MNC and I can help you with your task. Please discuss.

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% EUR
(3 Değerlendirme)
3.1
cherrystuart83

A proposal has not yet been provided

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% EUR
(5 Değerlendirme)
3.1
rameshweb212

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

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% EUR
(5 Değerlendirme)
2.7
christina717

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

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% EUR
(1 Yorum)
1.4
WebExpert1122

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

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% EUR
(1 Yorum)
2.6
ilatech

Hi, I'm a french software engineer, and I worked for 10 years for compagnies, as well as MySQL and SQL Server databases. Now I'm a freelancer. For your project, I am available from now, and for the time you want. Daha Fazla

€25 EUR in 2 gün içinde
(2 Değerlendirme)
0.7
pakcokwong

I can complete the task quick. I also will double check everything is right and make sure to meet what you want.

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% EUR
(0 Değerlendirme)
0.0
1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% EUR
(0 Değerlendirme)
0.0
1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% EUR
(0 Değerlendirme)
0.0
dwbabulal

A proposal has not yet been provided

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% EUR
(0 Değerlendirme)
0.0