到货库存导入(采购入库 Excel)
系统会从 Excel 中抓取:款式编号(清洗为SKU)、款式SKU、颜色及规格(提取尺码)、数量、商品名称、运营仓库、采购单号、入仓单号、采购员、入库日期。
库存汇总
| 产品SKU | 中文名 | 尺码 | 采购员 | 采购单号 | 入仓单号 | 入库日期 | 当前库存 | 更新时间 |
|---|---|---|---|---|---|---|---|---|
| RX25101000229902 | GC-Chemchamp 26女款背带短裤-头版-YS2101WBO | S | 袁日仙 | 326420 | 367923 | 2026-03-07 17:29:36 | 4 | 2026-03-22 17:35:26.399465 |
| RX25101000229901 | GC-Chemchamp 26女款背带短裤-头版-YS2101WBO | XS | 袁日仙 | 326420 | 367923 | 2026-03-07 17:29:36 | 4 | 2026-03-22 17:35:26.397910 |
| RX25071500149905 | SG-Ronde男款防风背心-YS9826MDO | XL | 袁日仙 | 327041 | 367924 | 2026-03-07 17:30:42 | 1 | 2026-03-22 17:35:26.396304 |
| RX25071500149903 | SG-Ronde男款防风背心-YS9826MDO | M | 袁日仙 | 327041 | 367924 | 2026-03-07 17:30:42 | 2 | 2026-03-22 17:35:26.394481 |
| ZT26013100399905 | Pastaria 26男款背带短裤-头版-YS9153MZD | XL | 曾亭 | 324492 | 367925 | 2026-03-07 17:32:13 | 4 | 2026-03-22 17:35:26.392599 |
| ZT26013100399904 | Pastaria 26男款背带短裤-头版-YS9153MZD | L | 曾亭 | 324492 | 367925 | 2026-03-07 17:32:13 | 5 | 2026-03-22 17:35:26.390636 |
| ZT26013100399903 | Pastaria 26男款背带短裤-头版-YS9153MZD | M | 曾亭 | 324492 | 367925 | 2026-03-07 17:32:13 | 6 | 2026-03-22 17:35:26.388413 |
| ZT26013100399902 | Pastaria 26男款背带短裤-头版-YS9153MZD | S | 曾亭 | 324492 | 367925 | 2026-03-07 17:32:13 | 5 | 2026-03-22 17:35:26.386417 |
| BH26013100069903 | MTB BFC Black 26男款短上衣-头版-YS9409MCD | M | 凌碧红 | 324482 | 367926 | 2026-03-07 17:32:39 | 7 | 2026-03-22 17:35:26.383653 |
| BH26013100069902 | MTB BFC Black 26男款短上衣-头版-YS9409MCD | S | 凌碧红 | 324482 | 367926 | 2026-03-07 17:32:39 | 5 | 2026-03-22 17:35:26.380800 |
| RX25092500269906 | GC-Restore男款短上衣-头版-YS9496MBLO | 2XL | 袁日仙 | 328967 | 369114 | 2026-03-09 10:48:28 | 2 | 2026-03-22 17:35:26.378058 |
| RX25092500269904 | GC-Restore男款短上衣-头版-YS9496MBLO | L | 袁日仙 | 328967 | 369114 | 2026-03-09 10:48:28 | 3 | 2026-03-22 17:35:26.375592 |
| WT25031500029905 | Rackd Element3 2025男款铁三短袖连体衣-YS9262MVBO | XL | 黄婉婷 | 326365 | 369116 | 2026-03-09 10:49:05 | 1 | 2026-03-22 17:35:26.373173 |
| WT25031500029904 | Rackd Element3 2025男款铁三短袖连体衣-YS9262MVBO | L | 黄婉婷 | 326365 | 369116 | 2026-03-09 10:49:05 | 1 | 2026-03-22 17:35:26.370789 |
| BH25120300039906 | Vector TRPH Blue男款短上衣-头版-YS9699MLK | 2XL | 凌碧红 | 324138 | 369118 | 2026-03-09 10:50:30 | 1 | 2026-03-22 17:35:26.368397 |
| BH25120300039905 | Vector TRPH Blue男款短上衣-头版-YS9699MLK | XL | 凌碧红 | 324138 | 369118 | 2026-03-09 10:50:30 | 4 | 2026-03-22 17:35:26.366039 |
| BH25120300039904 | Vector TRPH Blue男款短上衣-头版-YS9699MLK | L | 凌碧红 | 324138 | 369118 | 2026-03-09 10:50:30 | 3 | 2026-03-22 17:35:26.363655 |
| BH25120300039903 | Vector TRPH Blue男款短上衣-头版-YS9699MLK | M | 凌碧红 | 324138 | 369118 | 2026-03-09 10:50:30 | 4 | 2026-03-22 17:35:26.361242 |
| BH25120300019904 | Vector TRPH Navy男款短上衣-头版-YS9699MLK | L | 凌碧红 | 324138 | 369118 | 2026-03-09 10:50:30 | 2 | 2026-03-22 17:35:26.355935 |
| BH25120300019901 | Vector TRPH Navy男款短上衣-头版-YS9699MLK | XS | 凌碧红 | 324138 | 369118 | 2026-03-09 10:50:30 | 2 | 2026-03-22 17:35:26.298546 |