Drop-shop & supplier intentory

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|

Drop-shop & supplier intentory

Sanjeev Gupta
If a suppliers drop-ships to fulfill customer orders, is there a way by which we can track / manage suppliers inventor in ofbiz so we don't accept orders more that what the supplier has ?
Rgds
Sanjeev Gupta
www.digitalwebadvisors.com
Reply | Threaded
Open this post in threaded view
|

Re: Drop-shop & supplier intentory

Mike Z
Don't try to track a suppliers inventory.  Since it is not your assets, it
will mess up accounting.  But here is what you can do:

Setup an external process that reads the suppliers XML/CSV file to
determine current inventory levels of the supplier.  If their inventory
falls below a minimum level (determined by you), you can "age out" the
product by updating the following ofbiz tables:

Product: product_id -> sales_discontinuation_date
ProductCategoryMember: product_id -> date_thru (all records)

For low inventory, set the above fields to a date in the past (i.e.
01-01-1980), which turns off the ability to add to cart.  It should also
prevent the product from showing up in searches as well.  For adequate
inventory, set the above dates to blank or a date in the future
(01-01-2038).

If you want to track (just for info only) the last-known suppliers
inventory, you can add/update the following:

ProductFacility: product_id + facility_id  -> last_inventory_count

You can then read the suppliers last inventory count from the back-end.  As
far as I can see, it doesn't mess with accounting.

The are probably better ways of doing this.  Maybe someone else can chime
in.

On Wed, Mar 6, 2013 at 3:47 AM, Sanjeev Gupta <[hidden email]>wrote:

> If a suppliers drop-ships to fulfill customer orders, is there a way by
> which
> we can track / manage suppliers inventor in ofbiz so we don't accept orders
> more that what the supplier has ?
>
>
>
>
> -----
> Rgds
> Sanjeev
> www.sanjeevg.com
> @sanjeevgcom
> --
> View this message in context:
> http://ofbiz.135035.n4.nabble.com/Drop-shop-supplier-intentory-tp4639716.html
> Sent from the OFBiz - User mailing list archive at Nabble.com.
>
Reply | Threaded
Open this post in threaded view
|

Re: Drop-shop & supplier intentory

Sanjeev Gupta
Thanks Mike....the first options is in line with our requirement and the approach I had in mind. Will go ahead with it..
Rgds
Sanjeev Gupta
www.digitalwebadvisors.com