Check this workflow
Supplier price-file processing
7 of 7 steps confirmed. Open the full map
Step 1
Download the price file from the supplier email and save it to the shared drive
Category Assistant · Outlook · 10 min
Step 2
Fix the layout — every supplier uses a different format, so columns get moved and sizes retyped by hand
Category Assistant · Excel · 35 min
Step 3
Match supplier product codes to our item numbers
Merchandise Planner · Retail ERP · 40 min
Step 4
Update cost prices on matched items
Merchandise Planner · Retail ERP · 30 min
Step 5
Email the supplier a list of items that didn't match
Category Assistant · Outlook · 15 min
Step 6
Load corrected items once the supplier responds
Merchandise Planner · Retail ERP · 20 min
Step 7
Post a summary of price changes to the stores channel
Category Assistant · Teams · 5 min