到货库存导入(采购入库 Excel)
系统会从 Excel 中抓取:款式编号(清洗为SKU)、款式SKU、颜色及规格(提取尺码)、数量、商品名称、运营仓库、采购单号、入仓单号、采购员、入库日期。
库存汇总
| 产品SKU | 中文名 | 尺码 | 采购员 | 采购单号 | 入仓单号 | 入库日期 | 当前库存 | 更新时间 |
|---|---|---|---|---|---|---|---|---|
| YL26012400049904 | NCRC 26-5男款T恤-头版-YS9068MKB | L | 甘雅玲 | 320929 | 367867 | 2026-03-07 15:42:16 | 24 | 2026-03-22 17:35:26.667464 |
| YL26012400049902 | NCRC 26-5男款T恤-头版-YS9068MKB | S | 甘雅玲 | 320929 | 367867 | 2026-03-07 15:42:16 | 9 | 2026-03-22 17:35:26.665839 |
| YL26012400049901 | NCRC 26-5男款T恤-头版-YS9068MKB | XS | 甘雅玲 | 320929 | 367867 | 2026-03-07 15:42:16 | 2 | 2026-03-22 17:35:26.664241 |
| YL26012400039905 | NCRC 26-5女款T恤-头版-YS9068WQB | XL | 甘雅玲 | 320929 | 367867 | 2026-03-07 15:42:16 | 2 | 2026-03-22 17:35:26.662590 |
| YL26012400039904 | NCRC 26-5女款T恤-头版-YS9068WQB | L | 甘雅玲 | 320929 | 367867 | 2026-03-07 15:42:16 | 5 | 2026-03-22 17:35:26.661008 |
| YL26012400039903 | NCRC 26-5女款T恤-头版-YS9068WQB | M | 甘雅玲 | 320929 | 367867 | 2026-03-07 15:42:16 | 7 | 2026-03-22 17:35:26.659459 |
| YL26012400039902 | NCRC 26-5女款T恤-头版-YS9068WQB | S | 甘雅玲 | 320929 | 367867 | 2026-03-07 15:42:16 | 6 | 2026-03-22 17:35:26.657926 |
| DQ25030100109910 | 25TDF-GREEN男款短上衣-CD034MVO | 6XL | 吕丹琪 | 324143 | 367868 | 2026-03-07 15:43:02 | 10 | 2026-03-22 17:35:26.656415 |
| DQ25030100109909 | 25TDF-GREEN男款短上衣-CD034MVO | 5XL | 吕丹琪 | 324143 | 367868 | 2026-03-07 15:43:02 | 5 | 2026-03-22 17:35:26.654846 |
| DQ25030100109908 | 25TDF-GREEN男款短上衣-CD034MVO | 4XL | 吕丹琪 | 324143 | 367868 | 2026-03-07 15:43:02 | 5 | 2026-03-22 17:35:26.653277 |
| DQ25030100109905 | 25TDF-GREEN男款短上衣-CD034MVO | XL | 吕丹琪 | 324143 | 367868 | 2026-03-07 15:43:02 | 30 | 2026-03-22 17:35:26.651252 |
| DQ25030100109904 | 25TDF-GREEN男款短上衣-CD034MVO | L | 吕丹琪 | 324143 | 367868 | 2026-03-07 15:43:02 | 20 | 2026-03-22 17:35:26.598671 |
| DQ25030100109903 | 25TDF-GREEN男款短上衣-CD034MVO | M | 吕丹琪 | 324143 | 367868 | 2026-03-07 15:43:02 | 30 | 2026-03-22 17:35:26.597018 |
| RX26020900079906 | GC-Chemchamp 26 new男款短上衣-头版-CY075MJBO | 2XL | 袁日仙 | 326420 | 367869 | 2026-03-07 15:46:42 | 6 | 2026-03-22 17:35:26.595369 |
| RX26020900079904 | GC-Chemchamp 26 new男款短上衣-头版-CY075MJBO | L | 袁日仙 | 326420 | 367869 | 2026-03-07 15:46:42 | 3 | 2026-03-22 17:35:26.593826 |
| RX26020900079905 | GC-Chemchamp 26 new男款短上衣-头版-CY075MJBO | XL | 袁日仙 | 326420 | 367869 | 2026-03-07 15:46:42 | 8 | 2026-03-22 17:35:26.592240 |
| RX26020900079903 | GC-Chemchamp 26 new男款短上衣-头版-CY075MJBO | M | 袁日仙 | 326420 | 367869 | 2026-03-07 15:46:42 | 1 | 2026-03-22 17:35:26.590656 |
| RX26020900069904 | GC-Chemchamp 26 new女款短上衣-头版-CY075WDO | L | 袁日仙 | 326420 | 367869 | 2026-03-07 15:46:42 | 4 | 2026-03-22 17:35:26.589074 |
| RX26020900069901 | GC-Chemchamp 26 new女款短上衣-头版-CY075WDO | XS | 袁日仙 | 326420 | 367869 | 2026-03-07 15:46:42 | 8 | 2026-03-22 17:35:26.587485 |
| RX26020900029906 | GC-Santa Annas男款短上衣-头版-CY075MJBO | 2XL | 袁日仙 | 326420 | 367869 | 2026-03-07 15:46:42 | 2 | 2026-03-22 17:35:26.585946 |