到货库存导入(采购入库 Excel)
系统会从 Excel 中抓取:款式编号(清洗为SKU)、款式SKU、颜色及规格(提取尺码)、数量、商品名称、运营仓库、采购单号、入仓单号、采购员、入库日期。
库存汇总
| 产品SKU | 中文名 | 尺码 | 采购员 | 采购单号 | 入仓单号 | 入库日期 | 当前库存 | 更新时间 |
|---|---|---|---|---|---|---|---|---|
| ZT25120300129904 | PARIA25 Black Core男款跑步短裤-头版-YS2211MO | L | 曾亭 | 323288 | 369647 | 2026-03-10 10:38:54 | 3 | 2026-03-22 17:35:25.681718 |
| ZT25120300129903 | PARIA25 Black Core男款跑步短裤-头版-YS2211MO | M | 曾亭 | 323288 | 369647 | 2026-03-10 10:38:54 | 3 | 2026-03-22 17:35:25.679465 |
| ZT25120300129902 | PARIA25 Black Core男款跑步短裤-头版-YS2211MO | S | 曾亭 | 323288 | 369647 | 2026-03-10 10:38:54 | 2 | 2026-03-22 17:35:25.677227 |
| ZT25120300129901 | PARIA25 Black Core男款跑步短裤-头版-YS2211MO | XS | 曾亭 | 323288 | 369647 | 2026-03-10 10:38:54 | 1 | 2026-03-22 17:35:25.675041 |
| RX25090100099905 | On Pace Multi Sport-A男款短上衣-YS9409MDFS | XL | 袁日仙 | 326234 | 369659 | 2026-03-10 10:42:00 | 1 | 2026-03-22 17:35:25.672694 |
| RX25090100099904 | On Pace Multi Sport-A男款短上衣-YS9409MDFS | L | 袁日仙 | 326234 | 369659 | 2026-03-10 10:42:00 | 2 | 2026-03-22 17:35:25.670468 |
| RX25090100099903 | On Pace Multi Sport-A男款短上衣-YS9409MDFS | M | 袁日仙 | 326234 | 369659 | 2026-03-10 10:42:00 | 2 | 2026-03-22 17:35:25.668286 |
| RX25090100099902 | On Pace Multi Sport-A男款短上衣-YS9409MDFS | S | 袁日仙 | 326234 | 369659 | 2026-03-10 10:42:00 | 1 | 2026-03-22 17:35:25.666678 |
| RX25090100089903 | On Pace Multi Sport-A女款短上衣-YS9409WAHS | M | 袁日仙 | 326234 | 369659 | 2026-03-10 10:42:00 | 1 | 2026-03-22 17:35:25.665185 |
| RX26012800149904 | EXIT21男款短袖连体衣-头版-YS9251MGFO | L | 袁日仙 | 323329 | 369660 | 2026-03-10 10:44:41 | 5 | 2026-03-22 17:35:25.663639 |
| RX26012800149903 | EXIT21男款短袖连体衣-头版-YS9251MGFO | M | 袁日仙 | 323329 | 369660 | 2026-03-10 10:44:41 | 6 | 2026-03-22 17:35:25.662132 |
| MJ26022800089905 | RADA GCT 2026男款长上衣-头版-YS9640MHFO | XL | 庄镘洁 | 327079 | 369661 | 2026-03-10 10:45:07 | 2 | 2026-03-22 17:35:25.660526 |
| MJ26022800089904 | RADA GCT 2026男款长上衣-头版-YS9640MHFO | L | 庄镘洁 | 327079 | 369661 | 2026-03-10 10:45:07 | 3 | 2026-03-22 17:35:25.658853 |
| MJ26022800089903 | RADA GCT 2026男款长上衣-头版-YS9640MHFO | M | 庄镘洁 | 327079 | 369661 | 2026-03-10 10:45:07 | 5 | 2026-03-22 17:35:25.657199 |
| MJ26022800089902 | RADA GCT 2026男款长上衣-头版-YS9640MHFO | S | 庄镘洁 | 327079 | 369661 | 2026-03-10 10:45:07 | 2 | 2026-03-22 17:35:25.655649 |
| MJ26022800079903 | RADA GCT 2026女款长上衣-头版-YS9640WHAO | M | 庄镘洁 | 327079 | 369661 | 2026-03-10 10:45:07 | 1 | 2026-03-22 17:35:25.654062 |
| YL26022800109906 | Trailrider grey男款T恤-头版-YS9492MXQ | 2XL | 甘雅玲 | 329490 | 369662 | 2026-03-10 10:46:40 | 1 | 2026-03-22 17:35:25.652072 |
| YL26022800109905 | Trailrider grey男款T恤-头版-YS9492MXQ | XL | 甘雅玲 | 329490 | 369662 | 2026-03-10 10:46:40 | 2 | 2026-03-22 17:35:25.599037 |
| YL26022800109904 | Trailrider grey男款T恤-头版-YS9492MXQ | L | 甘雅玲 | 329490 | 369662 | 2026-03-10 10:46:40 | 5 | 2026-03-22 17:35:25.597189 |
| YL26022800109903 | Trailrider grey男款T恤-头版-YS9492MXQ | M | 甘雅玲 | 329490 | 369662 | 2026-03-10 10:46:40 | 1 | 2026-03-22 17:35:25.595307 |