到货库存导入(采购入库 Excel)
系统会从 Excel 中抓取:款式编号(清洗为SKU)、款式SKU、颜色及规格(提取尺码)、数量、商品名称、运营仓库、采购单号、入仓单号、采购员、入库日期。
库存汇总
| 产品SKU | 中文名 | 尺码 | 采购员 | 采购单号 | 入仓单号 | 入库日期 | 当前库存 | 更新时间 |
|---|---|---|---|---|---|---|---|---|
| ZT25121700129903 | USF 26男款短上衣-头版-YS9409MEKO | M | 曾亭 | 319928 | 357091 | 2026-01-29 11:43:24 | 1 | 2026-03-22 17:35:40.553724 |
| ZT25121700129902 | USF 26男款短上衣-头版-YS9409MEKO | S | 曾亭 | 319928 | 357091 | 2026-01-29 11:43:24 | 2 | 2026-03-22 17:35:40.551409 |
| RX26010700469903 | 26Stelvio-E8接筒袜-二版-YS9940EAN | M | 袁日仙 | 316772 | 357092 | 2026-01-29 11:43:43 | 10 | 2026-03-22 17:35:40.498842 |
| RX26010700469902 | 26Stelvio-E8接筒袜-二版-YS9940EAN | S | 袁日仙 | 316772 | 357092 | 2026-01-29 11:43:43 | 10 | 2026-03-22 17:35:40.497320 |
| RX26010700359900 | 26Stelvio-F3小布帽-二版-4181 | F | 袁日仙 | 316610 | 357093 | 2026-01-29 11:44:17 | 50 | 2026-03-22 17:35:40.495802 |
| RX26011000429900 | 24Stelvio-Triwhite小布帽-二版-YS9917X | F | 袁日仙 | 318898 | 357094 | 2026-01-29 11:44:47 | 20 | 2026-03-22 17:35:40.494249 |
| RX26011000419900 | 24Stelvio-Triblack小布帽-二版-YS9917X | F | 袁日仙 | 318898 | 357094 | 2026-01-29 11:44:47 | 20 | 2026-03-22 17:35:40.492712 |
| RX26010700599900 | 26Stelvio小布帽-二版-YS4098 | F | 袁日仙 | 317113 | 357101 | 2026-01-29 13:31:14 | 30 | 2026-03-22 17:35:40.491186 |
| RX26010700579900 | 26Stelvio beanies-F2小布帽-头版-YS4098 | F | 袁日仙 | 317113 | 357101 | 2026-01-29 13:31:14 | 30 | 2026-03-22 17:35:40.489621 |
| RX26010700569900 | 26Stelvio beanies-F3小布帽-头版-YS4098 | F | 袁日仙 | 317113 | 357101 | 2026-01-29 13:31:14 | 30 | 2026-03-22 17:35:40.488106 |
| JN26011000119904 | PW BHY redblack男款短袖连体衣-头版-YS9251MGIO | L | 陈锦娜 | 318323 | 357111 | 2026-01-29 13:49:15 | 1 | 2026-03-22 17:35:40.486214 |
| JN26011000119903 | PW BHY redblack男款短袖连体衣-头版-YS9251MGIO | M | 陈锦娜 | 318323 | 357111 | 2026-01-29 13:49:15 | 1 | 2026-03-22 17:35:40.484581 |
| ZT26011700329902 | Penske red男款短上衣-头版-YS9409MEKO | S | 曾亭 | 320022 | 357112 | 2026-01-29 13:49:54 | 1 | 2026-03-22 17:35:40.483043 |
| RX26011700209904 | Kiwiman男款短上衣-头版-YS9409MAVO | L | 袁日仙 | 319290 | 357113 | 2026-01-29 13:50:26 | 7 | 2026-03-22 17:35:40.481446 |
| RX26011700209905 | Kiwiman男款短上衣-头版-YS9409MAVO | XL | 袁日仙 | 319290 | 357113 | 2026-01-29 13:50:26 | 5 | 2026-03-22 17:35:40.479939 |
| RX26011700209903 | Kiwiman男款短上衣-头版-YS9409MAVO | M | 袁日仙 | 319290 | 357113 | 2026-01-29 13:50:26 | 3 | 2026-03-22 17:35:40.478374 |
| RX26011700209902 | Kiwiman男款短上衣-头版-YS9409MAVO | S | 袁日仙 | 319290 | 357113 | 2026-01-29 13:50:26 | 1 | 2026-03-22 17:35:40.476817 |
| LF2410230089907 | PD-PEDAL男款短上衣-CY105MFB | 3XL | 罗兰方 | 319930 | 357114 | 2026-01-29 13:51:31 | 1 | 2026-03-22 17:35:40.475248 |
| LF2410230089904 | PD-PEDAL男款短上衣-CY105MFB | L | 罗兰方 | 319930 | 357114 | 2026-01-29 13:51:31 | 1 | 2026-03-22 17:35:40.473544 |
| LF2410230089903 | PD-PEDAL男款短上衣-CY105MFB | M | 罗兰方 | 319930 | 357114 | 2026-01-29 13:51:31 | 2 | 2026-03-22 17:35:40.472026 |