
Automated development of a shipping cost and time database
- or -
Post a project like this£60(approx. $81)
- Posted:
- Proposals: 3
- Remote
- #2992199
- Expired
Description
Experience Level: Entry
I am seeking the development of a simple, update-able database development programme (/scraping tool), capable of inputting parameters into a web-based quoting tool, and scraping the auto-generated output. This will require:
Automating the population and submission of a simple input form based on c. 5,700 parameter combinations, and
Scraping the output data from the subsequent responses and storing them in a spreadsheet.
The data being collected is the shipping costs and shipping times from China (Guangdong) to the many Global Amazon Fulfilment Centres. The task will require:
Development of a raw dataset including:
a) the location (postcode/zip-code) of all major Amazon Fulfilment Centres Globally (I believe there are c. 175 in total, however i am happy to go with just one per state in the US and Canada, and one per country beyond that)
b) the average shipping cost and shipping times from Guangdong district in China to all of these identified fulfilment centres, based on
ranges for: dimensions, weight and units (inputs defined below), and
Transport via Mail, Express, Air and Sea (LCL and PCL) basis. (i.e. see description set out at this link: https://www.freightos.com/shipping-routes/shipping-from-china-to-the-united-states/ )
PLEASE INCLUDE YOUR SOURCES (i.e. the name of the carrier company quoting). I recommend generating these figures based on example quotes generated from the free aggregator: ‘Freightos.com’ https://ship.freightos.com/?utm_source=pardot&utm_medium=email&utm_campaign=202006-onboarding&utm_content=email-1a) -
The inputs should cover all combinations of the 3 variables set out in the attachment ( there are 19 x #units, 16 x different dimensions, and 19 x different weights x c.100-125 amazon fulfilment centre locations = c.60,000-80,000 combinations). Please see attachment for input metrics.
I hope this makes sense - many thanks for your interest.
Best,
Tom
Automating the population and submission of a simple input form based on c. 5,700 parameter combinations, and
Scraping the output data from the subsequent responses and storing them in a spreadsheet.
The data being collected is the shipping costs and shipping times from China (Guangdong) to the many Global Amazon Fulfilment Centres. The task will require:
Development of a raw dataset including:
a) the location (postcode/zip-code) of all major Amazon Fulfilment Centres Globally (I believe there are c. 175 in total, however i am happy to go with just one per state in the US and Canada, and one per country beyond that)
b) the average shipping cost and shipping times from Guangdong district in China to all of these identified fulfilment centres, based on
ranges for: dimensions, weight and units (inputs defined below), and
Transport via Mail, Express, Air and Sea (LCL and PCL) basis. (i.e. see description set out at this link: https://www.freightos.com/shipping-routes/shipping-from-china-to-the-united-states/ )
PLEASE INCLUDE YOUR SOURCES (i.e. the name of the carrier company quoting). I recommend generating these figures based on example quotes generated from the free aggregator: ‘Freightos.com’ https://ship.freightos.com/?utm_source=pardot&utm_medium=email&utm_campaign=202006-onboarding&utm_content=email-1a) -
The inputs should cover all combinations of the 3 variables set out in the attachment ( there are 19 x #units, 16 x different dimensions, and 19 x different weights x c.100-125 amazon fulfilment centre locations = c.60,000-80,000 combinations). Please see attachment for input metrics.
I hope this makes sense - many thanks for your interest.
Best,
Tom
Tom H.
100% (103)Projects Completed
77
Freelancers worked with
76
Projects awarded
74%
Last project
7 Oct 2024
Canada
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies