跳到主要内容
Acenda
EN中文
登录 预约演示
预约演示
Acenda 后台培训导入导出3:25

通过导入批量更新库存

导出 Inventory Details、编辑数量,再把文件导回 Acenda,一次更新大量商品的库存。

您将学到

  1. 在 Exports 标签页导出 Inventory Details
  2. 保留 SKU、仓库 ID、数量和已分配数量
  3. 以 Inventory Detail 类型导入;入站同步会覆盖它

在 Acenda 中的位置

Acenda 后台中的菜单路径。

DATA TRANSFERS > Imports > New Import

视频文字稿

文字稿为英文,与视频讲解内容一致。

When stock changes for many products, a round trip of export, edit and re-import updates them all at once. For one or two items, adjusting inventory by hand is faster.

Step one is to export your current inventory. In the sidebar, under Data Transfers, click Imports, then open the Exports tab. Choose Inventory Details from the Export Type dropdown, pick a Format, and start the export. Your file shows up in the Generated Files table, where you click Download. We won't run an export in this demo.

Step two is to prepare your file. Save it as .xlsx, .xlsm, or a CSV in UTF-8. Older .xls files are rejected. Only the first tab is read. Keep only these columns: SKU or product ID, warehouse ID, quantity, and, optionally, allocated.

Delete the system columns and any custom field columns, or rows can fail. Quantity is the new total on hand for that warehouse, not an amount to add. To find a warehouse ID, look under Channels, then Warehouses.

Step three is to import. Back on the Imports tab, click New Import. On the New File Import page, choose Inventory Detail from the Import Type dropdown. Then drag your file in or click Select file, and click Start Import. The button stays disabled until you choose a file.

We won't upload anything here. If you'll repeat the same layout, check Save custom import profile when you map your columns, so you don't have to remap next time.

Important: if a warehouse is linked to an inbound inventory sync, like ShipHero, ShipBob, Shopify, or NetSuite, the next sync overwrites your import. Use this for warehouses without an inbound sync. Each marketplace picks up imported inventory on its own schedule. If a row doesn't update, open the import on the Imports page to see which rows failed. If every row failed, check for extra columns.

To recap: export Inventory Details, keep only the SKU, warehouse ID, quantity and allocated columns, and import the file as Inventory Detail. An inbound sync overwrites imported quantities.

Questions? We're here to help. Chat with Acenda support in Acenda Admin, or visit acenda.com/help.

以纯文本打开文字稿

接下来观看

全部培训视频 →
3:03 导入导出将文件保存为 CSV UTF-8把导入文件保存为 CSV UTF-8,或直接导入 Excel 文件,让重音字符和符号在 Acenda 中正确显示。 3:01 导入导出找到每日商品备份在 Exports 下找到 Acenda 每日保存的商品目录备份,并用它恢复全部或部分商品目录。

想了解上线流程是怎样的?

预约演示

或者联系我们。

Acenda 提供这些资源仅供参考。我们力求内容准确,但其中仍可能存在错误、疏漏或遗漏,信息也可能过时。供应商应自行审慎判断,必要时咨询律师,并向相关销售渠道确认最新要求。