到货库存导入(采购入库 Excel)
系统会从 Excel 中抓取:款式编号(清洗为SKU)、款式SKU、颜色及规格(提取尺码)、数量、商品名称、运营仓库、采购单号、入仓单号、采购员、入库日期。
库存汇总
| 产品SKU | 中文名 | 尺码 | 采购员 | 采购单号 | 入仓单号 | 入库日期 | 当前库存 | 更新时间 |
|---|---|---|---|---|---|---|---|---|
| 1241110839906 | 24-WATER深蓝女款短上衣 | 2XL | 黄婉婷 | 313569 | 352479 | 2026-01-16 11:03:19 | 10 | 2026-03-22 17:35:48.565759 |
| 1241110839905 | 24-WATER深蓝女款短上衣 | XL | 黄婉婷 | 313569 | 352479 | 2026-01-16 11:03:19 | 10 | 2026-03-22 17:35:48.564203 |
| BH25123000079905 | Vector ITC男款慢跑背心-头版-YS9366MB | XL | 凌碧红 | 315610 | 352481 | 2026-01-16 11:04:33 | 1 | 2026-03-22 17:35:48.562638 |
| BH25123000079906 | Vector ITC男款慢跑背心-头版-YS9366MB | 2XL | 凌碧红 | 315610 | 352481 | 2026-01-16 11:04:33 | 5 | 2026-03-22 17:35:48.561094 |
| BH25123000079904 | Vector ITC男款慢跑背心-头版-YS9366MB | L | 凌碧红 | 315610 | 352481 | 2026-01-16 11:04:33 | 2 | 2026-03-22 17:35:48.559483 |
| BH25123000079903 | Vector ITC男款慢跑背心-头版-YS9366MB | M | 凌碧红 | 315610 | 352481 | 2026-01-16 11:04:33 | 2 | 2026-03-22 17:35:48.557966 |
| BH25123000079901 | Vector ITC男款慢跑背心-头版-YS9366MB | XS | 凌碧红 | 315610 | 352481 | 2026-01-16 11:04:33 | 5 | 2026-03-22 17:35:48.556402 |
| BH25123000069906 | Vector ITC男款跑步短裤-头版-YS2211MVAO | 2XL | 凌碧红 | 315610 | 352481 | 2026-01-16 11:04:33 | 5 | 2026-03-22 17:35:48.554862 |
| BH25123000069904 | Vector ITC男款跑步短裤-头版-YS2211MVAO | L | 凌碧红 | 315610 | 352481 | 2026-01-16 11:04:33 | 2 | 2026-03-22 17:35:48.553281 |
| BH25123000069903 | Vector ITC男款跑步短裤-头版-YS2211MVAO | M | 凌碧红 | 315610 | 352481 | 2026-01-16 11:04:33 | 3 | 2026-03-22 17:35:48.551167 |
| BH25123000069902 | Vector ITC男款跑步短裤-头版-YS2211MVAO | S | 凌碧红 | 315610 | 352481 | 2026-01-16 11:04:33 | 4 | 2026-03-22 17:35:48.498630 |
| ZT25123001369906 | PHUKET 26男款跑步背心-头版-YS8118M | 2XL | 曾亭 | 315615 | 352482 | 2026-01-16 11:05:17 | 6 | 2026-03-22 17:35:48.497072 |
| BH25123000069901 | Vector ITC男款跑步短裤-头版-YS2211MVAO | XS | 凌碧红 | 315610 | 352481 | 2026-02-06 16:53:35 | 2 | 2026-03-22 17:35:48.496959 |
| ZT25123001369905 | PHUKET 26男款跑步背心-头版-YS8118M | XL | 曾亭 | 315615 | 352482 | 2026-01-16 11:05:17 | 8 | 2026-03-22 17:35:48.494305 |
| ZT25123001369904 | PHUKET 26男款跑步背心-头版-YS8118M | L | 曾亭 | 315615 | 352482 | 2026-01-16 11:05:17 | 14 | 2026-03-22 17:35:48.492704 |
| ZT25123001369903 | PHUKET 26男款跑步背心-头版-YS8118M | M | 曾亭 | 315615 | 352482 | 2026-01-16 11:05:17 | 14 | 2026-03-22 17:35:48.491210 |
| ZT25123001369902 | PHUKET 26男款跑步背心-头版-YS8118M | S | 曾亭 | 315615 | 352482 | 2026-01-16 11:05:17 | 8 | 2026-03-22 17:35:48.489619 |
| ZT25122200549905 | Blue70 26 Elite男款长上衣-头版-YS9851MAO | XL | 曾亭 | 314140 | 352483 | 2026-01-16 11:06:02 | 1 | 2026-03-22 17:35:48.488088 |
| ZT25123000079904 | Titusville Nica C LW男款短上衣-头版-YS9409MEKO | L | 曾亭 | 314226 | 352484 | 2026-01-16 11:06:28 | 1 | 2026-03-22 17:35:48.486502 |
| ZT25123001269903 | Momentous 26女款POLO衫-头版-YS9697WCT | M | 曾亭 | 315606 | 352485 | 2026-01-16 11:06:51 | 1 | 2026-03-22 17:35:48.484979 |