到货库存导入(采购入库 Excel)
系统会从 Excel 中抓取:款式编号(清洗为SKU)、款式SKU、颜色及规格(提取尺码)、数量、商品名称、运营仓库、采购单号、入仓单号、采购员、入库日期。
库存汇总
| 产品SKU | 中文名 | 尺码 | 采购员 | 采购单号 | 入仓单号 | 入库日期 | 当前库存 | 更新时间 |
|---|---|---|---|---|---|---|---|---|
| RX26010700289902 | raw-26blue grey w女款背带短裤-头版-YS2057WO | S | 袁日仙 | 316014 | 359545 | 2026-02-05 14:29:31 | 16 | 2026-03-22 17:35:35.161992 |
| ZT26011000399904 | ENVE 26男款无袖三铁连体衣-头版-YS9794MD | L | 曾亭 | 317658 | 359546 | 2026-02-05 14:30:17 | 1 | 2026-03-22 17:35:35.160046 |
| YL26011400029905 | AZ shirt white-2男款短衬衫-头版-YS8223MD | XL | 甘雅玲 | 319015 | 359547 | 2026-02-05 14:30:42 | 3 | 2026-03-22 17:35:35.158074 |
| YL26011400029904 | AZ shirt white-2男款短衬衫-头版-YS8223MD | L | 甘雅玲 | 319015 | 359547 | 2026-02-05 14:30:42 | 5 | 2026-03-22 17:35:35.156116 |
| YL26011400029902 | AZ shirt white-2男款短衬衫-头版-YS8223MD | S | 甘雅玲 | 319015 | 359547 | 2026-02-05 14:30:42 | 6 | 2026-03-22 17:35:35.154092 |
| YL26011400029903 | AZ shirt white-2男款短衬衫-头版-YS8223MD | M | 甘雅玲 | 319015 | 359547 | 2026-02-05 14:30:42 | 7 | 2026-03-22 17:35:35.151468 |
| YL26011400029901 | AZ shirt white-2男款短衬衫-头版-YS8223MD | XS | 甘雅玲 | 319015 | 359547 | 2026-02-05 14:30:42 | 3 | 2026-03-22 17:35:35.098454 |
| LF26011400079901 | 26Sharjah男款短袖连体衣-头版-YS9229MXAO | XS | 罗兰方 | 319643 | 359549 | 2026-02-05 14:31:34 | 20 | 2026-03-22 17:35:35.096517 |
| LF26011400079902 | 26Sharjah男款短袖连体衣-头版-YS9229MXAO | S | 罗兰方 | 319643 | 359549 | 2026-02-05 14:31:34 | 20 | 2026-03-22 17:35:35.094544 |
| LF26011400079911 | 26Sharjah男款短袖连体衣-头版-YS9229MXAO | 2XS | 罗兰方 | 319643 | 359549 | 2026-02-05 14:31:34 | 10 | 2026-03-22 17:35:35.092605 |
| DQ2404220349910 | AQUA BLUE-A 2017(EU)男款短上衣-CD034MVFO | 6XL | 吕丹琪 | 319902 | 359550 | 2026-02-05 14:32:25 | 2 | 2026-03-22 17:35:35.090661 |
| DQ2404220349909 | AQUA BLUE-A 2017(EU)男款短上衣-CD034MVFO | 5XL | 吕丹琪 | 319902 | 359550 | 2026-02-05 14:32:25 | 2 | 2026-03-22 17:35:35.088662 |
| DQ2404220349908 | AQUA BLUE-A 2017(EU)男款短上衣-CD034MVFO | 4XL | 吕丹琪 | 319902 | 359550 | 2026-02-05 14:32:25 | 2 | 2026-03-22 17:35:35.086654 |
| DQ2404220349907 | AQUA BLUE-A 2017(EU)男款短上衣-CD034MVFO | 3XL | 吕丹琪 | 319902 | 359550 | 2026-02-05 14:32:25 | 5 | 2026-03-22 17:35:35.084689 |
| DQ2404220359906 | AQUA BLUE 2017 (EU)男款短上衣-CD034MVO | 2XL | 吕丹琪 | 319902 | 359550 | 2026-02-05 14:32:25 | 7 | 2026-03-22 17:35:35.082666 |
| DQ2404220359905 | AQUA BLUE 2017 (EU)男款短上衣-CD034MVO | XL | 吕丹琪 | 319902 | 359550 | 2026-02-05 14:32:25 | 25 | 2026-03-22 17:35:35.080718 |
| DQ2404220359904 | AQUA BLUE 2017 (EU)男款短上衣-CD034MVO | L | 吕丹琪 | 319902 | 359550 | 2026-02-05 14:32:25 | 20 | 2026-03-22 17:35:35.078714 |
| DQ2404220359903 | AQUA BLUE 2017 (EU)男款短上衣-CD034MVO | M | 吕丹琪 | 319902 | 359550 | 2026-02-05 14:32:25 | 15 | 2026-03-22 17:35:35.076707 |
| DQ2404220359902 | AQUA BLUE 2017 (EU)男款短上衣-CD034MVO | S | 吕丹琪 | 319902 | 359550 | 2026-02-05 14:32:25 | 2 | 2026-03-22 17:35:35.074709 |
| RX25123000039905 | WYLD-Halm男款跑步背心-头版-YS9346MAO | XL | 袁日仙 | 320231 | 359551 | 2026-02-05 14:32:51 | 1 | 2026-03-22 17:35:35.072767 |