✂️ Cut buy sheet and vendor receipt creation time by 30%

Organisation

Fortune 500 Retail Company

Role

UX Designer

Duration

1 month

Tools & Technologies

Figma

Data Heavy

Reporting

Vendors

Problem

The older system relied too heavily on Excel, which just created confusion for vendor tracking, receipt organization, and note sharing. They wanted this to be shareable, versioned, and user-friendly.

My role

Created interactive mid-fidelity prototypes for a new web-based enterprise-wide solution for buyers to create, edit, store, and share important process documents such as Buy Sheets, Assortment Sheets, and Purchase Orders.

Outcome

Cut vendor receipt (Assortment - Buy - Purchase Order) creation time by 30%

How I solved it
This was one of the most challenging projects in my career.


Research

Starting out, I had to skip the initial discovery phase due to time constraints. The client was fine with the potential lack of traditionally gathered user data to get initial design idea off the ground. The client wasn't having design conversations at all, and we needed to go "blue sky" with it and start with the basics.

This is a very typical trade-off that happens in consulting because many clients are pressed for time and we need to create value for them fast. It puts us in a startup mindset.


UI Kit Created From Scratch

After a thorough walk-through of an existing tool that the reps use for ordering and quotes, I moved on to starting the mid-fidelity component library. These components all had to be made from scratch since the client didn't have an in-house design team or a marketing department that kept at least a style guide.




Design

With all this and a limited amount of time, I prioritized what I was tackling first...assortment sheet creation.


At first I created a path in the top right for people to see where they were in the process but after some discussion with stakeholders the path was removed to conserve space.


V1


Final



Why Assortment Sheets first?

Because this is the first process bleeds into both buy sheets and PO (purchase order) creation.



Then I went into creating the Buy Sheeting mockups.

This was the most challenging part because buyers need to see their targets at all times when creating a buy sheet.

"The main problem with buy sheets is that the buyers were creating orders and sending those orders to vendors all through excel. This also served as their versioning technique. It's a time-consuming and confusing process and, if done wrong, costly." -notes from legacy research


Targets: Financial or operational metrics set by the retail management. This can include planned sales, gross margin return on investment (GMROI), or units per store per week 


Before, reps would toggle between two different systems to see their targets and their buy plan. Now, the targets are front and center and update automatically as they build the buy plan.



Lastly buy sheets flow into Purchase Orders (POs). POs are pretty straight forward. They serve as receipts for the buy sheets. They are the last step before sending a vendor a buy sheet. Before getting PO approval, they can take a number of actions and review their final selections.



This was just a taste of the entire process.


If you want to know more about tradeoffs, what didn't make it into production, and challenges, get in touch with me for the full presentation!

Final Outcome

Cut buy sheet and vendor receipt creation time by 30% (15min - 10min)


Creating a buy sheet is now as easy as an excel upload, PDF upload or creating the list from scratch and a couple of clicks instead of scouring through Excel files. 

Retrospective

My ability to self manage even surprised me. I was always taught to follow my manager but I took initiative and ownership for many parts of the process including bulk editing, creating the UI for the mockups and doing light initial research into what's currently working in other design libraries that deal with heavy data.

Challenges

The iteration turnaround times were challenging to say the absolute least. On the same day a new concept is presented, leadership would want a turnaround time that same day. I dealt with this by deprioritizing other flows or working with my manager to push the timeline out by a day. In the design world, turnaround times of about a day are normal. I was really tapping into my scrappy agency days because the client was so new to design and how it operates.