Find Jobs
Hire Freelancers

Dashboard to view and enrich the order data of my shop.

€250-750 EUR

Completed
Posted about 6 years ago

€250-750 EUR

Paid on delivery
Hi my name is Asdar from Italy, I'm a dropshipper seller (like dropshipping, not exactly dropshipping), so my customers order by me from ebay, amazon, website etc... and I (when the number of orders are enough) order that products from my supplier. My supplier ship the products to me, and I ship it at my customers. Thats the story... I have two tables in mysql, one with orders and customer datails and one with products ordered by customers. You can find an exportated version of these tables attached as *.xlsx This tables are generated automatically from a xml constantly updated with the last 30 days of purchased product from the various platform. I need a dashboard page on my website (not accessible from others) to visualize table's data, query data and elaborate/create data. Attached the pages that dashboard should have. About page1: This page take data from wp_ftp_orders_log and wp_ftp_items_log and show it. To make orders selectable and ready to create csv file of the order ready for my supplier simply pushing the relative button. Obviously, products bought from my customers who have already been ordered to my supplier need not to be ordered again the next time I push that button, aready elaborated rows should not be displayed here. Other comments handwritten on the image file. About page2: here there are the previous supplier orders, one for each row. There are 4 columns that you should generate: OrderNumber, AssignedOrderNumber, SupplierOrderTime, TotalWeight Other comments handwritten on the image file. About page3: here there are all the customer orders. There are 2 columns that require to be created on mysql wp_ftp_orders_log table: EstimatedDeliveryTime and PersonalNotes. EstimatedDeliveryTime is calculated starting from the input data in the page5 (settings). there are 4 different possibilities: MagSpedEco, MagSpedNorm, DropSpedEco, DropSpedNorm IF CostDescription is empty AND Carrier(in settings) = Carrier(in this page) THEN method ELSE IF CostDescription is empty AND Carrier(in settings) = Carrier(in this page) THEN method ELSE IF CostDescription is not empty AND Carrier(in settings) = Carrier(in this page) THEN method ELSE IF CostDescription is not empty AND Carrier(in settings) = Carrier(in this page) THEN method Once the method has been determinated should be applied the value on the section "shipping timing parameters" where I can input the number of business day for each method. First column is OrderPreparationTime, second column is ShippingTime. OrderPreparationTime + ShippingTime = number of business days used to calc EstimatedDeliveryTime. Date + number of business days = EstimatedDeliveryTime Other comments handwritten on the image file. About page4: here I can search Code of the product to get related data and add Tracking and Shipped. I would also the possibility to create a csv with the last days of shipped product based on Shipped value. csv like: Number,Tracking,Shipped Results in this page should be displayed by EstimatedDeliveryTime ordering. Other comments handwritten on the image file. About page5: In this page I can set any value. Other comments handwritten on the image file. The dashboard is for me only so it is not important how it looks but its functionality. The code should be properly commented. The worker must know how to do everything. Several mileston will divide the job. All data must be stored in MySQL tables and safe from malicious.
Project ID: 16453360

About the project

