Skip to content

Instantly share code, notes, and snippets.

@tspicer
tspicer / ara.csv
Created November 28, 2023 23:39
amazon retail analytics metric glossary
We can make this file beautiful and searchable if this error is corrected: Unclosed quoted field in line 4.
Metric,Definition,Dashboard
Aged 90+ Days Sellable Inventory,Number of units that is at least 90 days old and in sellable condition on the last day of the selected time frame.,Inventory
Aged 90+ Days Sellable Units,Cost of inventory that is at least 90 days old and in sellable condition on the last day of the selected time frame.,Inventory
Contra-COGS (CCOGS),"Contrary to the Cost of Goods Sold (Contra-COGS) represents funds that Amazon collects from vendors for agreements related to Amazon’s purchase, customer sales, or marketing of the vendor’s inventory. This amount excludes Display Ads Contra-COGS. Total CCOGs Amount is also referred to as Vendor Funded Contra-COGS (VFCC).
Total Contra Cogs amount = Vendor allowance amount.
+ Quick Pay Discounts Amount
+ Discretionary COOP Amount
Vendor Allowance Amount - Vendor Allowances are cost savings funded by the vendor, including damage allowance, volume incentive, and flex agreements.
Quick Pay Discounts Amount - Quick Pay Discounts are the estimated discount amo
@tspicer
tspicer / ledger_report_reconciliation_codes.csv
Last active December 27, 2022 00:34
Reconciliation events
Inventory adjustment reason Reconciliation reason (displayed in drop-down menu) Definition
Damaged at Amazon fulfillment center Inspected and disposition corrected Inventory that an inspection found was not damaged at the fulfillment center
Reimbursed Inventory for which you have been reimbursed
Remaining misplaced or damaged inventory The remaining inventory that has not been reconciled
Inventory misplaced Inventory found Misplaced inventory that was found
Reimbursed Inventory for which you have been reimbursed
Damaged inventory misplaced Damaged at Amazon fulfillment center inventory that was misplaced. Note: The reconciliation will be applied to the Damaged at Amazon fulfillment center inventory.
Remaining misplaced or damaged inventory The remaining inventory that has not been reconciled
Inventory found Replacement inventory found Inventory that was replaced to compensate for inventory that was lost or damaged, in accordance with the FBA inventory reimbursement policy.
@tspicer
tspicer / ledger_report_disposition_codes.csv
Last active December 27, 2022 00:49
Inventory dispositions
Inventory disposition Inventory state Definition
Sellable Sellable Inventory that looks and functions as described in the listing
Defective Unsellable Inventory that does not look or function as described in the listing and is not visibly damaged, such as a recalled product
Customer damaged Unsellable Inventory that was damaged by a customer
Distributor damaged Unsellable Inventory that was damaged by the seller, vendor, or distributor during receiving
Fulfillment center damaged Unsellable Inventory that was damaged at an Amazon fulfillment center
Carrier damaged Unsellable Inventory that was damaged by a carrier during receiving, while in transit to the buyer, or while in transit back to Amazon due to a return
Expired Unsellable Inventory that has passed its expiration date
@tspicer
tspicer / ledger_report_reason_codes.csv
Created December 27, 2022 00:23
Adjustment types and reason codes
Code Type Reason Definition
6 - Damaged at Amazon fulfillment center A decrease to your carrier-damaged inventory level. This code is always followed by a P code increase to your fulfillment-center-damaged inventory level.
7 - Damaged at Amazon fulfillment center A decrease to your expired inventory level. This code is always followed by a P code increase to your fulfillment-center-damaged inventory level.
E - Damaged at Amazon fulfillment center A decrease to your sellable inventory level. This code is always followed by a P code increase to your fulfillment-center-damaged inventory level.
H - Damaged at Amazon fulfillment center A decrease to your customer-damaged inventory level. This code is always followed by a P code increase to your fulfillment-center-damaged inventory level.
K - Damaged at Amazon fulfillment center A decrease to your defective inventory level. This code is always followed by a P code increase to your fulfillment-center-damaged inventory level.
U - Damaged at Amazon fulfillment center
Name Description
Date The date the report was requested
FNKSU Unique identifier that Amazon assigns to products stored in and fulfilled from an Amazon fulfillment center
ASIN Unique blocks of 10 letters or numbers that identify items. ASINs are assigned by Amazon. You can find the ASIN on the product detail page.
MSKU Unique identifier that you assign to products
Title The title of your product
Event type Type of event that caused a change in inventory, such as shipment, receipt, vendor return, warehouse transfer, adjustment, or customer return
Reference ID Transaction ID, such as a shipment ID or adjustment ID
Quantity Unit quantity for the transaction
Fulfillment center Fulfillment center where the inventory is stored
@tspicer
tspicer / summary_ledger_report_fields.csv
Created December 27, 2022 00:16
Amazon Summary Ledger Report Fields
Name Description
Date The date the report was requested
FNKSU Unique identifier that Amazon assigns to products stored in and fulfilled from an Amazon fulfillment center
ASIN Unique blocks of 10 letters or numbers that identify items. ASINs are assigned by Amazon. You can find the ASIN on the product detail page.
MSKU Unique identifier that you assign to products
Title The title of your product
Disposition The status of the product, such as sellable or damaged
Starting warehouse balance Units that were available for this product in fulfillment centers at the start of the time period
Receipts Units that were received in shipments to fulfillment centers
Customer shipments Completed deliveries of customer orders that Amazon has fulfilled
@tspicer
tspicer / summary_ledger_report.csv
Created December 27, 2022 00:12
Amazon Summary Ledger Report
We can make this file beautiful and searchable if this error is corrected: Unclosed quoted field in line 5.
Parameter,Description,Required?
ASIN,Unique blocks of 10 letters or numbers that identify items. ASINs are assigned by Amazon. You can find the ASIN on the product detail page.,"Not required
To generate a report for a specific product, enter the ASIN, MSKU, or FNSKU. Leaving these fields blank will generate a report for all products."
Merchant SKU,Unique identifier that you assign to products,"Not required
To generate a report for a specific product, enter the ASIN, MSKU, or FNSKU. Leaving these fields blank will generate a report for all products."
Fulfillment network SKU (FNSKU),Unique identifier that Amazon assigns to products stored in and fulfilled from an Amazon fulfillment center,"Not required
To generate a report for a specific product, enter the ASIN, MSKU, or FNSKU. Leaving these fields blank will generate a report for all products."
Aggregate report by location,"For the summary view, select Country to display inventory location by country or Fulfillment center to display inventory location by fulfi
#!/usr/bin/env bash
pip_url="https://bootstrap.pypa.io/get-pip.py"
agent_url="https://github.com/nginxinc/nginx-amplify-agent"
agent_conf_path="/etc/amplify-agent"
agent_conf_file="${agent_conf_path}/agent.conf"
nginx_conf_file="/etc/nginx/nginx.conf"
amplify_user=www-data
API_KEY={{NGINX_AMPLIFY_API}}
NGINX_AMPLIFY_HOST={{NGINX_AMPLIFY_HOST}}
@tspicer
tspicer / s3etag.sh
Created December 14, 2016 04:03 — forked from emersonf/s3etag.sh
A Bash script to compute ETag values for S3 multipart uploads on OS X.
#!/bin/bash
if [ $# -ne 2 ]; then
echo "Usage: $0 file partSizeInMb";
exit 0;
fi
file=$1
if [ ! -f "$file" ]; then
@tspicer
tspicer / theme
Created April 16, 2016 19:58
theme
{"last_tab":"5","theme-skin":"ascend","favicon":{"url":"","id":"","height":"","width":"","thumbnail":""},"button-styling":"rounded","theme-icon-style":"minimal","overall-bg-color":"#edeff0","overall-font-color":"#000000","back-to-top":"1","back-to-top-mobile":"0","smooth-scrolling":"0","one-page-scrolling":"1","responsive":"1","ext_responsive":"1","lightbox_script":"magnific","default-lightbox":"1","column_animation_easing":"easeOutQuart","column_animation_timing":"1000","external-dynamic-css":"0","google-analytics":"","custom-css":"","accent-color":"#5fcf80","extra-color-1":"#f1564f","extra-color-2":"#6b7a88","extra-color-3":"#333333","boxed_layout":"1","background-color":"#edeff0","background_image":{"url":"","id":"","height":"","width":"","thumbnail":""},"background-repeat":"","background-position":"","background-attachment":"","background-cover":"0","extended-theme-font":"0","navigation_font_family":{"font-family":"","font-options":"","google":"1","font-weight":"","font-style":"","subsets":"","text-transf