到货库存导入(采购入库 Excel)
系统会从 Excel 中抓取:款式编号(清洗为SKU)、款式SKU、颜色及规格(提取尺码)、数量、商品名称、运营仓库、采购单号、入仓单号、采购员、入库日期。
库存汇总
| 产品SKU | 中文名 | 尺码 | 采购员 | 采购单号 | 入仓单号 | 入库日期 | 当前库存 | 更新时间 |
|---|---|---|---|---|---|---|---|---|
| DZ251400039905 | WAST-WIND VEST-YBT2025防风背心 | XL | 黄瑞辉 | 312168 | 351320 | 2026-01-13 11:00:58 | 3 | 2026-03-22 17:35:50.357781 |
| DZ251400039904 | WAST-WIND VEST-YBT2025防风背心 | L | 黄瑞辉 | 312168 | 351320 | 2026-01-13 11:00:58 | 3 | 2026-03-22 17:35:50.356060 |
| DZ251400039901 | WAST-WIND VEST-YBT2025防风背心 | XS | 黄瑞辉 | 312168 | 351320 | 2026-01-13 11:00:58 | 1 | 2026-03-22 17:35:50.354478 |
| 1221600769907 | 寒江抓绒护臂 | 3XL | 黄婉婷 | 313833 | 351321 | 2026-01-13 11:01:41 | 6 | 2026-03-22 17:35:50.352862 |
| 1221600769906 | 寒江抓绒护臂 | 2XL | 黄婉婷 | 313833 | 351321 | 2026-01-13 11:01:41 | 7 | 2026-03-22 17:35:50.350271 |
| 1221600769905 | 寒江抓绒护臂 | XL | 黄婉婷 | 313833 | 351321 | 2026-01-13 11:01:41 | 7 | 2026-03-22 17:35:50.299142 |
| YK25122000039905 | spkid A-25男款长袖连体衣-头版-YS9236M | XL | 何咏凯 | 312496 | 351322 | 2026-01-13 11:03:50 | 2 | 2026-03-22 17:35:50.297484 |
| YK25122000039904 | spkid A-25男款长袖连体衣-头版-YS9236M | L | 何咏凯 | 312496 | 351322 | 2026-01-13 11:03:50 | 5 | 2026-03-22 17:35:50.295870 |
| YK25122000039903 | spkid A-25男款长袖连体衣-头版-YS9236M | M | 何咏凯 | 312496 | 351322 | 2026-01-13 11:03:50 | 6 | 2026-03-22 17:35:50.294251 |
| YK25122000039902 | spkid A-25男款长袖连体衣-头版-YS9236M | S | 何咏凯 | 312496 | 351322 | 2026-01-13 11:03:50 | 5 | 2026-03-22 17:35:50.292637 |
| YK25122000039901 | spkid A-25男款长袖连体衣-头版-YS9236M | XS | 何咏凯 | 312496 | 351322 | 2026-01-13 11:03:50 | 2 | 2026-03-22 17:35:50.290951 |
| ZT25121300599903 | 904Duval MTB女款短裤-头版-YS2074MA | M | 曾亭 | 311662 | 351324 | 2026-01-13 11:04:53 | 1 | 2026-03-22 17:35:50.289241 |
| JB25122200139903 | LHippo v4女款短袖三铁连体衣-三版-YS9251WCV | M | 郑杰彬 | 314041 | 351323 | 2026-01-26 16:03:36 | 63 | 2026-03-22 17:35:50.289123 |
| JB25122200139902 | LHippo v4女款短袖三铁连体衣-三版-YS9251WCV | S | 郑杰彬 | 314041 | 351323 | 2026-01-26 16:03:36 | 63 | 2026-03-22 17:35:50.289119 |
| ZT25123000879904 | Momentous 26男款POLO衫-头版-YS9697MLO | L | 曾亭 | 315368 | 351325 | 2026-01-13 11:05:31 | 1 | 2026-03-22 17:35:50.285653 |
| MN25123000109903 | Blue70 26女款抓绒夹克-头版-YS9655WBT | M | 林美霓 | 315445 | 351326 | 2026-01-13 11:06:24 | 1 | 2026-03-22 17:35:50.284081 |
| DQ25122200049910 | 25Heat-Black男款抓绒长上衣-二版-CD044MBAO | 6XL | 吕丹琪 | 313321 | 351327 | 2026-01-13 11:06:57 | 5 | 2026-03-22 17:35:50.282427 |
| DQ25122200049909 | 25Heat-Black男款抓绒长上衣-二版-CD044MBAO | 5XL | 吕丹琪 | 313321 | 351327 | 2026-01-13 11:06:57 | 2 | 2026-03-22 17:35:50.280854 |
| DQ25122200049908 | 25Heat-Black男款抓绒长上衣-二版-CD044MBAO | 4XL | 吕丹琪 | 313321 | 351327 | 2026-01-13 11:06:57 | 5 | 2026-03-22 17:35:50.279101 |
| DQ25122200049907 | 25Heat-Black男款抓绒长上衣-二版-CD044MBAO | 3XL | 吕丹琪 | 313321 | 351327 | 2026-01-13 11:06:57 | 8 | 2026-03-22 17:35:50.277449 |