25 tasks, each one witnessed by the sources that watched the job — and behind every one, a prompt you can use tonight.
You split time between data work and talking to people. Mornings often mean opening Excel files with sales, inventory, and purchase orders, then updating forecasts and reorder points. Afternoons usually focus on meetings: talking with buyers, sales teams, and suppliers about stock, promotions, or delivery issues.
You also check emails in Outlook for supplier invoices or shipment alerts, review SharePoint documents like contracts, and approve purchase requisitions or payments when needed. On busy days you might spend hours comparing vendor quotes and transportation options to solve supply delays.
Excel is the main tool: sales analysis, pivot tables, VLOOKUP/XLOOKUP, and stock models. PowerPoint and Word make reports and presentations for buyers or store managers. Outlook handles supplier and team communication; SharePoint stores contracts, specs, and versioned documents.
Access or Project appears in bigger chains: Access for small databases (SKU lists, supplier records) and Project for tracking rollout schedules. Know these six: Excel, Outlook, SharePoint, Word, PowerPoint, and sometimes Access or Project.
You use historical sales and cost data in Excel to calculate margins and elasticity: cost per unit, desired gross margin, and competitor prices. From that you recommend a mark-up percentage or markdown timing—often a specific number like 20–40% markup or a 10% markdown after four weeks if sell-through is low.
You then write the recommendation in Word or a PowerPoint slide and send it to merchandising or pricing committees via Outlook. The final price must also follow company pricing rules and legal regulations.
Yes, AI can speed up trend spotting and generate hypotheses from large Excel sheets, but never let it make final buying or contract decisions. Always verify AI outputs against raw data in Excel and your supplier contracts on SharePoint.
Keep supplier confidentiality: don’t paste vendor pricing or contract clauses into public AI chat tools. Use internal AI features inside approved systems or anonymize data first. Log decisions and keep Excel backups to trace errors.
Start with Excel skills: formulas, pivot tables, and basic macros. Take a short course on merchandising or supply chain basics (community college or online platforms). Learn how to write purchase orders and read invoices—practice with real templates in Word/Excel.
Apply for roles like inventory clerk, merchandise assistant, or junior buyer to learn vendor negotiation and procurement. On the job you’ll pick up SharePoint, Access, and Project from actual tasks.
A buyer focuses on sourcing and negotiating contracts and placing orders; a merchandiser focuses on how products appear in store and in advertising. A retail analyst sits between them: you analyze sales, recommend which products to stock, set pricing strategy, and evaluate supplier performance with data.
You’ll do more Excel modeling and reporting than a pure buyer, and more vendor evaluation and procurement knowledge than a visual merchandiser. Expect to coordinate both roles and feed them actionable numbers.
Data accuracy in Excel: clean, up-to-date sales and inventory data matters most. Small errors change reorder points, pricing, and invoice approvals, so build reliable spreadsheets and double-check formulas and source files.
Second, communication: you must explain numbers clearly in Outlook emails or PowerPoint slides so buyers, sales teams, and warehouse staff act on your recommendations.