到货库存导入(采购入库 Excel)
系统会从 Excel 中抓取:款式编号(清洗为SKU)、款式SKU、颜色及规格(提取尺码)、数量、商品名称、运营仓库、采购单号、入仓单号、采购员、入库日期。
库存汇总
| 产品SKU | 中文名 | 尺码 | 采购员 | 采购单号 | 入仓单号 | 入库日期 | 当前库存 | 更新时间 |
|---|---|---|---|---|---|---|---|---|
| DQ2407160109908 | 24ARROW-BLUE男款抓绒长上衣-CD044MBAO | 4XL | 吕丹琪 | 313321 | 351834 | 2026-01-14 16:14:37 | 10 | 2026-03-22 17:35:49.289096 |
| DQ2407160109904 | 24ARROW-BLUE男款抓绒长上衣-CD044MBAO | L | 吕丹琪 | 313321 | 351834 | 2026-01-14 16:14:37 | 15 | 2026-03-22 17:35:49.287499 |
| DQ2407160109902 | 24ARROW-BLUE男款抓绒长上衣-CD044MBAO | S | 吕丹琪 | 313321 | 351834 | 2026-01-14 16:14:37 | 2 | 2026-03-22 17:35:49.285899 |
| LF25123000139906 | TB-BROWN男款长上衣-头版-YS9605MAEO | 2XL | 罗兰方 | 316823 | 351841 | 2026-01-14 16:35:38 | 5 | 2026-03-22 17:35:49.284324 |
| LF25123000139904 | TB-BROWN男款长上衣-头版-YS9605MAEO | L | 罗兰方 | 316823 | 351841 | 2026-01-14 16:35:38 | 70 | 2026-03-22 17:35:49.282724 |
| LF25123000139902 | TB-BROWN男款长上衣-头版-YS9605MAEO | S | 罗兰方 | 316823 | 351841 | 2026-01-14 16:35:38 | 30 | 2026-03-22 17:35:49.281204 |
| LF25123000139905 | TB-BROWN男款长上衣-头版-YS9605MAEO | XL | 罗兰方 | 316823 | 351841 | 2026-01-14 16:35:38 | 10 | 2026-03-22 17:35:49.279647 |
| LF25123000139903 | TB-BROWN男款长上衣-头版-YS9605MAEO | M | 罗兰方 | 316823 | 351841 | 2026-01-14 16:35:38 | 50 | 2026-03-22 17:35:49.278080 |
| LF25123000139901 | TB-BROWN男款长上衣-头版-YS9605MAEO | XS | 罗兰方 | 316823 | 351841 | 2026-01-14 16:35:38 | 10 | 2026-03-22 17:35:49.276523 |
| DZ251203039907 | 古城青州2025男款长上衣 | 3XL | 何佳欣 | 312850 | 351863 | 2026-01-14 17:33:10 | 4 | 2026-03-22 17:35:49.275016 |
| DZ251203039906 | 古城青州2025男款长上衣 | 2XL | 何佳欣 | 312850 | 351863 | 2026-01-14 17:33:10 | 8 | 2026-03-22 17:35:49.273470 |
| DZ251203039905 | 古城青州2025男款长上衣 | XL | 何佳欣 | 312850 | 351863 | 2026-01-14 17:33:10 | 3 | 2026-03-22 17:35:49.271949 |
| DZ251203039904 | 古城青州2025男款长上衣 | L | 何佳欣 | 312850 | 351863 | 2026-01-14 17:33:10 | 5 | 2026-03-22 17:35:49.270329 |
| ZT26010700159907 | Ocala 25男款T恤-头版-YS9068MT | 3XL | 曾亭 | 316037 | 351865 | 2026-01-14 17:36:49 | 1 | 2026-03-22 17:35:49.268472 |
| ZT26010700159906 | Ocala 25男款T恤-头版-YS9068MT | 2XL | 曾亭 | 316037 | 351865 | 2026-01-14 17:36:49 | 1 | 2026-03-22 17:35:49.266902 |
| ZT26010700159905 | Ocala 25男款T恤-头版-YS9068MT | XL | 曾亭 | 316037 | 351865 | 2026-01-14 17:36:49 | 1 | 2026-03-22 17:35:49.265353 |
| ZT26010700159904 | Ocala 25男款T恤-头版-YS9068MT | L | 曾亭 | 316037 | 351865 | 2026-01-14 17:36:49 | 1 | 2026-03-22 17:35:49.263818 |
| ZT26010700159902 | Ocala 25男款T恤-头版-YS9068MT | S | 曾亭 | 316037 | 351865 | 2026-01-14 17:36:49 | 2 | 2026-03-22 17:35:49.262258 |
| ZT26010700159901 | Ocala 25男款T恤-头版-YS9068MT | XS | 曾亭 | 316037 | 351865 | 2026-01-14 17:36:49 | 1 | 2026-03-22 17:35:49.260604 |
| ZT26010700159911 | Ocala 25男款T恤-头版-YS9068MT | 2XS | 曾亭 | 316037 | 351865 | 2026-01-14 17:36:49 | 1 | 2026-03-22 17:35:49.258770 |