Advertising Inventory Booking online

Budget
Posted: 5 years ago
Opened
Description
I need to develop an online advertising inventory booking system for advertising spaces.

The system will allow the admin to create available locations with the available ad spaces to be rented by potential customers. The system needs to track the available inventory and give the admin the ability to see by location, by advertising spaces what is booked, what is available and what is being requested.

The cloud based system must have a modern look and have visual reports.

Break down of data tables:

Admin: access to the system
First Name
Last Name
Position
Email
Username
Password
Mobile Number
Mobile Number 2
Level of Securiy / Permissions:
• Admin – Total Access
• Admin assistant - ??
• Sales Team – access to each store availability, client and booking calender
• Graphic Artist – Access to bookings that are confirmed and have the ability activate artwork is ready??
• Printer – access to bookings that are confirmed and artwork that is activated to be printed ??
• Installer – access to bookings that are confirmed, artwork that is activated and confirmation of printer finished ??


Type of Business:
Name of Business Type
Description

Vendor / Client Company Table:
Name of Company
Type of Business (Select from Type of Business Table dropdown list)
Address Street 1
Address Street 2
City
State
Zipx Code
Country
Business Phone Number
Company Email Address
Note

Vendor / Client Company Person Table:
Name of Company (Select from Vendor / Client Company Table dropdown list)
Select Type (Radio option either Vendor or Client)
First Name
Last Name
Position
Email 1
Email 2
Username
Password
Mobile Number
Mobile Number 2
Note

Type of Brand:
Name of Type of Brand
Description

Brand:
Name Brand
Type of Brand (Select from Type of Brand Table dropdown list)
Description


Client Company / Client Person / Brand Table :
Name of Brand (Select from Name of Brand Table dropdown list)
Select Client Person (Select from Vendor / Client Company Table dropdown list)
Relation to Brand
Description

Conversation Table:
Name of Brand (Select from Client Company / Client Person / Brand Table dropdown list)
Type of Communication
Date
Notes
Reminder date


Type of Advertising:
Name of Advertising
Description

Type of Space:
Name of Space
Description



Advertising Space:
Name of Space
Name of Company (Select from Vendor Company Table dropdown list)
Type of Space (Select from Type of Space dropdown list)
Type of Advertising (Checkbox from the Type of Advertising Table)
Cost
NOTE: Rule – we need to have a rule for each advertising space with the type of advertising. For example one of the Advertising Types is called iCart which can either have the option to sell it in 25% percentiles or sell it in 10% percentiles. So if we have iCart at Location A (25% percentiles) then we can either have a maximum of 4 different clients or 1 client taking all 4 options. So we need to have a way to not over book based on the limitation on the amount of advertising space availability.




Seasons:
Name of Season
Start Date
End Date
Activate

Bookings:
Advertising Space (Select from Advertising Space Table dropdown list)
Client Company (Select from Vendor / Client Company Table dropdown list)
Season (Select from Season Table dropdown list)
Status – Enquiry, Confirmed, Canceled
Payment Status – Paid and Owing
NOTE – Payment system is freshbooks not sure if we can link the two systems to connect official estimates / invoices




The vendor will be able to log into the system and see all their spaces and review which clients are advertising at their spaces and which seasons

The client will be able to log into the system and see all the spaces they have booked and show the status

Once booking is completed Admin / Admin Assistant will assign booking to Graphic Artist, Printer and Installer

The graphic artist will be able to log into the system and see all advertising bookings assigned to them to prepare artwork and once artwork is develop have the ability to log back into the system to update artwork assignment with cloud based storage links for artwork files for printing company to have. Once graphic artist has update bookings Admin will be notified and Printer will also be notified via email.


The printer will be able to log into the system and see all advertising bookings assigned to them to prepare print artwork developed by graphic artist. Once printing is completed the printing company will log back into the system to update booking which will then trigger emails and notifications to Admin and installer

Once installer is completed the installer will upload images / videos of completed work and update booking status. Notifications will be sent to Admin. Once Admin is okay with images and videos the admin will then approve final work and an email with final images / videos will be sent to the Client informing them the job is completed with the images and videos in the email the client can also log into the system to review the installation images / videos.


Admin / Admin Assistant / Sales Team need to have the ability to review Advertising Spaces to see what is booked by client, by space, by season. What is available etc. multiple reports on locations, clients, vendors and advertising spaces. This will allow for an easier understanding of advertising inventory.


