Shopify Product Metafield Bulk Data Entry from Spreadsheet

Add custom metafields to multiple Shopify products for enhanced product information and functionality

The Prompt

Open Google Sheet with metafield data at: {{METAFIELD_SPREADSHEET_URL}} The spreadsheet should contain: - Product Title or SKU - Metafield Namespace - Metafield Key - Metafield Value - Metafield Type (text, number, json, etc.) Navigate to Shopify Admin. For each product (up to {{PRODUCT_COUNT}} products): - Go to Products section - Search for product by title or SKU from spreadsheet - Open product editor - Scroll down to Metafields section (or open from More actions menu) - Add new metafield: * **Namespace:** Enter from spreadsheet (e.g., custom, specifications, etc.) * **Key:** Enter metafield key (e.g., material, care_instructions, size_chart) * **Value:** Enter the value from spreadsheet * **Type:** Select appropriate type: - Single line text - Multi-line text - Number (integer) - Number (decimal) - True/False - JSON - Date - URL - File reference - For multiple metafields on same product: * Add each metafield separately * Ensure namespace and key are consistent * Verify type matches data - Common metafield use cases: * **Product Specifications:** namespace: specs, keys: material, dimensions, weight * **Care Instructions:** namespace: care, key: instructions * **Size Charts:** namespace: sizing, key: chart_url * **Video URLs:** namespace: media, key: video_url * **Custom Badges:** namespace: badges, key: label * **SEO Data:** namespace: seo, keys: focus_keyword, meta_title * **Inventory Details:** namespace: inventory, keys: supplier, lead_time - Verify metafield was added correctly - Save product - Move to next product **Note:** Metafields enable: - Custom product attributes - Enhanced theme functionality - App integrations - Structured data for SEO - Product filtering and sorting Add metafields to {{PRODUCT_COUNT}} products. Wait 20-40 seconds between products.

Customize Variables

Example: https://docs.google.com/spreadsheets/d/your-sheet-id

Example: 50

How to Use

With FillApp (One-Click)

  1. Install FillApp Chrome extension
  2. Customize the variables above with your values
  3. Click "Run in FillApp" in the sidebar
  4. The prompt will automatically load and execute

With Other AI Browser Agents

  1. Customize the variables above with your values
  2. Click "Copy Prompt" to copy the customized prompt
  3. Open your AI Browser Agent (ChatGPT Atlas, Perplexity Comet, Claude, etc.)
  4. Paste the prompt and execute according to your agent's interface

Note: Functionality may vary depending on your AI agent's capabilities.

Automate Your Browser.
Get More Done

Stop wasting time on manual tasks. Get the free extension and start automating form filling and multi‑step browser workflows instantly.

Add to Chrome