30 proposals
Remote project
Active 6 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
Hello, and thanks for the opportunity to bid on your project. https://www.freelancer.com/u/TenStar718.html I am an expert in many different area’s of web and mobile applications based on the following languages: Web(PHP, MySql, HTML5, Java) and Mobile (Native and Hybrid). I am also an expert in many different frameworks such as CodeIgniter, Laravel, Spring and jQuery. I have over 5 years industry experience in development and graduated with a Masters Degree in IT from the Hong Kong University. My PHP L1 exam score in Freelancer places me in the top 3% of developers. Please have confidence in my skill and quality of work. I assure, I will do my best to work with you on your project to present the best possible outcome for you and your customers. I will also do my best to correct any area of work where quality comes into question, I want to have pride in my service to your company and the final product provided. While I am happy to make adjustments and alterations as your project progresses please understand that I am a dedicated freelancer and any work that is substantially different from the project description may need the awarded fee to be re-negotiated. Feel free to contact me if you have any questions, and please review my 5 star profile. I look forward to working together in partnership on your project and into the future. Regards
€555 EUR in 10 days
5.0 (260 reviews)
8.9
8.9
30 freelancers are bidding on average €553 EUR for this job
User Avatar
Hello, my name’s Victoria. I represent the Ukrainian IT-company "Webbook". Have free devs on CMS Wordpress, Sql/MySql databases, PHP, XML for Your dashboard to start now. You can check our portfolio (https://www.freelancer.com/u/webbookstudio). Waiting for Your reply!
€618 EUR in 20 days
5.0 (352 reviews)
8.8
8.8
User Avatar
Hi I have gone through the details of your project and we find it well within our capabilities. I offer a wide range of services, including Web design, PHP/MySQL web application development, Open sources like Joomla, Os-commerce,vBulletin ,Shopify, Bigcommerce, Magneto ,Zen cart-Drupal , android and IOS , I can create and deliver the project as per the information.I have skilled, expert programmers I'm very excited to assist you in making your Sites successful – please feel free to contact me directly to discuss this position further. Thanks
€722 EUR in 20 days
4.7 (537 reviews)
8.5
8.5
User Avatar
Hello, I have read the details of your project and i have done similar kind of work like dropshipping , I have an experience of more than 10 years in web development and maintenance. I have in-depth knowledge of php, mysql, javascript , jquery, payment system integrations, API's, css, html, html5, wordpress. I will look forward to discuss with you. Thank you.
€500 EUR in 10 days
4.6 (329 reviews)
8.4
8.4
User Avatar
Hi there, I have gone through project details, As per your given details I think you need to build a Dashboard for Dropshipping company order showing. can you please start chat. Thank you
€450 EUR in 15 days
4.9 (152 reviews)
7.6
7.6
User Avatar
Hi dear, I've just checked your requirements. I am very interested in that sort of thing and have a lot of experiences of the field like that. If you hire me, I will be able to finish your project earlier ahead the appointed time and in timely manner. That will be absolutely perfect. My bid always is cheaper than other, but it will be changed little by little according to your details and the worth of your project. I can be willing to satisfy you with startling result. Thanks for your reading. *Note: Don't award me your project without consulting me.
€555 EUR in 3 days
5.0 (38 reviews)
7.3
7.3
User Avatar
A proposal has not yet been provided
€617 EUR in 10 days
4.9 (26 reviews)
7.1
7.1
User Avatar
Hello Sir I can make a script to update order data to database dynamically along with pages creation like the screenshots attached to manage the website content. I am ready to start right away. Regards Ashwin
€388 EUR in 3 days
5.0 (315 reviews)
7.0
7.0
User Avatar
Hello There! Mubin here, with 7 years of expertise in web & app Design and development. I Have checked the specified details, and a close discussion is needed to clarify functionality. Revert me with your valuable response. Thanks. Mubin. R
€400 EUR in 6 days
4.7 (60 reviews)
7.2
7.2
User Avatar
Hello Sir. I have 5 years of experience in web development. This is a very easy task I am interested to work for you on this project. Just message me so that we can start waiting for your positive response :)
€444 EUR in 10 days
5.0 (50 reviews)
5.1
5.1
User Avatar
Hello, Can we discuss in detail ?Do you have any timeframe? We welcome you to join hands with us as we think we are capable enough to start this project and we give you surety of answering all your queries. We are waiting to discuss in detail about the project so that we can provide you quality oriented results. We are a team of 100+ developers doing mobile and web application development. We have more than 5 years of experience Thanks Genius Team
€555 EUR in 20 days
5.0 (3 reviews)
4.6
4.6
User Avatar
A proposal has not yet been provided
€333 EUR in 5 days
5.0 (7 reviews)
4.3
4.3
User Avatar
Hi, I can help you immediately and finish it in few days. You can chat with me and I will give you demo 1 page. You can award to me if you satisfied my demo. Thanks, https://www.freelancer.com/u/catbig
€745 EUR in 5 days
5.0 (10 reviews)
4.1
4.1
User Avatar
I have good and full experiences on mobile/web/mac/windows application development for 8 years up. I had developed many native and hybrid apps such as Social Networking, Video&Voice Chatting, Dating, GPS, Map, Photo&Video Edit/Filter, Uber/Tinder like app, Booking/Ordering app. My main skills: ★ Swift 3/4, Objective C, Cocoa(xcode) ★ Java(Android Studio) ★ React Native, Ionic Framework, Xamarin, Ruby on Rails, Cordova, Phonegap ★ Python, C/C++/C#, ASP.net ★ Firebase, AWS, CMS and Rest APIs, Facebook/Instagram/Twitter API ★ PHP, Html, JavaScript, MySQL, CSS, Nodejs, Angularjs, Laravel, MongoDB ★ Cocos2d x, Unity 3D, 3D Max ★ OpenCV, GPUImage, Image/Voice Recognize I can show my fast development skill and assure high product quality for clients. I will always do my best for my clients and their project --
€555 EUR in 10 days
4.3 (5 reviews)
4.1
4.1
User Avatar
I will get you the full access to those project Relevant Skills and Experience A years of experience is involved on this project have done something similar to this exact project with a good communication skills
€555 EUR in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A professional programmer with over 17 years of experience Expert in the field of web and software in Front-end html5, css3, javascript, jquery, angular, node js in Back-end wordpress, django, laravel, magento Provides professional service throughout the project Open for consultation and guidance Contact me if you would like quality work at a fair price
€555 EUR in 10 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of ITALY
Rivalta, Italy
5.0
15
Payment method verified
Member since Oct 15, 2017

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.