homepage Welcome to WebmasterWorld Guest from
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
Become a Pro Member
Home / Forums Index / WebmasterWorld / Ecommerce
Forum Library, Charter, Moderators: buckworks

Ecommerce Forum

Ecommerce - In stock/out of stock message
Anyone knwo an "easy" way of getting this message into product pages?

10+ Year Member

Msg#: 2273 posted 8:30 pm on Jun 3, 2004 (gmt 0)

Ok, here's the problem

I have, say for instance, a large music instrument retail site or something along these lines - high value items. Because of this there is a sales hotline so that people can phone in and hear someone's voice and take their details - thus offering reasssurance.

This is fine, but when they start asking loads of questions, normally whether we have an item in stock, the sales phone isn't taking sales, but answering queries etc.

I would like to tackle one of the most common, by indicating on our product pages whether an item is in stock or not - and if not, how quickly we can get one to the customer.

All our product pages are static, nothing being read out of databases - it really has been a labour of love! I do have MYSQL capability on the server - so I thought maybe I could list all our products in a table and if the number in stock is 1 or >1 then it prompts a message on the pages i insert some code into "in stock". Maybe have another column I could check if it is back in 2 weeks, and another one for "within 1 week". etc etc.

I'd be grateful if anyone has any experience of using anything like this, and how useful they found it. Also, remember my MYSQL and PHP experience is 0! So ideally i want to be able to insert a line of code that will be automatically updated when the "database" i don't mind what guise it takes, is updated.

Ideally, i'd like to use a little piece of javascript in the page so I don't have to turn my pages into .php. I know js can be a bit crap but a few lines wouldn't hurt too much.

Any ideas/Suggestions etc etc would be great.

And - no. At the moment I don't want the whole site to be database driven.




wifi on the fly

10+ Year Member

Msg#: 2273 posted 9:14 pm on Jun 3, 2004 (gmt 0)

You could always have a custom shopping cart designed for your business. That would be one way to make sure things were perfect. But on the same lines I am sure there is some shopping cart software that will automatically put an "Out of Stock" sign when you are low. Assuming it is a dynamic page.


10+ Year Member

Msg#: 2273 posted 9:03 am on Jun 4, 2004 (gmt 0)

How many products do you need this information for? If it's only a handful, the easiest way might be to edit the html pages by hand each morning (if this is quicker than answering enquiries on the phone).

If there are a lot of products, then I'm sure a professional web developer could knock something up in a day or less.

One approach (of many):
1 - Give each product a unique id or name
2 - Create a .js file with an array of ProductID->AvailabilityDescription
3 - Create a function WriteAvailability(ProductID), that looks up the ProductID in the array, and Document.Write the AvailabilityDescription.
4 - Include the .js file in the <head> of each html page
5 - Call WriteAvailabilty(ProductID) in the relevant place in the html code.
6 - Update the .js file with new availability information as required.


10+ Year Member

Msg#: 2273 posted 11:26 am on Jun 4, 2004 (gmt 0)

Hi Pete - Yeah, this was the kind of thing I was after I think.

We are approaching nearly 1000 products at the moment so as you mentioned, doing it all by hand each time would get pretty tiring fast!

Where abouts can I find someone who can do this?...For cheap! If not for free! hehe =0)



10+ Year Member

Msg#: 2273 posted 11:44 am on Jun 4, 2004 (gmt 0)

Well you could always try the Commercial Exchange [webmasterworld.com] forum of this very website!


10+ Year Member

Msg#: 2273 posted 12:12 pm on Jun 4, 2004 (gmt 0)

Actinic generates static HTML pages and can automatically generate an out-of-stock message once stock reaches a pre-determined level. This happens when the site is refreshed from the desktop.

Declaration of interest: I work for actinic.



10+ Year Member

Msg#: 2273 posted 11:15 pm on Jun 7, 2004 (gmt 0)

The default build of oscommerce does this, & the software is free.

Global Options:
 top home search open messages active posts  

Home / Forums Index / WebmasterWorld / Ecommerce
rss feed

All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Home ¦ Free Tools ¦ Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About ¦ Library ¦ Newsletter
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved