Description of excel work: We require someone to carry out the following daily tasks:
- download orders into csv file
- clean up and format the csv file so that it is ready to send to warehouse/logistics partners
- send orders in csv file to warehouse/logistics partners
- once tracking codes have been created for orders these tracking codes need to be matched with the orders through vlookup functionality
- the tracking codes then need to be sent to customers by either uploading through our website or through partner websites
This is a daily task and should take no longer than an hour total each day
George H.100% (8)
Login to your account and send a proposal now to get this project.Log in
Clarification Board Ask a Question
Hi George. Having an outsourced person to do this who is not local to your company is fraught with potential issues. Firstly I'd suggest a method of automating at least the first part, if not possibly all. That depends on the system/backend you're using. If not, hire someone local. Happy to discuss automation.Thanks.
Would this task need to be completed at a certain time each day or is it flexible?
do you want to develop a custom script with which you can atomize the above process for you?
Can this be handled from offshore - India?
Good Morning George,
How many daily sales do you currently have? What is the anticipated growth of the business?
According to your wording this sounds like a process that is completed once a day at a set time, would that be correct?
If the work is carried out at £15.00 / hour and you have a 5 day working week that's an annual expense of £3900. Would you consider an automated process with minimal input from existing staff as a preferred solution?