web fulfillment l.
Download
Skip this Video
Loading SlideShow in 5 Seconds..
Web Fulfillment PowerPoint Presentation
Download Presentation
Web Fulfillment

Loading in 2 Seconds...

play fullscreen
1 / 38

Web Fulfillment - PowerPoint PPT Presentation


  • 109 Views
  • Uploaded on

Web Fulfillment. University of Minnesota Case Study Kevin Becker Martha Hoppe. Goals of the presentation. Background Fulfillment Process Physical Setup Staffing Credit Card Processing Interfaces with UPS Interface with RATEX Feedback Tools Future Directions Open Discussion.

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about 'Web Fulfillment' - fidelia


An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
web fulfillment

Web Fulfillment

University of Minnesota

Case Study

Kevin Becker

Martha Hoppe

goals of the presentation
Goals of the presentation
  • Background
  • Fulfillment Process
  • Physical Setup
  • Staffing
  • Credit Card Processing
  • Interfaces with UPS
  • Interface with RATEX
  • Feedback Tools
  • Future Directions
  • Open Discussion
slide4
$1.65 Million in sales in 2003-2004 (7%)
  • $113,500 in shipping in handling
background5
Background
  • Fall Rush 2003 - Textbooks
    • 4075 orders between July 15 and Sept. 30
    • 1191 (30%) came the week before rush
    • 700 came the Wednesday before rush
    • Average textbook order price $175.00
slide6
University wide authentication
    • Common user name and password
    • Extra security
slide7
Multiple store units
    • Users are assigned default store
    • Can change stores
background8
Background
  • Exports from RATEX nightly
  • No intentional backorders
  • No reservations
  • Ship to residence halls without specific room number
  • Substitute new/used automatically
background9
Background
  • Server Background
    • Two servers (web and database)
    • SunOS
    • Oracle9i
    • Remote/Outsourced administration
fulfillment process
Fulfillment Process
  • Step 1
    • Print orders
fulfillment process12
Fulfillment Process
  • Step 2
    • Pull Books
  • Step 3
    • Adjust order if needed.
      • Delete
      • Backorder
      • Switch new for used
fulfillment process15
Fulfillment Process
  • Step 4
    • Post Order
      • Charges credit card
      • Prints packing list/receipt
physical setup
Physical setup
  • Dedicated area for packing with supplies nearby
  • Easy access to scale
  • Easy access to computer
  • Handle each package as little as possible
  • Have enough space to avoid mixing up paperwork
staffing
Staffing
  • Dedicated staff during rush
  • Shopping shifts to staff from customers
  • Shipping and packing increases
  • Technology staff increases
online credit card processing
Online Credit Card Processing
  • No declined cards after picking
  • No bad credit card numbers
  • More fraud protection (CVV2)
  • No credit card number stored in RATEX
  • No credit card numbers printed on pick lists.
online credit card processing21
Online Credit Card Processing
  • YourPay (formerly SurePay) processes card information.
  • Created a tender for YourPay
  • Settlement is done on-line.
  • Balanced against register reports
  • Can exclude numbers, names and domains
  • Can alter orders before finalizing
  • Can charge at time of shipping not purchase
online credit card processing22
Online Credit Card Processing
  • Negatives
    • Refunds are complicated
    • Two different settlements
    • Final shipping order must be precise
interface with ups
Interface with UPS
  • Steps to interface
    • Create a view in Oracle with the database fields needed.
    • Install UPS WorldShip
    • Load ODBC client onto PC
    • Configure WorldShip
    • Open key entry window
    • Enter order number
    • Ship
    • Customer is emailed shipping notification and tracking number
interface with ups25
Interface with UPS
  • Production increase
    • Max orders per day before interface - 250
    • Theoretical max per day after interface - 1000
  • Data entry errors are gone
  • Label sensor stops mislabeling.
  • Pitfalls
    • “highway hypnosis”
      • Entering wrong order number
      • Wrong paperwork with package
ratex interface
RATEX Interface
  • Preliminary work
    • Registers need to be created in POS and SALES (special range of numbers)
    • Web registers are created based on IP addresses
    • Each workstation is given a register number
    • Export cashier numbers daily
ratex interface28
RATEX Interface
  • Web fulfillment closed, file created
  • ED SALES.MPQ SM-PROCESS.LIBERTY
    • Enter code below, before the line [SALES.MPQ BUILD.SALES.CRD.LIBERTY
      • 0020: HRUN USER.BP PROG.NAME
      • 0021: P
    • The program reads the text file and creates records in the VST format and writes them into POS.VST.UPLOAD and POS.VST.YTD
    • Sales processing runs and updates TMF’s and SALES files
ratex interface29
RATEX Interface
  • Drawbacks
    • Major - disrupts real-time inventory
    • No POS.EJF file
    • File not getting loaded correctly
      • Save copies of transaction files
feedback tools
Feedback tools
  • Web Statistics
  • Web reports
  • Surveys
customer surveys
Customer Surveys
  • Email follow ups
  • Pop-up Surveys
future directions
Future Directions
  • More frequent product update
  • Moving to “real time” updating
  • Student account charges
  • Normalizing data for export from RATEX
  • Auto transfers from warehouse to store
  • UPS address verification up front
  • Textbook pre-orders
  • Customer order status and history online
  • Pop-up surveys
  • Gift registry
thank you
Thank you
  • Questions can be directed to:
    • Technical
      • Kevin Becker becke008@umn.edu
    • Operational
      • Martha Hoppe hoppe020@umn.edu