到货库存导入(采购入库 Excel)
系统会从 Excel 中抓取:款式编号(清洗为SKU)、款式SKU、颜色及规格(提取尺码)、数量、商品名称、运营仓库、采购单号、入仓单号、采购员、入库日期。
库存汇总
| 产品SKU | 中文名 | 尺码 | 采购员 | 采购单号 | 入仓单号 | 入库日期 | 当前库存 | 更新时间 |
|---|---|---|---|---|---|---|---|---|
| LF25123000079903 | AMRUN-PAOLA2男款T恤-头版-YS9068MYH | M | 罗兰方 | 314723 | 348821 | 2026-01-05 17:28:22 | 3 | 2026-03-22 17:35:53.853412 |
| LF25123000079902 | AMRUN-PAOLA2男款T恤-头版-YS9068MYH | S | 罗兰方 | 314723 | 348821 | 2026-01-05 17:28:22 | 1 | 2026-03-22 17:35:53.851052 |
| LF25123000079901 | AMRUN-PAOLA2男款T恤-头版-YS9068MYH | XS | 罗兰方 | 314723 | 348821 | 2026-01-05 17:28:22 | 3 | 2026-03-22 17:35:53.799307 |
| YY25122200019902 | WT VC Comp铁三短袖男款连体衣-头版-YS9286MB | S | 刘莹滢 | 314773 | 348824 | 2026-01-05 17:29:56 | 1 | 2026-03-22 17:35:53.797348 |
| DZ256000019904 | Hero-2025冲孔胶条接筒袜 | L | 黄伟懿 | 314774 | 348825 | 2026-01-05 17:31:01 | 1 | 2026-03-22 17:35:53.795460 |
| WT25122000039901 | AC training 2026男款短袖连体衣-头版-YS9251MHLO | XS | 黄婉婷 | 314791 | 348833 | 2026-01-05 17:55:03 | 1 | 2026-03-22 17:35:53.793561 |
| WT25122000019901 | AC training 2026男款背带短裤-头版-YS2129MO | XS | 黄婉婷 | 314791 | 348833 | 2026-01-05 17:55:03 | 1 | 2026-03-22 17:35:53.791636 |
| DZ252400329904 | 2025大华国小女款背带长裤 | L | 何佳欣 | 311266 | 348932 | 2026-01-06 10:41:25 | 3 | 2026-03-22 17:35:53.789597 |
| DZ251400499902 | 凯乐石VG2616201水晶紫女款马甲 | S | 黄瑞辉 | 314827 | 348910 | 2026-03-09 11:09:10 | 4 | 2026-03-22 17:35:53.789460 |
| DZ251400489903 | 凯乐石VG2616101灰棕色男款马甲 | M | 黄瑞辉 | 314827 | 348910 | 2026-03-09 11:09:10 | 4 | 2026-03-22 17:35:53.789456 |
| DZ252400329903 | 2025大华国小女款背带长裤 | M | 何佳欣 | 311266 | 348932 | 2026-01-06 10:41:25 | 2 | 2026-03-22 17:35:53.785531 |
| DZ252400329902 | 2025大华国小女款背带长裤 | S | 何佳欣 | 311266 | 348932 | 2026-01-06 10:41:25 | 2 | 2026-03-22 17:35:53.783918 |
| RX25121300759903 | CUPCKE-Kieran Kelso男款短袖连体衣-头版-YS9229MCKO | M | 袁日仙 | 311674 | 348935 | 2026-01-06 10:42:32 | 1 | 2026-03-22 17:35:53.782329 |
| RX25122200059903 | CUPCKE-Foot Traffic男款慢跑背心-头版-YS555MAFO | M | 袁日仙 | 313678 | 348936 | 2026-01-06 10:44:17 | 1 | 2026-03-22 17:35:53.780796 |
| RX25122200049903 | CUPCKE-Foot Traffic女款慢跑背心-头版-YS9457WAFO | M | 袁日仙 | 313678 | 348936 | 2026-01-06 10:44:17 | 1 | 2026-03-22 17:35:53.779252 |
| RX25122200039903 | CUPCKE-Foot Traffic男款T恤-头版-YS9068MDQT | M | 袁日仙 | 313678 | 348936 | 2026-01-06 10:44:17 | 1 | 2026-03-22 17:35:53.777680 |
| ZT25121700219904 | Ride for Resilience女款短上衣-头版-YS9667WQO | L | 曾亭 | 311995 | 348937 | 2026-01-06 10:45:03 | 1 | 2026-03-22 17:35:53.776128 |
| ZT25121700219903 | Ride for Resilience女款短上衣-头版-YS9667WQO | M | 曾亭 | 311995 | 348937 | 2026-01-06 10:45:03 | 3 | 2026-03-22 17:35:53.774361 |
| ZT25121700219902 | Ride for Resilience女款短上衣-头版-YS9667WQO | S | 曾亭 | 311995 | 348937 | 2026-01-06 10:45:03 | 1 | 2026-03-22 17:35:53.772623 |
| ZT25121700209905 | Ride for Resilience男款短上衣-头版-YS9667MHO | XL | 曾亭 | 311995 | 348937 | 2026-01-06 10:45:03 | 2 | 2026-03-22 17:35:53.770944 |