到货库存导入(采购入库 Excel)
系统会从 Excel 中抓取:款式编号(清洗为SKU)、款式SKU、颜色及规格(提取尺码)、数量、商品名称、运营仓库、采购单号、入仓单号、采购员、入库日期。
库存汇总
| 产品SKU | 中文名 | 尺码 | 采购员 | 采购单号 | 入仓单号 | 入库日期 | 当前库存 | 更新时间 |
|---|---|---|---|---|---|---|---|---|
| LF2405080089904 | 24ASTANA男款长上衣-CD037M | L | 刘莹滢 | 324248 | 365041 | 2026-03-02 10:48:37 | 2 | 2026-03-22 17:35:29.785293 |
| LF2405080089902 | 24ASTANA男款长上衣-CD037M | S | 刘莹滢 | 324248 | 365041 | 2026-03-02 10:48:37 | 2 | 2026-03-22 17:35:29.783297 |
| LF2405080089901 | 24ASTANA男款长上衣-CD037M | XS | 刘莹滢 | 324248 | 365041 | 2026-03-02 10:48:37 | 2 | 2026-03-22 17:35:29.781344 |
| RX25090100199905 | Rattlesnake男款短上衣-YS9735MT | XL | 袁日仙 | 326594 | 365042 | 2026-03-02 10:49:32 | 2 | 2026-03-22 17:35:29.779413 |
| RX25122000439904 | Rattlesnake-black男款短上衣-头版-YS9735MT | L | 袁日仙 | 326594 | 365042 | 2026-03-02 10:49:32 | 1 | 2026-03-22 17:35:29.773574 |
| RX25122000439903 | Rattlesnake-black男款短上衣-头版-YS9735MT | M | 袁日仙 | 326594 | 365042 | 2026-03-02 10:49:32 | 2 | 2026-03-22 17:35:29.769672 |
| RX25122000439902 | Rattlesnake-black男款短上衣-头版-YS9735MT | S | 袁日仙 | 326594 | 365042 | 2026-03-02 10:49:32 | 2 | 2026-03-22 17:35:29.767726 |
| RX26012400109904 | LBCC-26 PRO RC TEAL男款短上衣-头版-YS9406MKFO | L | 袁日仙 | 320915 | 365043 | 2026-03-02 10:50:30 | 3 | 2026-03-22 17:35:29.765784 |
| RX26012400109903 | LBCC-26 PRO RC TEAL男款短上衣-头版-YS9406MKFO | M | 袁日仙 | 320915 | 365043 | 2026-03-02 10:50:30 | 5 | 2026-03-22 17:35:29.763830 |
| RX26012400109902 | LBCC-26 PRO RC TEAL男款短上衣-头版-YS9406MKFO | S | 袁日仙 | 320915 | 365043 | 2026-03-02 10:50:30 | 2 | 2026-03-22 17:35:29.761860 |
| RX26012400109901 | LBCC-26 PRO RC TEAL男款短上衣-头版-YS9406MKFO | XS | 袁日仙 | 320915 | 365043 | 2026-03-02 10:50:30 | 1 | 2026-03-22 17:35:29.759934 |
| ZT26012400219905 | Velo Atlanta sport男款短上衣-头版-YS9409MO | XL | 曾亭 | 322196 | 365044 | 2026-03-02 10:51:03 | 1 | 2026-03-22 17:35:29.757976 |
| ZT26012400219904 | Velo Atlanta sport男款短上衣-头版-YS9409MO | L | 曾亭 | 322196 | 365044 | 2026-03-02 10:51:03 | 2 | 2026-03-22 17:35:29.755977 |
| RX2404020469904 | Trizer 2024男款跑步T恤-CY116M | L | 袁日仙 | 320897 | 365045 | 2026-03-02 10:51:44 | 2 | 2026-03-22 17:35:29.753683 |
| RX2404020469903 | Trizer 2024男款跑步T恤-CY116M | M | 袁日仙 | 320897 | 365045 | 2026-03-02 10:51:44 | 4 | 2026-03-22 17:35:29.751602 |
| RX2404020459903 | Trizer 2024女款跑步T恤-CY116W | M | 袁日仙 | 320897 | 365045 | 2026-03-02 10:51:44 | 1 | 2026-03-22 17:35:29.699783 |
| RX2404020459902 | Trizer 2024女款跑步T恤-CY116W | S | 袁日仙 | 320897 | 365045 | 2026-03-02 10:51:44 | 1 | 2026-03-22 17:35:29.697952 |
| RX2404020459901 | Trizer 2024女款跑步T恤-CY116W | XS | 袁日仙 | 320897 | 365045 | 2026-03-02 10:51:44 | 1 | 2026-03-22 17:35:29.696291 |
| ZT26020900069903 | D2D童装背带短裤-头版-YS2007MF | M | 曾亭 | 326354 | 365046 | 2026-03-02 10:52:58 | 1 | 2026-03-22 17:35:29.694549 |
| RX26020400059903 | SG-X SGRT男款防风背心-头版-YS9826MDO | M | 袁日仙 | 326540 | 365047 | 2026-03-02 10:53:34 | 5 | 2026-03-22 17:35:29.692951 |