Fermé

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.

Compétences : Excel, Saisie de Données, Traitement de Données, Visual Basic, PHP

en voir plus : 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

Concernant l'employeur :
( 0 commentaires ) Singapore, Singapore

Nº du projet : #29858716

14 freelances font une offre moyenne de 146 $ pour ce travail

schoudhary1553

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% SGD en 5 jours
(496 Commentaires)
8.4
(234 Commentaires)
6.8
(203 Commentaires)
6.9
daniyal3214

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 Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% SGD en 1 jour
(118 Commentaires)
6.7
nemanjadj20

Hello? I have worked on Excel/Word/PPT/MACRO projects to what you are looking for, and I am confident I can exceed your expectations. I have attached samples of work very similar to what you are seeking. # create in Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% SGD en 3 jours
(46 Commentaires)
6.2
Ayo25

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.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% SGD en 2 jours
(11 Commentaires)
5.9
(118 Commentaires)
6.0
raoarslan56

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 Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% SGD en 1 jour
(17 Commentaires)
4.7
creativeface90

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% SGD en 7 jours
(3 Commentaires)
3.6
Wanngming

==== 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 Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% SGD en 1 jour
(3 Commentaires)
2.4
mdshezanmahmud9

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.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% SGD en 5 jours
(0 Commentaires)
0.0
lua09

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% SGD en 3 jours
(0 Commentaires)
0.0
zerishfirdous

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

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% SGD en 1 jour
(0 Commentaires)
0.0
RimasB

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% SGD en 2 jours
(0 Commentaires)
0.0