stock management

Forum|Forum|15 years ago
November 30, 2010
4 replies
678 views

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

Server side applications

This topic is closed to new replies. Start a new post to keep the conversation going.

V

Vincej1657

Known Participant

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.

A

Azhar_Hussain_RanaAuthor

Participant

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

A

Anonymous

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.

B

bregent

Participating Frequently

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.

.

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.