到货库存导入(采购入库 Excel)
系统会从 Excel 中抓取:款式编号(清洗为SKU)、款式SKU、颜色及规格(提取尺码)、数量、商品名称、运营仓库、采购单号、入仓单号、采购员、入库日期。
库存汇总
| 产品SKU | 中文名 | 尺码 | 采购员 | 采购单号 | 入仓单号 | 入库日期 | 当前库存 | 更新时间 |
|---|---|---|---|---|---|---|---|---|
| BH26011000109902 | MTB PW 26男款T恤-头版-YS9492MFD | S | 凌碧红 | 318246 | 354648 | 2026-01-22 11:32:05 | 11 | 2026-03-22 17:35:44.968707 |
| BH26011000109901 | MTB PW 26男款T恤-头版-YS9492MFD | XS | 凌碧红 | 318246 | 354648 | 2026-01-22 11:32:05 | 5 | 2026-03-22 17:35:44.966699 |
| BH26011000109911 | MTB PW 26男款T恤-头版-YS9492MFD | 2XS | 凌碧红 | 318246 | 354648 | 2026-01-22 11:32:05 | 8 | 2026-03-22 17:35:44.964684 |
| RX26010600029907 | BNE-CC 2021男款背带短裤-二版-YS9113MB | 3XL | 袁日仙 | 314953 | 354649 | 2026-01-22 11:32:34 | 3 | 2026-03-22 17:35:44.962594 |
| RX26010600029906 | BNE-CC 2021男款背带短裤-二版-YS9113MB | 2XL | 袁日仙 | 314953 | 354649 | 2026-01-22 11:32:34 | 2 | 2026-03-22 17:35:44.960484 |
| RX26010600029905 | BNE-CC 2021男款背带短裤-二版-YS9113MB | XL | 袁日仙 | 314953 | 354649 | 2026-01-22 11:32:34 | 3 | 2026-03-22 17:35:44.958337 |
| ZT25123001259903 | FL 25 Gators男款短袖连体衣-头版-YS9212MJFO | M | 曾亭 | 315604 | 354650 | 2026-01-22 11:32:56 | 1 | 2026-03-22 17:35:44.955979 |
| RX26010600029904 | BNE-CC 2021男款背带短裤-二版-YS9113MB | L | 袁日仙 | 314953 | 354649 | 2026-03-19 09:40:19 | 7 | 2026-03-22 17:35:44.955824 |
| ZT25123001259902 | FL 25 Gators男款短袖连体衣-头版-YS9212MJFO | S | 曾亭 | 315604 | 354650 | 2026-01-22 11:32:56 | 3 | 2026-03-22 17:35:44.950885 |
| BH26010700109904 | Vector EasyEast男款慢跑背心-头版-YS9366MB | L | 凌碧红 | 317367 | 354653 | 2026-01-22 11:33:20 | 2 | 2026-03-22 17:35:44.898204 |
| BH26010700109903 | Vector EasyEast男款慢跑背心-头版-YS9366MB | M | 凌碧红 | 317367 | 354653 | 2026-01-22 11:33:20 | 5 | 2026-03-22 17:35:44.896616 |
| BH26010700109902 | Vector EasyEast男款慢跑背心-头版-YS9366MB | S | 凌碧红 | 317367 | 354653 | 2026-01-22 11:33:20 | 7 | 2026-03-22 17:35:44.895018 |
| BH26010700109901 | Vector EasyEast男款慢跑背心-头版-YS9366MB | XS | 凌碧红 | 317367 | 354653 | 2026-01-22 11:33:20 | 4 | 2026-03-22 17:35:44.893239 |
| BH26010700109911 | Vector EasyEast男款慢跑背心-头版-YS9366MB | 2XS | 凌碧红 | 317367 | 354653 | 2026-01-22 11:33:20 | 8 | 2026-03-22 17:35:44.891218 |
| LF2411160109901 | TRI-VECTOR男款T恤-CY116MPO | XS | 罗兰方 | 318678 | 354703 | 2026-01-22 13:36:30 | 10 | 2026-03-22 17:35:44.889143 |
| LF2411160089903 | TRI-VECTOR男款背带短裤-CD038MDO | M | 罗兰方 | 318678 | 354703 | 2026-01-22 13:36:30 | 5 | 2026-03-22 17:35:44.887494 |
| MJ25093000019904 | LimpoWifi男款慢跑背心-头版-YS555MAFO | L | 庄镘洁 | 318679 | 354704 | 2026-01-22 13:37:14 | 5 | 2026-03-22 17:35:44.885912 |
| MJ25093000019903 | LimpoWifi男款慢跑背心-头版-YS555MAFO | M | 庄镘洁 | 318679 | 354704 | 2026-01-22 13:37:14 | 5 | 2026-03-22 17:35:44.884348 |
| MJ25093000019902 | LimpoWifi男款慢跑背心-头版-YS555MAFO | S | 庄镘洁 | 318679 | 354704 | 2026-01-22 13:37:14 | 5 | 2026-03-22 17:35:44.882678 |
| MJ25093000019901 | LimpoWifi男款慢跑背心-头版-YS555MAFO | XS | 庄镘洁 | 318679 | 354704 | 2026-01-22 13:37:14 | 5 | 2026-03-22 17:35:44.880819 |