Vending Management Software

Create a web-based vending management software to track inventory of products, assets, organize route and map it for speed and for deciding what product will do best at each location.

Based on mySQL database with stock/sales and machine info data imported from DEX files. Include mapping, reporting, graphs of selected data, scheduling of service, product stock management, etc...

DEX Files are generated by vending machines and updated on cloud server (USA Technologies) about every 2 hours and the system needs to connect to them, pull DEX files as a report transport via HTTP POST, and update the database fields accordingly, so the reports and machine status is always up-to-date.
Normally, DEX files are sent to cloud via Cell Network, but in case that signal is not available, we need a way (windows or android app) to manually retrieve DEX data from the machine via DEX->RS232->USB interface and then be able to upload it to our database over the internet.

Reports should be sortable by each field (ascending descending by clicking the header) and include, but not be limited to the following:

• Current status overview of all machines (With Location
• Products List -> Products Details with picture
• Machine List ->Machine Info->Machine can be updated by DEX or Manual Data Entry
• Users List -> User details
• Customers List -> Customer Info
• Locations List -> Location info (With google map)
• Routes List -> Route info
• Planogram List -> Planogram Details -> Graphical planogram with product pictures, price & QTY
• Planogram optimization (recommending expansion of fast selling products and reduction of slow ones based on historical data from route/location/machine)
• Schedules List -> schedules details by route, map, date, etc...
• Cash Reports by Machine (with Machine Name, Serial Number, Sales, Cash Dispensed, Cash to Tubes, Cash to Box, Bills In, Updated at)
• Machine Overview Detail (from DEX file) including:
o Sales Since Serviced (VA101)
o Cash In Since Serviced (CA305)
o Cash To Box Since Serviced (CA306)
o Cash To Tubes Since Serviced (CA307)
o Bills In Since Serviced (CA308)
o Cash Out Since Serviced (CA403)
o Manual Cash Out Since Serviced (CA404)
o Cash Added Since Serviced (CA1002)
o Lifetime sales (VA101)
o Sales since last reset (VA103)
o Lifetime Cash In (CA305)
o Lifetime Cash To Box (CA306)
o Lifetime Cash To Tubes (CA307)
o Lifetime Bills In (CA308)
o Lifetime Cash Out (CA403)
o Lifetime Manual Cash Out (CA404)
o Lifetime Cash Added (CA1002)
o Value of Tubes (CA1501)
• Sales Reports by Machine
• Service Reports by Machine
• Alerts (based on preset event conditions or reported by machines via MDB/DEX)
• STATS: (daily/weekly/monthly/annual/year-to-date/custom period)
• Product Inventory /Status - in machines and on-hand/ in warehouse
• Top performing machines/locations/products
• Commission tracking (different forms like: flat fee, percentage of: sales, gross profit or net profit)
• Expenses tracking per machine/location/route level (ie. machine lease, service, parts, fees, etc.)
• Total Sales / Gross/Net income (daily/weekly/monthly/annual/year-to-date/custom period)

Skills: HTML, MySQL, PHP, Website Design

See more: vending machine sales database, marketing research project software management, alumni software management universities pakistan, php mysql software management school, hospital software management ukraine price, drupal easy website build, alibaba website build, software mobile cell info, handicapping website build service design, software management php, joomla commerce website build, full website build, orient software management services faisalabad pakistan, web based university management software, copy exitsing website build site, drag drop website build bracelet, poker software management, teacher rating website build, bid website build, common questions freelance website build, handle projects web based project management software sms, website build bid, serendib software management solutions sri lanka, poker website build, software management car parking

About the Employer:
( 0 reviews ) Saskatoon, Canada

Project ID: #11304342

17 freelancers are bidding on average $178 for this job


Hello there, Hope you are doing great..!! Going through your project description we understand that you are looking for an experienced team of professional developers and designers to work on your assignment. We More

$250 CAD in 3 days
(94 Reviews)

Hello, Your project will be completed on time and with in your budget. We have working experience on similar projects throughout our 5 years. We have an expertize team of Web development, Apps Development and Inter More

$147 CAD in 3 days
(92 Reviews)

Hi, This is Sherly We could build a website. Payment could be released after you are completely satisfied with our output. our recent online store wordpress site in woocommerce. [url removed, login to view] https:// More

$266 CAD in 10 days
(87 Reviews)

hello, we have gone through your initial description of the project and ready to start [url removed, login to view] are new over here but not in this field of work. lets discuss the project further and start as we are qualified in the req More

$111 CAD in 5 days
(63 Reviews)

Hi greetings of the day I am a Experienced PHP Developer based out in Chennai,India. My experience revolves around development of web and mobile applications,Ecommerce websites. I believe that I am well qualified More

$120 CAD in 3 days
(41 Reviews)

Sir, We already have FULL PROFESSIONAL VENDING MANAGEMENT SYSTEM coded in PHP/MYSQL. DEMO 1: [url removed, login to view] Username/password: owner [at] [url removed, login to view] / admin More

$120 CAD in 1 day
(16 Reviews)

Hi, I love WORDPRESS and I have a large portfolio of sites built specifically on this platform. Below you can see a portfolio of my recent wordpress projects:- [url removed, login to view] [url removed, login to view] More

$500 CAD in 20 days
(14 Reviews)

Hello Sir, I have been in this industry for 5 years and such jobs are my daily practice. This is my first time on this site and hence you can see that I do not have any ratings/testimonials to show you. My name is Shua More

$155 CAD in 3 days
(11 Reviews)

Hello, I am very interested in your project. Please come on chat for detail discussion so that I can start your project asap. I am 5 years experienced PHP,HTML5/CSS3,MYSQL,WordPress,Bigcommerce, node js , andr More

$155 CAD in 3 days
(10 Reviews)

I have 7+ years experience in IT sector,i expertise in Bigcommerce , Wordpress, vBulletin ,OsCommerce, OpenCart , Prestashop, Shopify ,CodeIgniter, photoshop, html, css,SEO-SMO Expert ,illustrator, javascript, respon More

$30 CAD in 2 days
(10 Reviews)

Hi, I am professional in this task.I would like to assist you in your projects. Get it done professionally get it done right the 1st time. I am here to make long term relationship. I would like to get all details from More

$155 CAD in 3 days
(1 Review)

Hello Dear Hiring Manager, How are you doing, hope to be well. I am a software professional for the past 10 years, I am well versed on technologies like Java, PHP, HTML5, jquery, bootstrap, wordpress. Looking More

$250 CAD in 10 days
(0 Reviews)
$155 CAD in 3 days
(0 Reviews)

Hello, “A good beginning is half the battle.” We expertise in creating the best and easiest environment where your customers get well connected with you; be it website, application or design, our services are si More

$155 CAD in 3 days
(0 Reviews)

A proposal has not yet been provided

$155 CAD in 3 days
(0 Reviews)

i am a lead software engineer and responsible for creating web and desktop applications using different languages and technologies if u r interested just send me a message thank you and good luck

$155 CAD in 3 days
(0 Reviews)

sir We are willing to do your job as per the description provided by you. We have a good team that can complete your job.

$155 CAD in 3 days
(0 Reviews)