portscan

1) supply chain sorry if im gonna look like a teacher but...(as a supply chain and warehouse manager ;D i can't resist) I see too big chickens : -the time you waste on inventories, but its on the good way -the time you need to process an order (won't this be the next thing?) if you want to improve your "customer order delivery service rate" at no cost. the first 2 things to think of are : -do the lead times from my suppliers correspond to my supply chain system ? -What do i need to improve my lead times ? and this needs : -stock and order management working closely together, stock alerts when an id's stock is decreasing too fast (once it's at 0 it's simply too late) (you already have this alert system but you waste your time on inventories), -Calculating your suppliers' service rate (and serialize yours after that, 85% is the strict minimum, above 95% is too expensive) and find what to do to be in these targets. Actually sales/production/supply chain are 3 definitely different jobs that must be in one same brain. your orders seem to have increased a lot since a few weeks, and 6 weeks just to process an order is simply way too much and very dangerous. (add delivery and your get 9 weeks from customer order to customer delivery, even OEM's producing on order only can do better). As soon as you have more orders incoming than orders going out, then its getting verrrrry dangerous (looking at your order status page makes me :o each time i go and see if mine has been shipped). Supply chain is the key ! BUT you got it before i write it, that was obvious, i just wanted to confirm this. 2)warehouse I agree with you about barcodes, in your case, with small electronic parts, it's simply a waste of time. Decreasing stocks from order validations is really the key in your case. All you have to do is making sure you pack the right quantities and do FIFO on each part. 3)SQL, PHP, IPN Ok i'd be really happy to see your db's structure and show you an IPN php script that automatically decreases the stock once the order is validated. So now ok i'll wait for your datas and check what i can do on it. Bye Cyrille

i didnt know you already had a sql db ! nice... somethin like : a file created from the transaction and that's used by a simple "INSERT into" sql query at the end of you ipn script ? doable............ a query that inserts item number and -quantity to the inventory table. any way to have a description of the inventory table ? (table and field names) and the partlist table if you use indexes. should take a big dozen lines max into the ipn. or maybe a new ipn, don't know where you found yours then to get you inventory you'll have to sum the quantities per item (another ultra basic query). the usual start stock + in - out = actual stock. you could event show this stock in your order form so the user knows there's no proto boards ;D . bye

lol actually access + vba is very good to build quite simple stuff very quickly and quite user friendly (even if its some crosoft sh*t). 2003 is a nice one. far from the 97 ugly one. perfect choice imho for a few users with no big web stuff. much faster than php&mysql (which i do too, when the customer says he wants "pro stuff" for 2 users with no website behind, and we apply a "pro price" ;D ).

Hi all. Im a new one here. and waiting my stuff from smash ( 8) ) Idea : i spend my work time building access databases used for stock/order management. So Smash : would you be interested by such a tool, if it might help you do your stuff faster/more easily ? Bye