Jay's Tools
← Back to Home
Nordstrom Rack · DSCO Workflow

Nordstrom DS Inventory LOC

Clean a raw DSCO Orders workbook, keep only the shipping columns you need including ship_method, fill each SKU's inventory location, add a blank UPS tracking column, and download a ready-to-work Excel file.

1. Process RAW DSCO Excel

Keeps D, E, DX, EC, ED, EG, EH, EI, EL and ES (ship_method), then adds LOC and TRACKING.
Drop DSCO Orders Excel here
.xlsx or .xls · processed locally in your browser
The workbook is not uploaded to a server. Processing happens in this browser.
Output columns
line_item_sku · line_item_upc · ship_name · ship_address_1 · ship_address_2 · ship_city · ship_region · ship_postal · ship_phone · LOC · TRACKING

2. Paste Style List

Copy SKU/style rows directly from Excel and paste them here. LOC and UPC are matched from the master below.
Flexible matching ignores extra spaces around commas and slashes, so IVORY /GREEN and IVORY / GREEN match the same SKU.

3. STYLE / UPC / INVENTORY LOC Master

Edit locations and UPCs here. Changes are saved in this browser and automatically applied to both tools above.