到货库存导入(采购入库 Excel)
系统会从 Excel 中抓取:款式编号(清洗为SKU)、款式SKU、颜色及规格(提取尺码)、数量、商品名称、运营仓库、采购单号、入仓单号、采购员、入库日期。
库存汇总
| 产品SKU | 中文名 | 尺码 | 采购员 | 采购单号 | 入仓单号 | 入库日期 | 当前库存 | 更新时间 |
|---|---|---|---|---|---|---|---|---|
| MY25122000039904 | BRB男款长上衣-头版-YS8235M | L | 胡美英 | 312626 | 348197 | 2026-01-03 15:33:21 | 1 | 2026-03-22 17:35:54.581562 |
| MY25122000039902 | BRB男款长上衣-头版-YS8235M | S | 胡美英 | 312626 | 348197 | 2026-01-03 15:33:21 | 1 | 2026-03-22 17:35:54.580057 |
| RX25122000419905 | Jlife-Raid MTB 2025-A男款短上衣-头版-YS9410MYE | XL | 袁日仙 | 313204 | 348198 | 2026-01-03 15:33:53 | 2 | 2026-03-22 17:35:54.578520 |
| RX25122000419904 | Jlife-Raid MTB 2025-A男款短上衣-头版-YS9410MYE | L | 袁日仙 | 313204 | 348198 | 2026-01-03 15:33:53 | 5 | 2026-03-22 17:35:54.577000 |
| RX25122000419903 | Jlife-Raid MTB 2025-A男款短上衣-头版-YS9410MYE | M | 袁日仙 | 313204 | 348198 | 2026-01-03 15:33:53 | 1 | 2026-03-22 17:35:54.575424 |
| RX25122000409904 | Jlife-Raid MTB 2025-A女款短上衣-头版-YS9410WYA | L | 袁日仙 | 313204 | 348198 | 2026-01-03 15:33:53 | 3 | 2026-03-22 17:35:54.573793 |
| RX25122000409903 | Jlife-Raid MTB 2025-A女款短上衣-头版-YS9410WYA | M | 袁日仙 | 313204 | 348198 | 2026-01-03 15:33:53 | 1 | 2026-03-22 17:35:54.572235 |
| YK25122200019900 | NORIN接筒袜-头版-YS9940EC | F | 何咏凯 | 313987 | 348199 | 2026-01-03 15:34:50 | 3 | 2026-03-22 17:35:54.570472 |
| RX25120600289903 | SG-VCGH IBEX女款防风背心-头版-YS9826WAO | M | 袁日仙 | 309586 | 348200 | 2026-01-03 15:35:17 | 1 | 2026-03-22 17:35:54.568936 |
| RX2412300189904 | Trititan racing team-A男款短上衣-YS8008M | L | 袁日仙 | 311695 | 348201 | 2026-01-03 15:35:40 | 3 | 2026-03-22 17:35:54.567348 |
| ZT25120600139907 | Hewitt男款短上衣-头版-YS9409MEKO | 3XL | 曾亭 | 309281 | 348202 | 2026-01-03 15:36:04 | 1 | 2026-03-22 17:35:54.565785 |
| ZT25120600139905 | Hewitt男款短上衣-头版-YS9409MEKO | XL | 曾亭 | 309281 | 348202 | 2026-01-03 15:36:04 | 4 | 2026-03-22 17:35:54.564255 |
| ZT25120600139904 | Hewitt男款短上衣-头版-YS9409MEKO | L | 曾亭 | 309281 | 348202 | 2026-01-03 15:36:04 | 6 | 2026-03-22 17:35:54.562617 |
| ZT25120600139903 | Hewitt男款短上衣-头版-YS9409MEKO | M | 曾亭 | 309281 | 348202 | 2026-01-03 15:36:04 | 6 | 2026-03-22 17:35:54.561009 |
| ZT25120600139902 | Hewitt男款短上衣-头版-YS9409MEKO | S | 曾亭 | 309281 | 348202 | 2026-01-03 15:36:04 | 4 | 2026-03-22 17:35:54.559482 |
| ZT25120600139901 | Hewitt男款短上衣-头版-YS9409MEKO | XS | 曾亭 | 309281 | 348202 | 2026-01-03 15:36:04 | 1 | 2026-03-22 17:35:54.557957 |
| LF2403270419904 | 24Degree童装短上衣-CD042 | L | 罗兰方 | 311663 | 348203 | 2026-01-03 15:36:40 | 8 | 2026-03-22 17:35:54.556303 |
| LF2403270419903 | 24Degree童装短上衣-CD042 | M | 罗兰方 | 311663 | 348203 | 2026-01-03 15:36:40 | 8 | 2026-03-22 17:35:54.554723 |
| LF2403270419902 | 24Degree童装短上衣-CD042 | S | 罗兰方 | 311663 | 348203 | 2026-01-03 15:36:40 | 8 | 2026-03-22 17:35:54.553163 |
| LF2403270419901 | 24Degree童装短上衣-CD042 | XS | 罗兰方 | 311663 | 348203 | 2026-01-03 15:36:40 | 2 | 2026-03-22 17:35:54.550773 |