Using a Raspberry Pi for your own Inventory Management System Using a Raspberry Pi for your own Inventory Management System Share this:TwitterFacebookLinkedInRedditTumblrPinterestLike this:Like Loading... 39 thoughts on “Using a Raspberry Pi for your own Inventory Management System” Add yours Hi there, thanks to your post I found this little gem of inventory mangement. I see you have done a lot improovements. Are you willing to share your edits? Best Chris LikeLike Reply https://github.com/bitsandbots/inventory LikeLike Reply yes man! thank you very much LikeLiked by 1 person Reply I verified the code this morning and updated a few minor bits. LikeLike I like this project a lot. I’m following it, as I’m looking for a good use for my RPi3. Question – will this accept input from a barcode scanner? UPC/QR/ISBN/whatever? LikeLiked by 2 people Reply Good feature request! If you have implementation suggestions please send me an email. LikeLike Reply Good afternoon, I am very interested in getting this up and running, however I am stuck at a WordPress landing page after I have completed all the steps. Is there a checklist of where to start in my trouble shooting and audit of my work? It seems like I dont have any temlpates, but as I read through your guide it should have been included and defaulted in the files I downloaded. Thanks for reading! LikeLike Reply Hi Florian, Thank you for taking the time to share the issue you are having, it’s likely other people have had the same experience. The WordPress installation has over written the default settings of the web server installation. If you try the URL to your inventory management system directory, for example: http://localhost/inventory/index.php and you are redirected to WordPress then you will want to check your apache web server settings found in the /etc/apache2/apache.conf Let me know how it goes! LikeLike Reply Thank you for taking your time to respond . This is my first time but looking at the apache web server settings nothing seems to out of order . When try log in the site with localhost i get wordpress, if i try with ip adress//inventory/index.php i get a not found page . If i go on http://localhost/inventory/index.php i get 404 Thank you ! LikeLike Reply Where did you install, and by install, I mean, to which directory did you extract the contents of the inventory management system source-code? LikeLike Reply Mine is setup like this /var/www/html/warehouse-inventory-system , i kept the files in warehouse-inventory-system where they are . Thank you LikeLike Reply Hi Florian, I’m happy to help as much as I can 🙂 Your URL should be http://localhost/warehouse-inventory-system/index.php Double-check that the directory and file permissions are set correctly. LikeLike Reply If i try to log in i get Database connection failed:Access denied for user ‘admin’@’localhost’ (using password: YES) where do i choose the default log in ? Should i just go and grand all permission to admin user ? Thank you LikeLike Reply Check your MySql databases configuration. The access is denied because the default password is set to yes for user admin. Does user admin exist, if so is the password in the conf file inside the inventory management system directory set to that password. LikeLike Reply Ive got the same issure but cant find config file… LikeLike /inventory/includes/config.php LikeLike Great thanks, done that so i dont get the error anymore but get to a login screen and cant login LikeLike The default is “admin” for username and password. Or “user”, “special” LikeLike Hi, is the Add Sale page working or is it my config has some issues. LikeLike Reply Hi Adrian, what error are you receiving? LikeLike Reply Okay, check the GitHub LikeLike Hi, couple of things i need help with/ask about?: – Is there a way to change currency to £? – Is there anyway of changing it so prices could be say £1.30 as at the moment it only allows me to input whole numbers? – When adding products to a sale is there a way as adding multiple items at once, as if i put in qty’s for severasl items then click add item on one of the items it only adds that one item even though ive put in quantities for several? Either way this is a very nice inventory management tool 🙂 LikeLike Reply Thank you for your feedback. I’ve updated the cents for sales, but need to upload. I’ll see what I can do about changing the monetary system. LikeLike Reply Saw you updated some of the files… went to re-downloaded and deleted current folder contents and replaced with new download. Changed config file to my database password and now getting “Error on this Query : INSERT INTO log (user_id,remote_ip,action,date) VALUES (”,’::1′,’/’,’2019-11-21 21:51:03′)”… any ideas? LikeLike Reply The log is optional. Make sure that you have a table “log” and permission to insert; or you can comment-out the source-code if you don’t want to log. LikeLike Reply Stupid question but what source code? 😂 LikeLike Fixed it but now can’t login… using admin admin? LikeLike Fixed that but now cant login.. using u-admin and p-admin LikeLike If you’ve changed the login password, it should still be the same. Otherwise, you’ll need to reload the credentials in the database. LikeLike Hello, I was prompted with a login. Logging in with admin:admin brings me to Error on this Query : INSERT INTO log (user_id,remote_ip,action,date) VALUES (”,’192.168.x.x’,”,’2019-12-02 23:53:31′) Checked, I have a table for “log” not sure how to check if I have permissions on insert via phpmyadmin. ..which file should be edited to comment-out the source-code if I don’t want to log. Thanks LikeLike Reply Side note. Running Nginx & MariaDB. LikeLike Reply I haven’t installed from scratch in a while. Let me check it out, but if you want to comment out the logging, the file you’re seeking is in the includes directory. Bottom of file named “load.php” LikeLike Reply Looks like we were trying to get a server variable before starting the session. I fixed the load.php source code. Let me know if it works for you! LikeLike Thanks for the fast reply. Created fresh LAMP, Wordpress & LAMP is 100%. noticed 11 hours ago git was updated, I have done a fresh install of oswa. Still having the same issue, I receive the proper login/password prompt, and have tried all 3 default user/pws. they all end with the same result… Error on this Query : INSERT INTO log (user_id,remote_ip,action,date) VALUES (”,’192.168.x.x’,’auth.php’,’2019-12-03 23:02:18′) Refreshing the page results in the same error unless I delete the log, then I am prompted again with a login/pw, I’m currently stuck in a loop of entering default credentials, deleting the only log in the oswa_inv SQL tree and refreshing the index.php in my browser. I have confirmed the SQL user/pw is correct & matches the config.php, Also looks like user permissions are correct via phpmyadmin. Is there an older ver. I can install? Thoughts? Thanks again for your time. LikeLike Reply side note, commenting out the last line in load.php lets me log in with admin:admin LikeLike Reply Hi Freddy, thank you for your work. I appreciate you sharing your experience. I’ll look into the issue. For some reason the user id which in the case of admin is 1, is not being inserted in the SQL query. LikeLike Reply Hello, When adding media the 1st upload works, the next upload results an error. Error on this Query : INSERT INTO media ( file_name,file_type ) VALUES ( ‘imagefile0002.jpeg’, ‘image/jpeg’ Refresh the /media.php & try again I’m prompted “in red” The file image0002.jpeg already exists. checking the dir the file HAS been uploaded, using phpmyadmin I have manually added a new row under “media” nest with proper info, refreshing media.php, Now the new media is viewable in the GUI. Also, When adding a product, 1st product goes smooth, 2nd results an error Error on this Query : INSERT INTO stock (product_id,quantity,comments,date) VALUES (’10’,’1′,’initial stock’,’2019-12-04 20:04:15′) Reviewing product nest in phpmyadmin, The 2nd product has over written the 1st product instead of creating a new row under “product” nest. Manually added new row & filled in the proper info, all looks well in GUI after refreshing browser. Manually added 15 media files, as well new rows under “media” & “products” nest using phpmyadmin. All looks good in the GUI after refresh, Thoughts? LikeLike There was an error in the database schema. I have corrected the issue but have not fully tested. LikeLike Hi all, i have used this program on my pi3, after struggling couple of days got everything got Working, Db given access, Default login password is changed from OSWA_inv, …… and system is up and running fine!~ Now i m trying to land this project on 000webhost, almost set, Database config is updated with 000webhost database, access granted, login screen appears, but after login it hangs on Auth.php page, (i tried to bypass authentication and force session , but no use) Please help me on this ! my 000webhost url : http://burnished-ticks.000webhostapp.com/inv/index.php user/Password = admin/test thank You! LikeLike Reply Leave a Reply Cancel reply Enter your comment here... Fill in your details below or click an icon to log in: Email (required) (Address never made public) Name (required) Website You are commenting using your WordPress.com account. ( Log Out / Change ) You are commenting using your Google account. ( Log Out / Change ) You are commenting using your Twitter account. ( Log Out / Change ) You are commenting using your Facebook account. ( Log Out / Change ) Cancel Connecting to %s Notify me of new comments via email. Notify me of new posts via email. This site uses Akismet to reduce spam. Learn how your comment data is processed.