garrie007 wrote:Hi Rob,
Thanks for the reply, What i am trying to achive is a supplier of mine has 13,785 products that he can uplaod to my db to update my trade product list with specials etc via a custom api so i wanted it to automaticaly update the trade price plus my profit to a normal selling price.
How you getting on with your site?
Um, er, is the selling Price to Trade a fixed percentage??
The only way that I can see you could do this is to write a simple SQL to take the Trade Price and then increment it by the % increase and then use that as the Sale Price.
Mapping products to the DB from an external source is a bite of a nightmare though, good luck with that! I think there are at least 3 - 4 table and then the Catergory mapping, yuk!
Web Sites nearly there, got a really simply problem that's got me a bit stuck at the moment, if i'm in a Catergory viewing a product, I cannot then click on "Home" or "Contact Us" as the /catergory/default.aspx is not there and it throw's an error!!
I think this needs a URL rewrite setting but I am a bit lost as to a simply solution as I've not done anything with Navigation!!
Rob