Inventory
đź’Ž Built for Sidekick
⚡ Sidekick does this for you
shopify
sidekick
catalog
shipping
Backfill Product Weight and Dimensions for Shipping Accuracy
Fill in missing product weight and package dimensions across the catalog using sibling products or a reference table, to fix inaccurate shipping rates.
đź“‹ Prompt
Find every product in [SCOPE, e.g. “the entire catalog”] missing weight, length, width, or height values. For each missing product: Check if a similar product in the same [PRODUCT_TYPE] and roughly the same size category already has these values set – if so, propose using it as a reference. If no similar product exists, look up dimensions using this reference table: [DIMENSION_REFERENCE_TABLE]. If neither source applies, flag the product for manual measurement instead of guessing a number. Show me a table of product, current values (or “missing”), proposed values, and source (sibling match / reference table / needs manual measurement) before applying anything. Apply only after I confirm, then report products fixed automatically vs. flagged for manual measurement, and note this may affect shipping rates going forward.
How to Use
- Copy the prompt above
- Open Shopify Sidekick in your Shopify admin
- Paste the prompt and replace the bracketed placeholders with your details
- Review Sidekick's response and apply the suggestions