到货库存导入(采购入库 Excel)
系统会从 Excel 中抓取:款式编号(清洗为SKU)、款式SKU、颜色及规格(提取尺码)、数量、商品名称、运营仓库、采购单号、入仓单号、采购员、入库日期。
库存汇总
| 产品SKU | 中文名 | 尺码 | 采购员 | 采购单号 | 入仓单号 | 入库日期 | 当前库存 | 更新时间 |
|---|---|---|---|---|---|---|---|---|
| DZ261200059904 | TRCC 2026男款长上衣 | L | 何佳欣 | 315809 | 356148 | 2026-01-26 17:44:54 | 5 | 2026-03-22 17:35:42.180091 |
| DZ261200059903 | TRCC 2026男款长上衣 | M | 何佳欣 | 315809 | 356148 | 2026-01-26 17:44:54 | 6 | 2026-03-22 17:35:42.178094 |
| DZ261200059902 | TRCC 2026男款长上衣 | S | 何佳欣 | 315809 | 356148 | 2026-01-26 17:44:54 | 7 | 2026-03-22 17:35:42.175838 |
| DZ261200059901 | TRCC 2026男款长上衣 | XS | 何佳欣 | 315809 | 356148 | 2026-01-26 17:44:54 | 4 | 2026-03-22 17:35:42.173787 |
| LF26012400019903 | MPS-WHITE女款长袖连体衣-头版-YS9218WB | M | 罗兰方 | 319791 | 356152 | 2026-01-26 17:46:42 | 1 | 2026-03-22 17:35:42.171731 |
| DQ26011700049903 | INFLU-PINK男款短上衣-头版-YS9496MDBO | M | 吕丹琪 | 319794 | 356158 | 2026-01-26 17:49:20 | 1 | 2026-03-22 17:35:42.169787 |
| DQ26011700039903 | INFLU-BLUE男款短上衣-头版-YS9496MDBO | M | 吕丹琪 | 319794 | 356158 | 2026-01-26 17:49:20 | 1 | 2026-03-22 17:35:42.167812 |
| DQ26011700029903 | INFLU-GRAY男款短上衣-头版-YS9496MDBO | M | 吕丹琪 | 319794 | 356158 | 2026-01-26 17:49:20 | 1 | 2026-03-22 17:35:42.165809 |
| DQ26011700019903 | INFLU-LOTUS男款短上衣-二版-YS9496MDBO | M | 吕丹琪 | 319794 | 356158 | 2026-01-26 17:49:20 | 1 | 2026-03-22 17:35:42.163813 |
| JN26011000019904 | MAZATOR Teal男款背带短裤-头版-YS2129MO | L | 陈锦娜 | 319796 | 356163 | 2026-01-26 17:51:03 | 1 | 2026-03-22 17:35:42.162104 |
| YL26010700099903 | AZ shirt purple-1男款无袖衬衫-头版-YS8223MC | M | 甘雅玲 | 319798 | 356166 | 2026-01-26 17:52:15 | 1 | 2026-03-22 17:35:42.160515 |
| YL26010700079903 | AZ shirt red-1男款短衬衫-头版-YS8223MB | M | 甘雅玲 | 319798 | 356166 | 2026-01-26 17:52:15 | 1 | 2026-03-22 17:35:42.158795 |
| ZT26012100019903 | NVR pocket grey男款跑步短裤-头版-YS2211MGO | M | 曾亭 | 319799 | 356169 | 2026-01-26 17:53:24 | 1 | 2026-03-22 17:35:42.156845 |
| DZ261200069905 | TRCC 2026女款长上衣 | XL | 何佳欣 | 315809 | 356274 | 2026-01-27 10:53:35 | 1 | 2026-03-22 17:35:42.154977 |
| DZ261200069904 | TRCC 2026女款长上衣 | L | 何佳欣 | 315809 | 356274 | 2026-01-27 10:53:35 | 1 | 2026-03-22 17:35:42.152594 |
| DZ261200069903 | TRCC 2026女款长上衣 | M | 何佳欣 | 315809 | 356274 | 2026-01-27 10:53:35 | 5 | 2026-03-22 17:35:42.099068 |
| DZ261200069902 | TRCC 2026女款长上衣 | S | 何佳欣 | 315809 | 356274 | 2026-01-27 10:53:35 | 5 | 2026-03-22 17:35:42.097319 |
| DZ261200069901 | TRCC 2026女款长上衣 | XS | 何佳欣 | 315809 | 356274 | 2026-01-27 10:53:35 | 2 | 2026-03-22 17:35:42.095425 |
| DZ261200069911 | TRCC 2026女款长上衣 | 2XS | 何佳欣 | 315809 | 356274 | 2026-01-27 10:53:35 | 6 | 2026-03-22 17:35:42.093652 |
| DZ261100189903 | AVRLO-40-IZM男款短上衣 | M | 黄伟懿 | 317686 | 356276 | 2026-01-27 10:55:17 | 4 | 2026-03-22 17:35:42.091612 |