到货库存导入(采购入库 Excel)
系统会从 Excel 中抓取:款式编号(清洗为SKU)、款式SKU、颜色及规格(提取尺码)、数量、商品名称、运营仓库、采购单号、入仓单号、采购员、入库日期。
库存汇总
| 产品SKU | 中文名 | 尺码 | 采购员 | 采购单号 | 入仓单号 | 入库日期 | 当前库存 | 更新时间 |
|---|---|---|---|---|---|---|---|---|
| DQ20221217129909 | 17-B4-1防风背心 | 5XL | 吕丹琪 | 297389 | 347891 | 2026-01-02 15:15:35 | 3 | 2026-03-22 17:35:55.253765 |
| DQ20221217179904 | 19-B8-3防风背心 | L | 吕丹琪 | 297389 | 347891 | 2026-01-02 15:15:35 | 5 | 2026-03-22 17:35:55.251967 |
| DQ20221217179905 | 19-B8-3防风背心 | XL | 吕丹琪 | 297389 | 347891 | 2026-01-02 15:15:35 | 5 | 2026-03-22 17:35:55.199155 |
| DQ20221217179907 | 19-B8-3防风背心 | 3XL | 吕丹琪 | 297389 | 347891 | 2026-01-02 15:15:35 | 3 | 2026-03-22 17:35:55.197606 |
| DQ20221217179909 | 19-B8-3防风背心 | 5XL | 吕丹琪 | 297389 | 347891 | 2026-01-02 15:15:35 | 3 | 2026-03-22 17:35:55.196122 |
| DQ20221217139904 | 17-B4-2防风背心 | L | 吕丹琪 | 297389 | 347891 | 2026-01-02 15:15:35 | 5 | 2026-03-22 17:35:55.194590 |
| DQ20221217139905 | 17-B4-2防风背心 | XL | 吕丹琪 | 297389 | 347891 | 2026-01-02 15:15:35 | 5 | 2026-03-22 17:35:55.193126 |
| DQ20221217139906 | 17-B4-2防风背心 | 2XL | 吕丹琪 | 297389 | 347891 | 2026-01-02 15:15:35 | 5 | 2026-03-22 17:35:55.191624 |
| DQ20221217139909 | 17-B4-2防风背心 | 5XL | 吕丹琪 | 297389 | 347891 | 2026-01-02 15:15:35 | 5 | 2026-03-22 17:35:55.190102 |
| DQ20221217169902 | 19-B8-2防风背心 | S | 吕丹琪 | 297389 | 347891 | 2026-01-02 15:15:35 | 2 | 2026-03-22 17:35:55.188570 |
| DQ20221217169903 | 19-B8-2防风背心 | M | 吕丹琪 | 297389 | 347891 | 2026-01-02 15:15:35 | 5 | 2026-03-22 17:35:55.187084 |
| DQ20221217169904 | 19-B8-2防风背心 | L | 吕丹琪 | 297389 | 347891 | 2026-01-02 15:15:35 | 8 | 2026-03-22 17:35:55.185563 |
| DQ20221217169908 | 19-B8-2防风背心 | 4XL | 吕丹琪 | 297389 | 347891 | 2026-01-02 15:15:35 | 2 | 2026-03-22 17:35:55.184084 |
| DQ20221217169909 | 19-B8-2防风背心 | 5XL | 吕丹琪 | 297389 | 347891 | 2026-01-02 15:15:35 | 2 | 2026-03-22 17:35:55.182543 |
| DQ20221217119901 | 180012可拆卸女夹克 | XS | 吕丹琪 | 297389 | 347891 | 2026-01-02 15:15:35 | 7 | 2026-03-22 17:35:55.181060 |
| DQ20221217119902 | 180012可拆卸女夹克 | S | 吕丹琪 | 297389 | 347891 | 2026-01-02 15:15:35 | 10 | 2026-03-22 17:35:55.179501 |
| DQ20221217119903 | 180012可拆卸女夹克 | M | 吕丹琪 | 297389 | 347891 | 2026-01-02 15:15:35 | 30 | 2026-03-22 17:35:55.177984 |
| DQ20221217119904 | 180012可拆卸女夹克 | L | 吕丹琪 | 297389 | 347891 | 2026-01-02 15:15:35 | 20 | 2026-03-22 17:35:55.176422 |
| DQ20221217119905 | 180012可拆卸女夹克 | XL | 吕丹琪 | 297389 | 347891 | 2026-01-02 15:15:35 | 10 | 2026-03-22 17:35:55.174853 |
| DQ20221217189901 | 17-B3-1防风背心 | XS | 吕丹琪 | 297389 | 347891 | 2026-01-02 15:15:35 | 5 | 2026-03-22 17:35:55.173262 |