E-commerce, Quick Commerce & Logistics Fundamentals

Explore the pickup raised to creation process in first mile logistics, from order confirmation to generating a pickup in the logistics management system with key required details.

Execute pickup assignment and preparation by finalizing date, time, and location; shortlist vendors by availability; record weight and volume; map a cost-efficient route via route optimization.

Master the CN creation process for pickups: generate CN numbers, enter CN booklet, EV bill, consignor and consignee details, consignment data, and invoice details, then print CN copy.

Review the CN creation process and the three mandatory documents—invoice, e-way bill, and CN copy—and learn barcode pasting best practices to ensure accurate scanning and delivery proof.

Learn best practices for loading, unloading, and stacking, including hand pallet truck operation, material handling symbols, safe lifting posture, and stacking rules to prevent damage and injuries.

Define middle mile logistics as the movement of material from origin to destination processing centers, including CN retrieval, barcode scanning, loading, and securing cargo with nets and seals.

Explore vehicle types for first, middle, and last mile, from small pickups to 18-ton trucks, and learn pre-inspection steps: leakage checks, tarpaulin, cargo nets and hooks.

Last mile logistics is the final step delivering from a branch or pc to the end customer, involving delivery requests, vendor assignment, and pin code based planning.

Identify common causes of failed delivery, including vehicle placement, planning errors, 2PAY readiness, appointment conflicts, or consignee refusal, and apply actions like arranging alternate vehicles and rescheduling.

Learn the definition and key features of proof of delivery, including receiver name, signature, date and time, stamp, and remarks, and why POD ensures legal evidence and inventory integrity.

Explore the key metrics of last mile in quick commerce, including delivery time versus enroute time, order processing factors, rider login hours, OPH, and rider count.

Learn what incentives are, including financial, non-financial, and material types, and analyze order-based, earnings-based, and direct incentives, along with motivation, behavior modification, and retention.

Explain direct incentives, where there are no levels, riders receive an extra amount for every order, and where lock-in time slots enable targeted payouts.

Explore rider hiring sources—referrals, external vendors, social media ads, Google ads, and competitor outreach—and map the rider onboarding funnel from lead generation to verified onboarding.

Explore the main warehouse types used in logistics, including public, private, distribution centers, fulfillment centers, climate-controlled, automated, cold storage, bonded, and cross-docking facilities, with examples.

learn how first-in first-out and last-in first-out storage systems manage inventory flow, valuation, profitability, and tax implications using chairs as examples.

Explore space optimization strategies for warehouses, including flow layout, zoning, vertical space, dynamic slotting, ABC analysis, and automated systems to maximize storage density and efficiency.

Explore how a warehouse management system improves inventory accuracy and efficiency through real-time visibility and barcode scanning. Review integration, training, data migration, testing, and total cost of ownership.

Explore safety in warehouses by covering employee training, PPE, layout and signage, fire safety, ergonomics, lifting and forklift safety, hazardous materials handling, accident reporting, emergency preparedness, and health programs.

Define inventory management and its importance in maintaining optimal stock levels to meet demand while reducing holding costs, improving cash flow, and ensuring product availability.

Learn the core inventory control techniques—JIT, EOQ, ABC analysis, safety stock, ROP, FIFO, and LIFO—and their benefits and drawbacks for cost control and stockouts.

Learn the just-in-time inventory approach, a demand-driven system that minimizes waste and costs. It emphasizes supplier collaboration, continuous improvement, and flexible production to boost efficiency.

Explore ABC analysis of inventory, categorizing items into A, B, and C by annual consumption value, with data collection, ranking, and cumulative value, plus benefits and best practices.

Explore the economic order quantity (EOQ) model to minimize inventory costs by optimizing order quantity, using D, S, and H in the EOQ formula, and examining assumptions, benefits, and limitations.

Learn batch and serial number tracking to identify groups and individual items, support quality control, recalls, and regulatory compliance. Explore implementation considerations like barcode or RFID technology and software integration.

Explore barcode and RFID technology, including definitions and types such as 1D and 2D barcodes. Compare advantages and disadvantages: no line of sight, data capacity, real-time tracking, cost, and interference.

Understand stock replenishment strategies as systematic, data-driven methods to restock inventory, meet demand, reduce costs, improve cash flow, and minimize waste.

Define safety stock and its role as a buffer against variability, disruptions, and stockouts. Compute it with the Z sigma sqrt(L) formula using lead time, standard deviation, and service level.

Understand the definition and importance of the reorder point, and learn to calculate it using average daily demand, lead time, lead time demand, and safety stock with an example.

