到货库存导入(采购入库 Excel)
系统会从 Excel 中抓取:款式编号(清洗为SKU)、款式SKU、颜色及规格(提取尺码)、数量、商品名称、运营仓库、采购单号、入仓单号、采购员、入库日期。
库存汇总
| 产品SKU | 中文名 | 尺码 | 采购员 | 采购单号 | 入仓单号 | 入库日期 | 当前库存 | 更新时间 |
|---|---|---|---|---|---|---|---|---|
| YL26022800079907 | Trailrider grey男款长上衣-头版-YS9492MXV | 3XL | 甘雅玲 | 329490 | 369662 | 2026-03-10 10:46:40 | 1 | 2026-03-22 17:35:25.592837 |
| YL26022800079906 | Trailrider grey男款长上衣-头版-YS9492MXV | 2XL | 甘雅玲 | 329490 | 369662 | 2026-03-10 10:46:40 | 2 | 2026-03-22 17:35:25.590528 |
| YL26022800079903 | Trailrider grey男款长上衣-头版-YS9492MXV | M | 甘雅玲 | 329490 | 369662 | 2026-03-10 10:46:40 | 9 | 2026-03-22 17:35:25.588455 |
| YL26022800079905 | Trailrider grey男款长上衣-头版-YS9492MXV | XL | 甘雅玲 | 329490 | 369662 | 2026-03-10 10:46:40 | 4 | 2026-03-22 17:35:25.586499 |
| YL26022800079904 | Trailrider grey男款长上衣-头版-YS9492MXV | L | 甘雅玲 | 329490 | 369662 | 2026-03-10 10:46:40 | 8 | 2026-03-22 17:35:25.584999 |
| YL26022800079902 | Trailrider grey男款长上衣-头版-YS9492MXV | S | 甘雅玲 | 329490 | 369662 | 2026-03-10 10:46:40 | 2 | 2026-03-22 17:35:25.583447 |
| YL26022800079901 | Trailrider grey男款长上衣-头版-YS9492MXV | XS | 甘雅玲 | 329490 | 369662 | 2026-03-10 10:46:40 | 1 | 2026-03-22 17:35:25.581834 |
| YL26022800079911 | Trailrider grey男款长上衣-头版-YS9492MXV | 2XS | 甘雅玲 | 329490 | 369662 | 2026-03-10 10:46:40 | 4 | 2026-03-22 17:35:25.580193 |
| YL26022800079912 | Trailrider grey男款长上衣-头版-YS9492MXV | 3XS | 甘雅玲 | 329490 | 369662 | 2026-03-10 10:46:40 | 4 | 2026-03-22 17:35:25.578476 |
| YL26022800079918 | Trailrider grey男款长上衣-头版-YS9492MXV | 4XS | 甘雅玲 | 329490 | 369662 | 2026-03-10 10:46:40 | 4 | 2026-03-22 17:35:25.576630 |
| YL26022800079919 | Trailrider grey男款长上衣-头版-YS9492MXV | 5XS | 甘雅玲 | 329490 | 369662 | 2026-03-10 10:46:40 | 4 | 2026-03-22 17:35:25.575029 |
| YL26022800079920 | Trailrider grey男款长上衣-头版-YS9492MXV | 6XS | 甘雅玲 | 329490 | 369662 | 2026-03-10 10:46:40 | 4 | 2026-03-22 17:35:25.573448 |
| YL26022800059907 | Trailrider Oberberg男款长上衣-头版-YS9492MXV | 3XL | 甘雅玲 | 329490 | 369662 | 2026-03-10 10:46:40 | 1 | 2026-03-22 17:35:25.571727 |
| YL26022800059905 | Trailrider Oberberg男款长上衣-头版-YS9492MXV | XL | 甘雅玲 | 329490 | 369662 | 2026-03-10 10:46:40 | 2 | 2026-03-22 17:35:25.569809 |
| YL26022800059904 | Trailrider Oberberg男款长上衣-头版-YS9492MXV | L | 甘雅玲 | 329490 | 369662 | 2026-03-10 10:46:40 | 6 | 2026-03-22 17:35:25.568251 |
| YL26022800059903 | Trailrider Oberberg男款长上衣-头版-YS9492MXV | M | 甘雅玲 | 329490 | 369662 | 2026-03-10 10:46:40 | 2 | 2026-03-22 17:35:25.566649 |
| YL26022800059902 | Trailrider Oberberg男款长上衣-头版-YS9492MXV | S | 甘雅玲 | 329490 | 369662 | 2026-03-10 10:46:40 | 1 | 2026-03-22 17:35:25.565090 |
| YL26022800059901 | Trailrider Oberberg男款长上衣-头版-YS9492MXV | XS | 甘雅玲 | 329490 | 369662 | 2026-03-10 10:46:40 | 1 | 2026-03-22 17:35:25.563496 |
| YL26022800059912 | Trailrider Oberberg男款长上衣-头版-YS9492MXV | 3XS | 甘雅玲 | 329490 | 369662 | 2026-03-10 10:46:40 | 1 | 2026-03-22 17:35:25.561932 |
| YL26022800059920 | Trailrider Oberberg男款长上衣-头版-YS9492MXV | 6XS | 甘雅玲 | 329490 | 369662 | 2026-03-10 10:46:40 | 3 | 2026-03-22 17:35:25.560233 |