到货库存导入(采购入库 Excel)
系统会从 Excel 中抓取:款式编号(清洗为SKU)、款式SKU、颜色及规格(提取尺码)、数量、商品名称、运营仓库、采购单号、入仓单号、采购员、入库日期。
库存汇总
| 产品SKU | 中文名 | 尺码 | 采购员 | 采购单号 | 入仓单号 | 入库日期 | 当前库存 | 更新时间 |
|---|---|---|---|---|---|---|---|---|
| WT26011000089903 | ALIAS-Jamison男款短上衣-头版-YS9663MBUO | M | 黄婉婷 | 318785 | 357497 | 2026-01-30 11:24:28 | 9 | 2026-03-22 17:35:39.488096 |
| RX26012600019907 | Goat dark女款防风背心-头版-YS9828WAO | 3XL | 袁日仙 | 319547 | 357498 | 2026-01-30 11:25:01 | 2 | 2026-03-22 17:35:39.486489 |
| RX26012600019906 | Goat dark女款防风背心-头版-YS9828WAO | 2XL | 袁日仙 | 319547 | 357498 | 2026-01-30 11:25:01 | 2 | 2026-03-22 17:35:39.485005 |
| RX26012600019905 | Goat dark女款防风背心-头版-YS9828WAO | XL | 袁日仙 | 319547 | 357498 | 2026-01-30 11:25:01 | 4 | 2026-03-22 17:35:39.483492 |
| RX26012600019904 | Goat dark女款防风背心-头版-YS9828WAO | L | 袁日仙 | 319547 | 357498 | 2026-01-30 11:25:01 | 4 | 2026-03-22 17:35:39.481970 |
| RX26012600019903 | Goat dark女款防风背心-头版-YS9828WAO | M | 袁日仙 | 319547 | 357498 | 2026-01-30 11:25:01 | 4 | 2026-03-22 17:35:39.480422 |
| RX26012600019902 | Goat dark女款防风背心-头版-YS9828WAO | S | 袁日仙 | 319547 | 357498 | 2026-01-30 11:25:01 | 2 | 2026-03-22 17:35:39.478855 |
| DQ20230110019910 | BONAVELO男款背带短裤-CD038MDO | 6XL | 吕丹琪 | 319572 | 357499 | 2026-01-30 11:25:25 | 25 | 2026-03-22 17:35:39.476969 |
| DQ20230110019909 | BONAVELO男款背带短裤-CD038MDO | 5XL | 吕丹琪 | 319572 | 357499 | 2026-01-30 11:25:25 | 10 | 2026-03-22 17:35:39.475398 |
| DQ20230110019907 | BONAVELO男款背带短裤-CD038MDO | 3XL | 吕丹琪 | 319572 | 357499 | 2026-01-30 11:25:25 | 30 | 2026-03-22 17:35:39.473858 |
| DQ20230110019908 | BONAVELO男款背带短裤-CD038MDO | 4XL | 吕丹琪 | 319572 | 357499 | 2026-01-30 11:25:25 | 30 | 2026-03-22 17:35:39.472269 |
| DQ20230110019906 | BONAVELO男款背带短裤-CD038MDO | 2XL | 吕丹琪 | 319572 | 357499 | 2026-01-30 11:25:25 | 50 | 2026-03-22 17:35:39.470614 |
| DQ20230110019902 | BONAVELO男款背带短裤-CD038MDO | S | 吕丹琪 | 319572 | 357499 | 2026-01-30 11:25:25 | 30 | 2026-03-22 17:35:39.469025 |
| DQ20230110019901 | BONAVELO男款背带短裤-CD038MDO | XS | 吕丹琪 | 319572 | 357499 | 2026-01-30 11:25:25 | 20 | 2026-03-22 17:35:39.464522 |
| ZT26011400079905 | NVR pocket green男款跑步短裤-头版-YS2211MGO | XL | 曾亭 | 318919 | 357500 | 2026-01-30 11:25:50 | 5 | 2026-03-22 17:35:39.462661 |
| ZT26011400079904 | NVR pocket green男款跑步短裤-头版-YS2211MGO | L | 曾亭 | 318919 | 357500 | 2026-01-30 11:25:50 | 15 | 2026-03-22 17:35:39.460291 |
| ZT26011400079903 | NVR pocket green男款跑步短裤-头版-YS2211MGO | M | 曾亭 | 318919 | 357500 | 2026-01-30 11:25:50 | 21 | 2026-03-22 17:35:39.458717 |
| ZT26011400079902 | NVR pocket green男款跑步短裤-头版-YS2211MGO | S | 曾亭 | 318919 | 357500 | 2026-01-30 11:25:50 | 10 | 2026-03-22 17:35:39.457148 |
| DQ20230425069905 | National23-C男款短上衣-CD034MVO | XL | 吕丹琪 | 319581 | 357625 | 2026-01-30 16:24:01 | 10 | 2026-03-22 17:35:39.455556 |
| DQ20230425069904 | National23-C男款短上衣-CD034MVO | L | 吕丹琪 | 319581 | 357625 | 2026-01-30 16:24:01 | 20 | 2026-03-22 17:35:39.453926 |