Skip to content
View in the app

A better way to browse. Learn more.

Web Designer Forum

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

Inventory Database

Featured Replies

Hi all,


This paragraph is only background and can be skipped :santa_smiley:

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 :santa_tongue: ),

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

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.

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

  • 2 weeks later...

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.

 

Hi all,
This paragraph is only background and can be skipped :santa_smiley:
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 :santa_tongue: ),
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

Account

Navigation

Search

Search

Configure browser push notifications

Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.