到货库存导入(采购入库 Excel)
系统会从 Excel 中抓取:款式编号(清洗为SKU)、款式SKU、颜色及规格(提取尺码)、数量、商品名称、运营仓库、采购单号、入仓单号、采购员、入库日期。
库存汇总
| 产品SKU | 中文名 | 尺码 | 采购员 | 采购单号 | 入仓单号 | 入库日期 | 当前库存 | 更新时间 |
|---|---|---|---|---|---|---|---|---|
| LF2403040109908 | 24ASTANA男款短上衣-CD034MV | 4XL | 刘莹滢 | 324248 | 366857 | 2026-03-05 16:32:11 | 3 | 2026-03-22 17:35:27.990985 |
| LF2403040109909 | 24ASTANA男款短上衣-CD034MV | 5XL | 刘莹滢 | 324248 | 366857 | 2026-03-05 16:32:11 | 2 | 2026-03-22 17:35:27.989410 |
| LF2403040109907 | 24ASTANA男款短上衣-CD034MV | 3XL | 刘莹滢 | 324248 | 366857 | 2026-03-05 16:32:11 | 4 | 2026-03-22 17:35:27.987660 |
| LF2403040109906 | 24ASTANA男款短上衣-CD034MV | 2XL | 刘莹滢 | 324248 | 366857 | 2026-03-05 16:32:11 | 3 | 2026-03-22 17:35:27.985840 |
| LF2403040109905 | 24ASTANA男款短上衣-CD034MV | XL | 刘莹滢 | 324248 | 366857 | 2026-03-05 16:32:11 | 10 | 2026-03-22 17:35:27.984251 |
| LF2403040109904 | 24ASTANA男款短上衣-CD034MV | L | 刘莹滢 | 324248 | 366857 | 2026-03-05 16:32:11 | 10 | 2026-03-22 17:35:27.982657 |
| LF2403040109903 | 24ASTANA男款短上衣-CD034MV | M | 刘莹滢 | 324248 | 366857 | 2026-03-05 16:32:11 | 9 | 2026-03-22 17:35:27.981120 |
| LF2403040109901 | 24ASTANA男款短上衣-CD034MV | XS | 刘莹滢 | 324248 | 366857 | 2026-03-05 16:32:11 | 5 | 2026-03-22 17:35:27.979498 |
| ZT26013100419906 | Pastaria 26男款复合风衣-头版-YS9829MO | 2XL | 曾亭 | 324493 | 366858 | 2026-03-05 16:32:57 | 1 | 2026-03-22 17:35:27.977975 |
| ZT26013100419904 | Pastaria 26男款复合风衣-头版-YS9829MO | L | 曾亭 | 324493 | 366858 | 2026-03-05 16:32:57 | 2 | 2026-03-22 17:35:27.976423 |
| ZT26013100419903 | Pastaria 26男款复合风衣-头版-YS9829MO | M | 曾亭 | 324493 | 366858 | 2026-03-05 16:32:57 | 4 | 2026-03-22 17:35:27.974921 |
| ZT26013100419902 | Pastaria 26男款复合风衣-头版-YS9829MO | S | 曾亭 | 324493 | 366858 | 2026-03-05 16:32:57 | 1 | 2026-03-22 17:35:27.973400 |
| ZT26013100199905 | Pastaria 26男款短上衣-头版-YS9409MEKO | XL | 曾亭 | 324275 | 366860 | 2026-03-05 16:33:27 | 2 | 2026-03-22 17:35:27.971878 |
| ZT26013100199904 | Pastaria 26男款短上衣-头版-YS9409MEKO | L | 曾亭 | 324275 | 366860 | 2026-03-05 16:33:27 | 9 | 2026-03-22 17:35:27.970306 |
| ZT26013100199903 | Pastaria 26男款短上衣-头版-YS9409MEKO | M | 曾亭 | 324275 | 366860 | 2026-03-05 16:33:27 | 7 | 2026-03-22 17:35:27.968782 |
| ZT26013100199902 | Pastaria 26男款短上衣-头版-YS9409MEKO | S | 曾亭 | 324275 | 366860 | 2026-03-05 16:33:27 | 2 | 2026-03-22 17:35:27.967238 |
| ZT26013100199901 | Pastaria 26男款短上衣-头版-YS9409MEKO | XS | 曾亭 | 324275 | 366860 | 2026-03-05 16:33:27 | 3 | 2026-03-22 17:35:27.965668 |
| ZT26012400249906 | Velo Atlanta Pro男款背带短裤-头版-YS2025MXF | 2XL | 曾亭 | 322196 | 366861 | 2026-03-05 16:33:57 | 1 | 2026-03-22 17:35:27.964140 |
| ZT26012400249904 | Velo Atlanta Pro男款背带短裤-头版-YS2025MXF | L | 曾亭 | 322196 | 366861 | 2026-03-05 16:33:57 | 6 | 2026-03-22 17:35:27.962580 |
| ZT26012400249903 | Velo Atlanta Pro男款背带短裤-头版-YS2025MXF | M | 曾亭 | 322196 | 366861 | 2026-03-05 16:33:57 | 1 | 2026-03-22 17:35:27.960985 |