到货库存导入(采购入库 Excel)
系统会从 Excel 中抓取:款式编号(清洗为SKU)、款式SKU、颜色及规格(提取尺码)、数量、商品名称、运营仓库、采购单号、入仓单号、采购员、入库日期。
库存汇总
| 产品SKU | 中文名 | 尺码 | 采购员 | 采购单号 | 入仓单号 | 入库日期 | 当前库存 | 更新时间 |
|---|---|---|---|---|---|---|---|---|
| MJ26010700069904 | HF男款长上衣-头版-YS9410MYJ | L | 庄镘洁 | 317119 | 354164 | 2026-01-20 17:43:19 | 1 | 2026-03-22 17:35:45.895530 |
| RX25112200309905 | LBCC-26 PODIUM FUMEE男款短上衣-二版-YS9406MIBO | XL | 袁日仙 | 308441 | 354165 | 2026-01-20 17:44:07 | 22 | 2026-03-22 17:35:45.893853 |
| RX25112200309906 | LBCC-26 PODIUM FUMEE男款短上衣-二版-YS9406MIBO | 2XL | 袁日仙 | 308441 | 354165 | 2026-01-20 17:44:07 | 6 | 2026-03-22 17:35:45.892318 |
| RX25112200309904 | LBCC-26 PODIUM FUMEE男款短上衣-二版-YS9406MIBO | L | 袁日仙 | 308441 | 354165 | 2026-01-20 17:44:07 | 36 | 2026-03-22 17:35:45.890778 |
| RX25112200309903 | LBCC-26 PODIUM FUMEE男款短上衣-二版-YS9406MIBO | M | 袁日仙 | 308441 | 354165 | 2026-01-20 17:44:07 | 36 | 2026-03-22 17:35:45.889109 |
| RX25112200309902 | LBCC-26 PODIUM FUMEE男款短上衣-二版-YS9406MIBO | S | 袁日仙 | 308441 | 354165 | 2026-01-20 17:44:07 | 24 | 2026-03-22 17:35:45.887579 |
| RX25112200309901 | LBCC-26 PODIUM FUMEE男款短上衣-二版-YS9406MIBO | XS | 袁日仙 | 308441 | 354165 | 2026-01-20 17:44:07 | 11 | 2026-03-22 17:35:45.886009 |
| RX25112200309911 | LBCC-26 PODIUM FUMEE男款短上衣-二版-YS9406MIBO | 2XS | 袁日仙 | 308441 | 354165 | 2026-01-20 17:44:07 | 5 | 2026-03-22 17:35:45.884478 |
| BH26010700069905 | MTB NW Trail CO男款T恤-头版-YS9492MFB | XL | 凌碧红 | 316770 | 354166 | 2026-01-20 17:45:01 | 3 | 2026-03-22 17:35:45.882973 |
| BH26010700069904 | MTB NW Trail CO男款T恤-头版-YS9492MFB | L | 凌碧红 | 316770 | 354166 | 2026-01-20 17:45:01 | 5 | 2026-03-22 17:35:45.881381 |
| BH26010700069903 | MTB NW Trail CO男款T恤-头版-YS9492MFB | M | 凌碧红 | 316770 | 354166 | 2026-01-20 17:45:01 | 3 | 2026-03-22 17:35:45.879832 |
| LF26010700119901 | PD-TRIDENT NOS男款跑步背心-头版-YS9787M | XS | 罗兰方 | 316262 | 354167 | 2026-01-20 17:45:45 | 1 | 2026-03-22 17:35:45.878297 |
| LF26010700119904 | PD-TRIDENT NOS男款跑步背心-头版-YS9787M | L | 罗兰方 | 316262 | 354167 | 2026-01-20 17:45:45 | 1 | 2026-03-22 17:35:45.876724 |
| LF26010700119908 | PD-TRIDENT NOS男款跑步背心-头版-YS9787M | 4XL | 罗兰方 | 316262 | 354167 | 2026-01-20 17:45:45 | 1 | 2026-03-22 17:35:45.875111 |
| LF26010700119903 | PD-TRIDENT NOS男款跑步背心-头版-YS9787M | M | 罗兰方 | 316262 | 354167 | 2026-01-20 17:45:45 | 1 | 2026-03-22 17:35:45.873186 |
| RX26010700649904 | Stelvio-SC男款短上衣-头版-CY098MFO | L | 袁日仙 | 317941 | 354168 | 2026-01-20 17:46:55 | 5 | 2026-03-22 17:35:45.871113 |
| RX26010700649903 | Stelvio-SC男款短上衣-头版-CY098MFO | M | 袁日仙 | 317941 | 354168 | 2026-01-20 17:46:55 | 8 | 2026-03-22 17:35:45.869545 |
| RX26010700649902 | Stelvio-SC男款短上衣-头版-CY098MFO | S | 袁日仙 | 317941 | 354168 | 2026-01-20 17:46:55 | 8 | 2026-03-22 17:35:45.868042 |
| RX26010700649901 | Stelvio-SC男款短上衣-头版-CY098MFO | XS | 袁日仙 | 317941 | 354168 | 2026-01-20 17:46:55 | 3 | 2026-03-22 17:35:45.866455 |
| ZT26011700019903 | MUMU EVO女款短上衣-头版-YS9640WRLO | M | 曾亭 | 318370 | 354170 | 2026-01-20 17:48:53 | 1 | 2026-03-22 17:35:45.864929 |