到货库存导入(采购入库 Excel)
系统会从 Excel 中抓取:款式编号(清洗为SKU)、款式SKU、颜色及规格(提取尺码)、数量、商品名称、运营仓库、采购单号、入仓单号、采购员、入库日期。
库存汇总
| 产品SKU | 中文名 | 尺码 | 采购员 | 采购单号 | 入仓单号 | 入库日期 | 当前库存 | 更新时间 |
|---|---|---|---|---|---|---|---|---|
| YL26022800039905 | Trailrider Forest男款长上衣-头版-YS9492MXV | XL | 甘雅玲 | 329490 | 370213 | 2026-03-11 10:36:09 | 2 | 2026-03-22 17:35:25.100070 |
| YL26022800039904 | Trailrider Forest男款长上衣-头版-YS9492MXV | L | 甘雅玲 | 329490 | 370213 | 2026-03-11 10:36:09 | 4 | 2026-03-22 17:35:25.098079 |
| YL26022800039903 | Trailrider Forest男款长上衣-头版-YS9492MXV | M | 甘雅玲 | 329490 | 370213 | 2026-03-11 10:36:09 | 5 | 2026-03-22 17:35:25.095993 |
| YL26022800039901 | Trailrider Forest男款长上衣-头版-YS9492MXV | XS | 甘雅玲 | 329490 | 370213 | 2026-03-11 10:36:09 | 1 | 2026-03-22 17:35:25.094002 |
| ZT25090500039904 | BBR男款背带短裤-YS2196MO | L | 曾亭 | 327521 | 370215 | 2026-03-11 10:37:28 | 3 | 2026-03-22 17:35:25.092042 |
| ZT25090500039903 | BBR男款背带短裤-YS2196MO | M | 曾亭 | 327521 | 370215 | 2026-03-11 10:37:28 | 3 | 2026-03-22 17:35:25.089979 |
| ZT25090500039902 | BBR男款背带短裤-YS2196MO | S | 曾亭 | 327521 | 370215 | 2026-03-11 10:37:28 | 1 | 2026-03-22 17:35:25.087969 |
| RX25022600219904 | Aleon-Ruedas SJM男款短袖连体衣-YS9230MKB | L | 袁日仙 | 326387 | 370217 | 2026-03-11 10:38:17 | 1 | 2026-03-22 17:35:25.085928 |
| WT26013100049904 | spatz OC Fasta男款短上衣-头版-YS8053MB | L | 黄婉婷 | 324504 | 370218 | 2026-03-11 10:38:54 | 2 | 2026-03-22 17:35:25.083910 |
| WT26013100049903 | spatz OC Fasta男款短上衣-头版-YS8053MB | M | 黄婉婷 | 324504 | 370218 | 2026-03-11 10:38:54 | 5 | 2026-03-22 17:35:25.081805 |
| WT26013100049902 | spatz OC Fasta男款短上衣-头版-YS8053MB | S | 黄婉婷 | 324504 | 370218 | 2026-03-11 10:38:54 | 5 | 2026-03-22 17:35:25.079647 |
| YY25110800089903 | WT CTC Black Mitte男款T恤-头版-YS9681MO | M | 凌碧红 | 330234 | 370220 | 2026-03-11 10:40:44 | 1 | 2026-03-22 17:35:25.077457 |
| RX26012400279901 | SG-SOCKET SHADOW半指手套-MT018 | XS | 袁日仙 | 328607 | 370236 | 2026-03-11 11:12:43 | 2 | 2026-03-22 17:35:25.075320 |
| RX26012400279906 | SG-SOCKET SHADOW半指手套-MT018 | 2XL | 袁日仙 | 328607 | 370236 | 2026-03-11 11:12:43 | 2 | 2026-03-22 17:35:25.072927 |
| RX26012400279905 | SG-SOCKET SHADOW半指手套-MT018 | XL | 袁日仙 | 328607 | 370236 | 2026-03-11 11:12:43 | 10 | 2026-03-22 17:35:25.070487 |
| RX26012400279904 | SG-SOCKET SHADOW半指手套-MT018 | L | 袁日仙 | 328607 | 370236 | 2026-03-11 11:12:43 | 18 | 2026-03-22 17:35:25.068285 |
| RX26012400279903 | SG-SOCKET SHADOW半指手套-MT018 | M | 袁日仙 | 328607 | 370236 | 2026-03-11 11:12:43 | 20 | 2026-03-22 17:35:25.066097 |
| RX26012400279902 | SG-SOCKET SHADOW半指手套-MT018 | S | 袁日仙 | 328607 | 370236 | 2026-03-11 11:12:43 | 5 | 2026-03-22 17:35:25.063938 |
| RX26012400269906 | SG-BATISTE半指手套-MT018 | 2XL | 袁日仙 | 328607 | 370236 | 2026-03-11 11:12:43 | 2 | 2026-03-22 17:35:25.061595 |
| RX26012400269905 | SG-BATISTE半指手套-MT018 | XL | 袁日仙 | 328607 | 370236 | 2026-03-11 11:12:43 | 10 | 2026-03-22 17:35:25.059323 |