On Thu, Oct 1, 2009 at 8:12 AM, Alex Hayes <[email protected]> wrote:
>
> Perhaps I am missing something, but from what I have managed to work
> out, the inventory in Satchmo is just a counter
> (product.items_in_stock) on the Product model. Is this correct?

Yes.

>
> What my client really needs is to have an actual Inventory model. The
> reason for this is I need to store specific information about an
> actual physical product (for instance its serial number etc..) so that
> when its rented out, upon return this information can be verified.
> Does this currently exist in Satchmo?
>
> If not, I was thinking it could be implemented roughly as follows;
>
> Inventory:
>  - ForiegnKey to Product
>  - serial number
>  - contains information *
>
> Rental
>  - ForiegnKey Inventory
>  - ForiegnKey Order (or something like that, I need to look into this)
>  - date start and end (used to determine if there is rental stock for
> a given day)
>
> So, I have a few questions;
>
> 1) Is there currently an Inventory?

Just the counter, as you mention.

> 2) Is the above on the right track?

Looks good.

> 3) It seems like signals will be the best possible way to implement
> some of this functionality, unless anyone has any other suggestions. I
> would think that this functionality (Inventory) is overkill for most
> satchmo installations so implementing it into the core would be
> necessary overhead.

I think you should be able to use the default Django signals to do
this.  model_save, etc.  Agreed, you wouldn't want to bulk up core for
an optional feature like that.

> 4) I would like to submit this back to the community (perhaps Deifante
> can help, I have pm'd him waiting on response) however my requirements
> for the other information marked above with a * are most likely
> different to others. What is the best way of allowing other satchmo
> developers to add their own columns/properties/? to this table on
> their own installations? For instance, I want puk_code, imei_number
> etc.. but this would seem like a bad idea given that not every
> inventory item will need this information.

You could have a simple name/value field, right?  Unless you have to
do db queries against it, it should work just fine.

-- 
Bruce Kroeze
http://www.ecomsmith.com
It's time to hammer your site into shape.

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups 
"Satchmo users" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to 
[email protected]
For more options, visit this group at 
http://groups.google.com/group/satchmo-users?hl=en
-~----------~----~----~----~------~----~------~--~---

Reply via email to