到货库存导入(采购入库 Excel)
系统会从 Excel 中抓取:款式编号(清洗为SKU)、款式SKU、颜色及规格(提取尺码)、数量、商品名称、运营仓库、采购单号、入仓单号、采购员、入库日期。
库存汇总
| 产品SKU | 中文名 | 尺码 | 采购员 | 采购单号 | 入仓单号 | 入库日期 | 当前库存 | 更新时间 |
|---|---|---|---|---|---|---|---|---|
| ZT26012100359904 | infinity build男款抓绒夹克-头版-YS9655M | L | 曾亭 | 320875 | 357978 | 2026-01-31 17:42:35 | 2 | 2026-03-22 17:35:38.583729 |
| MJ26011400029907 | RADA LF 2025 Yellow男款短上衣-头版-YS9640MZDO | 3XL | 庄镘洁 | 319011 | 357979 | 2026-01-31 17:43:00 | 1 | 2026-03-22 17:35:38.582140 |
| MJ26011400029905 | RADA LF 2025 Yellow男款短上衣-头版-YS9640MZDO | XL | 庄镘洁 | 319011 | 357979 | 2026-01-31 17:43:00 | 2 | 2026-03-22 17:35:38.580494 |
| MJ26011400029906 | RADA LF 2025 Yellow男款短上衣-头版-YS9640MZDO | 2XL | 庄镘洁 | 319011 | 357979 | 2026-01-31 17:43:00 | 1 | 2026-03-22 17:35:38.578959 |
| MJ26011400029904 | RADA LF 2025 Yellow男款短上衣-头版-YS9640MZDO | L | 庄镘洁 | 319011 | 357979 | 2026-01-31 17:43:00 | 2 | 2026-03-22 17:35:38.577420 |
| MJ26011400029903 | RADA LF 2025 Yellow男款短上衣-头版-YS9640MZDO | M | 庄镘洁 | 319011 | 357979 | 2026-01-31 17:43:00 | 2 | 2026-03-22 17:35:38.575903 |
| ZT26011700109906 | BikeMS 26男款短上衣-头版-YS9409MEKO | 2XL | 曾亭 | 319263 | 357980 | 2026-01-31 17:43:27 | 1 | 2026-03-22 17:35:38.574315 |
| ZT26011700109905 | BikeMS 26男款短上衣-头版-YS9409MEKO | XL | 曾亭 | 319263 | 357980 | 2026-01-31 17:43:27 | 5 | 2026-03-22 17:35:38.572804 |
| ZT26011700109904 | BikeMS 26男款短上衣-头版-YS9409MEKO | L | 曾亭 | 319263 | 357980 | 2026-01-31 17:43:27 | 4 | 2026-03-22 17:35:38.571211 |
| ZT26011700109903 | BikeMS 26男款短上衣-头版-YS9409MEKO | M | 曾亭 | 319263 | 357980 | 2026-01-31 17:43:27 | 5 | 2026-03-22 17:35:38.569647 |
| ZT26011700109902 | BikeMS 26男款短上衣-头版-YS9409MEKO | S | 曾亭 | 319263 | 357980 | 2026-01-31 17:43:27 | 1 | 2026-03-22 17:35:38.568117 |
| ZT26012100239905 | LA MOZ Black男款慢跑背心-头版-YS9347MKO | XL | 曾亭 | 319716 | 357981 | 2026-01-31 17:43:56 | 1 | 2026-03-22 17:35:38.566431 |
| ZT26012100239903 | LA MOZ Black男款慢跑背心-头版-YS9347MKO | M | 曾亭 | 319716 | 357981 | 2026-01-31 17:43:56 | 3 | 2026-03-22 17:35:38.564927 |
| ZT26012100239902 | LA MOZ Black男款慢跑背心-头版-YS9347MKO | S | 曾亭 | 319716 | 357981 | 2026-01-31 17:43:56 | 3 | 2026-03-22 17:35:38.563306 |
| ZT26011000729902 | GetRAD TT男款短袖连体衣-头版-YS9211MCO | S | 曾亭 | 318102 | 357982 | 2026-01-31 17:44:23 | 1 | 2026-03-22 17:35:38.561338 |
| ZT26011000729911 | GetRAD TT男款短袖连体衣-头版-YS9211MCO | 2XS | 曾亭 | 318102 | 357982 | 2026-01-31 17:44:23 | 7 | 2026-03-22 17:35:38.559343 |
| WT26010700119905 | AC HCT 2026男款背带短裤-头版-YS2129MO | XL | 黄婉婷 | 316774 | 357983 | 2026-01-31 17:44:53 | 6 | 2026-03-22 17:35:38.557381 |
| WT26010700119904 | AC HCT 2026男款背带短裤-头版-YS2129MO | L | 黄婉婷 | 316774 | 357983 | 2026-01-31 17:44:53 | 12 | 2026-03-22 17:35:38.555618 |
| WT26010700119903 | AC HCT 2026男款背带短裤-头版-YS2129MO | M | 黄婉婷 | 316774 | 357983 | 2026-01-31 17:44:53 | 16 | 2026-03-22 17:35:38.553899 |
| WT26010700119902 | AC HCT 2026男款背带短裤-头版-YS2129MO | S | 黄婉婷 | 316774 | 357983 | 2026-01-31 17:44:53 | 7 | 2026-03-22 17:35:38.551663 |