到货库存导入(采购入库 Excel)
系统会从 Excel 中抓取:款式编号(清洗为SKU)、款式SKU、颜色及规格(提取尺码)、数量、商品名称、运营仓库、采购单号、入仓单号、采购员、入库日期。
库存汇总
| 产品SKU | 中文名 | 尺码 | 采购员 | 采购单号 | 入仓单号 | 入库日期 | 当前库存 | 更新时间 |
|---|---|---|---|---|---|---|---|---|
| DZ261100399901 | W14-AIR JERSEY-TTJH 26男款短上衣 | XS | 黄瑞辉 | 326660 | 369430 | 2026-03-09 17:14:05 | 1 | 2026-03-22 17:35:25.977725 |
| DZ261100399911 | W14-AIR JERSEY-TTJH 26男款短上衣 | 2XS | 黄瑞辉 | 326660 | 369430 | 2026-03-09 17:14:05 | 1 | 2026-03-22 17:35:25.976224 |
| DZ261100399912 | W14-AIR JERSEY-TTJH 26男款短上衣 | 3XS | 黄瑞辉 | 326660 | 369430 | 2026-03-09 17:14:05 | 1 | 2026-03-22 17:35:25.974697 |
| DZ261100399918 | W14-AIR JERSEY-TTJH 26男款短上衣 | 4XS | 黄瑞辉 | 326660 | 369430 | 2026-03-09 17:14:05 | 1 | 2026-03-22 17:35:25.973219 |
| BH26022800059904 | MTB UBFR Blue男款长上衣-头版-YS9492MDF | L | 凌碧红 | 327418 | 369431 | 2026-03-09 17:15:46 | 6 | 2026-03-22 17:35:25.971656 |
| BH26022800059905 | MTB UBFR Blue男款长上衣-头版-YS9492MDF | XL | 凌碧红 | 327418 | 369431 | 2026-03-09 17:15:46 | 5 | 2026-03-22 17:35:25.970097 |
| BH26022800059903 | MTB UBFR Blue男款长上衣-头版-YS9492MDF | M | 凌碧红 | 327418 | 369431 | 2026-03-09 17:15:46 | 2 | 2026-03-22 17:35:25.968463 |
| BH26022800059902 | MTB UBFR Blue男款长上衣-头版-YS9492MDF | S | 凌碧红 | 327418 | 369431 | 2026-03-09 17:15:46 | 1 | 2026-03-22 17:35:25.966952 |
| BH26022800059901 | MTB UBFR Blue男款长上衣-头版-YS9492MDF | XS | 凌碧红 | 327418 | 369431 | 2026-03-09 17:15:46 | 1 | 2026-03-22 17:35:25.965397 |
| YL26022800099907 | Trailrider yellow男款T恤-头版-YS9492MXQ | 3XL | 甘雅玲 | 329490 | 369432 | 2026-03-09 17:17:12 | 1 | 2026-03-22 17:35:25.963908 |
| YL26022800099906 | Trailrider yellow男款T恤-头版-YS9492MXQ | 2XL | 甘雅玲 | 329490 | 369432 | 2026-03-09 17:17:12 | 2 | 2026-03-22 17:35:25.962383 |
| YL26022800099905 | Trailrider yellow男款T恤-头版-YS9492MXQ | XL | 甘雅玲 | 329490 | 369432 | 2026-03-09 17:17:12 | 4 | 2026-03-22 17:35:25.960891 |
| YL26022800099904 | Trailrider yellow男款T恤-头版-YS9492MXQ | L | 甘雅玲 | 329490 | 369432 | 2026-03-09 17:17:12 | 4 | 2026-03-22 17:35:25.959337 |
| YL26022800099903 | Trailrider yellow男款T恤-头版-YS9492MXQ | M | 甘雅玲 | 329490 | 369432 | 2026-03-09 17:17:12 | 1 | 2026-03-22 17:35:25.957722 |
| YL26022800099901 | Trailrider yellow男款T恤-头版-YS9492MXQ | XS | 甘雅玲 | 329490 | 369432 | 2026-03-09 17:17:12 | 1 | 2026-03-22 17:35:25.956240 |
| YL26012400179905 | NCRC 2026 PRO Red女款T恤-头版-YS9068WKD | XL | 甘雅玲 | 322854 | 369433 | 2026-03-09 17:17:53 | 2 | 2026-03-22 17:35:25.954656 |
| YL26012400179904 | NCRC 2026 PRO Red女款T恤-头版-YS9068WKD | L | 甘雅玲 | 322854 | 369433 | 2026-03-09 17:17:53 | 4 | 2026-03-22 17:35:25.953090 |
| YL26012400179903 | NCRC 2026 PRO Red女款T恤-头版-YS9068WKD | M | 甘雅玲 | 322854 | 369433 | 2026-03-09 17:17:53 | 4 | 2026-03-22 17:35:25.950905 |
| YL26012400179902 | NCRC 2026 PRO Red女款T恤-头版-YS9068WKD | S | 甘雅玲 | 322854 | 369433 | 2026-03-09 17:17:53 | 5 | 2026-03-22 17:35:25.898563 |
| DQ20230318039906 | 23TDF-WHITE男款短上衣-CD034MVO | 2XL | 吕丹琪 | 324141 | 369434 | 2026-03-09 17:19:02 | 15 | 2026-03-22 17:35:25.897030 |