ROBOT.LK

Posted: **Wed Feb 15, 2012 6:15 pm**

I wanna set reorder level to stock table when quantity is @ 11kg in mysql , php database ? pls help me

Posted: **Wed Feb 15, 2012 10:57 pm**

I wanna set reorder level to stock table when quantity is @ 11kg in mysql , php database ? pls help me

First of Welcome to ROBOT.LK !!!

This is really simple. Say you have items stored in a table named as 'item_table' with two fields as 'quantity' and ' reorder_level'. The you can program reorder level for each and every item on the database.

For example:

Code: Select all

item_id     item_desc                  quantity         reorder_level
A00001     Anchor butter 200g            10                 5
A00002     Sugar                          1000.5          11

I have taken your example to sugar. Current sugar quantity in-stock is 1000.5 Kg and the reorder level is set to 11 Kg.

You need to execute an SQL command as below to get the list of items which reached reorder level.

Code: Select all

SELECT * FROM item_table WHERE quantity <= reorder_level

Good luck!

Posted: **Wed Feb 29, 2012 10:30 am**

Thanku very much saman.

It is very useful.
Can u pls xplain according to ur example how we can just update table by amount like 10kg , 20kg like wise then i want to take the whole amount of stock. eg previous stock 1000kg , now um adding 10kg so the system should show 1010kg. Pls help me. Iam new to Php n mySql n um doing my first project these days. Thnks in advance

Posted: **Wed Feb 29, 2012 3:17 pm**

Code: Select all

UPDATE item_table SET quantity=quantity+10 WHERE item_id=A00001

Posted: **Wed Feb 29, 2012 9:34 pm**

thank u very much

. I never thought dat is so simple as u mentioned.

.

ROBOT.LK

How to set reorder level

How to set reorder level

Re: How to set reorder level

Re: How to set reorder level

Re: How to set reorder level

Re: How to set reorder level