到货库存导入(采购入库 Excel)
系统会从 Excel 中抓取:款式编号(清洗为SKU)、款式SKU、颜色及规格(提取尺码)、数量、商品名称、运营仓库、采购单号、入仓单号、采购员、入库日期。
库存汇总
| 产品SKU | 中文名 | 尺码 | 采购员 | 采购单号 | 入仓单号 | 入库日期 | 当前库存 | 更新时间 |
|---|---|---|---|---|---|---|---|---|
| ZT25123001099905 | DHL25 Carbon LW男款T恤-头版-YS9068MT | XL | 曾亭 | 315527 | 352596 | 2026-01-16 15:56:07 | 25 | 2026-03-22 17:35:48.288511 |
| ZT25123001099903 | DHL25 Carbon LW男款T恤-头版-YS9068MT | M | 曾亭 | 315527 | 352596 | 2026-01-16 15:56:07 | 15 | 2026-03-22 17:35:48.286960 |
| ZT25123001099904 | DHL25 Carbon LW男款T恤-头版-YS9068MT | L | 曾亭 | 315527 | 352596 | 2026-02-27 15:52:16 | 36 | 2026-03-22 17:35:48.286849 |
| ZT25123001099902 | DHL25 Carbon LW男款T恤-头版-YS9068MT | S | 曾亭 | 315527 | 352596 | 2026-01-16 15:56:07 | 6 | 2026-03-22 17:35:48.284360 |
| ZT25123001099901 | DHL25 Carbon LW男款T恤-头版-YS9068MT | XS | 曾亭 | 315527 | 352596 | 2026-01-16 15:56:07 | 6 | 2026-03-22 17:35:48.282786 |
| LF26010700179905 | AMRUN-MILES男款T恤-头版-YS9068MYH | XL | 罗兰方 | 317290 | 352597 | 2026-01-16 15:57:05 | 2 | 2026-03-22 17:35:48.281221 |
| ZT26010700329903 | ELEVEN 26男款短上衣-头版-YS9409MEKO | M | 曾亭 | 316862 | 352654 | 2026-01-16 17:16:36 | 6 | 2026-03-22 17:35:48.279611 |
| ZT26010700329904 | ELEVEN 26男款短上衣-头版-YS9409MEKO | L | 曾亭 | 316862 | 352654 | 2026-03-17 10:31:14 | 4 | 2026-03-22 17:35:48.279502 |
| ZT26010700329902 | ELEVEN 26男款短上衣-头版-YS9409MEKO | S | 曾亭 | 316862 | 352654 | 2026-01-16 17:16:36 | 1 | 2026-03-22 17:35:48.277046 |
| LF25123000089906 | THREELINES-BRASS男款T恤-头版-YS9492MBKO | 2XL | 罗兰方 | 317014 | 352655 | 2026-01-16 17:17:23 | 10 | 2026-03-22 17:35:48.275491 |
| LF25123000089905 | THREELINES-BRASS男款T恤-头版-YS9492MBKO | XL | 罗兰方 | 317014 | 352655 | 2026-01-16 17:17:23 | 20 | 2026-03-22 17:35:48.273937 |
| LF25123000089904 | THREELINES-BRASS男款T恤-头版-YS9492MBKO | L | 罗兰方 | 317014 | 352655 | 2026-01-16 17:17:23 | 25 | 2026-03-22 17:35:48.272394 |
| LF25123000089903 | THREELINES-BRASS男款T恤-头版-YS9492MBKO | M | 罗兰方 | 317014 | 352655 | 2026-01-16 17:17:23 | 20 | 2026-03-22 17:35:48.270790 |
| LF25123000089902 | THREELINES-BRASS男款T恤-头版-YS9492MBKO | S | 罗兰方 | 317014 | 352655 | 2026-01-16 17:17:23 | 10 | 2026-03-22 17:35:48.269229 |
| RX25120300189907 | BNECC Club 2022-C男款短上衣-二版-YS9408MY | 3XL | 袁日仙 | 314953 | 352656 | 2026-01-16 17:17:51 | 3 | 2026-03-22 17:35:48.267643 |
| RX25120300189903 | BNECC Club 2022-C男款短上衣-二版-YS9408MY | M | 袁日仙 | 314953 | 352656 | 2026-01-16 17:17:51 | 3 | 2026-03-22 17:35:48.266078 |
| RX25120300189906 | BNECC Club 2022-C男款短上衣-二版-YS9408MY | 2XL | 袁日仙 | 314953 | 352656 | 2026-03-17 10:30:18 | 5 | 2026-03-22 17:35:48.265966 |
| WT26010700039903 | ALIAS-Lando男款背带短裤-头版-YS2128MCO | M | 黄婉婷 | 316046 | 352659 | 2026-01-16 17:19:53 | 3 | 2026-03-22 17:35:48.263418 |
| YL26010700069903 | AZ tee green-1男款长衬衫-头版-YS8236M | M | 甘雅玲 | 317405 | 352663 | 2026-01-16 17:22:28 | 1 | 2026-03-22 17:35:48.261853 |
| YL26010700089903 | AZ shirt white-1男款短衬衫-头版-YS8223MD | M | 甘雅玲 | 317407 | 352665 | 2026-01-16 17:23:39 | 1 | 2026-03-22 17:35:48.260139 |