Administrative Support & Data Entry for an E-commerce Store

An e-commerce entrepreneur needed help managing order records, updating product listings, and keeping supplier information up-to-date. Manual data entry was taking up valuable hours that could be better spent on marketing and business growth.

Objectives:
• Handle daily order and inventory updates.
• Maintain an accurate supplier and product database.
• Reduce manual work through spreadsheet automation.

Actions Taken:
1. Data Entry System: Created a master spreadsheet that tracked order dates, fulfillment status, customer details, and payment confirmations.
2. Product Update Process: Standardized the process of adding and editing product descriptions, images, and pricing.
3. Supplier Records: Built a contact directory for all suppliers, including lead times, MOQ (minimum order quantity), and preferred communication channels.
4. Automation: Used Google Sheets formulas and conditional formatting to flag low-stock items.
5. Weekly Reporting: Compiled and sent a weekly performance summary, including sales trends and stock warnings.

Results:
• Eliminated stock-outs by 90% with proactive low-stock alerts.
• Saved the client 10 hours/week on admin tasks.
• Improved accuracy of order data by implementing double-check protocols.

Tools Used: Google Sheets, Shopify, Dropbox, Slack.