Excel Spreadsheet for Order Generation to Warehouse
$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.
Projektin tunnus: #29858716
Tietoa projektista
13 freelanceria on tarjonnut keskimäärin $145 tähän työhön
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 sam Lisää
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 Visualizati Lisää
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 de Lisää
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 l Lisää
Hello sir, I can do this job in a neatly arranged way. If you give me the job, I want to do it. I have five years of experience in this work.
i have knowledge about the work and i understood all that needs to be done. please text me so we can discuss about the work and get it done ASAP