Explore automated replenishment systems that trigger orders at reorder points using demand forecasting, track inventory across locations, and integrate with ERP and WMS for dashboards.

Learn how workforce planning in ecommerce uses demand forecasting, supply analysis, and gap analysis to create action plans that align staffing with peak seasons, operations, and customer service.

Discover the types of manpower in e-commerce, from support roles to matrices like order fulfillment rate and inventory turnover rate. Identify roles such as order fulfillment specialist and inventory analyst.

Learn to manage seasonal workforce fluctuations by using flexible staffing options such as temporary staffing agencies, part-time hires, and cross-training, while ensuring clear communication of demand forecasts and training.

Assess manpower productivity in loading teams by calculating per hour output for fogeys, scanners using handheld devices (HHDs), and supervisors, and estimate required headcount from daily weight targets.

Explore the importance and types of rewards and recognition. Learn to design and implement a recognition program, and measure its effectiveness with surveys and performance metrics.

Learn rack location conventions using levels, aisles, and 01A-like codes, review manpower types (picker, putter, fruits and vegetables auditor) and order flow from placement to rider handoff, including drop zone.

Calculate picking manpower using IPO, PPI, and utilization, compute picking time per order, and determine required manpower for daily orders.

Identify the causes of high PPI in e-commerce warehousing, including new vs old manpower, wrong item locations, missing items, head SKUs, tail items, and picker time, and learn practical improvements.

Explore Microsoft Excel’s grid-based interface, mastering data entry, formulas, data analysis with pivot tables and charts, plus sorting, filtering, macros, collaboration, and security.

Learn how workbooks contain data, formulas, charts, and how worksheets are pages of rows, columns, and cells. Master creating, opening, saving, renaming, deleting, coloring tabs, switching sheets, and linking cells.

Identify Excel toolbars including the ribbon, quick access toolbar, and formula toolbar, and customize the quick access toolbar by adding, removing, and rearranging commands and tools like the name box.

Explore how autofill in Excel speeds data entry by extending numbers, dates, and text patterns with a simple drag, and fill series or copy formatting as needed.

Learn cell and number formatting in spreadsheets, including text alignment, orientation, color, fonts and bold/italic/underline, decimals, thousands separators, and rupee currency.

Analyze the structure of Excel formulas, including equals sign, functions, operators, and operands, through examples. Master the order of operations (PEMDAS) and the role of parentheses.

Explore relative and absolute references in Excel with practical examples. See how dragging formulas updates values and how dollar signs freeze B10.

Explore how to use excel's min, max, count, count A, and count blank functions to identify minimum and maximum values, count numeric cells, and count text strings in data.

Explore data management in Excel, focusing on organization, cleaning, validation, analysis, and visualization. Learn to use tables, sorting, duplicates removal, data validation, formulas, pivot tables, and charts to derive insights.

Master advanced Excel formulas like VLOOKUP, IF, NestedIF, SUMIF, COUNTIF, AVERAGEIF, SUMPRODUCT, and CONCATENATE to manipulate, analyze, and summarize complex data efficiently.

Learn how the if and ifs functions produce outputs based on conditions, using a login per rider example to show yes/no results and multi-condition logic.

Explore nested if to handle multiple logical tests and categorize values into three ranges from less than or equal to 5 to greater than 8.

Learn how to use VLOOKUP and XLOOKUP in Excel to search the first column, return corresponding values, and compare exact versus approximate matches.

Explore how countif counts occurrences that meet a condition and how sumif sums values that meet a condition, using store ids and orders as examples.

Master advanced COUNTIFS and SUMIFS functions to count appearances and sum orders under multiple conditions, using store ID 9628, year 2024, and month May.

Master selecting the right chart type for logistics data by applying column, bar, pie, and line charts to visualize shipment volumes, warehouse performance, delivery times, and trends.

Identify the basic components of a chart, including chart area, axes, axis titles, chart title, legend, grid lines, data labels, and a data table, to improve readability of data.

Create combo charts to compare two metrics, such as orders and OPH, using primary and secondary axes. Learn to assign each series to the axis and swap them as needed.

Master pivot tables to analyze weight dispatched from Delhi and Bangalore warehouses across Jan, Feb, and March, using origin and month fields, with destination filters to focus on Mumbai routes.

learn how to use value field settings in pivot tables to count store IDs and show data as percentages of grand total, column total, or row total.

Master filtering pivot table data in Excel using slicers and timelines. Filter by dates with slicers and by time periods with timelines for efficient data analysis.

Create a pivot table and use field items and sets to add a calculated field that divides login hours by number of riders to show average login hours per rider.