到货库存导入(采购入库 Excel)
系统会从 Excel 中抓取:款式编号(清洗为SKU)、款式SKU、颜色及规格(提取尺码)、数量、商品名称、运营仓库、采购单号、入仓单号、采购员、入库日期。
库存汇总
| 产品SKU | 中文名 | 尺码 | 采购员 | 采购单号 | 入仓单号 | 入库日期 | 当前库存 | 更新时间 |
|---|---|---|---|---|---|---|---|---|
| YL26011400039904 | AZ 2in1 white-1男款跑步短裤-二版-YS2211MDCO | L | 甘雅玲 | 319015 | 358964 | 2026-02-03 17:35:59 | 3 | 2026-03-22 17:35:36.490798 |
| YL26011400039903 | AZ 2in1 white-1男款跑步短裤-二版-YS2211MDCO | M | 甘雅玲 | 319015 | 358964 | 2026-02-03 17:35:59 | 7 | 2026-03-22 17:35:36.489180 |
| YL26011400039902 | AZ 2in1 white-1男款跑步短裤-二版-YS2211MDCO | S | 甘雅玲 | 319015 | 358964 | 2026-02-03 17:35:59 | 8 | 2026-03-22 17:35:36.487616 |
| YL26011400039901 | AZ 2in1 white-1男款跑步短裤-二版-YS2211MDCO | XS | 甘雅玲 | 319015 | 358964 | 2026-02-03 17:35:59 | 5 | 2026-03-22 17:35:36.486093 |
| BH26011700049906 | MTB 26 Woods Tan男款短衬衫-头版-YS9724MX | 2XL | 凌碧红 | 319595 | 358965 | 2026-02-03 17:36:41 | 5 | 2026-03-22 17:35:36.484545 |
| BH26011700049907 | MTB 26 Woods Tan男款短衬衫-头版-YS9724MX | 3XL | 凌碧红 | 319595 | 358965 | 2026-02-03 17:36:41 | 4 | 2026-03-22 17:35:36.482977 |
| BH26011700049905 | MTB 26 Woods Tan男款短衬衫-头版-YS9724MX | XL | 凌碧红 | 319595 | 358965 | 2026-02-03 17:36:41 | 9 | 2026-03-22 17:35:36.481330 |
| BH26011700049904 | MTB 26 Woods Tan男款短衬衫-头版-YS9724MX | L | 凌碧红 | 319595 | 358965 | 2026-02-03 17:36:41 | 14 | 2026-03-22 17:35:36.479823 |
| BH26011700049903 | MTB 26 Woods Tan男款短衬衫-头版-YS9724MX | M | 凌碧红 | 319595 | 358965 | 2026-02-03 17:36:41 | 13 | 2026-03-22 17:35:36.478255 |
| BH26011700049902 | MTB 26 Woods Tan男款短衬衫-头版-YS9724MX | S | 凌碧红 | 319595 | 358965 | 2026-02-03 17:36:41 | 5 | 2026-03-22 17:35:36.476696 |
| DQ2404220279906 | BMC2013 (EU)男款短上衣-CD034MVO | 2XL | 吕丹琪 | 319902 | 358967 | 2026-02-03 17:38:40 | 10 | 2026-03-22 17:35:36.475146 |
| DQ2404220279905 | BMC2013 (EU)男款短上衣-CD034MVO | XL | 吕丹琪 | 319902 | 358967 | 2026-02-03 17:38:40 | 25 | 2026-03-22 17:35:36.473539 |
| DQ2404220279904 | BMC2013 (EU)男款短上衣-CD034MVO | L | 吕丹琪 | 319902 | 358967 | 2026-02-03 17:38:40 | 20 | 2026-03-22 17:35:36.471962 |
| DQ2404220279901 | BMC2013 (EU)男款短上衣-CD034MVO | XS | 吕丹琪 | 319902 | 358967 | 2026-02-03 17:38:40 | 2 | 2026-03-22 17:35:36.470384 |
| DQ2404220159906 | GARMIN 2012 (EU)男款短上衣-CD034MVO | 2XL | 吕丹琪 | 319902 | 358967 | 2026-02-03 17:38:40 | 10 | 2026-03-22 17:35:36.468865 |
| DQ2404220159905 | GARMIN 2012 (EU)男款短上衣-CD034MVO | XL | 吕丹琪 | 319902 | 358967 | 2026-02-03 17:38:40 | 20 | 2026-03-22 17:35:36.467242 |
| DQ2404220159904 | GARMIN 2012 (EU)男款短上衣-CD034MVO | L | 吕丹琪 | 319902 | 358967 | 2026-02-03 17:38:40 | 20 | 2026-03-22 17:35:36.465645 |
| DQ2404220159903 | GARMIN 2012 (EU)男款短上衣-CD034MVO | M | 吕丹琪 | 319902 | 358967 | 2026-02-03 17:38:40 | 15 | 2026-03-22 17:35:36.464118 |
| MJ25112200049907 | TCHACO BichosdoMato25男款跑步背心-头版-YS9787MXO | 3XL | 庄镘洁 | 323195 | 358968 | 2026-02-03 17:38:18 | 10 | 2026-03-22 17:35:36.462553 |
| MJ25112200049906 | TCHACO BichosdoMato25男款跑步背心-头版-YS9787MXO | 2XL | 庄镘洁 | 323195 | 358968 | 2026-02-03 17:38:18 | 10 | 2026-03-22 17:35:36.461031 |