Completed

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

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.

Skills: eBay, MySQL, PHP, Software Architecture, XML

See more: magento order data export excel, download amazon order data excel, dashboard designer performance point data source, internal work order data, view post form data plugin, calendar order data rss feed, import order data quickbook, team planning view google calendar data api, example restaurant order data entry system, view edit mysql data script, view real time data php ajax mysql, magento custom order data, view offline website data, view completed tournament data full tilt, oscommerce order subject shop

About the Employer:
( 1 review ) Rivalta, Italy

Project ID: #16453360

Awarded to:

TenStar718

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: W More

€555 EUR in 10 days
(214 Reviews)
8.5

33 freelancers are bidding on average €559 for this job

webbookstudio

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. More

€618 EUR in 20 days
(158 Reviews)
8.2
monitrix

Hello, I have developed dashboard in website and you need a dashboard page on your website visualize table's data, query data and elaborate/create data. I can build a nice & professional dashboard for your websit More

€555 EUR in 10 days
(359 Reviews)
8.6
gopalvora

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 l More

€722 EUR in 20 days
(492 Reviews)
8.3
pointlogic

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, m More

€500 EUR in 10 days
(285 Reviews)
8.1
tarekahmed

[[ Dealing with you is our goal ]] [login to view URL] This link is a system for Multi Vendor That link is showing what I have Our previous projects are:- [ Stock Management System ] - More

€555 EUR in 10 days
(135 Reviews)
7.6
posspooja

Hello I am an Web Developer with more than 7 years of experience and shall get this done in about 14 days' time. Let me know if you have any doubts / queries about my expertise, will be more than happy to addre More

€789 EUR in 14 days
(146 Reviews)
7.7
€555 EUR in 10 days
(26 Reviews)
7.1
€555 EUR in 10 days
(94 Reviews)
6.6
seemasit

Hi,I had 5-year experience with Python, Laravel, Angular js, Node.Js, and Java so its easy and simple task for me. Please send me project complete requirement to start working on [login to view URL] take a look at our some work: More

€500 EUR in 10 days
(57 Reviews)
6.6
SevenStarInfo

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 val More

€400 EUR in 6 days
(58 Reviews)
6.9
enok7128

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
(79 Reviews)
6.5
gold2star

hi,dear. We understand your requirements and I am very interested in this job - 'Dashboard to view and enrich the order data of my shop.'. We are senior software developers and I am able to perform this task with my de More

€555 EUR in 5 days
(9 Reviews)
5.3
technoweb7

A proposal has not yet been provided

€617 EUR in 10 days
(12 Reviews)
5.3
nixtech

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 Ashw More

€388 EUR in 3 days
(34 Reviews)
4.9
farhan1991

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
(36 Reviews)
4.8
edison4mobile

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 a More

€555 EUR in 3 days
(16 Reviews)
5.1
Webbleu

Hello Dear Client, We have gone through your requirement and would to take this opportunity to work on this project. Can you send a detailed requirement about your project. About us We have been providing Web Desi More

€555 EUR in 10 days
(28 Reviews)
4.6
freelancerkpis

Hello, We are happy to bid on this project. ***** We are having a great team of Mobile developers with 7-8 years of experience in their field, We work with fully enthusiasm. Because programming is our Passion. More

€694 EUR in 10 days
(4 Reviews)
4.0
Geniusteam

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. W More

€555 EUR in 20 days
(3 Reviews)
4.1
catbig

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
(9 Reviews)
4.1