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
Freelance Opencart 1.5.x and 2.x Developer - Available For Hire
Latest Opencart 2 Project --> http://www.falcon-rangecookers.co.uk
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.
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.
Opencart Extensions | Professional opencart support | Support Ticket | support@cartbinder.com
No, this is not correct at all
it should simply work the same as it does for view order
it should simply work the same as it does for view order
Freelance Opencart 1.5.x and 2.x Developer - Available For Hire
Latest Opencart 2 Project --> http://www.falcon-rangecookers.co.uk
For how many orders you need to change?
Opencart Extensions | Professional opencart support | Support Ticket | support@cartbinder.com
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
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
Freelance Opencart 1.5.x and 2.x Developer - Available For Hire
Latest Opencart 2 Project --> http://www.falcon-rangecookers.co.uk
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.
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.
Opencart Extensions | Professional opencart support | Support Ticket | support@cartbinder.com
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!
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!
Freelance Opencart 1.5.x and 2.x Developer - Available For Hire
Latest Opencart 2 Project --> http://www.falcon-rangecookers.co.uk
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 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
Opencart Extensions | Professional opencart support | Support Ticket | 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.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
Freelance Opencart 1.5.x and 2.x Developer - Available For Hire
Latest Opencart 2 Project --> http://www.falcon-rangecookers.co.uk
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.
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
Well That's Not really an option
Freelance Opencart 1.5.x and 2.x Developer - Available For Hire
Latest Opencart 2 Project --> http://www.falcon-rangecookers.co.uk
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!!!
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?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!!!
Dedication and passion goes to those who are able to push and merge a project.
Regards,
Straightlight
Programmer / Opencart Tester
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.
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.
Who is online
Users browsing this forum: No registered users and 13 guests
