Tareproof

Packaging data

Import sales by state and year

Map units sold to existing SKUs and the covered EPR states.

Before you start

Create the SKUs first. Include sku_code, state_code, year and units_sold, with one intended total per SKU, state and year.

Access needed

Owners, admins and editors can import sales.

Steps

  1. Open Import sales from the SKU workflow.
  2. Choose CSV file or paste your CSV text. Map SKU code, State, Year and Units sold.
  3. Use a supported two-letter state code and the exact existing SKU code. Supply a whole reporting year and nonnegative whole units.
  4. Review row errors and the valid rows. Correct unknown SKU codes, unsupported states and invalid numbers before importing.
  5. Choose the Import action and review the completion counts. Reopen Reports or Fee forecast for the matching reporting year.

Expected result

Sales quantities drive supplied weight when multiplied by approved packaging. A later import replaces the existing total for the same SKU, state and year; it does not add to it.

Common problems

  • Consolidate duplicate SKU/state/year rows in the source file; do not expect transaction-level sales to be automatically summed.
  • Zero sales and missing sales are different. Do not use zero to hide unknown quantities.
  • Some valid rows can be written before a batch error. Inspect results before retrying.