A friend of mine has an online shop and a real one (no ubercart, human powered).
He stores products at the real shop (stock A) and at another depot where he rent some space (stock B).
When people order products online he needs to know where they are stored and how many of them are at stock A and stock B to ship them.
People from staff move products for demoing or selling from A to B and A. So they need to keep track of it. "Where the hell is product X right now?"

I started to put CCK fields to products representing additional stocks but i stopped since attributes are used for different sizes (which differ from product to product). CCK works just as one (or more) field per node but not per ubercart attribute. One way ist to make several products (nodes) from attributes which would lead to a bad shop design from a drupal+ubercart point of view. Another try is to ask you if there is a module which solves this problem by providing multiple stocks to use.

I'm also interested in ideas (not ready to use) which makes my head go round at this point...

Thanks for hints, Ronald

Comments

rszrama’s picture

rszrama commented
Status: Active » Closed (won't fix)

I'd recommend you take this discussion up in the Ubercart support forums where issues of inventory management and Ubercart's stock tracking support come up fairly regularly; basically, robust stock solutions only exist as contributed modules, not as core features at this point.

rokr’s picture

rokr
Location Bochum, Germany
commented

Thanks Ryan for putting this into the right direction.

robust stock solutions only exist as contributed modules

If you or someone else could point me to some of this modules for ubercart 2 - it would be great. I could only find this thread and some not up to date modules.

Thanks, Ronald

rszrama’s picture

rszrama commented

Unfortunately, that's the latest news. You might look for other threads by digitalfrontiers - I thought he had a synopsis thread somewhere listing the various stock solutions. They probably are in need of a D6 update, tho.

Gham’s picture

Gham commented

Hi

I'm about to start a project with an identical issue .. having an online shop but with multiple stock locations.

I want to add a value to products to say they may have quantites at various locations and would appreciate any pointers, also if anyone has successfully reproduced this functionality....

thanks G

cristhian’s picture

cristhian commented

Hello there,

I'm very interested in developing this too. If you check the ubercart's stock module, you'll see is not that hard... My idea would be like this: create (or set default) content types and use them as locations for stocks. An easy but maybe not the correct way to set the stock levels, is creating a content type called stock with the following fields: location as nodereference, product as nodereference, qty as decimal, min_thresold and max_thresold as decimal... The correct way would be doing this directly in the database, but we would need to do many things already done in cck, like the forms, widgets, views integration, etc (boring)...

Another point is creating an API to decide which location will be affected when an order is paid, in my case I'd set a default location for all internet orders and specific locations in orders made with UBERPOS, depending on the attending person.

So let's work together on this...

sokrplare’s picture

sokrplare commented

To hopefully save other people time, it looks like http://drupal.org/project/uberpos (dev, not alpha1 as of now) has support for multiple locations with stock support. Haven't tried it yet personally, but closest answer I've found so far.

Edit: Yup, checked it out and it definitely does - nice integration job done too. Also be sure to check-out this patch which adds support for the multiple locations to the Ubercart Bulk Stock Updater module - sweet!