Skip to main content

What is COGS in DataDoe?

Cost of goods sold (COGS) is what you pay to source or make one unit of a product. DataDoe does not fetch COGS from Amazon. You upload it as a CSV file. Uploaded COGS is used in profit reports and tables such as Order Line Items and Profit by SKU and Date.

Where do I upload COGS?

  1. Open Sellers & Vendors.
  2. Select a seller. COGS upload is available for sellers only.
  3. Go to Upload COGS and choose your file format.

You can also manage COGS manually for each SKU in the Inventory report.

How does effective dating work?

COGS is stored per SKU and From date. A row applies from that date until the next From date for the same SKU.

For example, SKU ABC-123 has a row with From date 2026-01-01. DataDoe uses that row for the SKU until you add another row with a later From date, such as 2026-03-01.

What is the file format?

Use the DataDoe CSV format to set costs per SKU and the date they start. You can download a sample CSV.

ColumnRequiredDescription
child_asinYesProduct ASIN (10 characters).
skuNoSKU this cost applies to. If empty, DataDoe resolves SKUs from your listings.
fromNoStart date (YYYY-MM-DD or MM/DD/YYYY). Empty means the cost applies from the earliest date.
cost_item_valueNoItem cost per unit (without shipping). Defaults to 0.
cost_item_shipping_valueNoShipping or inbound cost per unit. Defaults to 0.
cost_currencyYesCurrency code, for example USD or EUR.
item_supplier_nameNoSupplier name for the item (optional, up to 128 characters).

All required column headers must be present. You can omit optional columns from the header.

Re-uploading COGS

When you re-upload a CSV file, DataDoe updates matching rows with new cost values. A row matches when it has the same SKU, ASIN, currency and From date.

Supplier name behaviour:

  • If your CSV includes the item_supplier_name column, supplier values in the file replace stored values for matching rows. Leave a cell empty to clear the supplier name for that row.
  • If your CSV does not include the item_supplier_name column, existing supplier names are preserved for matching rows.
  • SellerBoard uploads never change supplier names on matching rows. New rows inserted from SellerBoard files have no supplier name.

Edits made in the per-SKU COGS editor also preserve supplier names when you change costs only.

Which tables use uploaded COGS?

Look for tables that contain COGS-related columns in the Data Scheme.

Need help?

If you have questions about uploading COGS or your data, contact us (opens in a new tab).