到货库存导入(采购入库 Excel)
系统会从 Excel 中抓取:款式编号(清洗为SKU)、款式SKU、颜色及规格(提取尺码)、数量、商品名称、运营仓库、采购单号、入仓单号、采购员、入库日期。
库存汇总
| 产品SKU | 中文名 | 尺码 | 采购员 | 采购单号 | 入仓单号 | 入库日期 | 当前库存 | 更新时间 |
|---|---|---|---|---|---|---|---|---|
| DQ20221217189902 | 17-B3-1防风背心 | S | 吕丹琪 | 297389 | 347891 | 2026-01-02 15:15:35 | 15 | 2026-03-22 17:35:55.171668 |
| DQ20221217189903 | 17-B3-1防风背心 | M | 吕丹琪 | 297389 | 347891 | 2026-01-02 15:15:35 | 15 | 2026-03-22 17:35:55.170158 |
| DQ20221217189904 | 17-B3-1防风背心 | L | 吕丹琪 | 297389 | 347891 | 2026-01-02 15:15:35 | 15 | 2026-03-22 17:35:55.168604 |
| DQ20221217189905 | 17-B3-1防风背心 | XL | 吕丹琪 | 297389 | 347891 | 2026-01-02 15:15:35 | 8 | 2026-03-22 17:35:55.167069 |
| DQ20221217199901 | 17-B3-2防风背心 | XS | 吕丹琪 | 297389 | 347891 | 2026-01-02 15:15:35 | 5 | 2026-03-22 17:35:55.165514 |
| DQ20221217199902 | 17-B3-2防风背心 | S | 吕丹琪 | 297389 | 347891 | 2026-01-02 15:15:35 | 5 | 2026-03-22 17:35:55.164009 |
| DQ20221217199903 | 17-B3-2防风背心 | M | 吕丹琪 | 297389 | 347891 | 2026-01-02 15:15:35 | 8 | 2026-03-22 17:35:55.162460 |
| DQ20221217199905 | 17-B3-2防风背心 | XL | 吕丹琪 | 297389 | 347891 | 2026-01-02 15:15:35 | 8 | 2026-03-22 17:35:55.160943 |
| DQ20221217199904 | 17-B3-2防风背心 | L | 吕丹琪 | 297389 | 347891 | 2026-01-02 15:15:35 | 8 | 2026-03-22 17:35:55.159401 |
| DQ20221217059903 | 220012骑行外套 | M | 吕丹琪 | 297389 | 347891 | 2026-01-02 15:15:35 | 20 | 2026-03-22 17:35:55.157877 |
| DQ20221217059904 | 220012骑行外套 | L | 吕丹琪 | 297389 | 347891 | 2026-01-02 15:15:35 | 30 | 2026-03-22 17:35:55.156311 |
| DQ20221217059905 | 220012骑行外套 | XL | 吕丹琪 | 297389 | 347891 | 2026-01-02 15:15:35 | 20 | 2026-03-22 17:35:55.154722 |
| DQ20221217059906 | 220012骑行外套 | 2XL | 吕丹琪 | 297389 | 347891 | 2026-01-02 15:15:35 | 10 | 2026-03-22 17:35:55.153155 |
| DQ20221217059907 | 220012骑行外套 | 3XL | 吕丹琪 | 297389 | 347891 | 2026-01-02 15:15:35 | 5 | 2026-03-22 17:35:55.150880 |
| DQ20221217059908 | 220012骑行外套 | 4XL | 吕丹琪 | 297389 | 347891 | 2026-01-02 15:15:35 | 5 | 2026-03-22 17:35:55.099571 |
| DQ20221217059909 | 220012骑行外套 | 5XL | 吕丹琪 | 297389 | 347891 | 2026-01-02 15:15:35 | 10 | 2026-03-22 17:35:55.098070 |
| DQ20221217089901 | 007c-2反光骑行夹克 | XS | 吕丹琪 | 297389 | 347891 | 2026-01-02 15:15:35 | 2 | 2026-03-22 17:35:55.096542 |
| DQ20221217089902 | 007c-2反光骑行夹克 | S | 吕丹琪 | 297389 | 347891 | 2026-01-02 15:15:35 | 2 | 2026-03-22 17:35:55.094988 |
| DQ20221217089903 | 007c-2反光骑行夹克 | M | 吕丹琪 | 297389 | 347891 | 2026-01-02 15:15:35 | 25 | 2026-03-22 17:35:55.093419 |
| DQ20221217089904 | 007c-2反光骑行夹克 | L | 吕丹琪 | 297389 | 347891 | 2026-01-02 15:15:35 | 25 | 2026-03-22 17:35:55.091906 |