Best way to update multiple prices via a web page

[Laphan]

Hi All

All I'm asking in this post is just for some user interface advice on the
best way round it.

Basically I've created a colours and sizes mechanism in my shopcart that
allows me to specify different prices for my products if a user selects say
a particular colour or size. To see my shabby work, please visit
[url]www.henrykaye.co.uk[/url] to see this in action.

From the customer interface point of view, its been quite straightforward
for me to populate my drop-down menus with the colours and then dynamically
change my prices to suit, but my quandary is from an admin point of view.

The scenario is, I have 1 product code showing on my web page with a
drop-down list of say sizes this time.

I don't want to display say 15 different permutations of sizes a) because if
I have lots of sizes its going to look crap and b) I don't know how many
sizes I'm going to enter.

I don't want to make the admin user select the product then the size, then
click a button to go to a new page so that I can query and put the price in
1 text box, so they change this, file it and then go through the process
again. To update 3 products with 10 sizes/prices, this is going to be about
90 page clicks!!

How does one allow an admin user to update a multitude of dynamic prices
from say 1 web page.

The DB I'm using is Access, but I don't think this really matters. I would
have thought the insert/update statement is going to be the same whether it
be Access or SQL Server.

Any good tips???

Rgds

Laphan

[Laphan]

Hi Guys

Any ideas??

Laphan <news@DoNotEmailMe.co.uk> wrote in message
news:urH3ZMiAEHA.3804@TK2MSFTNGP09.phx.gbl...
Hi All

All I'm asking in this post is just for some user interface advice on the
best way round it.

Basically I've created a colours and sizes mechanism in my shopcart that
allows me to specify different prices for my products if a user selects say
a particular colour or size. To see my shabby work, please visit
[url]www.henrykaye.co.uk[/url] to see this in action.

From the customer interface point of view, its been quite straightforward
for me to populate my drop-down menus with the colours and then dynamically
change my prices to suit, but my quandary is from an admin point of view.

The scenario is, I have 1 product code showing on my web page with a
drop-down list of say sizes this time.

I don't want to display say 15 different permutations of sizes a) because if
I have lots of sizes its going to look crap and b) I don't know how many
sizes I'm going to enter.

I don't want to make the admin user select the product then the size, then
click a button to go to a new page so that I can query and put the price in
1 text box, so they change this, file it and then go through the process
again. To update 3 products with 10 sizes/prices, this is going to be about
90 page clicks!!

How does one allow an admin user to update a multitude of dynamic prices
from say 1 web page.

The DB I'm using is Access, but I don't think this really matters. I would
have thought the insert/update statement is going to be the same whether it
be Access or SQL Server.

Any good tips???

Rgds

Laphan