stock management

[Azhar_Hussain_Rana]

Hello All,

I want some help about stock management, which is right way to control stock i.e automatically plus and mines items stock, recently I am working on two projects one for e-shop and one about money transfer please help me which is the best way  and how to” – “amount when agents make a transaction.

Thanks in advance

Azhar

[bregent]

Those questions are much too broad to be answered in a forum like this. Please ask more specific questions if you want anyone to answer. I would also question if you are posting to the correct forum. This is a Dreamweaver App Dev forum.

.

[Vincej1657]

I have spent a long time with retail and ERP systems. The 'best way' is the way the customer wants it.  The customer could be an accountant. he will have his own ideas. It can get very complex very quickly. If you really want to understand the topic for 100% start Googeling topics such as LIFO and FIFO, General cost Averaging and Unit Cost Averaging, Current Costs and Aged Costs.

I you don't want all that work, then just increment and decrement.  The accountant will scream at you quickly enough when he see's its not done his way.

[Azhar_Hussain_Rana]

Dear all,

First of all I am very thank full to you for this replay and sorry bcz I don’t write complete information about my question actually I am developing a web base application like e-shop in PHP and MYSQL and for that I want some help in stock  list .

Now my question is that how to control stock management in PHP MYSQL? I.e. when customer makes a sale, application automatically mines one or more items from stock.

Which is the best way in PHP MYSQL for that? i.e “Trigger” or “conditional (if) “statement or any other etc. and in database any special query?

I think now you are understand

I have installed developer toolbox in Dreamweaver cs4

Thanks again

[Guest]

There's an apparent language barrier. When an order is completed use an UPDATE query to update your database for the number of items available for the product. Consider cartweaver for shopping cart which updates stock of items available.