Please make suggestions on design plan to get the best possible outcome of success.
Skills:
CMS (Content Management System),Cloud Based,Inventory Management,Web Development & Design
Category
Source: guru.com

Add a bid

days

Similar freelance jobs

safe 
...
8 months ago
safe$7
Hi Robert P. , I noticed your profile and would like to offer you my project. We can discuss any details over chat....
safe 
"Hello, I need to create a website based on a . psd design file. Please also specify the timeframe within which you can complete this. Technical requirements: Layout (not pixel-perfect, but close to it) Responsiveness (the website should properly adapt to different screen sizes and devices) Clean code......
safe 
Project Title: Delphi Code Feature Creation Using delphi: Check to see if this already exsits, if not: create a shedulled task to start my program on PC startup with highest permissions, with no password or prompt. program is called for example: C:\Program Files (x86)\Myfolder\myprogram. exe If it already......
safe 
I want to create a program for customers and sellers to be able to use, to create a template for there artwork and be able to size them to there specific needs. And be able to download them as pdf or png files. This program will benefit the clothing industry with the industry i am in....
safe 
Hi, I am not quite sure if what I am asking is possible but within my University degree there is a calculator program which only works on the HP Prime prime calculator, I own a Casio fx-CG50 AU. I was hoping to have this program converted into a format which is compatible with my Casio calculator, all......
1 year ago
safe 
I am looking for a skilled C++ developer to help with a real-time object detection system for my project....
1 year ago
safe 
Project Title: Correct Rcpp armadillo code Overview: I am seeking a skilled developer to fix a compilation error in my Rcpp armadillo code. The code is currently throwing a compilation error, and I need it to be resolved promptly. Requirements: - Proficient in Rcpp and armadillo library - Strong understanding......
1 year ago
safe 
Project Description: - I am looking for a freelancer who can combine all the columns of 2 rows with similar values in Telerik Reporting. - The combined data needs to be displayed in a table view. - Ideal skills and experience for this job include: - Proficiency in Telerik Reporting. - Strong understanding......
1 year ago
safe$250
Bonjour Dmytro M. , j'ai remarqué votre profil et je souhaite vous proposer mon projet. Nous pouvons discuter des détails via le chat....
safe 
Hello, I am looking to develop a unity soccer game with moves like score hero 1. Map with 1-3 stars achievments 2. engine to make the goals like i want 3. smooth game play 4. IAP , shop , buy lives 5. lives to play 6. finger smoothness touch 7. the level will be added automticlly to the map 8. rewind......
1 year ago
safe 
Project Title: Bootloader For Renesas RL78 mcu Description: I am looking for a skilled developer to create a bootloader for the Renesas RL78 mcu. The ideal candidate should have experience with Renesas RL78 mcu and be familiar with the development environment. bootloader code is ready need help for run......
safe 
I am using EMA´s (50/75/100/200),two Stoch (5/5/5 and 5/3/3), RDX Indicator and the Indicator "The Arty". For Short Positions the Prive has to be under the 200 EMA (the 100EMA under 200, 75 under 100, 50 under 75, NOT crossing) and for Long Positions over the 200 EMA ( 100 over 200, 75 over 100, 50 over......
1 year ago
safe 
My project involves using an Emotional Stroop Task to measure and assess attentional bias towards emotional stimuli. To do this, I will be using the Drift Diffusion Model which is an analytical model to study the human decision making process. My study will need to include 90 participants in order to......
safe 
I am looking for a WPF Developer for a long term project....
1 year ago
safe 
I'd like to extract tables from pdf invoices files. At this stage i really only want the products that are in the tables on the invoices. The only information i would like from the invoices is supplier date (received) location received. Within thetables i require stock code, product item, the unit measurement......
1 year ago
safe 
Im creating a config using 'openbullet 1. 4', everything added successfully, due i have 3 years of using openbullet, but this request i never faced it before!...
1 year ago
safe 
This position is responsible for verifying data quality reports and queries, correcting errors and also tracking them....
2 year ago
safe 
We are currently looking for developer to contact us on developing integration/plugin for below listed platform. Please drop me message on which plugin you're able to develop. Please send similar plugin portfolio of your previous work. The plugin need to ready for uploading to marketplace . ActiveCampaign.......
3 year ago
View all