Simple Invoices - Forum

Hey Tarnok

re inventory control
- no work has been done on this
- can you detail what type of stuff you require

note: if you do details what type of features you need then anyone is free to help out whenever they want it they want this feature

once i see what you mean by inventory control i post more details

Cheers

Justin

Hey Justin

Our company sells computers/servers so we have multiple headings/specs to search from. Currently we use spreadsheets to organize the machines. The one "description" line in SI products dosn't really cut it out for us atm as we need multiple specs to individually put in or search from.

Also, lets say for instance that we sell 3 machines to a client but they choose to only keep two and return one of them, I am unaware if SI has the ability to adapt for a situation like this.

Regards,
Tarnok

Just as an update, with our current spreadsheets we have 10+ headings. Starting from serial #, processor type, Clock rate, RAM, etc. Is there anyway to have that many headings in the "products" portion of SI?

I would think you could do a second table called si_product_details, then add each of the fields you need. Relate it to the Main Product category by the product_id...now you just need the php and template to make a page, then call that page when a new main product is entered....something like that..

Of course i'm making this sound much easier than it is...especially since I don't know squat about php, but i do know about sql, database structure, and I stayed at a Holiday inn Express last night.

Well Staying at the Holiday Express usually increases your intelligence by a few points, whenever I have a exam to do, I immediately book a room at a holiday express for the additional benefits. Hahaha.

I understood what you are trying to say. I could even just use the product table and php pages that we have available and just add the extra fields that I am looking for, kinda like just hacking it in into the original structure. Issue is my php-fu is next to null and for some reason I cannot seem to get around to playing with the code.

Thanks for the additional discussion bmcgonag.

Same here. I"ll start working on some of the things I"d like as soon as I get an extra 5 seconds.

I don't know if I am straying from the topic first posted, but I'll shoot it out anyways.

An inventory system is also what is preventing me from adopting Simple Invoices, but I am very interested in where it is headed. By inventory system, I mean a way to keep track of the quantity of product in stock. For example, if I create an invoice for x amount of a product then it is automatically subtracted from the inventory. I suppose I could just create a custom field with quantity and subtract it manually, but anything to make my life easier would be great :-P

I appreciate what you've done here. Thanks.

[Removed Spam]