到货库存导入(采购入库 Excel)
系统会从 Excel 中抓取:款式编号(清洗为SKU)、款式SKU、颜色及规格(提取尺码)、数量、商品名称、运营仓库、采购单号、入仓单号、采购员、入库日期。
库存汇总
| 产品SKU | 中文名 | 尺码 | 采购员 | 采购单号 | 入仓单号 | 入库日期 | 当前库存 | 更新时间 |
|---|---|---|---|---|---|---|---|---|
| DQ210310019904 | BONAVELOTT半指手套-YS17033 | L | 吕丹琪 | 318088 | 358646 | 2026-02-02 18:18:51 | 120 | 2026-03-22 17:35:36.986153 |
| DQ210310019903 | BONAVELOTT半指手套-YS17033 | M | 吕丹琪 | 318088 | 358646 | 2026-02-02 18:18:51 | 70 | 2026-03-22 17:35:36.984208 |
| DQ2402290079902 | Rivanelle-Black半指手套-MT018 | S | 吕丹琪 | 318092 | 358647 | 2026-02-02 18:19:20 | 30 | 2026-03-22 17:35:36.982436 |
| DQ202312260119903 | Rivanelle-WHITE-1半指手套 | M | 吕丹琪 | 318092 | 358647 | 2026-02-02 18:19:20 | 20 | 2026-03-22 17:35:36.980678 |
| ZT26011400179906 | BH 26 white半指手套 | 2XL | 曾亭 | 318132 | 358648 | 2026-02-02 18:20:03 | 1 | 2026-03-22 17:35:36.978931 |
| ZT26011400179905 | BH 26 white半指手套 | XL | 曾亭 | 318132 | 358648 | 2026-02-02 18:20:03 | 5 | 2026-03-22 17:35:36.977361 |
| ZT26011400179904 | BH 26 white半指手套 | L | 曾亭 | 318132 | 358648 | 2026-02-02 18:20:03 | 11 | 2026-03-22 17:35:36.975846 |
| ZT26011400179903 | BH 26 white半指手套 | M | 曾亭 | 318132 | 358648 | 2026-02-02 18:20:03 | 7 | 2026-03-22 17:35:36.974295 |
| ZT26011400179902 | BH 26 white半指手套 | S | 曾亭 | 318132 | 358648 | 2026-02-02 18:20:03 | 1 | 2026-03-22 17:35:36.972700 |
| ZT26011400179901 | BH 26 white半指手套 | XS | 曾亭 | 318132 | 358648 | 2026-02-02 18:20:03 | 1 | 2026-03-22 17:35:36.971101 |
| ZT25092500669906 | Alpha 25 Blue半指手套-YS17049O | 2XL | 曾亭 | 318177 | 358649 | 2026-02-02 18:20:35 | 1 | 2026-03-22 17:35:36.969420 |
| ZT25092500669905 | Alpha 25 Blue半指手套-YS17049O | XL | 曾亭 | 318177 | 358649 | 2026-02-02 18:20:35 | 6 | 2026-03-22 17:35:36.967639 |
| ZT25092500669904 | Alpha 25 Blue半指手套-YS17049O | L | 曾亭 | 318177 | 358649 | 2026-02-02 18:20:35 | 4 | 2026-03-22 17:35:36.966142 |
| ZT25092500669903 | Alpha 25 Blue半指手套-YS17049O | M | 曾亭 | 318177 | 358649 | 2026-02-02 18:20:35 | 5 | 2026-03-22 17:35:36.964593 |
| ZT25092500669902 | Alpha 25 Blue半指手套-YS17049O | S | 曾亭 | 318177 | 358649 | 2026-02-02 18:20:35 | 3 | 2026-03-22 17:35:36.963044 |
| ZT25092500669901 | Alpha 25 Blue半指手套-YS17049O | XS | 曾亭 | 318177 | 358649 | 2026-02-02 18:20:35 | 1 | 2026-03-22 17:35:36.961439 |
| WT26011700079905 | Centreafrique半指手套 | XL | 黄婉婷 | 318189 | 358650 | 2026-02-02 18:21:12 | 5 | 2026-03-22 17:35:36.959866 |
| WT26011700079904 | Centreafrique半指手套 | L | 黄婉婷 | 318189 | 358650 | 2026-02-02 18:21:12 | 5 | 2026-03-22 17:35:36.958295 |
| WT26011700079903 | Centreafrique半指手套 | M | 黄婉婷 | 318189 | 358650 | 2026-02-02 18:21:12 | 5 | 2026-03-22 17:35:36.956715 |
| WT26011700079902 | Centreafrique半指手套 | S | 黄婉婷 | 318189 | 358650 | 2026-02-02 18:21:12 | 5 | 2026-03-22 17:35:36.955177 |