How’s Your Availability?
Monday, November 19th, 2007
A merchant recently asked about how to insert a custom message between the item price and the add to cart button that would show the availability of the item. With this merchant, he was putting up items in his store for collectible die-cast cars that were not released yet. It makes sense for this merchant to provide notice to his shoppers of new products that will be released shortly—especially with regards to collectibles, though I’d imagine there are other vertical markets where this is true.
So not only does it make sense to do this to capture interest with prospective buyers, but it also makes sense to do this for all stores in terms of setting expectations with customers. I read in a recent white paper about shoppers expectations that seventy-two percent would be less willing to shop with a retailer when sales items are out of stock. That’s a big number and it goes beyond just being able to keep items in stock. Merchants need to set expectations about order fulfillment times in addition to shipping delivery times—especially with the holidays fast approaching. The last thing you want is a customer to buy an item expecting a pre-holiday delivery which you can’t meet because you didn’t specify the item will not be in stock for 8 weeks.
The good thing is the Store Editor templates already include a feature that serves this function—the Availability field. The Availability field for 3.0 Editor templates appears below the price but above the add to cart button—right where shoppers can see it.

Availability field appears in red text with a standard option.
The Availability field can be set in the Variables page with a global variable that applies to all pages (your standard product availability). You can then set this on a per page basis using the Availability field on individual pages. However, for this particular merchant, he wanted to have a value appearing there which wasn’t in the standard list of values. He wanted to notify shoppers of the estimated release date for the item. Database Upload to the rescue.
You can set custom values for Availability on a per product basis in the following way.
- Make a note of the product IDs for which you wish to set a custom availability. Merchants can download their product database from Catalog Manager to set this for many products.
- Create a spreadsheet with two columns: ID and Availability (or delete all columns except for ID and add Availability if using your product database from Catalog Manager).
- Enter text in the availability column which you wish to appear on the product such as “Item is on backorder” or “Estimated release date January 2008″.
- Save the file as .CSV format with the name data.csv.
- Upload to the Store Editor using the database upload feature and click the Add button when uploaded. Note: Do not add this file as a Rebuild. This will wipe out your store contents except for the items and information in the spreadsheet. You can use the Revert feature if you make a mistake and Rebuild your store.
- Publish your changes when ready.

Availability field with custom availability message.
Paul Boisvert
Yahoo! Small Business
Comments
Steve,
While there is no standard way to display available inventory on the product page, we do offer two forms of inventory management: database upload and real-time inventory mangement. With database upload, you send updated inventory levels to Catalog Manager as often as you need to depending on your volume of orders and how much stock you keep on hand. With real-time inventory, you set up the system to call out to a server that maintains your stock levels. With either set up, buyers will have items checked against available inventory when the item is placed in the cart and again when the order is placed. Also with either you can choose to display in the cart how many items are in stock or more generally if an item is in stock or not.
Paul
Comment by pboisver — November 26, 2007 @ 3:52 am
I’d like to see a blog post regarding the lengthy (and very costly) system outage today. In order to make intelligent decisions regarding our ecommerce infrastructure, I need to know more than the system update tells us (“we’re looking into it…”). Please provide greater transparency as to the reasons for outages, as this is critical information.
Comment by Kelly Andrews — November 26, 2007 @ 7:59 pm
Leave a comment














Unfortunately, there is no way to reference the inventory from the website. When I have an item of limited availability, and no idea when or if it can be replaced, there is no way to let customers know that the item has been sold, or the current number of items available, without manual updating.
I could manually list the number of items in stock, but that would quickly become a management nightmare.
An “inventory” store tag that returns the current count of items in inventory would sure be helpful!
Steve
http://store.gemsevermore.com
Comment by Steve McQueen — November 25, 2007 @ 8:40 pm