cogs-tracking-allocation

Track cost of goods sold and landed costs to compute gross margin per order.

3|1|Updated Mar 21, 2026
One-click install
npx skills add https://github.com/tomtoto757/ecomm-ai-team --skill cogs-tracking-allocation-tomtoto757
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: cogs-tracking-allocation
Source: https://github.com/tomtoto757/ecomm-ai-team/tree/main/skills/catalog-inventory/finsilabs/catalog-inventory/cogs-tracking-allocation
Command: npx skills add https://github.com/tomtoto757/ecomm-ai-team --skill cogs-tracking-allocation-tomtoto757

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve? Merchants often see revenue on their income statement but cannot compute gross margin because unit costs are not tracked, and imported goods carry freight, customs, and duties that never get allocated into product cost. This Skill guides you through entering cost prices, connecting accounting integrations, and allocating landed costs so every order reports accurate COGS. ## Core Features & Use Cases - Platform Cost Setup: Step-by-step instructions for entering cost per variant in Shopify, WooCommerce, and BigCommerce, including bulk CSV imports via Matrixify. - Accounting Integration: Connect QuickBooks or Xero (via A2X, MyWorks, or native apps) so COGS journal entries post automatically when orders are fulfilled. - Landed Cost Allocation: Allocate freight, insurance, and duties across received SKUs by value, weight, or quantity before the first sale. - Custom FIFO Ledger: TypeScript reference implementation of a perpetual inventory cost ledger with FIFO layer consumption and weighted average costing for headless storefronts. - Use Case: An electronics importer receives a shipment with a separate freight invoice weeks later; use this Skill to allocate those landed costs across purchase lots and run a variance report comparing actual costs against standard costs. ## Quick Start Ask the AI to set up COGS tracking for your Shopify store by entering variant cost prices and connecting QuickBooks for automatic margin reporting.

Frequently Asked Questions about cogs-tracking-allocation

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I track cost of goods sold in Shopify?▼

Enter the Cost per item field on each product variant under Admin → Products → Pricing. Shopify's Analytics → Finances reports then show profit per product, and apps like A2X or QuickBooks Connector post COGS journal entries to your accounting software automatically.

How to allocate landed costs like freight and duties to inventory?▼

Calculate each layer's share as (product value / total shipment value) × total landed cost, then divide by units received to get a per-unit landed cost. Update the cost price before the first sale, or post a landed cost allocation journal entry in QuickBooks or Xero.

Should I use FIFO or weighted average costing for inventory?▼

FIFO consumes the oldest purchase lots first and suits high-value items, while weighted average recalculates cost dynamically from current inventory layers and suits fast-moving consumables. Choose one method per product category and avoid switching mid-year without a revaluation entry.

Why does my gross margin report show 100% profit on some products?▼

The cost price is missing for those variants, and platforms like Shopify and WooCommerce silently treat a missing cost as $0. Enter cost prices for all variants, using a bulk CSV import tool like Matrixify for large catalogs.

Does WooCommerce support COGS tracking natively?▼

WooCommerce stores a purchase cost field per product, but margin reporting requires a plugin such as WooCommerce Cost of Goods by SkyVerge or an analytics tool like Metorik. For accounting sync, MyWorks or QuickBooks Commerce posts COGS entries to QuickBooks.

When should I build a custom COGS system instead of using platform tools?▼

Build a custom cost ledger only when your platform or accounting integration cannot meet your costing method requirements, such as perpetual FIFO with landed cost allocation on a headless storefront. Otherwise, native cost fields plus QuickBooks or Xero integrations cover most needs.