Introduction

Prada's wholesale team was spending hours on spreadsheets. Every time a major retailer like Nordstrom, Saks, or Harrods sent in an order, the team faced the same grueling process: manually extracting data from massive Excel files, reformatting it line by line, and preparing it for upload to their legacy Oracle database.

One wrong cell? The entire upload would fail. Six hours of work down the drain.

It was a bottleneck that slowed down their entire wholesale operation. With orders coming in from multiple retailers across different seasons, the team was spending 30+ hours annually on a task that should take minutes.

The Solution

We built an AI parsing system that transforms the entire workflow. The system takes three inputs:

1.The retailer's order file (eg. Nordstrom)

2.Prada's style codes reference

3.Door mapping (which products go to which distribution centers)

Then, in under 10 seconds, it generates six perfectly formatted Excel files (one for each distribution center) ready to upload directly into Oracle.

The system doesn't just parse data. It's smart enough to cross-reference style codes, handle non-standard formats, match variant codes, and even flag errors from the retailer's side before upload. If something's off, it tells the team exactly which row needs attention.

The team can now upload their files and in  a blink of an eye have everything ready.

The Result

6 hours → Under 1 minute. 

The wholesale team can now process orders the same day they arrive instead of blocking out entire afternoons. Less manual work means fewer errors, faster turnaround times, and happier retail partners.