1 · Import SKUs
Required columns: sku, name. Optional: category, active, notes. Existing SKU codes are updated — safe to re-import. A dry run runs first; nothing is written until you confirm.
Example:
sku,name,category CG-BTL-750,Insulated Bottle 750 ml,Drinkware CG-TENT-2P,2-Person Trail Tent,Shelter
2 · Import packaging weights
Required columns: sku, material and a weight — grams (decimals fine) or mg. Optional: component (a label like “bottle” or “label”), recyclable and from_year (the reporting year a new weight holds from; the years before keep the weight they were reported with). This is the bulk-entry route for the numbers the whole register rests on. SKUs and materials must already exist — an unknown one is refused with a reason rather than invented, because a made-up material would quietly distort a filing. Re-uploading updates the weight for the same (sku, component, material), so correcting a spreadsheet is safe.
Example:
sku,component,material,grams,recyclable SKU-001,Bottle,PET,18.4,yes SKU-001,Label,Paper,0.9,yes SKU-001,Cap,HDPE,2.1,no
3 · Import units sold (annual)
Required columns: sku, state, year, units. One row per SKU × state × year — re-imports update the units. Unknown state codes are skipped with a reason; unknown SKU codes are imported and flagged, never silently dropped.
Example (your states: CA, CO, ME, MN, OR, OTHER, WA):
sku,state,year,units CG-BTL-750,OR,2026,14200 CG-BTL-750,CA,2026,31900 CG-TENT-2P,CO,2026,2210
4 · Import orders from your shop
Upload your shop's own orders export, one row per order line, and Packora adds up units sold per SKU, ship-to state and year for you. Each order line counts once, ever: import the same file again, or an overlapping one, and the lines already counted are skipped. Canceled, refunded and unpaid orders, orders shipped outside the US and orders to a state not on your States page are counted and reported, never imported. Units are added to the units on file.
The ship-to state may be a code (OR) or a name (Oregon), matched against your States page. Refunds inside an order that still counts are not subtracted: adjust those units by hand if your program asks you to.
On file
Limits & safety
Packora is a records & report-prep aid — not legal advice and not a filing system. Material categories, deadlines, and fee rates shown are operator-entered; verify everything with your PRO (producer responsibility organization) before filing.