到货库存导入(采购入库 Excel)
系统会从 Excel 中抓取:款式编号(清洗为SKU)、款式SKU、颜色及规格(提取尺码)、数量、商品名称、运营仓库、采购单号、入仓单号、采购员、入库日期。
库存汇总
| 产品SKU | 中文名 | 尺码 | 采购员 | 采购单号 | 入仓单号 | 入库日期 | 当前库存 | 更新时间 |
|---|---|---|---|---|---|---|---|---|
| DQ2406050079905 | BANESTO 1996(EU)男款短上衣-CD034MVO | XL | 吕丹琪 | 319902 | 359113 | 2026-02-04 11:17:28 | 20 | 2026-03-22 17:35:36.072343 |
| DQ2406050079904 | BANESTO 1996(EU)男款短上衣-CD034MVO | L | 吕丹琪 | 319902 | 359113 | 2026-02-04 11:17:28 | 30 | 2026-03-22 17:35:36.070845 |
| DQ2406050079903 | BANESTO 1996(EU)男款短上衣-CD034MVO | M | 吕丹琪 | 319902 | 359113 | 2026-02-04 11:17:28 | 20 | 2026-03-22 17:35:36.069285 |
| DQ2406050079902 | BANESTO 1996(EU)男款短上衣-CD034MVO | S | 吕丹琪 | 319902 | 359113 | 2026-02-04 11:17:28 | 3 | 2026-03-22 17:35:36.067728 |
| DQ2406050079901 | BANESTO 1996(EU)男款短上衣-CD034MVO | XS | 吕丹琪 | 319902 | 359113 | 2026-02-04 11:17:28 | 1 | 2026-03-22 17:35:36.066144 |
| YY26012100099906 | ONEA男款背带短裤-头版-YS2196MAO | 2XL | 刘莹滢 | 320374 | 359114 | 2026-02-04 11:17:49 | 2 | 2026-03-22 17:35:36.064525 |
| YY26012100099905 | ONEA男款背带短裤-头版-YS2196MAO | XL | 刘莹滢 | 320374 | 359114 | 2026-02-04 11:17:49 | 5 | 2026-03-22 17:35:36.062967 |
| YY26012100099904 | ONEA男款背带短裤-头版-YS2196MAO | L | 刘莹滢 | 320374 | 359114 | 2026-02-04 11:17:49 | 5 | 2026-03-22 17:35:36.061375 |
| YY26012100099903 | ONEA男款背带短裤-头版-YS2196MAO | M | 刘莹滢 | 320374 | 359114 | 2026-02-04 11:17:49 | 3 | 2026-03-22 17:35:36.059708 |
| YY26010700129904 | WT HCE Navy男款三角泳裤-头版-YS4075MA | L | 刘莹滢 | 316854 | 359116 | 2026-02-04 11:18:10 | 1 | 2026-03-22 17:35:36.058102 |
| YY26010700129903 | WT HCE Navy男款三角泳裤-头版-YS4075MA | M | 刘莹滢 | 316854 | 359116 | 2026-02-04 11:18:10 | 2 | 2026-03-22 17:35:36.056472 |
| YY26010700129902 | WT HCE Navy男款三角泳裤-头版-YS4075MA | S | 刘莹滢 | 316854 | 359116 | 2026-02-04 11:18:10 | 3 | 2026-03-22 17:35:36.054848 |
| DZ261200189902 | 凯乐石VG2617219简欧白女款长上衣 | S | 黄瑞辉 | 323617 | 359130 | 2026-02-04 11:22:51 | 1 | 2026-03-22 17:35:36.053148 |
| DZ261200279903 | 凯乐石VG2617119藤灰紫男款长上衣 | M | 黄瑞辉 | 323617 | 359130 | 2026-02-04 11:22:51 | 1 | 2026-03-22 17:35:35.998433 |
| DZ261100359902 | 凯乐石VG2617218藤灰紫女款短上衣 | S | 黄瑞辉 | 323617 | 359130 | 2026-02-04 11:22:51 | 1 | 2026-03-22 17:35:35.995190 |
| DZ261100349902 | 凯乐石VG2617218深鸢尾紫女款短上衣 | S | 黄瑞辉 | 323617 | 359130 | 2026-02-04 11:22:51 | 1 | 2026-03-22 17:35:35.993400 |
| DZ261100339903 | 凯乐石VG2617118藤灰紫男款短上衣 | M | 黄瑞辉 | 323617 | 359130 | 2026-02-04 11:22:51 | 1 | 2026-03-22 17:35:35.990023 |
| DZ261100209903 | 凯乐石VG2617118简欧白男款短上衣 | M | 黄瑞辉 | 323617 | 359130 | 2026-02-04 11:22:51 | 1 | 2026-03-22 17:35:35.988421 |
| 1211110579902 | 黑武士黑色短袖连体衣 | S | 何咏凯 | 323071 | 359132 | 2026-02-04 11:23:38 | 7 | 2026-03-22 17:35:35.981927 |
| 1261110529906 | 闪特粉棕女款短上衣 | 2XL | 林树 | 316467 | 359161 | 2026-02-04 13:43:00 | 10 | 2026-03-22 17:35:35.980110 |