到货库存导入(采购入库 Excel)
系统会从 Excel 中抓取:款式编号(清洗为SKU)、款式SKU、颜色及规格(提取尺码)、数量、商品名称、运营仓库、采购单号、入仓单号、采购员、入库日期。
库存汇总
| 产品SKU | 中文名 | 尺码 | 采购员 | 采购单号 | 入仓单号 | 入库日期 | 当前库存 | 更新时间 |
|---|---|---|---|---|---|---|---|---|
| LF26010700149905 | PD-TRIDENT男款跑步背心-头版-YS9787M | XL | 罗兰方 | 316262 | 354093 | 2026-01-20 16:37:27 | 3 | 2026-03-22 17:35:46.368995 |
| LF26010700149904 | PD-TRIDENT男款跑步背心-头版-YS9787M | L | 罗兰方 | 316262 | 354093 | 2026-01-20 16:37:27 | 3 | 2026-03-22 17:35:46.367227 |
| LF26010700149902 | PD-TRIDENT男款跑步背心-头版-YS9787M | S | 罗兰方 | 316262 | 354093 | 2026-01-20 16:37:27 | 1 | 2026-03-22 17:35:46.365322 |
| LF26010700149912 | PD-TRIDENT男款跑步背心-头版-YS9787M | 3XS | 罗兰方 | 316262 | 354093 | 2026-01-20 16:37:27 | 1 | 2026-03-22 17:35:46.363418 |
| RX25122200189905 | WYLD-coffee男款短上衣-头版-YS9470MQT | XL | 袁日仙 | 314029 | 354094 | 2026-01-20 16:39:49 | 2 | 2026-03-22 17:35:46.361419 |
| RX25122200189904 | WYLD-coffee男款短上衣-头版-YS9470MQT | L | 袁日仙 | 314029 | 354094 | 2026-01-20 16:39:49 | 1 | 2026-03-22 17:35:46.359891 |
| RX25122200179904 | WYLD-coffee女款短上衣-头版-YS9470WZAT | L | 袁日仙 | 314029 | 354094 | 2026-01-20 16:39:49 | 1 | 2026-03-22 17:35:46.358068 |
| RX25122200179903 | WYLD-coffee女款短上衣-头版-YS9470WZAT | M | 袁日仙 | 314029 | 354094 | 2026-01-20 16:39:49 | 1 | 2026-03-22 17:35:46.356277 |
| RX25122200179902 | WYLD-coffee女款短上衣-头版-YS9470WZAT | S | 袁日仙 | 314029 | 354094 | 2026-01-20 16:39:49 | 1 | 2026-03-22 17:35:46.354654 |
| RX25122200179901 | WYLD-coffee女款短上衣-头版-YS9470WZAT | XS | 袁日仙 | 314029 | 354094 | 2026-01-20 16:39:49 | 1 | 2026-03-22 17:35:46.352567 |
| ZT25110800159903 | MUMU Winter25抓绒护臂-头版-YS9935MPO | M | 曾亭 | 318089 | 354096 | 2026-01-20 16:41:05 | 3 | 2026-03-22 17:35:46.299493 |
| ZT25110800159902 | MUMU Winter25抓绒护臂-头版-YS9935MPO | S | 曾亭 | 318089 | 354096 | 2026-01-20 16:41:05 | 11 | 2026-03-22 17:35:46.297937 |
| ZT25110800159901 | MUMU Winter25抓绒护臂-头版-YS9935MPO | XS | 曾亭 | 318089 | 354096 | 2026-01-20 16:41:05 | 3 | 2026-03-22 17:35:46.296181 |
| LF25123000119906 | TG-Tutti-Frutti Morzine男款长上衣-头版-YS9605MAEO | 2XL | 罗兰方 | 316823 | 354097 | 2026-01-20 16:41:29 | 10 | 2026-03-22 17:35:46.294606 |
| LF25123000119905 | TG-Tutti-Frutti Morzine男款长上衣-头版-YS9605MAEO | XL | 罗兰方 | 316823 | 354097 | 2026-01-20 16:41:29 | 60 | 2026-03-22 17:35:46.292969 |
| LF25123000119904 | TG-Tutti-Frutti Morzine男款长上衣-头版-YS9605MAEO | L | 罗兰方 | 316823 | 354097 | 2026-01-20 16:41:29 | 90 | 2026-03-22 17:35:46.291268 |
| LF25123000119903 | TG-Tutti-Frutti Morzine男款长上衣-头版-YS9605MAEO | M | 罗兰方 | 316823 | 354097 | 2026-01-20 16:41:29 | 90 | 2026-03-22 17:35:46.289729 |
| LF25123000119902 | TG-Tutti-Frutti Morzine男款长上衣-头版-YS9605MAEO | S | 罗兰方 | 316823 | 354097 | 2026-01-20 16:41:29 | 30 | 2026-03-22 17:35:46.288183 |
| LF25123000119901 | TG-Tutti-Frutti Morzine男款长上衣-头版-YS9605MAEO | XS | 罗兰方 | 316823 | 354097 | 2026-01-20 16:41:29 | 20 | 2026-03-22 17:35:46.286296 |
| RX25112200439905 | LBCC-26 PODIUM PRO LATE RELEASE男款短上衣-二版-YS9406MKBO | XL | 袁日仙 | 308441 | 354098 | 2026-01-20 16:42:37 | 5 | 2026-03-22 17:35:46.284775 |