Profit Guard

Back to manual

User manual

Costs

Maintain direct costs, supplier contracts, fallback rules, and cost import audit history.

Import costs

Use manual SKU edits for one-off fixes and CSV imports for bulk updates. Preview mode validates files without writing to the database.

  1. Download or follow the CSV template.
  2. Run Preview first and review errors.
  3. Use Upsert for normal updates and Replace only when intentionally rebuilding a full batch.

CSV format

Direct cost files must identify each variant by SKU or Shopify variant ID and provide a positive cost amount with a valid currency code.

  1. Keep SKU values exactly aligned with Shopify.
  2. Use three-letter ISO currency codes.
  3. Review audit downloads after large imports.

Coverage and exceptions

Supplier contracts and fallback rules reduce missing cost gaps, but direct SKU cost should remain the most trusted source when available.

  1. Use supplier contracts for vendor-level defaults.
  2. Use fallback rules for product type, vendor, or tag assumptions.
  3. Review missing coverage before trusting report margins.

Related sections