到货库存导入(采购入库 Excel)
系统会从 Excel 中抓取:款式编号(清洗为SKU)、款式SKU、颜色及规格(提取尺码)、数量、商品名称、运营仓库、采购单号、入仓单号、采购员、入库日期。
库存汇总
| 产品SKU | 中文名 | 尺码 | 采购员 | 采购单号 | 入仓单号 | 入库日期 | 当前库存 | 更新时间 |
|---|---|---|---|---|---|---|---|---|
| MJ25123000069902 | TCHACO SONANGOL26男款POLO衫-头版-YS9450MO | S | 庄镘洁 | 315411 | 351540 | 2026-01-13 17:15:34 | 8 | 2026-03-22 17:35:49.770942 |
| MJ25123000069911 | TCHACO SONANGOL26男款POLO衫-头版-YS9450MO | 2XS | 庄镘洁 | 315411 | 351540 | 2026-01-13 17:15:34 | 2 | 2026-03-22 17:35:49.769346 |
| ZT25102200029906 | Dogs Tucson25 Elite男款长上衣-头版-YS9851MAO | 2XL | 曾亭 | 314051 | 351541 | 2026-01-13 17:16:00 | 1 | 2026-03-22 17:35:49.767821 |
| ZT25091700059905 | Dogs Tucson25男款短上衣-头版-YS9409MEKO | XL | 曾亭 | 314051 | 351541 | 2026-01-13 17:16:00 | 1 | 2026-03-22 17:35:49.766222 |
| ZT25091700059904 | Dogs Tucson25男款短上衣-头版-YS9409MEKO | L | 曾亭 | 314051 | 351541 | 2026-01-13 17:16:00 | 4 | 2026-03-22 17:35:49.764668 |
| ZT25091700059903 | Dogs Tucson25男款短上衣-头版-YS9409MEKO | M | 曾亭 | 314051 | 351541 | 2026-01-13 17:16:00 | 3 | 2026-03-22 17:35:49.763130 |
| ZT25091700059902 | Dogs Tucson25男款短上衣-头版-YS9409MEKO | S | 曾亭 | 314051 | 351541 | 2026-01-13 17:16:00 | 1 | 2026-03-22 17:35:49.761546 |
| ZT25123000759905 | Form 26 MTB男款短裤-头版-YS2074MO | XL | 曾亭 | 315334 | 351542 | 2026-01-13 17:16:37 | 1 | 2026-03-22 17:35:49.759758 |
| ZT25123000759903 | Form 26 MTB男款短裤-头版-YS2074MO | M | 曾亭 | 315334 | 351542 | 2026-01-13 17:16:37 | 1 | 2026-03-22 17:35:49.758051 |
| RX25092500019903 | DS-25velo star女款短上衣-头版-YS9663WCO | M | 袁日仙 | 313201 | 351543 | 2026-01-13 17:17:12 | 2 | 2026-03-22 17:35:49.756502 |
| RX25092500019902 | DS-25velo star女款短上衣-头版-YS9663WCO | S | 袁日仙 | 313201 | 351543 | 2026-01-13 17:17:12 | 6 | 2026-03-22 17:35:49.754564 |
| RX25092500019901 | DS-25velo star女款短上衣-头版-YS9663WCO | XS | 袁日仙 | 313201 | 351543 | 2026-01-13 17:17:12 | 2 | 2026-03-22 17:35:49.752956 |
| RX25101500019903 | DS-26pink strawberry-A女款短上衣-头版-YS9040WHO | M | 袁日仙 | 313201 | 351543 | 2026-01-13 17:17:12 | 2 | 2026-03-22 17:35:49.750394 |
| RX25101500019902 | DS-26pink strawberry-A女款短上衣-头版-YS9040WHO | S | 袁日仙 | 313201 | 351543 | 2026-01-13 17:17:12 | 6 | 2026-03-22 17:35:49.699280 |
| RX25101500019901 | DS-26pink strawberry-A女款短上衣-头版-YS9040WHO | XS | 袁日仙 | 313201 | 351543 | 2026-01-13 17:17:12 | 2 | 2026-03-22 17:35:49.697671 |
| MJ26010700019906 | RADA Friends White 2025-1男款短上衣-头版-YS9640MZDO | 2XL | 庄镘洁 | 316615 | 351545 | 2026-01-13 17:19:00 | 1 | 2026-03-22 17:35:49.696160 |
| MJ26010700019905 | RADA Friends White 2025-1男款短上衣-头版-YS9640MZDO | XL | 庄镘洁 | 316615 | 351545 | 2026-01-13 17:19:00 | 1 | 2026-03-22 17:35:49.694549 |
| LF26010700039906 | HP-TRIPPIN男款山地车打底短裤-三版-4183MD | 2XL | 罗兰方 | 316415 | 351551 | 2026-01-13 17:37:21 | 1 | 2026-03-22 17:35:49.693054 |
| LF26010700039905 | HP-TRIPPIN男款山地车打底短裤-三版-4183MD | XL | 罗兰方 | 316415 | 351551 | 2026-01-13 17:37:21 | 1 | 2026-03-22 17:35:49.691481 |
| LF26010700029904 | HP-MAUI男款山地车打底短裤-二版-4183MD | L | 罗兰方 | 316415 | 351551 | 2026-01-13 17:37:21 | 1 | 2026-03-22 17:35:49.689914 |