库龄报告
下载的库龄报告能够帮助您快速确定库存商品在运营中心存储的时长以及哪些商品即将支付长期仓储费。
此报告还为您的所有亚马逊物流库存提供各种详细信息,例如:销量、当前可售数量、您发布的商品价格以及亚马逊商城中同款商品的最低价格。
要下载此报告,请执行以下操作:
转至亚马逊物流库龄页面,点击右上角的【下载报告】
针对最新数据选择【请求下载】,或针对之前的某一时间点选择【下载】
在您选择的电子表格程序中打开下载的 .txt 文件
报告中包含每个 ASIN 的以下信息:
字段名 | 描述 |
---|---|
snapshot-date | 报告的生成日期 |
sku | 您分配给所售商品的唯一编码,由字母和数字组成 |
fnsku | 亚马逊分配给由亚马逊运营中心存储和配送的商品的唯一编码,由字母和数字组成 |
asin | 亚马逊分配给通过亚马逊销售的商品的唯一编码,由 10 个字母或数字组成 |
product-name | 商品的名称 |
condition | 商品状况(新品、二手等) |
available-quantity(sellable) | 可售库存商品的数量 |
qty-with-removals-in-progress | 请求退还或弃置的库存商品的数量 |
inv-age-0-to-90-days | 在运营中心已存储 0-90 天的可售商品的数量 |
inv-age-91-to-180-days | 在运营中心已存储 91-180 天的可售商品的数量 |
inv-age-181-to-270-days | 在运营中心已存储 181-270 天的可售商品的数量 |
inv-age-271-to-365-days | 在运营中心已存储 271-365 天的可售商品的数量 |
inv-age-365-plus-days | 在运营中心已存储超过 365 天的可售商品的数量 |
currency | 用于支付预计长期仓储费的货币 |
qty-to-be-charged-ltsf-6-mo | 在运营中心已存储 180 至 365 天且需支付 180 天长期仓储费的可售商品的数量。例如,亚马逊物流轻小商品计划商品需支付 180 天的长期仓储费。(自 2019 年 2 月起,标准亚马逊物流商品无需支付 180 天的长期仓储费。) |
projected-ltsf-6-mo | 截至下一收费日期在运营中心已存储 180 至 365 天的商品预计需要支付的长期仓储费。 |
qty-to-be-charged-ltsf-12-mo | 截至下一收费日期(每月 15 日)在运营中心已存储超过 365 天的可售商品的数量 |
projected-ltsf-12-mo | 截至下一收费日期(每月 15 日)在运营中心已存储超过 365 天的商品预计需要支付的长期仓储费 |
units-shipped-last-7-days | 过去 7 天售出的商品数量 |
units-shipped-last-30-days | 过去 30 天售出的商品数量 |
units-shipped-last-60-days | 过去 60 天售出的商品数量 |
units-shipped-last-90-days | 过去 90 天售出的商品数量 |
alert | 此商品存在低流量或低转化率提醒时显示 低流量表明只有少数潜在买家查看了商品信息。您可以使用操作列表中的【改进关键词】功能,对商品信息进行搜索优化。您还可以使用【推广商品】功能,通过商品推广来提高商品的流量。 低转化率表明潜在买家查看了商品信息但未跟进和购买商品。确保提供高品质的详情页面和有竞争力的价格有助于提高转化率。 |
your-price | 您发布的商品价格 |
sale_price | 您促销商品的价格 |
lowest_price_new | 此商品的新品在亚马逊商城的最低价格(含运费) |
lowest_price_used | 此商品的二手商品在亚马逊商城的最低价格(含运费) |
Recommended action | 建议您对库存采取的措施。提出建议的依据是本报告生成时的库存状况、ASIN 提醒及各种已知信息。 |
Healthy Inventory Level | 根据商品需求和您的成本,不是冗余库存的库存数量。我们的建议以帮助您达到这一库存水平为目标。 |
Recommended Sales Price | 有助于您根据当前库存设置来销售库存的建议销售价格。该值可能与最低价格或购买按钮价格不同。我们建议您在售出冗余库存之前维持该商品价格。 |
Recommended Sale Duration | 如果建议为促销,则该数值是有助于您售出冗余库存的预计促销持续天数。 |
Estimated Storage Cost | 在不采取任何措施来提高销量或移除库存时,预计的亚马逊物流仓储费和您的储存成本。仓储费可能包含长期仓储费,根据您当前的销售率确定。预计费用以 3 年为周期来计算。注意: 库存数量基于库存的每日快照,可能与您的实际库存数量不同。 |
Recommended Removal Quantity | 移除库存可能比为库存缴纳仓储费更有益处的预计库存数量。 |
estimated-cost-savings-of-recommended-actions | 与不采取任何措施(需要为相应库存支付仓储费)相比,采取建议措施预计可以节约的成本。 |
sell_through | 售出率为过去 90 天内售出并配送的商品数量除以该时间段内运营中心的平均可售库存商品数量。追踪售出率可帮助您确定是否需要采取措施来提高商品的流量或转化率。 |
item-volume | 商品的体积,计算方法是将最长边、次长边和最短边相乘。这些测量值通常对应商品的长度、宽度和高度。 |
volume-units | 商品体积的计量单位。 |
storage-type | 设置有仓储限制的商品的仓储类型分类。有六种仓储类型:标准尺寸、大件、服装、鞋靴、易燃物或气溶胶。 注意: 标准尺寸包括小件和标准商品类型。 |
亚马逊官网原文详情:
Inventory Age Report
A downloaded Inventory Age report helps you quickly identify how long items in your inventory have been in fulfillment centers and those items subject to upcoming long-term storage fees.
The report also provides details about sales, current sellable quantities, your list price, and the lowest price on Amazon for the same item for all of your fulfilled-by-Amazon inventory.
To download this report:
Go to the FBA Inventory Age page, click Download Report in the upper right
Select Request Download for most current data, or Download for a previous point in time
Open the downloaded .txt file in the spreadsheet program of your choice
The following per-ASIN information is included in the report:
Field name Description snapshot-date The date the report was generated sku Unique blocks of letters and numbers that are assigned by you to the product you are selling fnsku Unique blocks of letters and numbers that are assigned by Amazon to products stored in and fulfilled from an Amazon fulfillment center asin Unique blocks of 10 letters or numbers assigned by Amazon to the products sold through Amazon product-name The name of your product condition The condition of the unit (new, used, etc.) available-quantity(sellable) The number of units in inventory available for purchase qty-with-removals-in-progress The number of units in inventory that you have requested be returned to you or disposed of inv-age-0-to-90-days The number of sellable units that have been in the fulfillment center for the last 0-90 days inv-age-91-to-180-days The number of sellable units that have been in the fulfillment center for the last 91-180 days inv-age-181-to-270-days The number of sellable units that have been in the fulfillment center for the last 181-270 days inv-age-271-to-365-days The number of sellable units that have been in the fulfillment center for the last 271-365 days inv-age-365-plus-days The number of sellable units that have been in the fulfillment center for the last 365+ days currency The currency for the estimated long-term storage fee charge qty-to-be-charged-ltsf-6-mo The number of sellable units that will have been in the fulfillment center for 180 to 365 days and are eligible for the 180-day LTSF charge. For example, FBA Small and Light products are subject to this 180-day LTSF charge. (As of February 2019, standard FBA units will not be charged 180-day long term storage fees.) projected-ltsf-6-mo The projected long-term storage fee for units that have been in fulfillment centers for 180 to 365 days on the next charge date. qty-to-be-charged-ltsf-12-mo The number of sellable units that will have been in the fulfillment center for more than 365 days as of the next charge date (monthly on the 15th) projected-ltsf-12-mo The projected long-term storage fee that will be charged for units that have been in fulfillment centers for more than 365 days on the next charge date (monthly on the 15th) units-shipped-last-7-days Units sold in the last 7 days units-shipped-last-30-days Units sold in the last 30 days units-shipped-last-60-days Units sold in the last 60 days units-shipped-last-90-days Units sold in the last 90 days alert Shows when this item has a low traffic or low conversion alert Low traffic indicates that a low number of potential buyers have seen the listings. Use the Improve Keywords feature in the actions list to optimize your listing for search. The Advertise Listing feature allows you to advertise through Sponsored Products to drive additional traffic to your listing.
Low conversion indicates that potential buyers are viewing the listing but do not follow through to purchase the product. Ensuring a high quality detail page and pricing competitively helps improve conversion rates.
your-price Your listed price sale_price Your sale price if you are running a sale on the product lowest_price_new The lowest price (including shipping) for this item in new condition on Amazon lowest_price_used The lowest price (including shipping) for this item in used condition on Amazon Recommended action The action recommended for your inventory. Recommendations depend on your inventory position, ASIN alerts, and known inputs at the time the report is generated. Healthy Inventory Level Quantity of inventory that is not considered excess based on product demand and your costs. Our recommendations are based on helping you reach this level of inventory. Recommended Sales Price Sales price recommended to help you sell through your inventory based on your current inventory settings. This value may be different from the lowest price or Buy Box price. We recommend that you keep your product at this price until you have sold through your excess inventory. Recommended Sale Duration If a sale is recommended, this is the estimated sale duration in days that would likely help you sell through your excess inventory. Estimated Storage Cost Estimated FBA storage fees and your holding cost of capital if no action is taken to help sell through or remove your inventory. The storage fees may include the Long-term Storage Fee and are based on your current sales rate. The estimation is calculated over a 3-year horizon. Note: Inventory quantities are based on a daily snapshot and may differ from your actual inventory quantities. Recommended Removal Quantity Estimated quantity of inventory that would likely benefit from removal instead of being charged storage fees. estimated-cost-savings-of-recommended-actions Estimated cost savings between taking the recommended action versus the storage fees you would incur on that inventory by taking no action. sell-through The rate at which your units sold and shipped over the past 90 days divided by the average inventory available at fulfillment centers during that time period. Tracking your sell-through rate can help you determine whether you need to take action to improve traffic or conversion for your products. item-volume The volume of the item, which is calculated by multiplying the longest side, median side, and shortest side together. These measurements generally correspond to the length, width, and height of the item. volume-units Unit of measurement for the volume of the item. storage-type Storage type category of the product for which storage limits are set. There are six storage types: standard-size, oversize, apparel, footwear, flammable or aerosol. Note: standard-size is including small and standard types.
文章来源:亚马逊官方网站