到货库存导入(采购入库 Excel)
系统会从 Excel 中抓取:款式编号(清洗为SKU)、款式SKU、颜色及规格(提取尺码)、数量、商品名称、运营仓库、采购单号、入仓单号、采购员、入库日期。
库存汇总
| 产品SKU | 中文名 | 尺码 | 采购员 | 采购单号 | 入仓单号 | 入库日期 | 当前库存 | 更新时间 |
|---|---|---|---|---|---|---|---|---|
| RX26011700149905 | Urbis 2025男款铁三背心-头版-YS9730MO | XL | 袁日仙 | 319267 | 359077 | 2026-02-04 11:06:41 | 1 | 2026-03-22 17:35:36.293365 |
| RX26011700149903 | Urbis 2025男款铁三背心-头版-YS9730MO | M | 袁日仙 | 319267 | 359077 | 2026-02-04 11:06:41 | 7 | 2026-03-22 17:35:36.291880 |
| RX26011700149902 | Urbis 2025男款铁三背心-头版-YS9730MO | S | 袁日仙 | 319267 | 359077 | 2026-02-04 11:06:41 | 1 | 2026-03-22 17:35:36.290318 |
| YL25093000089906 | SYLBS 2025 triclark男款短上衣-头版-YS9640MY | 2XL | 甘雅玲 | 319276 | 359080 | 2026-02-04 11:07:40 | 1 | 2026-03-22 17:35:36.288783 |
| YL25093000089905 | SYLBS 2025 triclark男款短上衣-头版-YS9640MY | XL | 甘雅玲 | 319276 | 359080 | 2026-02-04 11:07:40 | 8 | 2026-03-22 17:35:36.287236 |
| YL25093000089904 | SYLBS 2025 triclark男款短上衣-头版-YS9640MY | L | 甘雅玲 | 319276 | 359080 | 2026-02-04 11:07:40 | 3 | 2026-03-22 17:35:36.285679 |
| YL25093000089903 | SYLBS 2025 triclark男款短上衣-头版-YS9640MY | M | 甘雅玲 | 319276 | 359080 | 2026-02-04 11:07:40 | 6 | 2026-03-22 17:35:36.284213 |
| YL25093000089902 | SYLBS 2025 triclark男款短上衣-头版-YS9640MY | S | 甘雅玲 | 319276 | 359080 | 2026-02-04 11:07:40 | 5 | 2026-03-22 17:35:36.282622 |
| YL25093000089901 | SYLBS 2025 triclark男款短上衣-头版-YS9640MY | XS | 甘雅玲 | 319276 | 359080 | 2026-02-04 11:07:40 | 1 | 2026-03-22 17:35:36.281038 |
| YL25093000089911 | SYLBS 2025 triclark男款短上衣-头版-YS9640MY | 2XS | 甘雅玲 | 319276 | 359080 | 2026-02-04 11:07:40 | 1 | 2026-03-22 17:35:36.279341 |
| YL25093000079906 | SYLBS 2025 triclark男款背带短裤-头版-YS2029M | 2XL | 甘雅玲 | 319276 | 359080 | 2026-02-04 11:07:40 | 1 | 2026-03-22 17:35:36.277789 |
| YL25093000079905 | SYLBS 2025 triclark男款背带短裤-头版-YS2029M | XL | 甘雅玲 | 319276 | 359080 | 2026-02-04 11:07:40 | 3 | 2026-03-22 17:35:36.275939 |
| YL25093000079904 | SYLBS 2025 triclark男款背带短裤-头版-YS2029M | L | 甘雅玲 | 319276 | 359080 | 2026-02-04 11:07:40 | 2 | 2026-03-22 17:35:36.274368 |
| YL25093000079903 | SYLBS 2025 triclark男款背带短裤-头版-YS2029M | M | 甘雅玲 | 319276 | 359080 | 2026-02-04 11:07:40 | 3 | 2026-03-22 17:35:36.272849 |
| YL25093000079902 | SYLBS 2025 triclark男款背带短裤-头版-YS2029M | S | 甘雅玲 | 319276 | 359080 | 2026-02-04 11:07:40 | 4 | 2026-03-22 17:35:36.271307 |
| YL25093000079901 | SYLBS 2025 triclark男款背带短裤-头版-YS2029M | XS | 甘雅玲 | 319276 | 359080 | 2026-02-04 11:07:40 | 1 | 2026-03-22 17:35:36.269765 |
| YL25093000079911 | SYLBS 2025 triclark男款背带短裤-头版-YS2029M | 2XS | 甘雅玲 | 319276 | 359080 | 2026-02-04 11:07:40 | 1 | 2026-03-22 17:35:36.268234 |
| YY26011700019906 | ONEA Summit 2.0 Green男款短上衣-头版-YS8137MGO | 2XL | 刘莹滢 | 320246 | 359082 | 2026-02-04 11:09:15 | 2 | 2026-03-22 17:35:36.266605 |
| ZT26011700079904 | OTBG yellow男款长上衣-头版-YS9068MDY | L | 曾亭 | 319593 | 359081 | 2026-03-18 17:31:25 | 30 | 2026-03-22 17:35:36.266485 |
| ZT26011700079903 | OTBG yellow男款长上衣-头版-YS9068MDY | M | 曾亭 | 319593 | 359081 | 2026-03-18 17:31:25 | 50 | 2026-03-22 17:35:36.266483 |