到货库存导入(采购入库 Excel)
系统会从 Excel 中抓取:款式编号(清洗为SKU)、款式SKU、颜色及规格(提取尺码)、数量、商品名称、运营仓库、采购单号、入仓单号、采购员、入库日期。
库存汇总
| 产品SKU | 中文名 | 尺码 | 采购员 | 采购单号 | 入仓单号 | 入库日期 | 当前库存 | 更新时间 |
|---|---|---|---|---|---|---|---|---|
| DQ20221217089905 | 007c-2反光骑行夹克 | XL | 吕丹琪 | 297389 | 347891 | 2026-01-02 15:15:35 | 20 | 2026-03-22 17:35:55.090287 |
| DQ20221217089906 | 007c-2反光骑行夹克 | 2XL | 吕丹琪 | 297389 | 347891 | 2026-01-02 15:15:35 | 10 | 2026-03-22 17:35:55.088722 |
| DZ252200439904 | 2025大华国小男款背带短裤 | L | 何佳欣 | 311266 | 347941 | 2026-01-02 17:16:46 | 6 | 2026-03-22 17:35:55.087196 |
| DZ252200439905 | 2025大华国小男款背带短裤 | XL | 何佳欣 | 311266 | 347941 | 2026-01-02 17:16:46 | 1 | 2026-03-22 17:35:55.085630 |
| DZ252200439906 | 2025大华国小男款背带短裤 | 2XL | 何佳欣 | 311266 | 347941 | 2026-01-02 17:16:46 | 1 | 2026-03-22 17:35:55.084141 |
| DZ252200439907 | 2025大华国小男款背带短裤 | 3XL | 何佳欣 | 311266 | 347941 | 2026-01-02 17:16:46 | 1 | 2026-03-22 17:35:55.082547 |
| 1231600489900 | 行者EVO紫色小布帽 | F | 黄婉婷 | 313840 | 347942 | 2026-01-02 17:17:32 | 7 | 2026-03-22 17:35:55.080989 |
| RX25071900319903 | SG-Wokingham CC女款防风背心-YS9826WAO | M | 袁日仙 | 311192 | 347949 | 2026-01-02 17:19:13 | 1 | 2026-03-22 17:35:55.079445 |
| RX25071900319905 | SG-Wokingham CC女款防风背心-YS9826WAO | XL | 袁日仙 | 311192 | 347949 | 2026-01-02 17:19:13 | 1 | 2026-03-22 17:35:55.077877 |
| RX25071900329902 | SG-Wokingham CC男款防风背心-YS9826MDO | S | 袁日仙 | 311192 | 347949 | 2026-01-02 17:19:13 | 1 | 2026-03-22 17:35:55.076327 |
| RX25071900329903 | SG-Wokingham CC男款防风背心-YS9826MDO | M | 袁日仙 | 311192 | 347949 | 2026-01-02 17:19:13 | 1 | 2026-03-22 17:35:55.074787 |
| RX25071900329904 | SG-Wokingham CC男款防风背心-YS9826MDO | L | 袁日仙 | 311192 | 347949 | 2026-01-02 17:19:13 | 1 | 2026-03-22 17:35:55.073262 |
| RX25071900329905 | SG-Wokingham CC男款防风背心-YS9826MDO | XL | 袁日仙 | 311192 | 347949 | 2026-01-02 17:19:13 | 1 | 2026-03-22 17:35:55.071771 |
| RX25121300309901 | CUPCKE-26Valkyrie女款无袖连体衣-头版-YS9229WQO | XS | 袁日仙 | 311240 | 347950 | 2026-01-02 17:19:52 | 1 | 2026-03-22 17:35:55.070193 |
| RX25121300329902 | CUPCKE-26Valkyrie-A女款短袖连体衣-头版-YS9229WXZO | S | 袁日仙 | 311240 | 347950 | 2026-01-02 17:19:52 | 3 | 2026-03-22 17:35:55.068617 |
| RX25121300329903 | CUPCKE-26Valkyrie-A女款短袖连体衣-头版-YS9229WXZO | M | 袁日仙 | 311240 | 347950 | 2026-01-02 17:19:52 | 5 | 2026-03-22 17:35:55.066714 |
| RX25121300329904 | CUPCKE-26Valkyrie-A女款短袖连体衣-头版-YS9229WXZO | L | 袁日仙 | 311240 | 347950 | 2026-01-02 17:19:52 | 1 | 2026-03-22 17:35:55.065200 |
| RX25121300339903 | CUPCKE-26Valkyrie-B女款短袖连体衣-头版-YS9229WXYO | M | 袁日仙 | 311240 | 347950 | 2026-01-02 17:19:52 | 1 | 2026-03-22 17:35:55.063671 |
| ZT25120600149901 | Hewitt sport男款短上衣-头版-YS9409MO | XS | 曾亭 | 309281 | 347951 | 2026-01-02 17:20:25 | 3 | 2026-03-22 17:35:55.061817 |
| ZT25120600149902 | Hewitt sport男款短上衣-头版-YS9409MO | S | 曾亭 | 309281 | 347951 | 2026-01-02 17:20:25 | 2 | 2026-03-22 17:35:55.059493 |