到货库存导入(采购入库 Excel)
系统会从 Excel 中抓取:款式编号(清洗为SKU)、款式SKU、颜色及规格(提取尺码)、数量、商品名称、运营仓库、采购单号、入仓单号、采购员、入库日期。
库存汇总
| 产品SKU | 中文名 | 尺码 | 采购员 | 采购单号 | 入仓单号 | 入库日期 | 当前库存 | 更新时间 |
|---|---|---|---|---|---|---|---|---|
| ZT25120900019901 | Hewitt pocket男款T恤-头版-YS8155M | XS | 曾亭 | 310579 | 347967 | 2026-01-02 17:25:03 | 1 | 2026-03-22 17:35:54.891652 |
| ZT25120900019902 | Hewitt pocket男款T恤-头版-YS8155M | S | 曾亭 | 310579 | 347967 | 2026-01-02 17:25:03 | 4 | 2026-03-22 17:35:54.890083 |
| ZT25120900019903 | Hewitt pocket男款T恤-头版-YS8155M | M | 曾亭 | 310579 | 347967 | 2026-01-02 17:25:03 | 5 | 2026-03-22 17:35:54.888228 |
| ZT25120900019904 | Hewitt pocket男款T恤-头版-YS8155M | L | 曾亭 | 310579 | 347967 | 2026-01-02 17:25:03 | 3 | 2026-03-22 17:35:54.886582 |
| ZT25120900019905 | Hewitt pocket男款T恤-头版-YS8155M | XL | 曾亭 | 310579 | 347967 | 2026-01-02 17:25:03 | 2 | 2026-03-22 17:35:54.885040 |
| ZT25120900019906 | Hewitt pocket男款T恤-头版-YS8155M | 2XL | 曾亭 | 310579 | 347967 | 2026-01-02 17:25:03 | 2 | 2026-03-22 17:35:54.883482 |
| ZT25120900019907 | Hewitt pocket男款T恤-头版-YS8155M | 3XL | 曾亭 | 310579 | 347967 | 2026-01-02 17:25:03 | 2 | 2026-03-22 17:35:54.881905 |
| ZT25120900019908 | Hewitt pocket男款T恤-头版-YS8155M | 4XL | 曾亭 | 310579 | 347967 | 2026-01-02 17:25:03 | 2 | 2026-03-22 17:35:54.879860 |
| RX2407160019907 | KPCC-A男款短上衣-YS9409MDAS | 3XL | 袁日仙 | 311234 | 347968 | 2026-01-02 17:25:35 | 1 | 2026-03-22 17:35:54.878266 |
| MJ25112600109906 | TCHACO GROUP男款T恤-二版-YS9681MO | 2XL | 庄镘洁 | 313696 | 347969 | 2026-01-02 17:26:15 | 2 | 2026-03-22 17:35:54.876695 |
| MJ25112600109907 | TCHACO GROUP男款T恤-二版-YS9681MO | 3XL | 庄镘洁 | 313696 | 347969 | 2026-01-02 17:26:15 | 2 | 2026-03-22 17:35:54.875172 |
| ZT25121700549901 | Starkey MTB男款T恤-头版-YS9492MO | XS | 曾亭 | 312391 | 347970 | 2026-01-02 17:26:44 | 1 | 2026-03-22 17:35:54.873565 |
| ZT25121700549902 | Starkey MTB男款T恤-头版-YS9492MO | S | 曾亭 | 312391 | 347970 | 2026-01-02 17:26:44 | 3 | 2026-03-22 17:35:54.871642 |
| ZT25121700549903 | Starkey MTB男款T恤-头版-YS9492MO | M | 曾亭 | 312391 | 347970 | 2026-01-02 17:26:44 | 2 | 2026-03-22 17:35:54.869946 |
| ZT25121700549905 | Starkey MTB男款T恤-头版-YS9492MO | XL | 曾亭 | 312391 | 347970 | 2026-01-02 17:26:44 | 1 | 2026-03-22 17:35:54.868413 |
| ZT25121700569902 | Starkey sport男款短上衣-头版-YS9409MO | S | 曾亭 | 312391 | 347970 | 2026-01-02 17:26:44 | 1 | 2026-03-22 17:35:54.866863 |
| ZT25121700569903 | Starkey sport男款短上衣-头版-YS9409MO | M | 曾亭 | 312391 | 347970 | 2026-01-02 17:26:44 | 3 | 2026-03-22 17:35:54.865307 |
| ZT25121700589904 | Starkey Coach sport男款短上衣-头版-YS9409MO | L | 曾亭 | 312391 | 347970 | 2026-01-02 17:26:44 | 1 | 2026-03-22 17:35:54.863784 |
| RX25120600459902 | CUPCKE-James Thorp女款短裤-二版-YS9121WO | S | 袁日仙 | 310350 | 347971 | 2026-01-02 17:27:09 | 1 | 2026-03-22 17:35:54.861986 |
| RX25120600469902 | CUPCKE-James Thorp女款背带短裤-二版-YS9113WO | S | 袁日仙 | 310350 | 347971 | 2026-01-02 17:27:09 | 1 | 2026-03-22 17:35:54.860403 |