到货库存导入(采购入库 Excel)
系统会从 Excel 中抓取:款式编号(清洗为SKU)、款式SKU、颜色及规格(提取尺码)、数量、商品名称、运营仓库、采购单号、入仓单号、采购员、入库日期。
库存汇总
| 产品SKU | 中文名 | 尺码 | 采购员 | 采购单号 | 入仓单号 | 入库日期 | 当前库存 | 更新时间 |
|---|---|---|---|---|---|---|---|---|
| ZT26013100239905 | Pastaria 26 Primo男款短上衣-头版-YS9470MYBO | XL | 曾亭 | 324275 | 366713 | 2026-03-05 13:35:20 | 1 | 2026-03-22 17:35:28.302309 |
| ZT26013100239904 | Pastaria 26 Primo男款短上衣-头版-YS9470MYBO | L | 曾亭 | 324275 | 366713 | 2026-03-05 13:35:20 | 2 | 2026-03-22 17:35:28.297465 |
| ZT26013100239903 | Pastaria 26 Primo男款短上衣-头版-YS9470MYBO | M | 曾亭 | 324275 | 366713 | 2026-03-05 13:35:20 | 6 | 2026-03-22 17:35:28.294702 |
| ZT26013100239902 | Pastaria 26 Primo男款短上衣-头版-YS9470MYBO | S | 曾亭 | 324275 | 366713 | 2026-03-05 13:35:20 | 3 | 2026-03-22 17:35:28.290193 |
| ZT26013100229903 | Pastaria 26 LW女款短上衣-头版-YS9409WKO | M | 曾亭 | 324275 | 366713 | 2026-03-05 13:35:20 | 2 | 2026-03-22 17:35:28.287680 |
| ZT26013100219903 | Pastaria 26 LW男款短上衣-头版-YS9409MEKO | M | 曾亭 | 324275 | 366713 | 2026-03-05 13:35:20 | 1 | 2026-03-22 17:35:28.285358 |
| ZT26013100209904 | Pastaria 26女款短上衣-头版-YS9409WKO | L | 曾亭 | 324275 | 366713 | 2026-03-05 13:35:20 | 1 | 2026-03-22 17:35:28.282996 |
| ZT26013100209903 | Pastaria 26女款短上衣-头版-YS9409WKO | M | 曾亭 | 324275 | 366713 | 2026-03-05 13:35:20 | 2 | 2026-03-22 17:35:28.280641 |
| ZT26020900039903 | D2D童装短上衣-头版-YS9409MCLO | M | 曾亭 | 326354 | 366714 | 2026-03-05 13:37:50 | 1 | 2026-03-22 17:35:28.278164 |
| WT26020900049906 | Rackd SVT男款跑步背心-二版-YS555MAXO | 2XL | 黄婉婷 | 326412 | 366716 | 2026-03-05 13:39:18 | 1 | 2026-03-22 17:35:28.275599 |
| RX26012800199903 | EXIT21男款长上衣-头版-YS9620MBO | M | 袁日仙 | 324501 | 366715 | 2026-03-13 11:13:16 | 4 | 2026-03-22 17:35:28.275443 |
| WT26020900049905 | Rackd SVT男款跑步背心-二版-YS555MAXO | XL | 黄婉婷 | 326412 | 366716 | 2026-03-05 13:39:18 | 2 | 2026-03-22 17:35:28.271005 |
| WT26020900049904 | Rackd SVT男款跑步背心-二版-YS555MAXO | L | 黄婉婷 | 326412 | 366716 | 2026-03-05 13:39:18 | 6 | 2026-03-22 17:35:28.264566 |
| WT26020900049903 | Rackd SVT男款跑步背心-二版-YS555MAXO | M | 黄婉婷 | 326412 | 366716 | 2026-03-05 13:39:18 | 3 | 2026-03-22 17:35:28.261021 |
| WT26020900049902 | Rackd SVT男款跑步背心-二版-YS555MAXO | S | 黄婉婷 | 326412 | 366716 | 2026-03-05 13:39:18 | 2 | 2026-03-22 17:35:28.197844 |
| WT26020900049901 | Rackd SVT男款跑步背心-二版-YS555MAXO | XS | 黄婉婷 | 326412 | 366716 | 2026-03-05 13:39:18 | 1 | 2026-03-22 17:35:28.195693 |
| YL26013100109905 | TGSC White男款慢跑背心-头版-YS9347MKQ | XL | 甘雅玲 | 324871 | 366718 | 2026-03-05 13:41:52 | 2 | 2026-03-22 17:35:28.193340 |
| YL26013100109904 | TGSC White男款慢跑背心-头版-YS9347MKQ | L | 甘雅玲 | 324871 | 366718 | 2026-03-05 13:41:52 | 7 | 2026-03-22 17:35:28.191653 |
| YL26013100109903 | TGSC White男款慢跑背心-头版-YS9347MKQ | M | 甘雅玲 | 324871 | 366718 | 2026-03-05 13:41:52 | 5 | 2026-03-22 17:35:28.190085 |
| YL26013100109902 | TGSC White男款慢跑背心-头版-YS9347MKQ | S | 甘雅玲 | 324871 | 366718 | 2026-03-05 13:41:52 | 1 | 2026-03-22 17:35:28.188383 |