OpenCart Community

If you change the price of an item in your catalog after it has been ordered , when you go to edit order, it shows the new price on the item , not the price it was ordered at.

so it looks like its simply pulling the product from the database, rather than getting the products details that were ordered.

If you view an order, then the price is what it should be, ie. the ordered price, not the current price.

Paul

yes that is correct when you trying to edit the order it will bring up the new price as it need to calculate all the totals again.

If you think in standard way it seems to be correct way. Because it is not expected that price is changing for all.

So the solution would be add your previous price again. Quickly make a change and save your order. And change to new price again.

No, this is not correct at all

it should simply work the same as it does for view order

For how many orders you need to change?

I dont have to change any orders, im simply reporting a bug in opencart that needs fixing for future.

the fact is no matter what is in the database for the order, the edit order screen pulls the price from the current product price.
this is clearly wrong, and view order shows the price of the product at the time of ordering, and this is what edit order should be doing.

Paul

When you edit an order. And you try to add new products it will take price from product. It also has to combine a price for options as well in the price.

The same applies to already edited product. Opencart gets the latest price and its options price because OpenCart makes sure this product exist and its options as well.

If it takes from database then you cannot add products. As does not exist in system. And this is a reason to gets from product table and not from order table.

Your missing my point, im talking about products that are already on an order, i`ll give you the example that brought it to my attention :-

We sold a product at £599.99 , a week later this product went up to £649.99

I ended up refunding the order, so i went into edit order, and there it shows you the products on the order, but the price was showing as £649.99 even though it should be £599.99 as this is the price it was sold at.

I clicked on view order, and it was showing the product at the correct price of £599.99

If i was trying to add a new product , then yes it would be £649.99 but this is a product that is already on the invoice.

Now imagine, if a colleague who wasn't as on the ball as me , went into edit order before doing the refund, and saw £649.99 as the price and refunded that to the customer... enough said!

Yes i understand this point before only.

I think you need a developer to make the view order fields as input fields instead of text fields.

If you need us to develop this then we can do it. Mail us at support@cartbinder.com

imdevlper18 wrote:Yes i understand this point before only.

I think you need a developer to make the view order fields as input fields instead of text fields.

If you need us to develop this then we can do it. Mail us at support@cartbinder.com

I am a developer, if i wanted to fix it, i would fix it, but that wouldn't help out the rest of the community now.

Yes this is definitely a serious bug. Was working correct in the opencart 1.5.6.4

So on edit order the order information has to be pull out from the order_product table with the information at the date of purchase (not only price, but description, model, etc...) and not the current information from the product table. Otherwise what's the point of saving information in order_product table?

As Kenberne1965 pointed out correctly the price may change over time and this way you just can't edit the order without making a mess. Not only the price, but model, description or other information can change over time.

We have a shop where prices are changed quite frequently and after updating to OC2 we are basically blocked, we have to make manual invoices, and orders, and running our orders in Excel. What a mess...

I've took a look and it seems that it using the CURL request from the catalog to gathering the information.

Worse still I reported this bug via the bug tracker and was told to just delete the order and raise a new one? from Daniel himself.



Well That's Not really an option

Ken, have you solved this issue? Because as I see, there is no willing to solve this bug (it's not even recognized as a bug).

I am wondering how nobody else complaining about this error.

I have an order when I click view, I see a product with a price of $150, if I am trying to edit I see with a price of $200.
OK, that's true that today the product price is $200, but yesterday was $150, and that's the price for that order.

THIS IS A SERIOUS BUG!!!

retti wrote:Ken, have you solved this issue? Because as I see, there is no willing to solve this bug (it's not even recognized as a bug).

I am wondering how nobody else complaining about this error.

I have an order when I click view, I see a product with a price of $150, if I am trying to edit I see with a price of $200.
OK, that's true that today the product price is $200, but yesterday was $150, and that's the price for that order.

THIS IS A SERIOUS BUG!!!

Which OC version are you referring this report for?

yes
its a serious bug
we are developing big marketplace https://www.mygerrys.com

but this bug has stopped our development and we are thinking about new opensource solution other than opencart.

I have seen many threads but i think even developer of opencart himself is not interested in taking this bug out.