Support » Fixing WordPress » Inventory management

  • peterpaul123

    (@peterpaul123)


    Hello all,

    I have the task to make an inventory manager system for our technical department.

    The challenge: We have quit some machines that need repair and maintenance. For these repairs and maintenance the technical department uses quit some machine parts. Mainly small parts like bolts and rings. To keep track of all these parts (200+ items) we want to set up an inventory management system.

    What I would like to do if possible. I want to set up a wall full with small boxes and a barcode or QR-code on the boxes. So when someone for example takes 3 rings out of a box he can scan de code on the box with a scanner/tablet/phones and the system will automatically register this in the inventory manager system. So if there were 20 rings the system will automatically adjust 20 rings in to 17 rings. This is the main goal.

    I have seen quite some inventory manager plugins. But not with the scanning function.

    I am not sure if this is possible but I would like to hear your feedback.

    Ty in advance

Viewing 2 replies - 1 through 2 (of 2 total)
  • JNashHawkins

    (@jnashhawkins)

    There used to be a USB device from Radio Shack called a :CueCat that would read a bar code and help you find product descriptions and such… The company that made that device went belly up but I found one in a junk box last year and went looking for info about it.

    There are some people who made use of that silly little thing to handle some tasks including bar codes and such. I image there are other readers that work the same way and maybe perusing some info about that might put you on track for more info on doing something there.

    http://www.cexx.org/cuecat.htm

    I’d think the database to run it would be the big problem but maybe you could assign SKUs to each item and find a way to interface that via a WordPress plugin and have it possibly talk to Some eCommerce plugins even for handling more of that.

    I don’t know of any such plugin but a small, locally generated SKU database with bar codes might get you started.

    Another option might be to use a database integrated into WordPress to make it easier to search via typed in SKUs and descriptions. A standalone local WordPress might be a good place to start. The bar codes could then be the second step.

    My own experience is to sit down with some paper and draw out what I think I want in a logical list like a flow chart. Start answering the ‘what if’ questions with more branches in that chart and see if it doesn’t suggest something.

    Usually, I’ll hit a real snag but by thinking it through on paper I can often get past that snag.

    The impossible often has a neat answer once you look hard enough.

    I’ve heard of other companies and people designing a tool for some task and then finding a whole new business entity in that product down the road.

    mrtom414

    (@mrtom414)

    I did something like this before but it was with PHP and MySQL. It keeps inventory for covers that were used for printing books. It worked really well. I have a lot of programs I created that run an intranet site. Some of the programs even monitor events on a mainframe system. All you’re goals are achievable.

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Inventory management’ is closed to new replies.