到货库存导入(采购入库 Excel)
系统会从 Excel 中抓取:款式编号(清洗为SKU)、款式SKU、颜色及规格(提取尺码)、数量、商品名称、运营仓库、采购单号、入仓单号、采购员、入库日期。
库存汇总
| 产品SKU | 中文名 | 尺码 | 采购员 | 采购单号 | 入仓单号 | 入库日期 | 当前库存 | 更新时间 |
|---|---|---|---|---|---|---|---|---|
| 1241220179907 | 彩带黑色背带短裤 | 3XL | 黄婉婷 | 313440 | 351534 | 2026-01-13 17:13:09 | 15 | 2026-03-22 17:35:49.853337 |
| 1241220179906 | 彩带黑色背带短裤 | 2XL | 黄婉婷 | 313440 | 351534 | 2026-01-13 17:13:09 | 15 | 2026-03-22 17:35:49.799655 |
| 1221600779907 | 孤影抓绒护腿 | 3XL | 黄婉婷 | 313833 | 351535 | 2026-01-13 17:13:59 | 6 | 2026-03-22 17:35:49.797964 |
| 1241220179905 | 彩带黑色背带短裤 | XL | 黄婉婷 | 313440 | 351534 | 2026-02-02 16:44:50 | 17 | 2026-03-22 17:35:49.797830 |
| 1221600779906 | 孤影抓绒护腿 | 2XL | 黄婉婷 | 313833 | 351535 | 2026-01-13 17:13:59 | 7 | 2026-03-22 17:35:49.794696 |
| 1221600779905 | 孤影抓绒护腿 | XL | 黄婉婷 | 313833 | 351535 | 2026-01-13 17:13:59 | 7 | 2026-03-22 17:35:49.793037 |
| RX25070800149906 | LBCC-26 GRAY男款防风背心-YS9099MEO | 2XL | 袁日仙 | 306785 | 351537 | 2026-01-13 17:15:10 | 1 | 2026-03-22 17:35:49.791297 |
| 1231110639907 | 落日印象短上衣 | 3XL | 黄婉婷 | 313834 | 351536 | 2026-01-23 11:23:14 | 13 | 2026-03-22 17:35:49.791172 |
| 1231110639906 | 落日印象短上衣 | 2XL | 黄婉婷 | 313834 | 351536 | 2026-01-23 11:23:14 | 13 | 2026-03-22 17:35:49.791170 |
| 1231110639905 | 落日印象短上衣 | XL | 黄婉婷 | 313834 | 351536 | 2026-01-23 11:23:14 | 14 | 2026-03-22 17:35:49.791166 |
| RX25070800149905 | LBCC-26 GRAY男款防风背心-YS9099MEO | XL | 袁日仙 | 306785 | 351537 | 2026-01-13 17:15:10 | 7 | 2026-03-22 17:35:49.786433 |
| RX25070800149904 | LBCC-26 GRAY男款防风背心-YS9099MEO | L | 袁日仙 | 306785 | 351537 | 2026-01-13 17:15:10 | 10 | 2026-03-22 17:35:49.784872 |
| RX25070800149903 | LBCC-26 GRAY男款防风背心-YS9099MEO | M | 袁日仙 | 306785 | 351537 | 2026-01-13 17:15:10 | 10 | 2026-03-22 17:35:49.783309 |
| RX25070800149902 | LBCC-26 GRAY男款防风背心-YS9099MEO | S | 袁日仙 | 306785 | 351537 | 2026-01-13 17:15:10 | 7 | 2026-03-22 17:35:49.781799 |
| RX25070800149901 | LBCC-26 GRAY男款防风背心-YS9099MEO | XS | 袁日仙 | 306785 | 351537 | 2026-01-13 17:15:10 | 3 | 2026-03-22 17:35:49.780251 |
| MJ25123000069906 | TCHACO SONANGOL26男款POLO衫-头版-YS9450MO | 2XL | 庄镘洁 | 315411 | 351540 | 2026-01-13 17:15:34 | 2 | 2026-03-22 17:35:49.778701 |
| MJ25123000069907 | TCHACO SONANGOL26男款POLO衫-头版-YS9450MO | 3XL | 庄镘洁 | 315411 | 351540 | 2026-01-13 17:15:34 | 2 | 2026-03-22 17:35:49.777196 |
| MJ25123000069905 | TCHACO SONANGOL26男款POLO衫-头版-YS9450MO | XL | 庄镘洁 | 315411 | 351540 | 2026-01-13 17:15:34 | 13 | 2026-03-22 17:35:49.775605 |
| MJ25123000069904 | TCHACO SONANGOL26男款POLO衫-头版-YS9450MO | L | 庄镘洁 | 315411 | 351540 | 2026-01-13 17:15:34 | 12 | 2026-03-22 17:35:49.774049 |
| MJ25123000069903 | TCHACO SONANGOL26男款POLO衫-头版-YS9450MO | M | 庄镘洁 | 315411 | 351540 | 2026-01-13 17:15:34 | 13 | 2026-03-22 17:35:49.772503 |