Skip navigation
Azhar Hussain Rana
Azhar Hussain Rana Calculating status...
Currently Being Moderated

stock management

Nov 30, 2010 12:28 PM

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

 

 

 

251 Views   4 Replies   Latest reply: the_shocker, Dec 1, 2010 12:47 PM
 
Replies
  • bregent
    Currently Being Moderated
    1. bregent,
    Nov 30, 2010 1:59 PM   in reply to Azhar Hussain Rana
    Report

    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.

    .

     
    |
    Mark as:
  • Vincej1657
    Currently Being Moderated
    2. Vincej1657,
    Nov 30, 2010 3:59 PM   in reply to Azhar Hussain Rana
    Report

    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.

     
    |
    Mark as:
  • Azhar Hussain Rana
    Currently Being Moderated
    3. Azhar Hussain Rana,
    Dec 1, 2010 10:55 AM   in reply to Vincej1657
    Report

    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

     
    |
    Mark as:
  • the_shocker
    Currently Being Moderated
    4. the_shocker,
    Dec 1, 2010 12:47 PM   in reply to Azhar Hussain Rana
    Report

    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.

     
    |
    Mark as:
Actions

More Like This

  • Retrieving data ...

Bookmarked By (0)

Answers + Points = Status

  • 10 points awarded for Correct Answers
  • 5 points awarded for Helpful Answers
  • 10,000+ points
  • 1,001-10,000 points
  • 501-1,000 points
  • 5-500 points