到货库存导入(采购入库 Excel)
系统会从 Excel 中抓取:款式编号(清洗为SKU)、款式SKU、颜色及规格(提取尺码)、数量、商品名称、运营仓库、采购单号、入仓单号、采购员、入库日期。
库存汇总
| 产品SKU | 中文名 | 尺码 | 采购员 | 采购单号 | 入仓单号 | 入库日期 | 当前库存 | 更新时间 |
|---|---|---|---|---|---|---|---|---|
| 1241220229903 | 骑锐背带短裤 | M | 黄婉婷 | 314085 | 357482 | 2026-01-30 11:11:58 | 1 | 2026-03-22 17:35:39.684023 |
| MJ26011700069904 | ALD Catalyst男款短上衣-头版-YS9470MQO | L | 庄镘洁 | 319785 | 357483 | 2026-01-30 11:13:13 | 2 | 2026-03-22 17:35:39.682457 |
| MJ26011700069903 | ALD Catalyst男款短上衣-头版-YS9470MQO | M | 庄镘洁 | 319785 | 357483 | 2026-01-30 11:13:13 | 8 | 2026-03-22 17:35:39.680683 |
| MJ26011700069902 | ALD Catalyst男款短上衣-头版-YS9470MQO | S | 庄镘洁 | 319785 | 357483 | 2026-01-30 11:13:13 | 8 | 2026-03-22 17:35:39.678991 |
| MJ26011700069901 | ALD Catalyst男款短上衣-头版-YS9470MQO | XS | 庄镘洁 | 319785 | 357483 | 2026-01-30 11:13:13 | 3 | 2026-03-22 17:35:39.677478 |
| LF26011400049902 | 26Sharjah男款背带短裤-头版-CY110MYO | S | 罗兰方 | 319643 | 357484 | 2026-01-30 11:14:24 | 10 | 2026-03-22 17:35:39.675992 |
| LF26011400049911 | 26Sharjah男款背带短裤-头版-CY110MYO | 2XS | 罗兰方 | 319643 | 357484 | 2026-01-30 11:14:24 | 10 | 2026-03-22 17:35:39.674469 |
| LF26011400049901 | 26Sharjah男款背带短裤-头版-CY110MYO | XS | 罗兰方 | 319643 | 357484 | 2026-01-30 11:14:24 | 10 | 2026-03-22 17:35:39.672962 |
| LF26011400049912 | 26Sharjah男款背带短裤-头版-CY110MYO | 3XS | 罗兰方 | 319643 | 357484 | 2026-01-30 11:14:24 | 10 | 2026-03-22 17:35:39.671340 |
| ZT2411050239901 | MUMU Winter24抓绒护腿-YS9967MO | XS | 曾亭 | 319258 | 357485 | 2026-01-30 11:14:50 | 9 | 2026-03-22 17:35:39.669684 |
| DQ2401290039902 | Bonavelo童装短裤-CD043B | S | 吕丹琪 | 319572 | 357486 | 2026-01-30 11:15:25 | 10 | 2026-03-22 17:35:39.668164 |
| DQ2401290039901 | Bonavelo童装短裤-CD043B | XS | 吕丹琪 | 319572 | 357486 | 2026-01-30 11:15:25 | 20 | 2026-03-22 17:35:39.666630 |
| ZT26011700379905 | BH 26 white护臂-头版-YS9945T | XL | 曾亭 | 320051 | 357487 | 2026-01-30 11:15:53 | 1 | 2026-03-22 17:35:39.665143 |
| ZT26011700379904 | BH 26 white护臂-头版-YS9945T | L | 曾亭 | 320051 | 357487 | 2026-01-30 11:15:53 | 7 | 2026-03-22 17:35:39.663510 |
| ZT26011700379903 | BH 26 white护臂-头版-YS9945T | M | 曾亭 | 320051 | 357487 | 2026-01-30 11:15:53 | 9 | 2026-03-22 17:35:39.661974 |
| ZT26011700379902 | BH 26 white护臂-头版-YS9945T | S | 曾亭 | 320051 | 357487 | 2026-01-30 11:15:53 | 6 | 2026-03-22 17:35:39.660334 |
| ZT26011700379901 | BH 26 white护臂-头版-YS9945T | XS | 曾亭 | 320051 | 357487 | 2026-01-30 11:15:53 | 1 | 2026-03-22 17:35:39.658471 |
| ZT26011700549908 | BH 26 white男款防风背心-头版-YS9046MEO | 4XL | 曾亭 | 320080 | 357488 | 2026-01-30 11:16:50 | 1 | 2026-03-22 17:35:39.656963 |
| ZT26011700549905 | BH 26 white男款防风背心-头版-YS9046MEO | XL | 曾亭 | 320080 | 357488 | 2026-01-30 11:16:50 | 1 | 2026-03-22 17:35:39.655310 |
| ZT26011700549904 | BH 26 white男款防风背心-头版-YS9046MEO | L | 曾亭 | 320080 | 357488 | 2026-01-30 11:16:50 | 4 | 2026-03-22 17:35:39.653711 |