Inventory 💎 Built for Sidekick ⚡ Sidekick does this for you
shopify sidekick catalog finances

Backfill Cost-Per-Item Across the Product Catalog

Fill in missing cost-per-item at the product level from a supplier cost sheet so profit reporting and margin analysis are complete and accurate.

đź“‹ Prompt
Run in Sidekick
Find every product in [SCOPE, e.g. “the entire catalog”] with a missing cost-per-item, and match it to a cost using this source: [COST_SOURCE, e.g. “this cost sheet keyed by SKU: COST_SHEET_REFERENCE”].

For each product:

  Show current cost (or “missing”), matched cost, current price, and resulting margin.
  Flag products where no match is found in the cost source.
  Flag products where the computed margin is below [MARGIN_THRESHOLD]% or above [MARGIN_THRESHOLD_HIGH]%, since these often indicate a bad cost match rather than a real outlier.


Show the full table for review before applying anything. Apply only after I confirm, then report: products updated, average margin before vs. after the backfill, and a list of unmatched products still needing a manual cost entry.

How to Use

  1. Copy the prompt above
  2. Open Shopify Sidekick in your Shopify admin
  3. Paste the prompt and replace the bracketed placeholders with your details
  4. Review Sidekick's response and apply the suggestions