到货库存导入(采购入库 Excel)
系统会从 Excel 中抓取:款式编号(清洗为SKU)、款式SKU、颜色及规格(提取尺码)、数量、商品名称、运营仓库、采购单号、入仓单号、采购员、入库日期。
库存汇总
| 产品SKU | 中文名 | 尺码 | 采购员 | 采购单号 | 入仓单号 | 入库日期 | 当前库存 | 更新时间 |
|---|---|---|---|---|---|---|---|---|
| WT26010700189905 | AC HCT 2026男款长上衣-头版-YS8007MBO | XL | 黄婉婷 | 316815 | 359106 | 2026-02-04 11:15:31 | 7 | 2026-03-22 17:35:36.153238 |
| WT26010700189904 | AC HCT 2026男款长上衣-头版-YS8007MBO | L | 黄婉婷 | 316815 | 359106 | 2026-02-04 11:15:31 | 6 | 2026-03-22 17:35:36.151180 |
| WT26010700189903 | AC HCT 2026男款长上衣-头版-YS8007MBO | M | 黄婉婷 | 316815 | 359106 | 2026-02-04 11:15:31 | 15 | 2026-03-22 17:35:36.098708 |
| WT26010700189902 | AC HCT 2026男款长上衣-头版-YS8007MBO | S | 黄婉婷 | 316815 | 359106 | 2026-02-04 11:15:31 | 12 | 2026-03-22 17:35:36.097193 |
| ZT26011700209903 | Fix Gold Elite女款短上衣-头版-YS9409WKO | M | 曾亭 | 320016 | 359107 | 2026-02-04 11:15:55 | 1 | 2026-03-22 17:35:36.095543 |
| ZT26011700179906 | Fix Lion Elite男款短上衣-头版-YS9409MEKO | 2XL | 曾亭 | 320016 | 359107 | 2026-02-04 11:15:55 | 3 | 2026-03-22 17:35:36.093926 |
| ZT26011700179905 | Fix Lion Elite男款短上衣-头版-YS9409MEKO | XL | 曾亭 | 320016 | 359107 | 2026-02-04 11:15:55 | 3 | 2026-03-22 17:35:36.092358 |
| ZT26011700179904 | Fix Lion Elite男款短上衣-头版-YS9409MEKO | L | 曾亭 | 320016 | 359107 | 2026-02-04 11:15:55 | 5 | 2026-03-22 17:35:36.090849 |
| ZT26011700179903 | Fix Lion Elite男款短上衣-头版-YS9409MEKO | M | 曾亭 | 320016 | 359107 | 2026-02-04 11:15:55 | 3 | 2026-03-22 17:35:36.089295 |
| ZT26011700179902 | Fix Lion Elite男款短上衣-头版-YS9409MEKO | S | 曾亭 | 320016 | 359107 | 2026-02-04 11:15:55 | 3 | 2026-03-22 17:35:36.087784 |
| RX26012100059906 | Jlife-Ibel男款短上衣-头版-YS9640MY | 2XL | 袁日仙 | 320274 | 359108 | 2026-02-04 11:16:22 | 1 | 2026-03-22 17:35:36.086193 |
| RX26012100059905 | Jlife-Ibel男款短上衣-头版-YS9640MY | XL | 袁日仙 | 320274 | 359108 | 2026-02-04 11:16:22 | 5 | 2026-03-22 17:35:36.084629 |
| RX26012100059904 | Jlife-Ibel男款短上衣-头版-YS9640MY | L | 袁日仙 | 320274 | 359108 | 2026-02-04 11:16:22 | 6 | 2026-03-22 17:35:36.083108 |
| RX26012100059903 | Jlife-Ibel男款短上衣-头版-YS9640MY | M | 袁日仙 | 320274 | 359108 | 2026-02-04 11:16:22 | 6 | 2026-03-22 17:35:36.081507 |
| RX26012100059902 | Jlife-Ibel男款短上衣-头版-YS9640MY | S | 袁日仙 | 320274 | 359108 | 2026-02-04 11:16:22 | 2 | 2026-03-22 17:35:36.079964 |
| ZT26011700559903 | BH 26 Blue Elite男款长上衣-头版-YS9851MAO | M | 曾亭 | 320080 | 359110 | 2026-02-04 11:16:48 | 1 | 2026-03-22 17:35:36.078426 |
| DQ2406050079906 | BANESTO 1996(EU)男款短上衣-CD034MVO | 2XL | 吕丹琪 | 319902 | 359113 | 2026-02-04 11:17:28 | 20 | 2026-03-22 17:35:36.076773 |
| DQ26012100079903 | KTTY女款短上衣-头版-YS8007W | M | 吕丹琪 | 320108 | 359112 | 2026-02-10 14:29:23 | 4 | 2026-03-22 17:35:36.076621 |
| DQ26012100079902 | KTTY女款短上衣-头版-YS8007W | S | 吕丹琪 | 320108 | 359112 | 2026-02-10 14:29:23 | 6 | 2026-03-22 17:35:36.076619 |
| DQ26012100079901 | KTTY女款短上衣-头版-YS8007W | XS | 吕丹琪 | 320108 | 359112 | 2026-02-10 14:29:23 | 6 | 2026-03-22 17:35:36.076616 |