Excel Spreadsheet for Order Generation to Warehouse
$30-250 SGD
Suljettu
Julkaistu noin 3 vuotta sitten
$30-250 SGD
Maksettu toimituksen yhteydessä
Hi, I'm looking to create an order sheet in the form of an excel spreadsheet. The main page or tab is the order sheet that can be handed to a warehouse manager so that he knows how many orders there are, what are the items (SKU number of products) and the corresponding quantities, its corresponding order number, the order recipient as well as the preferred packaging type. A second tab will act as a raw data depositary which the main page will pick information from. The information will come from the sales platform (such as Amazon or other websites that i may do business on and I will export my orders on those websites to paste onto this depositary area so that the excel can "scan" through. A 3rd tab will have all the product SKUs of my shop, along with its preferred packaging type (bubble wrap, carton box etc).
In the scenario where there are multiple product SKUs in a single order, the excel must decide based on the weight or size (maybe we can enter the dimensions of the products in the product SKU section) and come back with the best packaging method, meaning, if i have a larger product that requires a carton box packaging and a smaller product that needs only a bubble wrap, then the excel will decide that the better way to pack the order will be with a carton box.
This excel spread sheet will be used to compile orders from multiple sales platforms (Alibaba, our own website etc, details will be provided to you if you pick up the project), so this excel should display in the order page that's going to the warehouse, he platform that the order belongs to, the name of the courier service (sometimes in one platform, customers can choose between 1 of 2 shipping company). so this information will be part of the data we will input into the data depositary area.
Do let me know if this is doable, i may have something similar now but it is all manual.
Hi, Greetings!
✅ I have checked and gone through the project details and I am very skilled in it.
✅Completed Time: In project deadline
We have worked on 660 + Projects. I have 6 + years of the experience in same kind of projects. If you are looking for a true Freelancer, I am the Right person for you. I am available almost 24-7 and am very responsive. I feel proud that I am a trusted Freelancer who pleases almost every single client. You can rest assure, your work will be delivered well in advance of others, with passion and accuracy. I guarantee you instant communication & responses when you need me. Why choose me? I think every client is the reason for my success. I only take projects which I am sure I can do quickly.
My Portfolio Items: https://www.freelancer.com/u/schoudhary1553
I would really like to work with you on this project. If interested, Kindly contact me via chat for further details and discussion..
Thank you
Sandeep
Digital screencast
Hello, I just read your project description and will be glad to assist you with that on top priority basis. I am an experienced Data Analyst and advance level Excel user. Data Analytics, Automation and Data Visualization are the areas of my expertise. Lets discuss more about your project and how my skills, qualification and past experience is tailored to meet your requirements.
I am a data entry specialist and statistician. I have advanced knowledge of Microsoft excel and R language. Please check out my portfolio for my past projects and reviews.
Here, I have read your job description carefully! I have created lots of order tracking customize excel spreadsheet as per user requirements, i can show you.. I will create you excel spreadsheet, to enter the orders detail, Database tab for all the orders, that will help to manage the sizes of package, decision making for package (i-e carbon box/bubble), sales record tab and courier detail tab, I would like to add search with multiple criteria feature as well, I can start right now, I will complete your work within your time limit and budget, Please text me to discuss more...
Hello,
Checking your requirements we found ourselves fit to proceed with this project. We are very much confident that we can achieve and fulfill all the project needs.
with our efforts.
Before start workings I would like to have a detailed discussion with you on this project in order to clarify the specifications better as i have some queries also. Kindly initiate me on chat to make a live conversation.
Profile:
https://www.freelancer.com/u/creativeface90
==== Able to start work right away ====
Hi, bro!
I have read your job specification very carefully.
I have rich experiences with Excel VBA .
As a talented and skillful software developer, I am 100% sure to complete this job perfectly on time and on budget.
I am ready to get started my work right away.
I hope your kind contact to discuss more.
Best regards
Ming Wang
Hi, I read through the job and I am absolutely sure that I can do the project very well. I can complete your project on time and within your budget. I am confident I can exceed your expectations. I would love to work on your project.
Hope you can consider me.
Hey there,
Sounds that you do a lot of manual work in order to track your orders and keep things rolling. I could help you out there to cut manual work and automate it for easier use. For starters I could simply take a look at your files and tell what could be done, in terms of timeline & costs. Since I am new here, I would not charge you much (more interested in building my reputation).
In relation to your point about multiple products stacked in a single order and packaging size adjustment, this should be possible to automate, at least partially (i.e. quare, rectangle, sphere formed products). Regarding products that have these standard forms, my advice would be to implement it by summing product dimensions and verifying that these dimensions do not exceed the packaging dimensions (i.e. Product 1 height + Product 2 height should be less than packaging height, and, Product 1 Lenght/Width + Product 2 Lenght/Width should be less than the packaging Length/Width).
Best of luck with you project.
Kind regards,
Rimas
