Page 2 of 2

Re: Looking to know if Opencart can do this

Posted: Sat Dec 01, 2012 3:17 pm
by lewismedia
Like I said, I am very new and might not have any idea about what I am talking about...
We were all new to this at some point in our lives. My suggestion to you is that Google and Stack Exchange will be your ally when searching for the answers that you seek. It is a very rare occurrence that I am not able to solve my problem with these two resources, when I encounter a question that I cannot answer. That and a couple good PHP books and a working knowledge of MVC framework. Best wishes. Cheers.

Re: Looking to know if Opencart can do this

Posted: Mon Dec 03, 2012 10:52 am
by gladen
Thank Lewis, but I'm all good here. I am not attempting to do what the original poster is, I just thought the method I described might also work for what the original poster is attempting.

Re: Looking to know if Opencart can do this

Posted: Sun Jun 01, 2014 6:53 am
by amobilept
I wonder if anyone can help me with an sql query that can acomplish the following.

product cost * profit margin = wholesale customer group special price

The resulting amounts do not have to be pretty as these would be just for the wholesale customer group.

From my research so far, I know that to change the main customer price with a percentage I input the following:
UPDATE product SET price = ROUND(price * 1.05, 2)

I do not know too much about mysql but i guess what I wanted was a sql query something more like:
UPDATE product SET special (for specific customer group) = ROUND(cost * 1.5, 2)

Is this even possible to do? Can anyone provide me with some feedback on what the correct query should be? I didnĀ“t want to mess too much with the database since the website is live.

By the way I am still on 1.4.9.4.

Thanks in advance.