Need to Create Excel Spread Sheet 

Post an ad like this for FREE!
  • Date Listed12/04/2021
  • Job TypeCasual
  • Company NameMJ Store
  • Education LevelDiploma

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.

Attach a file(maximum 2MB)
By clicking "Send" you accept the Terms of Use and Privacy Notice and agree to receive newsletters and promo offers from us.
Add to Watchlist
 Safety Tips - Your safety is important to us and we believe that you can stay safe. Learn MoreReport this ad
BLK 113 Bukit Purmei Road
You might be interested in these similar ads
RecruitFirst is hiring Coordinator! You will be outsourced to:Location: Hillview/Aljunied (Can choose)Pay: $8.50/hrDuration: 3 months (extendable)Working hours: - 5 days per week (4 weekdays + 1 weekend)- *Shifts will be rostered weekly and subject to changes(Between 11am – 2am, Opening Shift: 11am – 5pmMid Shift: 12pm – 6pmClosing Shift: 5pm – 10pmExtended Shift: 9pm – 2am)Responsibilities:- ...
50 X TEMP AMBASSADORS/ MOBILE APP PROMOTERS | MIN. 2 MONTHS | SHOPPING MALLS | $10/H + COMMHiring for Temp Ambassadors to promote a new Digital Payment App!You will be allocated to stores in various shopping malls!Minimum 2 months, extendableWorkdays/Hours:GROUP A: 3-6 days per week (including both weekends preferred)GROUP B: 2 days per week (SAT & SUN)12pm – 9pm / 11am – 8pm (1 hour break ...
Online Mystery Shoppers in Alexandra / Commonwealth, preview image
Online Mystery Shoppers
Help a large Social Media platform evaluate the e-commerce shopping experience by purchasing items and completing surveys related to the experience. Mystery Shoppers will be completing and reviewing the shopping experience of e-commerce advertisers on a well-known social media platform. What’s in it for you? Mystery Shoppers keep their purchases.Mystery Shoppers are ...
Ex/Current MOE teachers for Home Tuition in Alexandra / Commonwealth, preview image
Ex/Current MOE teachers for Home Tuition
We are looking for Ex/Current MOE teachers - for Part-time Home Tuition. Join our Telegram Channel ( to view and apply for assignments! @CocoAssignmentsHourly rate: $50-70/h for Primary, $55-80/h for Secondary, $70-120/h for JCJob details:Academic Coach for students;Provide personalised help for students, in a 1-to-1 home tuition setting;Provide supplementary notes, creat ...
Temporary Cleaner
Job Description: · Cleaning kitchen area and ensuring that all kitchen equipment and utensils are clean and accounted for · Ensure all the rubbish bins are cleared inside the kitchen · Clean and disinfect all the glass panels, doors and tables · Clean the dust on the walls · Top up hand soap, dishwashing liquid · Mop ...
Temp Screener/ Contact Tracer @ Hypermarket (Redhill, Immediate - 30 Jun) x 10
Duration: Immediate - 30 JuneLocation: Redhill, Lengkok Bahru- Assist on Safe entry, verify and make sure customer has check in safe entry apps*Friends can work together**No experiences needed*- Able to commit 6 days a week including both weekends- Able to commit rotating shift from 7am -3pm/ 3pm - 11pm Salary: $8.50/hr - Mon - Fri$9.50/hr - Sat, Sun & PHAttire: Plain black tee, dark jeans and ...
Math Assistant Teacher (Part-Time) in Alexandra / Commonwealth, preview image
Math Assistant Teacher (Part-Time)
Duties:1. Facilitate a group of primary and secondary school students in Math2. Support duties like preparing lesson materials and marketing Requirement:• Singaporean or PR
• Good in Math• Work in Weekday 3pm to 730pm, Sat 9am to 330pm• Centres: Bukit Merah / Ang Mo Kio / Serangoon• $8 per hour. Increment after probation.Poly, JC or University student are welcome. Training will be providedWhatsApp ...
More ads