到货库存导入(采购入库 Excel)
系统会从 Excel 中抓取:款式编号(清洗为SKU)、款式SKU、颜色及规格(提取尺码)、数量、商品名称、运营仓库、采购单号、入仓单号、采购员、入库日期。
库存汇总
| 产品SKU | 中文名 | 尺码 | 采购员 | 采购单号 | 入仓单号 | 入库日期 | 当前库存 | 更新时间 |
|---|---|---|---|---|---|---|---|---|
| JN26012800029911 | ARG女款背带短裤-头版-YS9163WQAT | 2XS | 陈锦娜 | 323279 | 360976 | 2026-02-09 11:23:42 | 3 | 2026-03-22 17:35:32.166161 |
| RX26012100179905 | CUPCKE-Sarah Thomas男款慢跑背心-头版-YS555MAFO | XL | 袁日仙 | 320880 | 360977 | 2026-02-09 11:24:27 | 1 | 2026-03-22 17:35:32.164579 |
| RX26012100179903 | CUPCKE-Sarah Thomas男款慢跑背心-头版-YS555MAFO | M | 袁日仙 | 320880 | 360977 | 2026-02-09 11:24:27 | 1 | 2026-03-22 17:35:32.163026 |
| RX26012100169905 | CUPCKE-Sarah Thomas男款T恤-头版-YS9068MDQT | XL | 袁日仙 | 320880 | 360977 | 2026-02-09 11:24:27 | 1 | 2026-03-22 17:35:32.161428 |
| RX26012100169903 | CUPCKE-Sarah Thomas男款T恤-头版-YS9068MDQT | M | 袁日仙 | 320880 | 360977 | 2026-02-09 11:24:27 | 1 | 2026-03-22 17:35:32.159576 |
| RX26010700419908 | 26Stelvio-C2男款短上衣-二版-CY098MEO | 4XL | 袁日仙 | 316610 | 360981 | 2026-02-09 11:24:51 | 3 | 2026-03-22 17:35:32.157698 |
| RX26010700419907 | 26Stelvio-C2男款短上衣-二版-CY098MEO | 3XL | 袁日仙 | 316610 | 360981 | 2026-02-09 11:24:51 | 3 | 2026-03-22 17:35:32.156053 |
| RX26010700419906 | 26Stelvio-C2男款短上衣-二版-CY098MEO | 2XL | 袁日仙 | 316610 | 360981 | 2026-02-09 11:24:51 | 15 | 2026-03-22 17:35:32.154350 |
| RX26010700419905 | 26Stelvio-C2男款短上衣-二版-CY098MEO | XL | 袁日仙 | 316610 | 360981 | 2026-02-09 11:24:51 | 30 | 2026-03-22 17:35:32.152353 |
| RX26010700419904 | 26Stelvio-C2男款短上衣-二版-CY098MEO | L | 袁日仙 | 316610 | 360981 | 2026-02-09 11:24:51 | 40 | 2026-03-22 17:35:32.102206 |
| RX26010700419903 | 26Stelvio-C2男款短上衣-二版-CY098MEO | M | 袁日仙 | 316610 | 360981 | 2026-02-09 11:24:51 | 35 | 2026-03-22 17:35:32.100677 |
| RX26010700419902 | 26Stelvio-C2男款短上衣-二版-CY098MEO | S | 袁日仙 | 316610 | 360981 | 2026-02-09 11:24:51 | 10 | 2026-03-22 17:35:32.099192 |
| RX26010700419901 | 26Stelvio-C2男款短上衣-二版-CY098MEO | XS | 袁日仙 | 316610 | 360981 | 2026-02-09 11:24:51 | 5 | 2026-03-22 17:35:32.097660 |
| ZT26012400139904 | MACC 2023抓绒护臂-二版-YS9935MO | L | 曾亭 | 320858 | 360982 | 2026-02-09 11:25:23 | 1 | 2026-03-22 17:35:32.096135 |
| ZT26012400139903 | MACC 2023抓绒护臂-二版-YS9935MO | M | 曾亭 | 320858 | 360982 | 2026-02-09 11:25:23 | 1 | 2026-03-22 17:35:32.094452 |
| ZT26012400139901 | MACC 2023抓绒护臂-二版-YS9935MO | XS | 曾亭 | 320858 | 360982 | 2026-02-09 11:25:23 | 1 | 2026-03-22 17:35:32.092953 |
| MJ26012100089905 | ALR 2026 Black男款背带短裤-头版-YS2047MEBO | XL | 庄镘洁 | 320061 | 360983 | 2026-02-09 11:25:49 | 7 | 2026-03-22 17:35:32.091431 |
| MJ26012100089904 | ALR 2026 Black男款背带短裤-头版-YS2047MEBO | L | 庄镘洁 | 320061 | 360983 | 2026-02-09 11:25:49 | 11 | 2026-03-22 17:35:32.089900 |
| MJ26012100089903 | ALR 2026 Black男款背带短裤-头版-YS2047MEBO | M | 庄镘洁 | 320061 | 360983 | 2026-02-09 11:25:49 | 17 | 2026-03-22 17:35:32.088368 |
| MJ26012100089902 | ALR 2026 Black男款背带短裤-头版-YS2047MEBO | S | 庄镘洁 | 320061 | 360983 | 2026-02-09 11:25:49 | 17 | 2026-03-22 17:35:32.086828 |