到货库存导入(采购入库 Excel)
系统会从 Excel 中抓取:款式编号(清洗为SKU)、款式SKU、颜色及规格(提取尺码)、数量、商品名称、运营仓库、采购单号、入仓单号、采购员、入库日期。
库存汇总
| 产品SKU | 中文名 | 尺码 | 采购员 | 采购单号 | 入仓单号 | 入库日期 | 当前库存 | 更新时间 |
|---|---|---|---|---|---|---|---|---|
| ZT26030400189905 | Infinit 26 Blue男款POLO衫-头版-YS9697MLO | XL | 曾亭 | 329117 | 375311 | 2026-03-20 10:50:08 | 1 | 2026-03-22 17:35:20.664154 |
| ZT26030400189904 | Infinit 26 Blue男款POLO衫-头版-YS9697MLO | L | 曾亭 | 329117 | 375311 | 2026-03-20 10:50:08 | 1 | 2026-03-22 17:35:20.662417 |
| ZT26030400189903 | Infinit 26 Blue男款POLO衫-头版-YS9697MLO | M | 曾亭 | 329117 | 375311 | 2026-03-20 10:50:08 | 1 | 2026-03-22 17:35:20.660872 |
| MJ26013100029902 | ARA REBEL女款背带短裤-头版-YS2213W | S | 庄镘洁 | 324506 | 375312 | 2026-03-20 10:50:31 | 2 | 2026-03-22 17:35:20.659344 |
| MY26011400019905 | ENSO burgundy女款跑步短裤-头版-YS2254W | XL | 胡美英 | 319171 | 375313 | 2026-03-20 10:50:56 | 1 | 2026-03-22 17:35:20.657836 |
| MY26011400019904 | ENSO burgundy女款跑步短裤-头版-YS2254W | L | 胡美英 | 319171 | 375313 | 2026-03-20 10:50:56 | 2 | 2026-03-22 17:35:20.656215 |
| MY26011400019903 | ENSO burgundy女款跑步短裤-头版-YS2254W | M | 胡美英 | 319171 | 375313 | 2026-03-20 10:50:56 | 3 | 2026-03-22 17:35:20.654611 |
| MY26011400019902 | ENSO burgundy女款跑步短裤-头版-YS2254W | S | 胡美英 | 319171 | 375313 | 2026-03-20 10:50:56 | 5 | 2026-03-22 17:35:20.653111 |
| MY26011400019901 | ENSO burgundy女款跑步短裤-头版-YS2254W | XS | 胡美英 | 319171 | 375313 | 2026-03-20 10:50:56 | 4 | 2026-03-22 17:35:20.650977 |
| YY26022800079903 | ALIAS-AER TEAM男款背带短裤-头版-YS2047MAYO | M | 刘莹滢 | 330829 | 375314 | 2026-03-20 10:51:18 | 6 | 2026-03-22 17:35:20.598600 |
| RX26031100139904 | CUPCKE-Nuna女款T恤-二版-YS9087WO | L | 袁日仙 | 331473 | 375315 | 2026-03-20 10:52:07 | 1 | 2026-03-22 17:35:20.597111 |
| RX26031100139902 | CUPCKE-Nuna女款T恤-二版-YS9087WO | S | 袁日仙 | 331473 | 375315 | 2026-03-20 10:52:07 | 1 | 2026-03-22 17:35:20.595606 |
| RX26031100089906 | CUPCKE-Nuna-B男款T恤-头版-YS9068MDQT | 2XL | 袁日仙 | 331473 | 375315 | 2026-03-20 10:52:07 | 1 | 2026-03-22 17:35:20.594101 |
| RX26031100089905 | CUPCKE-Nuna-B男款T恤-头版-YS9068MDQT | XL | 袁日仙 | 331473 | 375315 | 2026-03-20 10:52:07 | 1 | 2026-03-22 17:35:20.592549 |
| RX26031100089904 | CUPCKE-Nuna-B男款T恤-头版-YS9068MDQT | L | 袁日仙 | 331473 | 375315 | 2026-03-20 10:52:07 | 2 | 2026-03-22 17:35:20.591023 |
| RX26031100089903 | CUPCKE-Nuna-B男款T恤-头版-YS9068MDQT | M | 袁日仙 | 331473 | 375315 | 2026-03-20 10:52:07 | 3 | 2026-03-22 17:35:20.589511 |
| MY26030400019904 | B3L 26 Flander男款抓绒长上衣-头版-YS8042MO | L | 胡美英 | 329728 | 375316 | 2026-03-20 10:52:39 | 6 | 2026-03-22 17:35:20.588051 |
| MY26030400019903 | B3L 26 Flander男款抓绒长上衣-头版-YS8042MO | M | 胡美英 | 329728 | 375316 | 2026-03-20 10:52:39 | 11 | 2026-03-22 17:35:20.586507 |
| MY26030400019902 | B3L 26 Flander男款抓绒长上衣-头版-YS8042MO | S | 胡美英 | 329728 | 375316 | 2026-03-20 10:52:39 | 4 | 2026-03-22 17:35:20.585040 |
| YY26020900039905 | Outskirts-TEMPO Green男款背带短裤-头版-YS2128MEO | XL | 刘莹滢 | 326612 | 375317 | 2026-03-20 10:53:11 | 1 | 2026-03-22 17:35:20.583521 |