Changing price of store items after uploading..?

Once an item is added to the store, how can I change the price of that item?

Not the currency, the price. 

Im selling videos so have them listed in the store as a file to download.

Thing is, once the file is added, I cannot edit anything on that file, just the store description etc...

The price and file name is then fixed...

There's a long slog way to do it by uploading a new file of same file type with the updated price, then swapping the file names on my server...

Not the most straight forward though. 

Should be an edit in admin for this!?

 there is no way to do that through the administration panel of dolphin but there are some soulutions :-

1- hide the product and then reupload it and set a different price .

2- this on is pretty hard one to do but it is the effective way to do that :

go to your phpmyadmin => select the database => open the "bx_store_products" table finally  edit the "price_range"

note in the price range you will fined "%s" and next to it the number so keep in mined that you dont delete the "%s"

The database way works, only thing is the original price still shows in the 'items' box when you view the product.

Tim

yes, cleared cache still the same.

The change in bx_store_products has updated the price of each item but only when listed in the 'store home' or 'latest product' list etc..

System price is still the same. 

Has stayed the same on the 'items' block on the product page (where the file is listed) and is also the same in the paypal chekout...

 sorry didnt notice that you have also to change it in "bx_store_product_files" table

Brilliant, works perfectly!!!

Thanks :-)