到货库存导入(采购入库 Excel)
系统会从 Excel 中抓取:款式编号(清洗为SKU)、款式SKU、颜色及规格(提取尺码)、数量、商品名称、运营仓库、采购单号、入仓单号、采购员、入库日期。
库存汇总
| 产品SKU | 中文名 | 尺码 | 采购员 | 采购单号 | 入仓单号 | 入库日期 | 当前库存 | 更新时间 |
|---|---|---|---|---|---|---|---|---|
| YY26020400019902 | Gursh Black男款T恤-头版-YS9068MRB | S | 刘莹滢 | 325223 | 361651 | 2026-02-10 17:32:22 | 1 | 2026-03-22 17:35:30.499110 |
| WT26020400029901 | Linger波纹黑蓝男款短上衣-头版-YS9788MH | XS | 黄婉婷 | 325224 | 361653 | 2026-02-10 17:33:42 | 1 | 2026-03-22 17:35:30.497594 |
| WT26020400019903 | Linger颜料蓝黑男款短上衣-头版-YS9788MH | M | 黄婉婷 | 325224 | 361653 | 2026-02-10 17:33:42 | 1 | 2026-03-22 17:35:30.496118 |
| JB26012800129904 | COXX Yellow男款短上衣-二版-YS8137MH | L | 郑杰彬 | 324979 | 361679 | 2026-02-10 17:59:55 | 1 | 2026-03-22 17:35:30.494600 |
| JB26012800119905 | COXX Red男款短上衣-二版-YS8137MH | XL | 郑杰彬 | 324979 | 361679 | 2026-02-10 17:59:55 | 1 | 2026-03-22 17:35:30.493035 |
| JB26012800119903 | COXX Red男款短上衣-二版-YS8137MH | M | 郑杰彬 | 324979 | 361679 | 2026-02-10 17:59:55 | 1 | 2026-03-22 17:35:30.491537 |
| JB26012800049905 | COXX Grey防风背心-头版-YS8057MT | XL | 郑杰彬 | 324979 | 361679 | 2026-02-10 17:59:55 | 1 | 2026-03-22 17:35:30.490063 |
| JB26012800039905 | COXX Blue防风背心-头版-YS8057MT | XL | 郑杰彬 | 324979 | 361679 | 2026-02-10 17:59:55 | 1 | 2026-03-22 17:35:30.488557 |
| JB26012800089905 | COXX Black男款长上衣-二版-YS8037MG | XL | 郑杰彬 | 324979 | 361679 | 2026-02-10 17:59:55 | 1 | 2026-03-22 17:35:30.487067 |
| JB26012800089904 | COXX Black男款长上衣-二版-YS8037MG | L | 郑杰彬 | 324979 | 361679 | 2026-02-10 17:59:55 | 1 | 2026-03-22 17:35:30.485515 |
| JB26012800089903 | COXX Black男款长上衣-二版-YS8037MG | M | 郑杰彬 | 324979 | 361679 | 2026-02-10 17:59:55 | 1 | 2026-03-22 17:35:30.484031 |
| JB26012800029905 | COXX Black防风背心-头版-YS8057MT | XL | 郑杰彬 | 324979 | 361679 | 2026-02-10 17:59:55 | 1 | 2026-03-22 17:35:30.482442 |
| JB26012800059906 | COXX Black风衣-头版-YS8030MT | 2XL | 郑杰彬 | 324979 | 361679 | 2026-02-10 17:59:55 | 1 | 2026-03-22 17:35:30.480959 |
| JB26012800059905 | COXX Black风衣-头版-YS8030MT | XL | 郑杰彬 | 324979 | 361679 | 2026-02-10 17:59:55 | 1 | 2026-03-22 17:35:30.479461 |
| JB26012800059904 | COXX Black风衣-头版-YS8030MT | L | 郑杰彬 | 324979 | 361679 | 2026-02-10 17:59:55 | 1 | 2026-03-22 17:35:30.477970 |
| JB26012800019905 | COXX White男款短袖连体衣-头版-YS9262MEDT | XL | 郑杰彬 | 324979 | 361679 | 2026-02-10 17:59:55 | 1 | 2026-03-22 17:35:30.476460 |
| BH26020400049903 | WT TT Mesh女款慢跑背心-头版-YS9346WE | M | 凌碧红 | 326406 | 363461 | 2026-02-25 16:59:44 | 1 | 2026-03-22 17:35:30.468858 |
| BH26020400039908 | WT TT Mesh男款慢跑背心-头版-YS9347MHO | 4XL | 凌碧红 | 326406 | 363461 | 2026-02-25 16:59:44 | 1 | 2026-03-22 17:35:30.467281 |
| BH26020400039903 | WT TT Mesh男款慢跑背心-头版-YS9347MHO | M | 凌碧红 | 326406 | 363461 | 2026-02-25 16:59:44 | 1 | 2026-03-22 17:35:30.465666 |
| BH26020400029903 | WT TT IRI女款T恤-头版-YS9681WO | M | 凌碧红 | 326406 | 363461 | 2026-02-25 16:59:44 | 1 | 2026-03-22 17:35:30.464155 |