到货库存导入(采购入库 Excel)
系统会从 Excel 中抓取:款式编号(清洗为SKU)、款式SKU、颜色及规格(提取尺码)、数量、商品名称、运营仓库、采购单号、入仓单号、采购员、入库日期。
库存汇总
| 产品SKU | 中文名 | 尺码 | 采购员 | 采购单号 | 入仓单号 | 入库日期 | 当前库存 | 更新时间 |
|---|---|---|---|---|---|---|---|---|
| 1251120439905 | 轻扬土黄防风外套 | XL | 林树 | 305335 | 356110 | 2026-01-30 10:38:00 | 70 | 2026-03-22 17:35:42.389625 |
| 1251120439903 | 轻扬土黄防风外套 | M | 林树 | 305335 | 356110 | 2026-01-26 17:19:00 | 70 | 2026-03-22 17:35:42.386193 |
| 1251120439902 | 轻扬土黄防风外套 | S | 林树 | 305335 | 356110 | 2026-01-26 17:19:00 | 30 | 2026-03-22 17:35:42.384593 |
| DZ261200109906 | 貓頭鷹車隊 2025女款長上衣 | 2XL | 何佳欣 | 315801 | 356113 | 2026-01-26 17:28:11 | 1 | 2026-03-22 17:35:42.382933 |
| DZ261200109905 | 貓頭鷹車隊 2025女款長上衣 | XL | 何佳欣 | 315801 | 356113 | 2026-01-26 17:28:11 | 2 | 2026-03-22 17:35:42.381284 |
| DZ261200109904 | 貓頭鷹車隊 2025女款長上衣 | L | 何佳欣 | 315801 | 356113 | 2026-01-26 17:28:11 | 1 | 2026-03-22 17:35:42.379638 |
| DZ261200109902 | 貓頭鷹車隊 2025女款長上衣 | S | 何佳欣 | 315801 | 356113 | 2026-01-26 17:28:11 | 1 | 2026-03-22 17:35:42.377992 |
| 1231120049907 | 2023-WEDNESDAY(深红)长上衣 | 3XL | 黄婉婷 | 315986 | 356118 | 2026-01-26 17:29:38 | 3 | 2026-03-22 17:35:42.376316 |
| 1231120049906 | 2023-WEDNESDAY(深红)长上衣 | 2XL | 黄婉婷 | 315986 | 356118 | 2026-01-26 17:29:38 | 3 | 2026-03-22 17:35:42.374795 |
| 1231120049905 | 2023-WEDNESDAY(深红)长上衣 | XL | 黄婉婷 | 315986 | 356118 | 2026-01-26 17:29:38 | 3 | 2026-03-22 17:35:42.373255 |
| 1231120049904 | 2023-WEDNESDAY(深红)长上衣 | L | 黄婉婷 | 315986 | 356118 | 2026-01-26 17:29:38 | 1 | 2026-03-22 17:35:42.371760 |
| 1231600809907 | 2023-THURSDAY(湖蓝)内搭背心 | 3XL | 黄婉婷 | 316533 | 356119 | 2026-01-26 17:30:06 | 3 | 2026-03-22 17:35:42.370231 |
| 1231600809906 | 2023-THURSDAY(湖蓝)内搭背心 | 2XL | 黄婉婷 | 316533 | 356119 | 2026-01-26 17:30:06 | 3 | 2026-03-22 17:35:42.368702 |
| 1231600809905 | 2023-THURSDAY(湖蓝)内搭背心 | XL | 黄婉婷 | 316533 | 356119 | 2026-01-26 17:30:06 | 2 | 2026-03-22 17:35:42.367215 |
| 1231600809904 | 2023-THURSDAY(湖蓝)内搭背心 | L | 黄婉婷 | 316533 | 356119 | 2026-01-26 17:30:06 | 2 | 2026-03-22 17:35:42.365680 |
| MY25122200089906 | LABEL bay男款短上衣-头版-YS9735MJBO | 2XL | 胡美英 | 313360 | 356120 | 2026-01-26 17:31:25 | 1 | 2026-03-22 17:35:42.364164 |
| MY25122200089905 | LABEL bay男款短上衣-头版-YS9735MJBO | XL | 胡美英 | 313360 | 356120 | 2026-01-26 17:31:25 | 1 | 2026-03-22 17:35:42.362601 |
| MY25122200089904 | LABEL bay男款短上衣-头版-YS9735MJBO | L | 胡美英 | 313360 | 356120 | 2026-01-26 17:31:25 | 2 | 2026-03-22 17:35:42.361053 |
| MY25122200089901 | LABEL bay男款短上衣-头版-YS9735MJBO | XS | 胡美英 | 313360 | 356120 | 2026-01-26 17:31:25 | 2 | 2026-03-22 17:35:42.359496 |
| MY25122200089903 | LABEL bay男款短上衣-头版-YS9735MJBO | M | 胡美英 | 313360 | 356120 | 2026-01-26 17:31:25 | 4 | 2026-03-22 17:35:42.357974 |