Excel Spreadsheet for Order Generation to Warehouse

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.

Evner: Excel, Dataindførsel, Databehandling, Visual Basic, PHP

Se mere: excel purchase order creator, excel based report generation, excel vba order management, excel inventory order form, excel work order form macro, excel based order form, i`m looking designer, excel tradestation order integration, excel vba order tasks, i`m looking php script rent villa, create feedback spreadsheet excel, understanding excel spreadsheet order entry, i m looking for a excel teacher, i\ m looking for dropshipping for all kind of product to sell on ebay and amazon with a PayPal account i will pay him for the pr, i\\\ m looking for dropshipping for all kind of product to sell on ebay and amazon with a PayPal account i will pay him for the , Hi! I\ m looking someone who can gather inf, Hi, I\ m looking for someone who can draw something similar to the image attached. In the image there\ s an astronaut drawn o

Om arbejdsgiveren:
( 0 bedømmelser ) Singapore, Singapore

Projekt ID: #29858716

13 freelancere byder i gennemsnit $145 timen for dette job


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 Flere

$240 SGD in 5 dage
(501 bedømmelser)
(251 bedømmelser)
(210 bedømmelser)

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 Flere

$70 SGD på 1 dag
(119 bedømmelser)

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.

$100 SGD in 2 dage
(11 bedømmelser)
(121 bedømmelser)

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 Flere

$140 SGD på 1 dag
(17 bedømmelser)

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 Flere

$180 SGD in 7 dage
(3 bedømmelser)

==== 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 th Flere

$70 SGD på 1 dag
(4 bedømmelser)

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.

$111 SGD in 5 dage
(0 bedømmelser)

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 o Flere

$80 SGD in 3 dage
(0 bedømmelser)

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

$100 SGD på 1 dag
(0 bedømmelser)

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 Flere

$50 SGD in 2 dage
(0 bedømmelser)