到货库存导入(采购入库 Excel)
系统会从 Excel 中抓取:款式编号(清洗为SKU)、款式SKU、颜色及规格(提取尺码)、数量、商品名称、运营仓库、采购单号、入仓单号、采购员、入库日期。
库存汇总
| 产品SKU | 中文名 | 尺码 | 采购员 | 采购单号 | 入仓单号 | 入库日期 | 当前库存 | 更新时间 |
|---|---|---|---|---|---|---|---|---|
| WT26010700099902 | ALIAS-CCNS男款背带短裤-头版-YS2128MCO | S | 黄婉婷 | 316353 | 357861 | 2026-01-31 14:50:22 | 6 | 2026-03-22 17:35:38.788498 |
| WT26010700099901 | ALIAS-CCNS男款背带短裤-头版-YS2128MCO | XS | 黄婉婷 | 316353 | 357861 | 2026-01-31 14:50:22 | 2 | 2026-03-22 17:35:38.786724 |
| DQ20220506039907 | SLOVENIA 2022(EU)短上衣-CD034MV | 3XL | 吕丹琪 | 321985 | 357862 | 2026-01-31 14:51:08 | 5 | 2026-03-22 17:35:38.785159 |
| DQ20220506039906 | SLOVENIA 2022(EU)短上衣-CD034MV | 2XL | 吕丹琪 | 321985 | 357862 | 2026-01-31 14:51:08 | 15 | 2026-03-22 17:35:38.783541 |
| DQ20220506039905 | SLOVENIA 2022(EU)短上衣-CD034MV | XL | 吕丹琪 | 321985 | 357862 | 2026-01-31 14:51:08 | 15 | 2026-03-22 17:35:38.781690 |
| DQ20220506039904 | SLOVENIA 2022(EU)短上衣-CD034MV | L | 吕丹琪 | 321985 | 357862 | 2026-01-31 14:51:08 | 15 | 2026-03-22 17:35:38.779893 |
| DQ20220506039903 | SLOVENIA 2022(EU)短上衣-CD034MV | M | 吕丹琪 | 321985 | 357862 | 2026-01-31 14:51:08 | 5 | 2026-03-22 17:35:38.777986 |
| DQ20220506039902 | SLOVENIA 2022(EU)短上衣-CD034MV | S | 吕丹琪 | 321985 | 357862 | 2026-01-31 14:51:08 | 2 | 2026-03-22 17:35:38.776164 |
| RX26011000409900 | 24Stelvio-C19小布帽-二版-4181 | F | 袁日仙 | 318898 | 357864 | 2026-01-31 14:51:32 | 20 | 2026-03-22 17:35:38.773019 |
| MY26011400139905 | ENSO black 8112W女款跑步背心-头版-YS8112WO | XL | 胡美英 | 319738 | 357865 | 2026-01-31 14:53:47 | 1 | 2026-03-22 17:35:38.771216 |
| MY26011400139904 | ENSO black 8112W女款跑步背心-头版-YS8112WO | L | 胡美英 | 319738 | 357865 | 2026-01-31 14:53:47 | 2 | 2026-03-22 17:35:38.769635 |
| MY26011400139903 | ENSO black 8112W女款跑步背心-头版-YS8112WO | M | 胡美英 | 319738 | 357865 | 2026-01-31 14:53:47 | 2 | 2026-03-22 17:35:38.768135 |
| MY26011400139902 | ENSO black 8112W女款跑步背心-头版-YS8112WO | S | 胡美英 | 319738 | 357865 | 2026-01-31 14:53:47 | 5 | 2026-03-22 17:35:38.766556 |
| MY26011400139901 | ENSO black 8112W女款跑步背心-头版-YS8112WO | XS | 胡美英 | 319738 | 357865 | 2026-01-31 14:53:47 | 5 | 2026-03-22 17:35:38.764657 |
| RX26010700229906 | raw-26Nocturnal Drift-A男款短上衣-头版-YS9781MJO | 2XL | 袁日仙 | 316014 | 357867 | 2026-01-31 14:55:14 | 6 | 2026-03-22 17:35:38.763103 |
| RX26010700229905 | raw-26Nocturnal Drift-A男款短上衣-头版-YS9781MJO | XL | 袁日仙 | 316014 | 357867 | 2026-01-31 14:55:14 | 16 | 2026-03-22 17:35:38.761378 |
| RX26010700229903 | raw-26Nocturnal Drift-A男款短上衣-头版-YS9781MJO | M | 袁日仙 | 316014 | 357867 | 2026-01-31 14:55:14 | 14 | 2026-03-22 17:35:38.759802 |
| RX26010700229904 | raw-26Nocturnal Drift-A男款短上衣-头版-YS9781MJO | L | 袁日仙 | 316014 | 357867 | 2026-01-31 14:55:14 | 22 | 2026-03-22 17:35:38.758106 |
| RX26010700229902 | raw-26Nocturnal Drift-A男款短上衣-头版-YS9781MJO | S | 袁日仙 | 316014 | 357867 | 2026-01-31 14:55:14 | 12 | 2026-03-22 17:35:38.756563 |
| ZT26011000679903 | GetRAD sport女款背带短裤-头版-YS9149WJ | M | 曾亭 | 318039 | 357868 | 2026-01-31 14:55:43 | 1 | 2026-03-22 17:35:38.755040 |