Hi,
I am not in know how to build the source code for the store module but have seen in the database there are three price fields, i was wondering if or how i could change these fields hopefully the unitprice to be calculated field in the database. What i want to achieve is to be able to edit resources for say wieght to be set as exchange rate and in the db use unit price to calculated field to be weight * purchase price. Thus rendering a price out. I have tried changing these fields to be calculated but then when updating a product in the store admin it give a dnn error. Is there anyway around this is the sproc hard coded in the store as i have even tried to change the sproc in the db. If anyone has an idea how i can get this working it would really be appreciated. Thanks

Hi i just changed the UnitCost to calculated ProductWeight * PurchasePrice

and then in the sp
Store_Products_UpdateProduct

I remove the @UnitCost money, and UnitCost   = @UnitCost,
I am using latest store 3 version and dnn i got down about 1 week ago so i am assuming its version 5

when going to store admin and editing a product with the above change dnn stay on the product detail page and gives admin error i dont see any codes

Thanks

a better way to update the UnitCost is to use: UnitCost = CAST(@PurchasePrice * @Weight) AS MONEY)

---

We (team members) are Humans offering their knowledge, their work and their spare time FOR FREE to benefit the community. It would be so particularly appreciated that your messages begin with "Hello" and end with "Thank you" or any other form of politeness. Ask yourself what your reaction would be, if you were approached by me (a total stranger) on the street to ask you something without saying "Hello" nor "Thank you"? After several years of services dedicated to the community, I begin to be tired to read requests without any form of politeness.