到货库存导入(采购入库 Excel)
系统会从 Excel 中抓取:款式编号(清洗为SKU)、款式SKU、颜色及规格(提取尺码)、数量、商品名称、运营仓库、采购单号、入仓单号、采购员、入库日期。
库存汇总
| 产品SKU | 中文名 | 尺码 | 采购员 | 采购单号 | 入仓单号 | 入库日期 | 当前库存 | 更新时间 |
|---|---|---|---|---|---|---|---|---|
| ZT25122000209903 | Lemmonaid Yellow Elite女款长上衣-头版-YS9851WO | M | 曾亭 | 313042 | 351680 | 2026-01-14 10:45:48 | 1 | 2026-03-22 17:35:49.565872 |
| ZT25122000199905 | Lemmonaid Yellow Elite男款长上衣-头版-YS9851MAO | XL | 曾亭 | 313042 | 351680 | 2026-01-14 10:45:48 | 1 | 2026-03-22 17:35:49.564352 |
| ZT25122000199904 | Lemmonaid Yellow Elite男款长上衣-头版-YS9851MAO | L | 曾亭 | 313042 | 351680 | 2026-01-14 10:45:48 | 1 | 2026-03-22 17:35:49.562841 |
| ZT25122000199903 | Lemmonaid Yellow Elite男款长上衣-头版-YS9851MAO | M | 曾亭 | 313042 | 351680 | 2026-01-14 10:45:48 | 2 | 2026-03-22 17:35:49.561303 |
| RX26010700159903 | CUPCKE-GOSCHE女款短上衣-头版-YS9421WCO | M | 袁日仙 | 315632 | 351681 | 2026-01-14 10:46:42 | 1 | 2026-03-22 17:35:49.559762 |
| RX25122200089903 | CUPCKE-Foot Traffic男款短袖连体衣-头版-YS9229MCJO | M | 袁日仙 | 313678 | 351683 | 2026-01-14 10:48:07 | 1 | 2026-03-22 17:35:49.558188 |
| RX25122200079904 | CUPCKE-Foot Traffic-A男款短袖连体衣-头版-YS9229MCKO | L | 袁日仙 | 313678 | 351683 | 2026-01-14 10:48:07 | 1 | 2026-03-22 17:35:49.556548 |
| ZT26010700249901 | Chaney 25 Pro男款背带短裤-头版-YS2025MXF | XS | 曾亭 | 316595 | 351686 | 2026-01-14 10:49:16 | 1 | 2026-03-22 17:35:49.554630 |
| ZT26010700149903 | BH 26 white男款短袖连体衣-头版-YS9212MJFO | M | 曾亭 | 316002 | 351685 | 2026-01-29 14:02:04 | 5 | 2026-03-22 17:35:49.554467 |
| ZT26010700149902 | BH 26 white男款短袖连体衣-头版-YS9212MJFO | S | 曾亭 | 316002 | 351685 | 2026-01-29 14:02:04 | 6 | 2026-03-22 17:35:49.554466 |
| ZT26010700249904 | Chaney 25 Pro男款背带短裤-头版-YS2025MXF | L | 曾亭 | 316595 | 351686 | 2026-03-02 15:55:29 | 5 | 2026-03-22 17:35:49.554464 |
| ZT26010700249903 | Chaney 25 Pro男款背带短裤-头版-YS2025MXF | M | 曾亭 | 316595 | 351686 | 2026-03-02 15:55:29 | 9 | 2026-03-22 17:35:49.554462 |
| ZT26010700249902 | Chaney 25 Pro男款背带短裤-头版-YS2025MXF | S | 曾亭 | 316595 | 351686 | 2026-03-02 15:55:29 | 7 | 2026-03-22 17:35:49.554459 |
| RX25070800159905 | LBCC-26 GRAY女款防风背心-YS9099WCO | XL | 袁日仙 | 306785 | 351687 | 2026-01-14 10:49:39 | 2 | 2026-03-22 17:35:49.497222 |
| RX25070800159904 | LBCC-26 GRAY女款防风背心-YS9099WCO | L | 袁日仙 | 306785 | 351687 | 2026-01-14 10:49:39 | 9 | 2026-03-22 17:35:49.495606 |
| RX25070800159903 | LBCC-26 GRAY女款防风背心-YS9099WCO | M | 袁日仙 | 306785 | 351687 | 2026-01-14 10:49:39 | 14 | 2026-03-22 17:35:49.494029 |
| RX25070800159902 | LBCC-26 GRAY女款防风背心-YS9099WCO | S | 袁日仙 | 306785 | 351687 | 2026-01-14 10:49:39 | 14 | 2026-03-22 17:35:49.492445 |
| RX25070800159901 | LBCC-26 GRAY女款防风背心-YS9099WCO | XS | 袁日仙 | 306785 | 351687 | 2026-01-14 10:49:39 | 7 | 2026-03-22 17:35:49.490872 |
| RX25070800159911 | LBCC-26 GRAY女款防风背心-YS9099WCO | 2XS | 袁日仙 | 306785 | 351687 | 2026-01-14 10:49:39 | 1 | 2026-03-22 17:35:49.489328 |
| DQ2407160099909 | 24ARROW-GRAY男款抓绒长上衣-CD044MBAO | 5XL | 吕丹琪 | 313321 | 351688 | 2026-01-14 10:50:10 | 3 | 2026-03-22 17:35:49.487797 |