TTB COLA + state ABC license per state, upload and compliance flow?

Two separate compliance regimes that both run on every SKU:

TTB COLA (federal): Certificate of Label Approval from the Alcohol and Tobacco Tax and Trade Bureau. Required before any alcoholic beverage with >7% ABV (wine), >0.5% ABV (beer/spirits) can be sold across state lines. You submit label artwork + formula → TTB approves → COLA number is issued. Approval takes 4-12 weeks typically.

State ABC (Alcoholic Beverage Control) license: Per-state license to ship into that state. Each state has its own ABC board with its own rules. License fees range $50, $2,500/yr/state. Some states require annual renewal, some 3-year. Some require a bond, some require in-state agent.

The Magento flow:

• Product attributes per SKU: ttb_cola_number, ttb_cola_expiry, abc_license_states (multi-select of states where this SKU has license coverage).
• Admin warnings when COLA is missing or expiring (60-day warning, 30-day, 7-day).
• Checkout enforcement: if customer’s ship-to state isn’t in the SKU’s abc_license_states, block the order with a clear message ("This product cannot be shipped to TX, we don’t hold a Texas ABC license for spirits.").
• Compliance dashboard: admin view showing which SKUs are missing approvals for which states, sortable by expiry date.

For multi-state shippers, integrate Sovos ShipCompliant for Beverage Alcohol or Avalara AvaTax for Beverage Alcohol. Both are SaaS that automates state tax calc + carrier rejection lookup + license renewal tracking. ~$500, $3,000/mo depending on volume.