到货库存导入(采购入库 Excel)
系统会从 Excel 中抓取:款式编号(清洗为SKU)、款式SKU、颜色及规格(提取尺码)、数量、商品名称、运营仓库、采购单号、入仓单号、采购员、入库日期。
库存汇总
| 产品SKU | 中文名 | 尺码 | 采购员 | 采购单号 | 入仓单号 | 入库日期 | 当前库存 | 更新时间 |
|---|---|---|---|---|---|---|---|---|
| YL26022800049905 | Trailrider Black-1男款长上衣-头版-YS9492MXV | XL | 甘雅玲 | 329490 | 369662 | 2026-03-10 10:46:40 | 1 | 2026-03-22 17:35:25.558660 |
| YL26022800049904 | Trailrider Black-1男款长上衣-头版-YS9492MXV | L | 甘雅玲 | 329490 | 369662 | 2026-03-10 10:46:40 | 2 | 2026-03-22 17:35:25.557166 |
| YL26022800049903 | Trailrider Black-1男款长上衣-头版-YS9492MXV | M | 甘雅玲 | 329490 | 369662 | 2026-03-10 10:46:40 | 8 | 2026-03-22 17:35:25.555634 |
| YL26022800049902 | Trailrider Black-1男款长上衣-头版-YS9492MXV | S | 甘雅玲 | 329490 | 369662 | 2026-03-10 10:46:40 | 2 | 2026-03-22 17:35:25.553873 |
| YL26022800049901 | Trailrider Black-1男款长上衣-头版-YS9492MXV | XS | 甘雅玲 | 329490 | 369662 | 2026-03-10 10:46:40 | 2 | 2026-03-22 17:35:25.551796 |
| MJ26020900029905 | Pave Trivium Club 2026男款短袖连体衣-头版-YS9253MBDO | XL | 庄镘洁 | 326249 | 369674 | 2026-03-10 10:52:52 | 1 | 2026-03-22 17:35:25.498301 |
| MJ26020900029906 | Pave Trivium Club 2026男款短袖连体衣-头版-YS9253MBDO | 2XL | 庄镘洁 | 326249 | 369674 | 2026-03-10 10:52:52 | 2 | 2026-03-22 17:35:25.496506 |
| MJ26020900029904 | Pave Trivium Club 2026男款短袖连体衣-头版-YS9253MBDO | L | 庄镘洁 | 326249 | 369674 | 2026-03-10 10:52:52 | 4 | 2026-03-22 17:35:25.481962 |
| MJ26020900029903 | Pave Trivium Club 2026男款短袖连体衣-头版-YS9253MBDO | M | 庄镘洁 | 326249 | 369674 | 2026-03-10 10:52:52 | 1 | 2026-03-22 17:35:25.480195 |
| BH26022800069905 | MTB UBFR Black男款长上衣-头版-YS9492MDF | XL | 凌碧红 | 327418 | 369675 | 2026-03-10 10:53:15 | 6 | 2026-03-22 17:35:25.478281 |
| BH26022800069904 | MTB UBFR Black男款长上衣-头版-YS9492MDF | L | 凌碧红 | 327418 | 369675 | 2026-03-10 10:53:15 | 5 | 2026-03-22 17:35:25.476724 |
| BH26022800069903 | MTB UBFR Black男款长上衣-头版-YS9492MDF | M | 凌碧红 | 327418 | 369675 | 2026-03-10 10:53:15 | 2 | 2026-03-22 17:35:25.475195 |
| BH26022800069902 | MTB UBFR Black男款长上衣-头版-YS9492MDF | S | 凌碧红 | 327418 | 369675 | 2026-03-10 10:53:15 | 1 | 2026-03-22 17:35:25.473544 |
| BH26022800069901 | MTB UBFR Black男款长上衣-头版-YS9492MDF | XS | 凌碧红 | 327418 | 369675 | 2026-03-10 10:53:15 | 1 | 2026-03-22 17:35:25.471625 |
| YL26012400249906 | NCRC 2026 PRO Blue男款T恤-头版-YS9068MKD | 2XL | 甘雅玲 | 322854 | 369678 | 2026-03-10 10:55:14 | 4 | 2026-03-22 17:35:25.470017 |
| YL26012400249905 | NCRC 2026 PRO Blue男款T恤-头版-YS9068MKD | XL | 甘雅玲 | 322854 | 369678 | 2026-03-10 10:55:14 | 7 | 2026-03-22 17:35:25.468398 |
| YL26012400249904 | NCRC 2026 PRO Blue男款T恤-头版-YS9068MKD | L | 甘雅玲 | 322854 | 369678 | 2026-03-10 10:55:14 | 14 | 2026-03-22 17:35:25.466796 |
| YL26012400249903 | NCRC 2026 PRO Blue男款T恤-头版-YS9068MKD | M | 甘雅玲 | 322854 | 369678 | 2026-03-10 10:55:14 | 16 | 2026-03-22 17:35:25.465259 |
| YL26012400249902 | NCRC 2026 PRO Blue男款T恤-头版-YS9068MKD | S | 甘雅玲 | 322854 | 369678 | 2026-03-10 10:55:14 | 7 | 2026-03-22 17:35:25.463703 |
| YL26012400249901 | NCRC 2026 PRO Blue男款T恤-头版-YS9068MKD | XS | 甘雅玲 | 322854 | 369678 | 2026-03-10 10:55:14 | 2 | 2026-03-22 17:35:25.462091 |