Re: inventory management

Thanks for the responses. Has anyone seen a good inventory system on
places like github that I could browse through someone else's code to
get ideas?

On Dec 3, 3:47 am, "Kostis Mamassis - Megaventory.com"
<kostis.konstanti...@gmail.com> wrote:
> Hi there,
>
> the way to handle this is to create one product (SKU) for each
> quantity type. This will cover all cases since I assume that the price
> of the product may also change according to the quantity and quantity
> type. Then setup a system similar (but not same) to kitting where, if
> you sell the SKU having the quantity type in pints you will have to
> subtract from the master SKU the respective quantity in gallons (it is
> a division by a factor). You will not loose track of those products
> because you will group them under the master product or category.
> Google "kitting" to get some more info.
>
> Thanks,
> kostis
>
> On 2 Äåê, 19:03, fly2279 <kennethf...@gmail.com> wrote:
>
>
>
> > I need guidance on how to setup an inventory system. The inventory I
> > am managing is in liquid form and will be added/subtracted in
> > different units. For example Product A will be added from the supplier
> > in gallons, distributed out the door in pints, and applied in fluid
> > ounces. I thought about having a quantity field in the products table
> > to keep track of this but the only problem I see is which unit do I
> > store it in? If it's stored in gallons and you subtract only a few
> > ounces then it won't be very accurate to have a huge decimal number
> > i.e. you had 5 gallons and subtracted a few ounces so now you have
> > 4.966 gallons left. I could store it in ounces to avoid that but each
> > product will have different units and it might be difficult to keep
> > track of all that.
>
> > Any suggestions on a good way to handle this? Are there any examples
> > of inventory/inventory management systems for cake?

Check out the new CakePHP Questions site http://cakeqs.org and help others with their CakePHP related questions.

You received this message because you are subscribed to the Google Groups "CakePHP" group.
To post to this group, send email to cake-php@googlegroups.com
To unsubscribe from this group, send email to
cake-php+unsubscribe@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php?hl=en