到货库存导入(采购入库 Excel)
系统会从 Excel 中抓取:款式编号(清洗为SKU)、款式SKU、颜色及规格(提取尺码)、数量、商品名称、运营仓库、采购单号、入仓单号、采购员、入库日期。
库存汇总
| 产品SKU | 中文名 | 尺码 | 采购员 | 采购单号 | 入仓单号 | 入库日期 | 当前库存 | 更新时间 |
|---|---|---|---|---|---|---|---|---|
| ZT25123001079907 | DHL25 Carbon男款POLO衫-头版-YS9697MLO | 3XL | 曾亭 | 315527 | 352276 | 2026-01-15 17:05:36 | 1 | 2026-03-22 17:35:48.684580 |
| ZT25123001079906 | DHL25 Carbon男款POLO衫-头版-YS9697MLO | 2XL | 曾亭 | 315527 | 352276 | 2026-01-15 17:05:36 | 2 | 2026-03-22 17:35:48.682602 |
| ZT25123001079904 | DHL25 Carbon男款POLO衫-头版-YS9697MLO | L | 曾亭 | 315527 | 352276 | 2026-01-15 17:05:36 | 7 | 2026-03-22 17:35:48.680531 |
| ZT25123001079905 | DHL25 Carbon男款POLO衫-头版-YS9697MLO | XL | 曾亭 | 315527 | 352276 | 2026-02-28 15:29:44 | 6 | 2026-03-22 17:35:48.680390 |
| ZT25123001079903 | DHL25 Carbon男款POLO衫-头版-YS9697MLO | M | 曾亭 | 315527 | 352276 | 2026-01-15 17:05:36 | 3 | 2026-03-22 17:35:48.677286 |
| RX25121700269904 | BNECC Ride Leader女款短上衣-头版-YS9409WAKS | L | 袁日仙 | 312386 | 352277 | 2026-01-15 17:11:44 | 4 | 2026-03-22 17:35:48.675354 |
| RX25121700269903 | BNECC Ride Leader女款短上衣-头版-YS9409WAKS | M | 袁日仙 | 312386 | 352277 | 2026-01-15 17:11:44 | 2 | 2026-03-22 17:35:48.673462 |
| RX25121700269902 | BNECC Ride Leader女款短上衣-头版-YS9409WAKS | S | 袁日仙 | 312386 | 352277 | 2026-01-15 17:11:44 | 2 | 2026-03-22 17:35:48.671602 |
| WT25122200059904 | 360-Fred Whitton男款短袖连体衣-头版-YS9251MO | L | 黄婉婷 | 313684 | 352278 | 2026-01-15 17:15:11 | 1 | 2026-03-22 17:35:48.669692 |
| WT25122200059903 | 360-Fred Whitton男款短袖连体衣-头版-YS9251MO | M | 黄婉婷 | 313684 | 352278 | 2026-01-15 17:15:11 | 2 | 2026-03-22 17:35:48.667549 |
| WT25122200059902 | 360-Fred Whitton男款短袖连体衣-头版-YS9251MO | S | 黄婉婷 | 313684 | 352278 | 2026-01-15 17:15:11 | 4 | 2026-03-22 17:35:48.665579 |
| WT25122200059901 | 360-Fred Whitton男款短袖连体衣-头版-YS9251MO | XS | 黄婉婷 | 313684 | 352278 | 2026-01-15 17:15:11 | 1 | 2026-03-22 17:35:48.663908 |
| ZT25123000089903 | Dogs Tucson25女款短上衣-头版-YS9409WKO | M | 曾亭 | 314744 | 352279 | 2026-01-15 17:15:54 | 2 | 2026-03-22 17:35:48.662180 |
| ZT26010700349904 | Eleven 26男款抓绒长上衣-头版-YS9057MCAT | L | 曾亭 | 316862 | 352280 | 2026-01-15 17:16:38 | 1 | 2026-03-22 17:35:48.660471 |
| ZT26010700349903 | Eleven 26男款抓绒长上衣-头版-YS9057MCAT | M | 曾亭 | 316862 | 352280 | 2026-01-15 17:16:38 | 2 | 2026-03-22 17:35:48.658815 |
| ZT26010700259903 | Chaney 25男款短袖连体衣-头版-YS9212MJFO | M | 曾亭 | 316595 | 352281 | 2026-01-15 17:17:05 | 2 | 2026-03-22 17:35:48.656999 |
| ZT26010700259902 | Chaney 25男款短袖连体衣-头版-YS9212MJFO | S | 曾亭 | 316595 | 352281 | 2026-01-15 17:17:05 | 3 | 2026-03-22 17:35:48.654896 |
| ZT25123000409903 | FV 26 TT男款短袖连体衣-头版-YS9211MCO | M | 曾亭 | 315016 | 352282 | 2026-01-15 17:17:33 | 3 | 2026-03-22 17:35:48.652769 |
| ZT25123000409902 | FV 26 TT男款短袖连体衣-头版-YS9211MCO | S | 曾亭 | 315016 | 352282 | 2026-01-15 17:17:33 | 2 | 2026-03-22 17:35:48.599444 |
| RX26010700439902 | CUPCKE-Emma Watson NZ女款背带短裤-头版-YS9113WO | S | 袁日仙 | 316611 | 352286 | 2026-01-15 17:18:58 | 1 | 2026-03-22 17:35:48.597881 |