到货库存导入(采购入库 Excel)
系统会从 Excel 中抓取:款式编号(清洗为SKU)、款式SKU、颜色及规格(提取尺码)、数量、商品名称、运营仓库、采购单号、入仓单号、采购员、入库日期。
库存汇总
| 产品SKU | 中文名 | 尺码 | 采购员 | 采购单号 | 入仓单号 | 入库日期 | 当前库存 | 更新时间 |
|---|---|---|---|---|---|---|---|---|
| DZ251203129902 | 凯乐石VG2617119简欧白男款长上衣 | S | 黄瑞辉 | 329502 | 369144 | 2026-03-09 11:15:29 | 1 | 2026-03-22 17:35:26.177009 |
| DZ261200279904 | 凯乐石VG2617119藤灰紫男款长上衣 | L | 黄瑞辉 | 329502 | 369144 | 2026-03-09 11:15:29 | 1 | 2026-03-22 17:35:26.175482 |
| DZ261100349903 | 凯乐石VG2617218深鸢尾紫女款短上衣 | M | 黄瑞辉 | 329502 | 369144 | 2026-03-09 11:15:29 | 1 | 2026-03-22 17:35:26.173987 |
| DZ261100359901 | 凯乐石VG2617218藤灰紫女款短上衣 | XS | 黄瑞辉 | 329502 | 369144 | 2026-03-09 11:15:29 | 1 | 2026-03-22 17:35:26.172464 |
| DZ251106949904 | 凯乐石VG2617118深鸢尾紫男款短上衣 | L | 黄瑞辉 | 329502 | 369144 | 2026-03-09 11:15:29 | 1 | 2026-03-22 17:35:26.170952 |
| DZ261100339902 | 凯乐石VG2617118藤灰紫男款短上衣 | S | 黄瑞辉 | 329502 | 369144 | 2026-03-09 11:15:29 | 1 | 2026-03-22 17:35:26.169393 |
| LF26013100039906 | WASP-BLUE男款跑步背心-二版-YS9787MO | 2XL | 罗兰方 | 324273 | 369344 | 2026-03-09 15:56:47 | 1 | 2026-03-22 17:35:26.167904 |
| LF26013100039905 | WASP-BLUE男款跑步背心-二版-YS9787MO | XL | 罗兰方 | 324273 | 369344 | 2026-03-09 15:56:47 | 3 | 2026-03-22 17:35:26.166366 |
| LF26013100039904 | WASP-BLUE男款跑步背心-二版-YS9787MO | L | 罗兰方 | 324273 | 369344 | 2026-03-09 15:56:47 | 7 | 2026-03-22 17:35:26.164872 |
| LF26013100039903 | WASP-BLUE男款跑步背心-二版-YS9787MO | M | 罗兰方 | 324273 | 369344 | 2026-03-09 15:56:47 | 9 | 2026-03-22 17:35:26.163348 |
| LF26013100039902 | WASP-BLUE男款跑步背心-二版-YS9787MO | S | 罗兰方 | 324273 | 369344 | 2026-03-09 15:56:47 | 5 | 2026-03-22 17:35:26.161828 |
| YL26012400239906 | NCRC 2026 PRO Red男款T恤-头版-YS9068MKD | 2XL | 甘雅玲 | 322854 | 369346 | 2026-03-09 15:58:28 | 4 | 2026-03-22 17:35:26.160289 |
| YL26012400239905 | NCRC 2026 PRO Red男款T恤-头版-YS9068MKD | XL | 甘雅玲 | 322854 | 369346 | 2026-03-09 15:58:28 | 7 | 2026-03-22 17:35:26.158696 |
| YL26012400239904 | NCRC 2026 PRO Red男款T恤-头版-YS9068MKD | L | 甘雅玲 | 322854 | 369346 | 2026-03-09 15:58:28 | 14 | 2026-03-22 17:35:26.157179 |
| YL26012400239903 | NCRC 2026 PRO Red男款T恤-头版-YS9068MKD | M | 甘雅玲 | 322854 | 369346 | 2026-03-09 15:58:28 | 16 | 2026-03-22 17:35:26.155630 |
| YL26012400239902 | NCRC 2026 PRO Red男款T恤-头版-YS9068MKD | S | 甘雅玲 | 322854 | 369346 | 2026-03-09 15:58:28 | 7 | 2026-03-22 17:35:26.154092 |
| YL26012400239901 | NCRC 2026 PRO Red男款T恤-头版-YS9068MKD | XS | 甘雅玲 | 322854 | 369346 | 2026-03-09 15:58:28 | 2 | 2026-03-22 17:35:26.152335 |
| BH25120300029908 | Vector TRPH Pink男款短上衣-头版-YS9699MLK | 4XL | 凌碧红 | 324138 | 369347 | 2026-03-09 15:59:06 | 1 | 2026-03-22 17:35:26.100506 |
| BH25120300029906 | Vector TRPH Pink男款短上衣-头版-YS9699MLK | 2XL | 凌碧红 | 324138 | 369347 | 2026-03-09 15:59:06 | 1 | 2026-03-22 17:35:26.098929 |
| BH25120300029905 | Vector TRPH Pink男款短上衣-头版-YS9699MLK | XL | 凌碧红 | 324138 | 369347 | 2026-03-09 15:59:06 | 2 | 2026-03-22 17:35:26.097389 |