December 11, 201312 yr Hi all, This paragraph is only background and can be skipped I'm a volunteer at a youth movement in Belgium and I would like to tackle a problem we've encountered with our inventory list. Our organization goes on vacations and for every vacation we need to pack material from a warehouse. Currently we have an Excel list of all items available. We fill in this list (often via Dropbox), print it (which is a waste of paper, since most fields are empty) and take it with us when we go pack. The problem is however that this list contains many items, which are often also vaguely named. We would like to add pictures and descriptions, categories etc. I'm fairly new to website building, but I am prepared to do some studying and have a few months time (only on some evening though ), I'm here asking where to start my search and I do realize that all I'm asking is very idealistic The goal: - a static database (with static I mean that the users don't need to add content, they should just be able to fill in one field: the Amount of items they would like) - the ability for an admin to fill in a form with Name, Description, some Info fields, and a picture (ideally drag and drop) at any time to add an item to the database - an export function that selects all items for which the Amount field was filled in and prints them to a single page. - the ability to log in to different copies of this list (one for each vacation) All ideas are welcome! I'm looking for software, programming languages etc. Thanks in advance! Robbe
December 12, 201312 yr Well the brief is quite open so there are a hundred different possibilities. I'd say the easiest way to do this for a beginner would be to use something like WordPress, get an eCommerce plugin to handle the inventory, order management, and exporting function.
December 13, 201312 yr Nah dude, i know what you need trust on this http://www.developphp.com/list_php_video.php#E__Commerce_Website_Tutorial_Admin_Shopping_Cart_PayPal Go onto that website and click the video, its for a e-commerce solution but you only need videos 1 to 8 if you do those videos you should be able to answer every question with a solution you just asked.. Personally you dont need to understand the code, just follow instructions and download the package which you can find on the last video, keep what you need and what delete you dont. and you should have a simple inventory system within a day or two!! P.S You will need a server
December 27, 201312 yr Question 1. DO you already have web hosting with PHP/MySQL or ASP/MSSQL available? Question 2. What do you know about HTML, CSS, PHP, MySQL (ASP, MSSQL), Javascript and other web languages? If the answers to the above questions are: Question 1. No Question 2. Sod all You are pretty much wasting your time. Your youngsters will be grown up and married with children before you have got anywhere with this. You would likely be better off taking a look at the free Google Docs You should be able to do all this in one of their spreadsheets.
January 3, 201412 yr Hi all, This paragraph is only background and can be skipped I'm a volunteer at a youth movement in Belgium and I would like to tackle a problem we've encountered with our inventory list. Our organization goes on vacations and for every vacation we need to pack material from a warehouse. Currently we have an Excel list of all items available. We fill in this list (often via Dropbox), print it (which is a waste of paper, since most fields are empty) and take it with us when we go pack. The problem is however that this list contains many items, which are often also vaguely named. We would like to add pictures and descriptions, categories etc. I'm fairly new to website building, but I am prepared to do some studying and have a few months time (only on some evening though ), I'm here asking where to start my search and I do realize that all I'm asking is very idealistic The goal: - a static database (with static I mean that the users don't need to add content, they should just be able to fill in one field: the Amount of items they would like) - the ability for an admin to fill in a form with Name, Description, some Info fields, and a picture (ideally drag and drop) at any time to add an item to the database - an export function that selects all items for which the Amount field was filled in and prints them to a single page. - the ability to log in to different copies of this list (one for each vacation) All ideas are welcome! I'm looking for software, programming languages etc. Thanks in advance! Robbe You could probably manage to do most of that using MS Access. It shouldn't take more than a couple of days.I'd advise you to spend a couple of hours reading up on databases, and the rules of normalisation. Access wizards will pretty much hold your hand and do the entire thing for you.
Create an account or sign in to comment