到货库存导入(采购入库 Excel)
系统会从 Excel 中抓取:款式编号(清洗为SKU)、款式SKU、颜色及规格(提取尺码)、数量、商品名称、运营仓库、采购单号、入仓单号、采购员、入库日期。
库存汇总
| 产品SKU | 中文名 | 尺码 | 采购员 | 采购单号 | 入仓单号 | 入库日期 | 当前库存 | 更新时间 |
|---|---|---|---|---|---|---|---|---|
| 1231110499906 | Thunder深灰短上衣 | 2XL | 黄婉婷 | 317914 | 358563 | 2026-02-02 16:43:20 | 3 | 2026-03-22 17:35:37.366897 |
| 1231110499904 | Thunder深灰短上衣 | L | 黄婉婷 | 317914 | 358563 | 2026-02-02 16:43:20 | 3 | 2026-03-22 17:35:37.365377 |
| 1231110499903 | Thunder深灰短上衣 | M | 黄婉婷 | 317914 | 358563 | 2026-02-02 16:43:20 | 1 | 2026-03-22 17:35:37.363853 |
| 1241220179904 | 彩带黑色背带短裤 | L | 黄婉婷 | 316951 | 358564 | 2026-02-02 16:44:50 | 6 | 2026-03-22 17:35:37.360406 |
| DQ2404220339906 | SKY2014 (EU)男款短上衣-CD034MVO | 2XL | 吕丹琪 | 319902 | 358566 | 2026-02-02 16:49:06 | 10 | 2026-03-22 17:35:37.358769 |
| RX26012100029906 | Jlife-Ibel Staff男款T恤-头版-YS9068M | 2XL | 袁日仙 | 320274 | 358565 | 2026-03-03 15:58:32 | 2 | 2026-03-22 17:35:37.358593 |
| RX26012100029905 | Jlife-Ibel Staff男款T恤-头版-YS9068M | XL | 袁日仙 | 320274 | 358565 | 2026-03-03 15:58:32 | 6 | 2026-03-22 17:35:37.358592 |
| RX26012100029904 | Jlife-Ibel Staff男款T恤-头版-YS9068M | L | 袁日仙 | 320274 | 358565 | 2026-03-03 15:58:32 | 16 | 2026-03-22 17:35:37.358590 |
| RX26012100029903 | Jlife-Ibel Staff男款T恤-头版-YS9068M | M | 袁日仙 | 320274 | 358565 | 2026-03-03 15:58:32 | 30 | 2026-03-22 17:35:37.358588 |
| RX26012100029902 | Jlife-Ibel Staff男款T恤-头版-YS9068M | S | 袁日仙 | 320274 | 358565 | 2026-03-03 15:58:32 | 6 | 2026-03-22 17:35:37.358585 |
| DQ2404220339905 | SKY2014 (EU)男款短上衣-CD034MVO | XL | 吕丹琪 | 319902 | 358566 | 2026-02-02 16:49:06 | 25 | 2026-03-22 17:35:37.352988 |
| DQ2404220339904 | SKY2014 (EU)男款短上衣-CD034MVO | L | 吕丹琪 | 319902 | 358566 | 2026-02-02 16:49:06 | 25 | 2026-03-22 17:35:37.350431 |
| DQ2404220339903 | SKY2014 (EU)男款短上衣-CD034MVO | M | 吕丹琪 | 319902 | 358566 | 2026-02-02 16:49:06 | 20 | 2026-03-22 17:35:37.298194 |
| DQ2404220339902 | SKY2014 (EU)男款短上衣-CD034MVO | S | 吕丹琪 | 319902 | 358566 | 2026-02-02 16:49:06 | 4 | 2026-03-22 17:35:37.296524 |
| DQ2404220339901 | SKY2014 (EU)男款短上衣-CD034MVO | XS | 吕丹琪 | 319902 | 358566 | 2026-02-02 16:49:06 | 2 | 2026-03-22 17:35:37.294705 |
| ZT26011400129906 | Boston Scientific White男款短上衣-头版-CY104MO | 2XL | 曾亭 | 319589 | 358567 | 2026-02-02 16:49:43 | 3 | 2026-03-22 17:35:37.292989 |
| ZT26011400129907 | Boston Scientific White男款短上衣-头版-CY104MO | 3XL | 曾亭 | 319589 | 358567 | 2026-02-02 16:49:43 | 3 | 2026-03-22 17:35:37.291218 |
| ZT26011400129904 | Boston Scientific White男款短上衣-头版-CY104MO | L | 曾亭 | 319589 | 358567 | 2026-02-02 16:49:43 | 2 | 2026-03-22 17:35:37.289492 |
| ZT26011400129903 | Boston Scientific White男款短上衣-头版-CY104MO | M | 曾亭 | 319589 | 358567 | 2026-02-02 16:49:43 | 2 | 2026-03-22 17:35:37.287850 |
| MJ26012100129906 | TCHACO CORRIDADASAGUAS男款POLO衫-头版-YS9450MO | 2XL | 庄镘洁 | 320646 | 358568 | 2026-02-02 16:50:16 | 3 | 2026-03-22 17:35:37.286087 |