Cancelled

Stock Control Database

To Create an on-line stock control database using a web front end and created in PHP with Mysql The applications should be ‘on-line’ with secure (username/password) logins. They should all support multiple simultaneous access. The company consists of 10 retail outlets It should be assumed that this will be subject to change with possible expansion.

Users The users can be split into three categories:

• Developers

• Administrators

• Shop Managers

• Shop Users

2.2 Administrators

They can run all applications and edit all fields

2.32.4 Shop Users

. They can run certain applications only (e.g. Stock Control) and edit fields in a limited fashion

2.42.5 User Database

Table 1: Approx 25 records ( two per shop) and one per administrator/developer.

Username

Password

Access Level

Shop

Email

Tel Num

Fax Num

Table 2: Approx 10 records (one per shop)

Shop Name (text 25 chars, unique)

Shop Code (text 3 chars, unique)

Shop Manager Name

Shop Email

Address 1

Address 2

Address 3

Postcode

Tel Num

Fax Num

It is important to realise that access to the databases by ‘Shop Users’ should be default only show records specific to that shop, whereas access by ‘Administrators’ and ‘Developers’ will need to provide selection of the ‘shop’.

3 Stock Control

3.1 Introduction

This application is to provide a central stock database across the business (all shops). It should provide the features necessary for easy working from the shops to maintain their stock records and make inspections of stock at other shops.

3.2 Database Definition

Stock Table: Approx 5000 records

Fields:

Item Code (unique 8 digit number, incrementing automatically for new records)

Description (text 35 chars, unique)

Brand (lookup from Brand table presented alphabetically)

Supplier Code

Cost

Price

Special Offer Price

No Vat Applicable

Category

Carriage

Status

Status Date

Note: All fields above are ‘required’ except ‘Supplier Code’.

Stock Variant Table:

Fields:

Item Code

Identifier1

Identifier2

Variant Description

Discount Price

‘Variant Description’ is for example S, M, L, XL and red, yellow, green or red/green, yellow/blue etc.

‘Discount Price’

A record is created in this table whenever a new item is created in the Stock table.

Shop Stock Table:-Specific

Fields:

Shop Name

Item Code

Variant Identifier1

Variant Identifier2

Variant Description

In Stock

Minimum Stock

To Order

Ordered

Allocated

Supplier Table: Approx 50 records.

Fields:

Supplier

Category Table: Approx 20 records

Fields:

Category

Carriage Table: Approx 10 records.

Fields:

Carriage Code

Description

Status Table: Approx 4 records.

Fields:

Status

3.3 Rendering

All results should be displayed in a ‘table’ format with up to 100 records showing.

The application must be able to hand ‘null’ entries in the database.

All currency fields to be shown in £0.00 format (unless null).

Text fields should be displayed ‘not-wrapped’, except description field that can be ‘wrapped’

3.4 Applications

3.4.1 All Applications

Given the number of records, then all applications must provide the following facilities:

• Search for given number in ‘Item Code’.

• Search for given string in ‘Description’.

• Search for given string in ‘Supplier Code’

• Match all records with a non-null ‘Special Offer Price’

They also must provide the criteria to show a set of records based on a user-selection of:

• ‘Supplier’

• ‘Brand’

• ‘Category’

• ‘Status’

These may be used as together or singly.

Records should be displayed in ascending order defined from fields:

• Supplier

• Brand

• Category

• Description

3.4.2 Maintaining Stock Levels

3.4.3 Inter-Company Invoice

Each shop will be able to raise an ‘Inter-Company’ Invoice report based on records from the database

3.4.4 Stock Across Shops

All levels of user will be able to login and view the stock levels across the shops.

3.4.5 Stock Allocation

An administrator will be able to login and view the stock levels across the shops (similar to above) and be able to set the ‘Allocated’ fields of each shop.

3.4.6 Database Administration

3.4.6.1 Record Creation & Update

Administrators will be able to login and create new records for the all the tables

3.4.6.2 Item Status Control

3.4.7 Database Remedial Work

Administrators will also be able to edit the fields of each shop

3.5 Data Export

The stock database is used on the web sites for each shop for price & description delivery for web pages and e-commerce.

4 Cheque Register

4.1 Introduction

This application is a simple ‘ticket ‘issuing and usage’’ register

4.2 Database Definition

Stock Table: Approx 6000 records

4.3 Rendering

The display should show the last 15 entries

4.4 Applications

4.4.1 All Applications

Given the number of records,

4.4.2 Cheques Used

4.4.3 Cheques Issued

4.4.4 Database Administration

Administrators will be able to login and view old records

5 Purchase Ledger

5.1 Introduction

This application is a monthly summary of purchases for each shop

5.2 Database Definition

Stock Table: Approx 120,000 records

