You are viewing this forum as a guest. Login to an existing account, or create a new account, to reply to topics and to create new topics.
Is this the expected behaviour.............
Set Product Offer Product Sort/Search Price as 15,
Go To Inventory Items. Select Inv Item ID and Set Reg Each / Vol Sch* as £1.00
Save Product.
Click to Update same product, and the Product Sort/Search Price has changed to 1 as it has been overwritten by the Reg Each / Vol Sch* value.
This will happen for any product you set the Reg Each / Vol Sch* as 1.00 or over.
If you set the Reg Each / Vol Sch* as 0.99 or under, it will not overwrite the Product Sort/Search Price value.
I don't think it should be overwriting the Product Sort/Search Price value, as it is pretty pointless having this field if it is just going to be overwritten.
Offline
It seems this is intentional.
I have modified ECOM_Prod so that the sort price is no longer overwritten by the regprice value.
Offline
or you could have...
Leave Product Sort/Search Price as 0.00 to use Reg Price value in sort price order, or Enter a Integer here to use in sort price order.
As my prices are all dynamic, I need a Sort price to be used as the Reg Price is set to £1.00 for every product(it is set to £1 for a good reason and can't be changed)
but I do understand why you have done it this way.
Offline
I considered your suggestion, however the pricing for the product offer is stored in a different table, which would require mucho resources when doing searches and sorts to use as the sort price field. That's why sort price is in there, to avoid all that, and it's updated automatically so as to avoid having to maintain it.
In your case I'd recommend disabling the sort controls on the product offer listings and ignoring this, unless the functionality is crucial to you. Typically sorting by price is only an effective tool on category pages with many offers, perhaps pages upon pages of offers. Note that this does not address advanced searches which use price parameters - those use sort price as well.
Offline