到货库存导入(采购入库 Excel)
系统会从 Excel 中抓取:款式编号(清洗为SKU)、款式SKU、颜色及规格(提取尺码)、数量、商品名称、运营仓库、采购单号、入仓单号、采购员、入库日期。
库存汇总
| 产品SKU | 中文名 | 尺码 | 采购员 | 采购单号 | 入仓单号 | 入库日期 | 当前库存 | 更新时间 |
|---|---|---|---|---|---|---|---|---|
| RX25102200059903 | LBCC-26BAROUDEUR velo男款背带短裤-头版-YS9134MIAO | M | 袁日仙 | 324388 | 369483 | 2026-03-09 18:02:01 | 30 | 2026-03-22 17:35:25.799540 |
| RX25102200059904 | LBCC-26BAROUDEUR velo男款背带短裤-头版-YS9134MIAO | L | 袁日仙 | 324388 | 369483 | 2026-03-09 18:02:01 | 22 | 2026-03-22 17:35:25.798021 |
| RX25102200059902 | LBCC-26BAROUDEUR velo男款背带短裤-头版-YS9134MIAO | S | 袁日仙 | 324388 | 369483 | 2026-03-09 18:02:01 | 7 | 2026-03-22 17:35:25.796166 |
| RX25102200059901 | LBCC-26BAROUDEUR velo男款背带短裤-头版-YS9134MIAO | XS | 袁日仙 | 324388 | 369483 | 2026-03-09 18:02:01 | 1 | 2026-03-22 17:35:25.794451 |
| YY26020700019903 | ALIAS-PRO男款背带短裤-头版-YS2047MAYO | M | 刘莹滢 | 329731 | 369485 | 2026-03-09 18:03:40 | 1 | 2026-03-22 17:35:25.792880 |
| MJ26030400049904 | Bythlon Red-1男款T恤-头版-YS9068MKAO | L | 庄镘洁 | 329740 | 369488 | 2026-03-09 18:07:10 | 1 | 2026-03-22 17:35:25.791293 |
| MJ26030400039904 | Bythlon Red-2男款T恤-头版-YS9068MKAO | L | 庄镘洁 | 329740 | 369488 | 2026-03-09 18:07:10 | 1 | 2026-03-22 17:35:25.789718 |
| DZ266300049902 | 凯乐石VM2655001白色半指手套 | S | 黄瑞辉 | 329499 | 369614 | 2026-03-10 09:24:25 | 1 | 2026-03-22 17:35:25.788093 |
| DZ266300039903 | 凯乐石VM2655001黑色半指手套 | M | 黄瑞辉 | 329499 | 369614 | 2026-03-10 09:24:25 | 1 | 2026-03-22 17:35:25.785933 |
| ZT25052600029904 | PARIA25 Grain男款跑步短裤-YS2211MO | L | 曾亭 | 323288 | 369647 | 2026-03-10 10:38:54 | 3 | 2026-03-22 17:35:25.758219 |
| ZT25052600029905 | PARIA25 Grain男款跑步短裤-YS2211MO | XL | 曾亭 | 323288 | 369647 | 2026-03-10 10:38:54 | 2 | 2026-03-22 17:35:25.755938 |
| ZT25052600029903 | PARIA25 Grain男款跑步短裤-YS2211MO | M | 曾亭 | 323288 | 369647 | 2026-03-10 10:38:54 | 3 | 2026-03-22 17:35:25.753199 |
| ZT25052600029902 | PARIA25 Grain男款跑步短裤-YS2211MO | S | 曾亭 | 323288 | 369647 | 2026-03-10 10:38:54 | 2 | 2026-03-22 17:35:25.699365 |
| ZT25120300139906 | PARIA25 Leopard男款跑步短裤-头版-YS2211MO | 2XL | 曾亭 | 323288 | 369647 | 2026-03-10 10:38:54 | 1 | 2026-03-22 17:35:25.697202 |
| ZT25120300139905 | PARIA25 Leopard男款跑步短裤-头版-YS2211MO | XL | 曾亭 | 323288 | 369647 | 2026-03-10 10:38:54 | 2 | 2026-03-22 17:35:25.694981 |
| ZT25120300139904 | PARIA25 Leopard男款跑步短裤-头版-YS2211MO | L | 曾亭 | 323288 | 369647 | 2026-03-10 10:38:54 | 4 | 2026-03-22 17:35:25.692819 |
| ZT25120300139902 | PARIA25 Leopard男款跑步短裤-头版-YS2211MO | S | 曾亭 | 323288 | 369647 | 2026-03-10 10:38:54 | 2 | 2026-03-22 17:35:25.690620 |
| ZT25120300139903 | PARIA25 Leopard男款跑步短裤-头版-YS2211MO | M | 曾亭 | 323288 | 369647 | 2026-03-10 10:38:54 | 4 | 2026-03-22 17:35:25.688442 |
| ZT25120300129906 | PARIA25 Black Core男款跑步短裤-头版-YS2211MO | 2XL | 曾亭 | 323288 | 369647 | 2026-03-10 10:38:54 | 2 | 2026-03-22 17:35:25.686243 |
| ZT25120300129905 | PARIA25 Black Core男款跑步短裤-头版-YS2211MO | XL | 曾亭 | 323288 | 369647 | 2026-03-10 10:38:54 | 3 | 2026-03-22 17:35:25.684015 |