到货库存导入(采购入库 Excel)
系统会从 Excel 中抓取:款式编号(清洗为SKU)、款式SKU、颜色及规格(提取尺码)、数量、商品名称、运营仓库、采购单号、入仓单号、采购员、入库日期。
库存汇总
| 产品SKU | 中文名 | 尺码 | 采购员 | 采购单号 | 入仓单号 | 入库日期 | 当前库存 | 更新时间 |
|---|---|---|---|---|---|---|---|---|
| DZ212700039905 | PRO2021背带七分裤 | XL | 何佳欣 | 318430 | 358336 | 2026-02-02 10:40:41 | 1 | 2026-03-22 17:35:38.380624 |
| DZ212700039904 | PRO2021背带七分裤 | L | 何佳欣 | 318430 | 358336 | 2026-02-02 10:40:41 | 3 | 2026-03-22 17:35:38.378979 |
| DZ212700039903 | PRO2021背带七分裤 | M | 何佳欣 | 318430 | 358336 | 2026-02-02 10:40:41 | 3 | 2026-03-22 17:35:38.377386 |
| WT26012100029904 | RSG 2026 Black背带短裤-头版-YS2057MO | L | 黄婉婷 | 320083 | 358337 | 2026-02-02 10:41:15 | 1 | 2026-03-22 17:35:38.375685 |
| WT26012100029903 | RSG 2026 Black背带短裤-头版-YS2057MO | M | 黄婉婷 | 320083 | 358337 | 2026-02-02 10:41:15 | 12 | 2026-03-22 17:35:38.373852 |
| WT26012100029902 | RSG 2026 Black背带短裤-头版-YS2057MO | S | 黄婉婷 | 320083 | 358337 | 2026-02-02 10:41:15 | 2 | 2026-03-22 17:35:38.371877 |
| BH25111900199905 | LBW 26 CA Black男款短上衣-头版-YS9470MQYO | XL | 凌碧红 | 319588 | 358338 | 2026-02-02 10:42:14 | 1 | 2026-03-22 17:35:38.369958 |
| BH25111900199904 | LBW 26 CA Black男款短上衣-头版-YS9470MQYO | L | 凌碧红 | 319588 | 358338 | 2026-02-02 10:42:14 | 2 | 2026-03-22 17:35:38.368410 |
| BH25111900069902 | LBW 26 CA Blue女款短上衣-头版-YS9470WZYO | S | 凌碧红 | 319588 | 358338 | 2026-02-02 10:42:14 | 2 | 2026-03-22 17:35:38.366785 |
| MJ26012100049905 | ALR 2026 Medium Gray男款背带短裤-头版-YS2047MEBO | XL | 庄镘洁 | 320061 | 358339 | 2026-02-02 10:42:41 | 6 | 2026-03-22 17:35:38.365236 |
| MJ26012100049904 | ALR 2026 Medium Gray男款背带短裤-头版-YS2047MEBO | L | 庄镘洁 | 320061 | 358339 | 2026-02-02 10:42:41 | 8 | 2026-03-22 17:35:38.363567 |
| MJ26012100049903 | ALR 2026 Medium Gray男款背带短裤-头版-YS2047MEBO | M | 庄镘洁 | 320061 | 358339 | 2026-02-02 10:42:41 | 13 | 2026-03-22 17:35:38.361877 |
| MJ26012100049902 | ALR 2026 Medium Gray男款背带短裤-头版-YS2047MEBO | S | 庄镘洁 | 320061 | 358339 | 2026-02-02 10:42:41 | 13 | 2026-03-22 17:35:38.360208 |
| DQ2404220329910 | SKY2014-A(EU)男款短上衣-CD034MVFO | 6XL | 吕丹琪 | 319902 | 358340 | 2026-02-02 10:45:06 | 4 | 2026-03-22 17:35:38.358578 |
| DQ2404220329909 | SKY2014-A(EU)男款短上衣-CD034MVFO | 5XL | 吕丹琪 | 319902 | 358340 | 2026-02-02 10:45:06 | 4 | 2026-03-22 17:35:38.356967 |
| DQ2404220329908 | SKY2014-A(EU)男款短上衣-CD034MVFO | 4XL | 吕丹琪 | 319902 | 358340 | 2026-02-02 10:45:06 | 4 | 2026-03-22 17:35:38.355274 |
| DQ2404220329907 | SKY2014-A(EU)男款短上衣-CD034MVFO | 3XL | 吕丹琪 | 319902 | 358340 | 2026-02-02 10:45:06 | 5 | 2026-03-22 17:35:38.353533 |
| DQ2404220269910 | BMC-A 2013 (EU)男款短上衣-CD034MVFO | 6XL | 吕丹琪 | 319902 | 358340 | 2026-02-02 10:45:06 | 5 | 2026-03-22 17:35:38.351130 |
| DQ2404220269909 | BMC-A 2013 (EU)男款短上衣-CD034MVFO | 5XL | 吕丹琪 | 319902 | 358340 | 2026-02-02 10:45:06 | 5 | 2026-03-22 17:35:38.299238 |
| DQ2404220269908 | BMC-A 2013 (EU)男款短上衣-CD034MVFO | 4XL | 吕丹琪 | 319902 | 358340 | 2026-02-02 10:45:06 | 5 | 2026-03-22 17:35:38.297318 |