到货库存导入(采购入库 Excel)
系统会从 Excel 中抓取:款式编号(清洗为SKU)、款式SKU、颜色及规格(提取尺码)、数量、商品名称、运营仓库、采购单号、入仓单号、采购员、入库日期。
库存汇总
| 产品SKU | 中文名 | 尺码 | 采购员 | 采购单号 | 入仓单号 | 入库日期 | 当前库存 | 更新时间 |
|---|---|---|---|---|---|---|---|---|
| ZT25031100099904 | Fit4-2女款T恤-YS9087WT | L | 曾亭 | 321974 | 357761 | 2026-01-31 10:10:36 | 1 | 2026-03-22 17:35:39.158971 |
| DZ261000129902 | Brunei 2026女款长袖长裤连体衣 | S | 何佳欣 | 321617 | 357693 | 2026-02-02 14:19:16 | 2 | 2026-03-22 17:35:39.158858 |
| ZT25031100129904 | Fit4-2男款T恤-YS9068MT | L | 曾亭 | 321974 | 357761 | 2026-01-31 10:10:36 | 1 | 2026-03-22 17:35:39.156316 |
| DQ20220506049913 | SLOVENIA-A 2022(EU)短上衣-CD034MVF | 7XL | 吕丹琪 | 321985 | 357762 | 2026-01-31 10:12:14 | 2 | 2026-03-22 17:35:39.154788 |
| DQ20220506049910 | SLOVENIA-A 2022(EU)短上衣-CD034MVF | 6XL | 吕丹琪 | 321985 | 357762 | 2026-01-31 10:12:14 | 2 | 2026-03-22 17:35:39.153186 |
| DQ20220506049909 | SLOVENIA-A 2022(EU)短上衣-CD034MVF | 5XL | 吕丹琪 | 321985 | 357762 | 2026-01-31 10:12:14 | 2 | 2026-03-22 17:35:39.150713 |
| DQ20220506049908 | SLOVENIA-A 2022(EU)短上衣-CD034MVF | 4XL | 吕丹琪 | 321985 | 357762 | 2026-01-31 10:12:14 | 2 | 2026-03-22 17:35:39.098476 |
| DQ200917019913 | Slovakia-1 2021(EU)男款短上衣-CD034MVF | 7XL | 吕丹琪 | 321985 | 357762 | 2026-01-31 10:12:14 | 5 | 2026-03-22 17:35:39.096924 |
| DQ200917019910 | Slovakia-1 2021(EU)男款短上衣-CD034MVF | 6XL | 吕丹琪 | 321985 | 357762 | 2026-01-31 10:12:14 | 5 | 2026-03-22 17:35:39.095360 |
| DQ200410019907 | SLOVAKIA 2020(EU)短上衣 | 3XL | 吕丹琪 | 321985 | 357762 | 2026-01-31 10:12:14 | 20 | 2026-03-22 17:35:39.093777 |
| DQ200410019905 | SLOVAKIA 2020(EU)短上衣 | XL | 吕丹琪 | 321985 | 357762 | 2026-01-31 10:12:14 | 40 | 2026-03-22 17:35:39.092269 |
| DQ200410019906 | SLOVAKIA 2020(EU)短上衣 | 2XL | 吕丹琪 | 321985 | 357762 | 2026-01-31 10:12:14 | 35 | 2026-03-22 17:35:39.090756 |
| DQ200410019904 | SLOVAKIA 2020(EU)短上衣 | L | 吕丹琪 | 321985 | 357762 | 2026-01-31 10:12:14 | 25 | 2026-03-22 17:35:39.089264 |
| DQ200410019903 | SLOVAKIA 2020(EU)短上衣 | M | 吕丹琪 | 321985 | 357762 | 2026-01-31 10:12:14 | 12 | 2026-03-22 17:35:39.087770 |
| DQ2406050049910 | LAVIE-A 1985(EU)男款短上衣-CD034MVFO | 6XL | 吕丹琪 | 321985 | 357763 | 2026-01-31 10:13:13 | 5 | 2026-03-22 17:35:39.086268 |
| DQ2406050049909 | LAVIE-A 1985(EU)男款短上衣-CD034MVFO | 5XL | 吕丹琪 | 321985 | 357763 | 2026-01-31 10:13:13 | 5 | 2026-03-22 17:35:39.084784 |
| DQ2406050049907 | LAVIE-A 1985(EU)男款短上衣-CD034MVFO | 3XL | 吕丹琪 | 321985 | 357763 | 2026-01-31 10:13:13 | 10 | 2026-03-22 17:35:39.083281 |
| DQ2406050059906 | LAVIE 1985(EU)男款短上衣-CD034MVO | 2XL | 吕丹琪 | 321985 | 357763 | 2026-01-31 10:13:13 | 15 | 2026-03-22 17:35:39.081705 |
| DQ2406050059905 | LAVIE 1985(EU)男款短上衣-CD034MVO | XL | 吕丹琪 | 321985 | 357763 | 2026-01-31 10:13:13 | 30 | 2026-03-22 17:35:39.080210 |
| DQ2406050059904 | LAVIE 1985(EU)男款短上衣-CD034MVO | L | 吕丹琪 | 321985 | 357763 | 2026-01-31 10:13:13 | 30 | 2026-03-22 17:35:39.078690 |