This is a rather general feature request. I'm interested to see if other drupal EC users would benefit from these from better support for this kind of business model. I'd also like to generate awareness of the issue and this area of E commerce that drupal EC is not currently catering for very well. I hope this thread will lead to patches being developed for EC to better cater for this type of business model...

A client of mine runs a store that parallel imports snow-sports product and sells only online in competition with physical sports-equipment stores.

Due to the industry's anti-internet-friendliness, he sources product overseas and doesn't have a continuous supply of product. He typically has 1 to 5 of each product, and cannot get more of exactly the same brand/model/size/color when they sell out.

Another client resells handpicked used clothing, and never has more than one of a particular product.

Both these situations require special stock management. The main problem is that drupal EC reduces stock by one when and only when a transaction is marked as paid. For one-of-a-kind style stores, this can cause a problem. It may take several days for a payment to be received and possibly a day or two more for the transaction to be updated in drupal EC (in a COD payment for example). During that time the product is still 'in stock' and others can purchase it.

The current solution I have for this is simply setting C.O.D such that transactions are marked as paid automatically, when the order is confirmed. However this is not ideal, as the order can not be marked as 'canceled' if the client doesn't follow through with the purchase. Additionally stock must be restored manually for each product the client purchased.

Would it be useful to calculate 'in_stock' based on 'stock' minus pending transactions? And then leave stock to be adjusted when the order is paid?

Or would it be best to adjust stock directly on order-confirm and order-cancel? If so, how can we avoid stock being adjusted twice on both order-confirm AND transaction-paid? Without disrupting inventory management for stores with large inventories and consistent supplies?

Another great feature for the second client would be to have a 'one-of-a-kind' product type where inventory is already enabled, and stock is one. Any exceptions to this could be done through a different product type.

Comments

tille’s picture

this is exactly the problem I am currently facing: a shop for one-of-a-kind products. For me the best solution would be to have some kind of a 'reserved' status - which would 'block' the product so that nobody else could reserve it once it is reserved..
At the moment I am a bit lost with this problem since it is indeed a crucial feature.. Having two clients claiming the same object/product would be a nightmare.... - ..anybody any ideas how this could be solved..?

thanks!! t..

gordon’s picture

Yes we are going to be adding an ec_availablity module which will handle all stock. Not only will it handle checking to see if a product has stock, it will check the stock levels, as well as do temporary allocation.

Because of the new product features this function will be able to be added to any type of product.

Bevan’s picture

Cool! Where can we be involved with testing and feedback on this?

tille’s picture

..just wondering if there's anything new about this matter..?

greetings, till..

vikingew’s picture

Last time I checked my Modules page in Admin the e-Commerse Product Types group contained an Availability module. I don't use it though so can't tell if it measures up the the request above.

gordon’s picture

Yes the new ec_availablity module does allow for better control of limited products.

It will also have once it it finished temporary allocation and better subtraction of stock on sale.

royal007’s picture

i tried the 3.3 & dev versions of ecommerce and i don't see no ec_availablity module under product types. where is it???

brmassa’s picture

royal007,

It is on eC4, eC3 wont have new features anymore.

regards,

massa

brmassa’s picture

Status: Active » Fixed

Guys,

im gonna close it. Fell free to reopen for further questions

regards,

massa

tille’s picture

"..It is on eC4.."

..that'd be very good news!! ..but where is eC4 located..? ..is it up? ..is it coming? ..or is it upcoming..? :]

greetz, t..

brmassa’s picture

tille,

eC4 is, yet, only on our CVS.

you can get it using:
1* a CVS client
2* repository ":pserver@cvs.drupal.org:/cvs/drupal-contrib"
3* module "/contribuition/modules/ecommerce"
4* tag "DRUPAL-5--4"

soon we will publish the dev code as a beta.

regards,

massa

tille’s picture

thank you very much, massa!
This is a crucial feature which is definitely needed before we can go online - so i suppose I'll better try to be patient..

..maybe now I better stop bothering you and let you 'do your things'..:]

greetz, t..

vikingew’s picture

You can also get it from the "view all releases" link, just scroll down and look for the v4 dev version. If update status is installled it will then keep track on new releases and serve you a direct link.

Anonymous’s picture

Status: Fixed » Closed (fixed)