Order Status Excel Entry

via Freelancer ·

Budget / SalaryHourly project
TypeFreelance project
LocationRemote
Posted1 hour ago
I need daily order-status records keyed into an Excel spreadsheet that I use to monitor fulfilment. Accuracy is the priority: every line must match its corresponding purchase order number, current status, carrier reference, and delivery ETA.

Once each day’s batch is finished in Excel, I also export the file into a small SQL database that drives our dashboard and, for a separate analytics routine, sync a copy of the same data into a MongoDB collection. If you already know the basics of INSERT statements and simple MongoDB imports, that will make the hand-off much smoother, but your main task is clean, well-formatted Excel entry.

Deliverables
• Updated Excel file with all new orders validated against source documents
• CSV (or similar) ready for SQL import, using my field order
• Optional: JSON dump for MongoDB if you are comfortable creating it

I will provide a template, data sources, and clear data-validation rules; you return the files by 4 p.m. GMT each workday. If the spreadsheet opens error-free and the SQL import completes without duplicate-key clashes, the milestone is approved.
data entry excel sql nosql couch & mongo database administration elasticsearch mongodb data management
Apply on Freelancer →

Project sourced from Freelancer.com. Applications happen directly on the original platform — we never collect your data.