5.3 Vat Rate

The Tax rate is selected for each record

5.35.4 Rendering

The display should show the entire month’s records

5.4.15.5.1 All Applications

All applications must provide the following facilities:

FULL DETAILS WILL BE GIVEN AT AWARD OF PROJECT

Skills: Accounting, Microsoft Access, PHP, Software Architecture, System Admin

See more: access stock control database, create stock control database, stock control database, fashion stock control database, create database update stock control, access stock control database example, administrator stock database php, create database stock control, stock control database php, create php stock control web application, stock control project access, database stock control php, php create stock control database, php stock control database example, working at the limited, web developer supplier, web developer split, web developer price table, web developer on line, web developer introduction, web developer e commerce database, up string, tax manager, summary of web developer, summary of a web developer

About the Employer:
( 0 reviews ) Liverpool, United Kingdom

Project ID: #582083

23 freelancers are bidding on average $987 for this job

dewmagic

Dear Sir, we are making same online software for a india show company for their godown and shops including with online belling & financial report also. We are ready to take this opportunity. Please check our PM for More

$1000 USD in 21 days
(85 Reviews)
6.8
stefanache

Hi, WAMP flexible solution: -front-end: AFL/JFL(or Ajax,Javascript: see [url removed, login to view] samples)+Java -backend : PHP(or Codeigniter)+ MYSQL(or VisualFoxPro,MS-Access,MS-Excel,XML/CSV...) Recent project finished (for a More

$1500 USD in 45 days
(15 Reviews)
4.8
DBguy

Good Evening. Please check your PMB. Thank you for the consideration. Best Regards.

$750 USD in 14 days
(15 Reviews)
4.4
russel02cuet

Hello I read you application details. It is a large and good project. The bid price is not mandatory. I have a developing team. I will also provide support for future development.

$750 USD in 15 days
(55 Reviews)
4.5
nickProfessional

Please see private message. Nick

$1200 USD in 15 days
(5 Reviews)
3.6
fathlabstudio

Hello! Let me help you on this project. Ready to start immediately. Thank you.

$750 USD in 14 days
(10 Reviews)
3.5
BSoftTech

I can provide the stock database online with the options noted. I've good experience in PHP/MySQL development and online ecommerce solutions. Thanks, John

$1200 USD in 45 days
(1 Review)
2.7
axeacc

Hi, Please check PM for details. Thanks

$750 USD in 30 days
(4 Reviews)
2.6
webs4less

I would be happy to help you with your project, I can begin immediately and located in the US on the East Coast.

$750 USD in 10 days
(2 Reviews)
3.0
fishstewardLLC

Have experience with accounting systems implementation, have worked in financial industry. English is my first language.

$900 USD in 20 days
(0 Reviews)
0.0
rohit555

Hi.. i can do that what you are looking for. i have a good experience of web application development using the same technologies and have handled the data(i.e. stocks for your interest) very carefully and effectively. More

$1080 USD in 27 days
(0 Reviews)
0.0
ScottCaldwell

Please see my private message.

$1000 USD in 30 days
(3 Reviews)
0.0
thedzibans

We are a ten member team who have professionally mastered the skills of Web Design and Development. We provide excellent quality service within our clients’ budget to their utmost satisfaction. We offer an outstandi More

$750 USD in 25 days
(0 Reviews)
0.0
nadunalexander

I am selling same kind of systems for upermarkets. Sop I can fully understand ur problem and do it exactly what u want.

$1500 USD in 60 days
(0 Reviews)
0.0
SkySoftware

Hi i am experienced developer. Can complete your project in minimum cost with proper Qualiy Assured standards. Thanks Aakash

$750 USD in 20 days
(0 Reviews)
0.0
davcom

I'm the I.T Director of a U.K based web company, currently in Mauritius. I can do this in under 1 month. I could develop this in FLEX instead, which I think would be more appropriate than plain HTML / PHP...

$1500 USD in 30 days
(0 Reviews)
0.0
datchley

I am a Senior Software Engineer with 15 years experience designing Intranet and web applications for large and small businesses. I have expertise not only web application design and development but also in backend proc More

$1500 USD in 30 days
(0 Reviews)
0.0
dvnsoft

Dear Sir, We can do your project. thanks!

$750 USD in 15 days
(0 Reviews)
0.0
Pechworksv

Hi, I am experienced profesional in PHP/MYSQL and I can complete your requirement on an immediate [url removed, login to view]

$750 USD in 15 days
(0 Reviews)
0.0
SoftSolution1

Hello Greetings from Software Solutions We are a team of professionals and are specialised in Inventory related softwares for garments exporters, automobile dealers, restaurants, retail shops etc. Our experties i More

$1000 USD in 15 days
(0 Reviews)
0.0