到货库存导入(采购入库 Excel)
系统会从 Excel 中抓取:款式编号(清洗为SKU)、款式SKU、颜色及规格(提取尺码)、数量、商品名称、运营仓库、采购单号、入仓单号、采购员、入库日期。
库存汇总
| 产品SKU | 中文名 | 尺码 | 采购员 | 采购单号 | 入仓单号 | 入库日期 | 当前库存 | 更新时间 |
|---|---|---|---|---|---|---|---|---|
| ZT25123001139908 | DHL25 Frost sport男款短上衣-头版-YS9409MO | 4XL | 曾亭 | 315529 | 352065 | 2026-01-15 10:53:59 | 1 | 2026-03-22 17:35:48.888818 |
| ZT25123001139906 | DHL25 Frost sport男款短上衣-头版-YS9409MO | 2XL | 曾亭 | 315529 | 352065 | 2026-01-15 10:53:59 | 2 | 2026-03-22 17:35:48.887255 |
| ZT25123001139905 | DHL25 Frost sport男款短上衣-头版-YS9409MO | XL | 曾亭 | 315529 | 352065 | 2026-01-15 10:53:59 | 1 | 2026-03-22 17:35:48.885673 |
| ZT25123001139903 | DHL25 Frost sport男款短上衣-头版-YS9409MO | M | 曾亭 | 315529 | 352065 | 2026-01-15 10:53:59 | 1 | 2026-03-22 17:35:48.884165 |
| RX25121700279906 | BNECC Ride Leader男款短上衣-头版-YS9409MDAS | 2XL | 袁日仙 | 312386 | 352066 | 2026-01-15 10:54:28 | 2 | 2026-03-22 17:35:48.882549 |
| RX25121700279905 | BNECC Ride Leader男款短上衣-头版-YS9409MDAS | XL | 袁日仙 | 312386 | 352066 | 2026-01-15 10:54:28 | 6 | 2026-03-22 17:35:48.880666 |
| RX25121700279904 | BNECC Ride Leader男款短上衣-头版-YS9409MDAS | L | 袁日仙 | 312386 | 352066 | 2026-01-15 10:54:28 | 12 | 2026-03-22 17:35:48.879033 |
| RX25121700279903 | BNECC Ride Leader男款短上衣-头版-YS9409MDAS | M | 袁日仙 | 312386 | 352066 | 2026-01-15 10:54:28 | 3 | 2026-03-22 17:35:48.877493 |
| ZT25123000589903 | Form 26 Elite男款长上衣-头版-YS9851MAO | M | 曾亭 | 315257 | 352231 | 2026-01-15 15:35:41 | 1 | 2026-03-22 17:35:48.875980 |
| RX26010700459902 | CUPCKE-Emma Watson NZ女款短上衣-头版-YS9421WCO | S | 袁日仙 | 316611 | 352232 | 2026-01-15 15:37:39 | 1 | 2026-03-22 17:35:48.874407 |
| MJ25121700029902 | Brett Sizwe Amanzi女款短上衣-头版-YS9407WO | S | 庄镘洁 | 312043 | 352233 | 2026-01-15 15:39:14 | 3 | 2026-03-22 17:35:48.872673 |
| MJ25121700029903 | Brett Sizwe Amanzi女款短上衣-头版-YS9407WO | M | 庄镘洁 | 312043 | 352233 | 2026-02-03 18:23:07 | 6 | 2026-03-22 17:35:48.872557 |
| YK25122000029904 | spkid B-25男款长袖连体衣-头版-YS9236M | L | 何咏凯 | 312496 | 352235 | 2026-01-15 15:40:52 | 5 | 2026-03-22 17:35:48.869690 |
| YK25122000029903 | spkid B-25男款长袖连体衣-头版-YS9236M | M | 何咏凯 | 312496 | 352235 | 2026-01-15 15:40:52 | 5 | 2026-03-22 17:35:48.868169 |
| YK25122000029902 | spkid B-25男款长袖连体衣-头版-YS9236M | S | 何咏凯 | 312496 | 352235 | 2026-01-15 15:40:52 | 4 | 2026-03-22 17:35:48.866608 |
| YK25122000029901 | spkid B-25男款长袖连体衣-头版-YS9236M | XS | 何咏凯 | 312496 | 352235 | 2026-01-15 15:40:52 | 1 | 2026-03-22 17:35:48.865057 |
| DQ25122200059910 | ELK-BLACK男款抓绒长上衣-二版-CD044MBAO | 6XL | 吕丹琪 | 313321 | 352236 | 2026-01-15 15:41:39 | 3 | 2026-03-22 17:35:48.863168 |
| DQ25122200059909 | ELK-BLACK男款抓绒长上衣-二版-CD044MBAO | 5XL | 吕丹琪 | 313321 | 352236 | 2026-01-15 15:41:39 | 4 | 2026-03-22 17:35:48.861535 |
| DQ25122200059907 | ELK-BLACK男款抓绒长上衣-二版-CD044MBAO | 3XL | 吕丹琪 | 313321 | 352236 | 2026-01-15 15:41:39 | 10 | 2026-03-22 17:35:48.860033 |
| DQ25122200059906 | ELK-BLACK男款抓绒长上衣-二版-CD044MBAO | 2XL | 吕丹琪 | 313321 | 352236 | 2026-01-15 15:41:39 | 20 | 2026-03-22 17:35:48.858490 |