» Home » price » Page 1
aspx sql gridview “display price*sublength in price column”
Category : Programming Languages

when displaying price on a magazine for a subscription i see on my page:


Price | Subscription Length


69.95 | 12


69.95 | 24


the 24 month subscription should show double the 12 month (139.9) but i havent implemented this in the database and it is already built and being used successfully in all other areas.


i came up with a simple formul


View Replies


need help to figure out average price markup on products, I have cost and selling price
Category : Databases

I have a database that has products in it, with both the cost and selling price.


I want to create a simple report that will group similar costing, and figure out how much markup there is.


I will then use this to apply the markup on new products.


So my database looks like:


productid, costPrice, sellingPrice
123, 9.99, 14.99


View Replies


Magento configure product regular price being set to zero when sale price occured
Category : Web Design

I noticed a issue on my configure product today. and Hope all of you guys can help me solve this problem.
I am running magento CE 1.7.0 on the site.


Here is the issue link
http://fishermandepot.com/best-deals/yo-zuri-surface-bull-gt-popper.html#.UOyhGKz5VHA


The issue happened as if you choice the drop down options for a sale item, it displayed on that page as


View Replies


Price optimisation with multipliers - how to optimise based on price when each section has a multiplier?
Category : Programming Languages

I have an assignment at work that involves finding the solution to this difficult problem.


Customers here can buy product allocations in either daily, monthly, quarterly or yearly amounts. Each step has a multiplier associated with it to incentivise people to book the longest allocation, so for example a day = 1.5 times the unit price, quarter = 1.3, month=1.2 etc.


This


View Replies


Change Magento price logic (tier price + custom option)
Category : Web Design

I'm having an issue with Magento's simple products price logic, using Magento 1.7.0.2


We sell our products (e. g. t-shirts) on a tier price basis with an additional discount, if the customer decides to put our logo on the product. To explain the problem in Magento, I first have to show you our pricing plan:


Product without our logo:


1-3 pieces: 20%
4-5 piec

View Replies


join two tables to get tomorrow's price (and the price two days from “now”)
Category : Databases

I'm trying to do a JOIN query to analyze some stocks. In my first table called top10perday, I list 10 stocks per day that I have chosen to "buy" the next day and sell the following day:


date symbol
07-Aug-08 PM
07-Aug-08 HNZ
07-Aug-08 KFT
07-Aug-08 MET
...
08-Aug-08 WYE
08-Aug-08 XOM
08-Aug-08 SGP
08-A

View Replies


Least price upcs for products by store wise and by Global from a price table
Category : Databases

This is what is my price table looks like


Product_id prod_upc str_nbr Price
prod110010 4122067755 12 1.22
prod110010 4122067755 21 2.88
prod110010 4122063030 21 3.88
prod110010 4122063030 12 2.88
prod110010 4122063031 12 2.88
prod110010 4122063031 21 4.88

I have two requirements to s


View Replies


Query the database for laptops with price close to entered price
Category : Databases

We are now doing embedded mysql queries for a small local website. I am wondering how I might do this query "Ask the user for a price and find the PC whose price is closest to the desired price. Print the maker, model number, and speed of the PC."


How might I find the pc with the price closest to the entered price from the user?
I know I need to do a natural join between prod


View Replies


how to define different price and discount price by (color + size) in zencart?
Category : Programming Languages

how to define different price and discount price by (color + size) in zencart?
defaultly, zencart can define a product price base on attributes, such as color .
but I can not find how to set defferent attribute with random discount price. can any one tell me how to do?



View Replies


Price update working but not with multiple select and discounting the price at the end
Category : Web Design

I have multiple dropdown lists calculating a total price at the end, it works great apart from a few issues.


Firstly, I would like to add further prices to it, so it should read:


Total : £20.97


V.A.T : £4.19


Total Amount : £25.16


I'm sure this is simple but i cannot think how?


Secondly - It only works on a single select


View Replies


Next
2012 / 2017 Copyrights BigHow , All Rights Reserved .