到货库存导入(采购入库 Excel)
系统会从 Excel 中抓取:款式编号(清洗为SKU)、款式SKU、颜色及规格(提取尺码)、数量、商品名称、运营仓库、采购单号、入仓单号、采购员、入库日期。
库存汇总
| 产品SKU | 中文名 | 尺码 | 采购员 | 采购单号 | 入仓单号 | 入库日期 | 当前库存 | 更新时间 |
|---|---|---|---|---|---|---|---|---|
| ZT25121700349902 | PalmCoast sport男款背带短裤-头版-YS9149MH | S | 曾亭 | 312027 | 349217 | 2026-01-06 17:58:14 | 1 | 2026-03-22 17:35:53.257081 |
| RX25090100199904 | Rattlesnake男款短上衣-YS9735MT | L | 袁日仙 | 312508 | 349216 | 2026-03-02 10:49:32 | 4 | 2026-03-22 17:35:53.256943 |
| RX25122000439906 | Rattlesnake-black男款短上衣-头版-YS9735MT | 2XL | 袁日仙 | 312508 | 349216 | 2026-03-02 10:49:32 | 3 | 2026-03-22 17:35:53.256941 |
| RX25122000439905 | Rattlesnake-black男款短上衣-头版-YS9735MT | XL | 袁日仙 | 312508 | 349216 | 2026-03-02 10:49:32 | 3 | 2026-03-22 17:35:53.256938 |
| WT25121300249902 | AC-Fuetiao男款长上衣-头版-YS9795MRO | S | 黄婉婷 | 311485 | 349218 | 2026-01-06 17:58:35 | 3 | 2026-03-22 17:35:53.252196 |
| WT25121300249901 | AC-Fuetiao男款长上衣-头版-YS9795MRO | XS | 黄婉婷 | 311485 | 349218 | 2026-01-06 17:58:35 | 3 | 2026-03-22 17:35:53.199133 |
| JB25122200129905 | COXX Blue男款短上衣-头版-YS8137MT | XL | 郑杰彬 | 315044 | 349222 | 2026-01-06 18:09:26 | 1 | 2026-03-22 17:35:53.197276 |
| JB25122200129904 | COXX Blue男款短上衣-头版-YS8137MT | L | 郑杰彬 | 315044 | 349222 | 2026-01-06 18:09:26 | 1 | 2026-03-22 17:35:53.195613 |
| JB25122200119905 | COXX Yellow男款短上衣-头版-YS8137MT | XL | 郑杰彬 | 315044 | 349222 | 2026-01-06 18:09:26 | 1 | 2026-03-22 17:35:53.193616 |
| JB25122200119904 | COXX Yellow男款短上衣-头版-YS8137MT | L | 郑杰彬 | 315044 | 349222 | 2026-01-06 18:09:26 | 1 | 2026-03-22 17:35:53.192080 |
| JB25122200109905 | COXX Red男款短上衣-头版-YS8137MT | XL | 郑杰彬 | 315044 | 349222 | 2026-01-06 18:09:26 | 1 | 2026-03-22 17:35:53.190503 |
| JB25122200109904 | COXX Red男款短上衣-头版-YS8137MT | L | 郑杰彬 | 315044 | 349222 | 2026-01-06 18:09:26 | 1 | 2026-03-22 17:35:53.189013 |
| JB25122200099905 | COXX Black男款背带短裤-头版-YS2029MT | XL | 郑杰彬 | 315044 | 349222 | 2026-01-06 18:09:26 | 1 | 2026-03-22 17:35:53.187506 |
| JB25122200099904 | COXX Black男款背带短裤-头版-YS2029MT | L | 郑杰彬 | 315044 | 349222 | 2026-01-06 18:09:26 | 2 | 2026-03-22 17:35:53.185992 |
| YY25110500129905 | WT 2026 Black Mitte男款长上衣-头版-YS9681MHO | XL | 刘莹滢 | 315048 | 349227 | 2026-01-06 18:15:34 | 1 | 2026-03-22 17:35:53.184417 |
| JB25123000059903 | ICARUS男款跑步背心-头版-YS8127MT | M | 郑杰彬 | 315047 | 349224 | 2026-01-27 11:00:55 | 11 | 2026-03-22 17:35:53.184295 |
| JB25123000069903 | ICARUS男款跑步短裤-头版-YS2214MLT | M | 郑杰彬 | 315047 | 349224 | 2026-01-30 17:20:47 | 11 | 2026-03-22 17:35:53.184292 |
| YY25110500149906 | WT 2026 Black男款铁三背心-头版-YS9730MHO | 2XL | 刘莹滢 | 315048 | 349227 | 2026-01-06 18:15:34 | 1 | 2026-03-22 17:35:53.180993 |
| MY25120300159903 | spatz convoy2 brown男款背带短裤-头版-YS2141M | M | 胡美英 | 315049 | 349229 | 2026-01-06 18:16:35 | 1 | 2026-03-22 17:35:53.179446 |
| MY25120300159902 | spatz convoy2 brown男款背带短裤-头版-YS2141M | S | 胡美英 | 315049 | 349229 | 2026-01-06 18:16:35 | 1 | 2026-03-22 17:35:53.177928 |