Skip to content

Instantly share code, notes, and snippets.

View tspicer's full-sized avatar
💭
I may be slow to respond.

Thomas Spicer tspicer

💭
I may be slow to respond.
View GitHub Profile
@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_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 / 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
#!/usr/bin/env bash
# WordPress Installer and Configuration Script
#
# This script automates the process of installing and configuring WordPress.
# It includes functions for downloading WordPress, setting up the configuration,
# installing necessary plugins, and configuring SSL.
#######################################
# Downloads and sets up WordPress core files