Show inventory remaining?

[rhendrix9]

How / Can I show the number of items remaining for a product?

[stefanie]

You can't show how many more items you have in stock in the shopping cart, but we won't allow a buyer to add more to a cart than is available.



You are notified with an email when your inventory reaches 5 or less.

[quiet]

Hi Stefanie,



Aside from the shopping cart, is there some way to display the # of stock remaining on a specific product somewhere on our website?



Just wondering if there is some post/query that we can request the stock remaining -- it would help sales if customers know there are only a few quantity remaining -- but it would be a pain to manually update it as e-junkie sales are processed.



Thanks for any info...

[E-junkie_Guru]

Sorry, we don't have any method to do what you describe.

[uyd]

any update on this?



it would be helpful to users to know how much, if any, stock is remaining on an item. at the very least a simple "Out of Stock" / "Active" tag indicating the current availability of an item.

[E-junkie_Ninja]

Currently we still do not have any method to allow you to see how many of a product you have left with out viewing the product in your account.

[quiet]

Haven't seen this post active since I first asked, back in March!



In reply to UYD -- the best solution is to create a basic counter with MySQL that holds the same inventory information that your E-junkie inventory uses.



So, if you have 100 QTY in stock on a certain item, you set an item in your own database with 100 QTY.



When a purchase is successfully completed, use an e-mail or success-page response to enter the data into your database, and update the QTY for that item for 99 (-1 from current qty).



You can then query your own database and display that inventory stock qty next to your products. It will be close enough for most purposes.



(I haven't done this, as of yet, but I am quite sure it is feasible! You'd have to have a PHP script as an event handler to update a MySQL DB upon a transaction, in my example.)

[uyd]

thanks Quiet!

i will take that into consideration

[quiet]

Let me know how it works out, UYD!



Post any code you come up with here. I will do the same, if I end up taking my own advice and completing it before you do.



I have an upcoming project in the next month or so that might require this specific need.

[E-junkie_Guru]

BTW, you may be interested in our Integration feature, which is our recommended method for simply and reliably transmitting order data to a script at your end for post-checkout processing:

http://www.e-junkie.com/ej/help.integration.htm

[quiet]

Yep! Thanks for pointing that URL out, Tyson!



That will work perfectly for this situation.



So you'd insert the handler/parser URL into the payment variable box of the item etc.



I'll post here any results after I have time to implement something simple that will accomplish what we are aiming for here.



I noticed Aweber is available for integration... any chance of seeing MailChimp (http://eepurl.com/cbGh) integration sometime?

[E-junkie_Guru]

We don't have plans for any built-in preintegration with MailChimp like we have for Aweber, but if MailChimp can receive PayPal IPN-style submissions of order data, they may be able to use our generic Integration method -- i.e., just place their IPN submission URL in the Common Notification URL field or Payment Variable Info URL field(s).