Thread: New Merchant - Natural Instinct

Jon has made available a database of all the their products. To download visit <a href="http://www.naturalinstinct.co.uk/downloads.aspx" target="_new">www.naturalinstinct.co.uk/downloads.aspx</a>

thanks for mentioning that pete. If any of our affiliates can think of ways we can help them then please don't hesitate to call the office on 0870 794 2130 or email jon@naturalinstinct.co.uk

Jon

Jon,

Any chance of adding the category to the product catalogue?

Ian

HI IM,

Unfortunately that data is kept in a seperate linked table because a product can be in may different categories.

i can give you a copy of that table if you think it would help, it just has two colums - productID and categoryID , i guess i would have to give you the category table too so that you could extract the category names.

I'm quite happy to provide all this data if you think you can do something with some funky SQL ?

Hi Jon,

If you've got the time to provide them then that would be great. I'm sure I can knock some SQL together to make it meaningful.

If you don't want to put it on the site with the product catalogue then you can mail it to me at ian@[no spam]kissyou.co.uk (remove the [no spam])

Thanks

Ian

ian, would you like an excel sheet or an access database ?

Jon,

Excel preferably, but if its easier for you Access will be fine (or even just a CSV text file).

Ian

sent