Skip to content

Shop Filter Bulk Upload

Menu Location: Products > Shop > Shop Filter Bulk Upload

Access Level: Administrator and above

Last Updated: 2026-03-01


Overview

The Shop Filter Bulk Upload page allows you to create or update multiple product filters simultaneously using CSV file upload. This tool dramatically speeds up filter management, making it easy to tag hundreds of products with dietary labels, allergen warnings, or category tags in one operation.

Primary Functions:

  • Upload CSV file to create/update product filters in bulk
  • Tag multiple products with filter attributes simultaneously
  • Update existing filter assignments
  • Remove filters from products in bulk
  • Save time compared to editing products individually
  • Maintain consistent filter taxonomy across catalog

Page Layout

Header Section

  • Download Template Button: Get CSV template with correct format
  • Upload CSV Button: Select and upload filter assignment file
  • Instructions Panel: Quick reference for CSV format

Upload Section

  • File Selector: Choose CSV file from computer
  • Preview Area: Shows first 10 rows of uploaded file for verification
  • Validation Messages: Displays any format or data errors before processing

Results Section (after upload)

  • Success Count: Number of filters successfully applied
  • Error Report: Any products or filters that failed with explanations
  • Change Summary: Overview of what was added, updated, or removed

CSV File Format

Required Columns

Column Structure:

  1. Product SKU or Product ID: Unique identifier for product
  2. Filter Name: Name of filter to apply (e.g., "Gluten-Free", "Organic", "Local")
  3. Action: "ADD", "REMOVE", or "REPLACE"

Example CSV:

Product SKU,Filter Name,Action
ORG-APPLE-001,Organic,ADD
ORG-APPLE-001,Local,ADD
BEEF-RIBEYE-02,Grass-Fed,ADD
BEEF-RIBEYE-02,Keto-Friendly,ADD
MILK-WHOLE-001,Contains Dairy,ADD
PASTA-WHEAT-01,Gluten-Free,REMOVE

Optional Columns

  • Filter Value: For filters requiring value (e.g., "Protein: 25g")
  • Priority: Display order if filter order matters
  • Notes: Internal notes about filter assignment

Actions & Operations

Download CSV Template

Purpose: Get pre-formatted CSV file with correct column headers

Steps:

  1. Click "Download Template" button
  2. Template downloads to computer
  3. Open in Excel or Google Sheets
  4. Fill in product and filter information
  5. Save as CSV file

Template Includes:

  • Correct column headers
  • Example rows showing proper format
  • Instructions worksheet (if Excel format)

Upload Bulk Filter CSV

Purpose: Apply filters to multiple products at once

Steps:

  1. Prepare CSV file with product and filter data
  2. Click "Upload CSV" button
  3. Select file from computer
  4. Review preview of first 10 rows
  5. Verify data looks correct
  6. Click "Process Upload" button
  7. Wait for processing (may take 30-60 seconds for large files)
  8. Review results and error report
  9. Correct any errors and re-upload if needed

Requirements:

  • CSV file format (not Excel .xlsx)
  • Valid product SKUs or IDs
  • Filter names must match existing filters (or system creates new ones)
  • Maximum file size: typically 5MB or 5,000 rows

Create New Filters via Upload

Purpose: Automatically create new filter types while applying to products

Steps:

  1. Include new filter names in CSV
  2. System detects filter doesn't exist yet
  3. Automatically creates new filter
  4. Applies filter to specified products
  5. Review newly created filters in filter management
  6. Add descriptions or customize as needed

Note: Some systems require filters to be pre-created. Check your configuration.


Common Use Cases

Use Case 1: Tag All Organic Products

Goal: Apply "Organic" filter to all certified organic products

Steps:

  1. Export current product list with SKUs
  2. Filter in Excel to organic products only (by name, vendor, or certification)
  3. Create CSV with:
    • Column 1: Product SKUs of all organic items
    • Column 2: "Organic" for all rows
    • Column 3: "ADD" for all rows
  4. Upload CSV
  5. Verify all organic products now show "Organic" filter on shop
  6. Test customer filter functionality

Example: 150 organic products tagged in 2 minutes vs 1-2 hours of manual entry.

Use Case 2: Dietary Label Campaign

Goal: Add comprehensive dietary labels (Vegan, Keto, Paleo, etc.) to entire catalog

Steps:

  1. Review product catalog and identify dietary attributes
  2. Create spreadsheet categorizing each product:
    • Gluten-Free: Yes/No
    • Dairy-Free: Yes/No
    • Vegan: Yes/No
    • Keto-Friendly: Yes/No
    • Paleo: Yes/No
  3. Convert to bulk upload CSV format (one row per product-filter)
  4. Example:
    SKU-001,Gluten-Free,ADD
    SKU-001,Vegan,ADD
    SKU-001,Paleo,ADD
    SKU-002,Keto-Friendly,ADD
    SKU-002,Dairy-Free,ADD
    
  5. Upload and process
  6. Review customer shop for new filter options

Benefits:

  • Customers can now filter by dietary preferences
  • Improves shopping experience
  • Increases sales to specialty diet customers

Use Case 3: Seasonal Product Tagging

Goal: Tag all summer seasonal products for featured collection

Steps:

  1. Identify all summer seasonal products
  2. Create CSV tagging them with "Summer" filter
  3. Upload CSV
  4. Create "Summer Favorites" shop category filtered by this tag
  5. Products automatically appear in summer collection
  6. When season ends, upload REMOVE action CSV to clear tags

Use Case 4: Allergen Labeling

Goal: Add "Contains" warnings for common allergens

Steps:

  1. Review products for allergen content
  2. Create comprehensive CSV with all allergen filters:
    • Contains Dairy
    • Contains Eggs
    • Contains Tree Nuts
    • Contains Peanuts
    • Contains Soy
    • Contains Wheat/Gluten
  3. Contains Shellfish
  4. Upload CSV
  5. Customers can now filter to avoid allergens
  6. Regulatory compliance improved

Critical for:

  • Customer safety
  • Legal compliance
  • Building trust

Use Case 5: Bulk Filter Correction

Goal: Remove incorrectly applied filters from products

Steps:

  1. Identify products with wrong filter (e.g., "Gluten-Free" on wheat pasta)
  2. Create CSV with REMOVE action:
    PASTA-WHEAT-01,Gluten-Free,REMOVE
    BREAD-WHEAT-05,Gluten-Free,REMOVE
    
  3. Upload and process
  4. Verify incorrect filters removed
  5. Add correct filters if needed

Troubleshooting

Upload Fails with "Invalid CSV Format"

Solutions:

  1. Ensure file is saved as CSV (not Excel .xlsx)
  2. Check that all required columns are present
  3. Verify column headers match exactly (case-sensitive)
  4. Remove any blank rows or columns
  5. Check for special characters that may break CSV format
  6. Try exporting template and copying data into it

Some Products Not Updated

Check Error Report for:

  1. Invalid Product SKU: SKU doesn't exist in catalog
  2. Verify SKU spelling
  3. Check if product was deleted
  4. Use Product ID instead of SKU if available
  5. Filter Name Doesn't Exist: For systems requiring pre-created filters
  6. Create filter first in filter management
  7. Check spelling of filter name
  8. Permissions Error: Insufficient access to modify these products
  9. Contact administrator

Filters Created But Don't Show on Shop

Check:

  1. Filter is marked "Active" in filter management
  2. Filter display is enabled for customer shop
  3. Enough products have filter to show in filter list (minimum threshold)
  4. Cache cleared (customer may see old shop version)
  5. Filter is assigned to correct product category/section

File Too Large Error

Solutions:

  1. Split CSV into smaller files (1,000 rows each)
  2. Upload in batches
  3. Process highest priority products first
  4. Contact administrator about file size limits

  • Filter Management - Create and configure filter types
  • Product Catalog - Manage individual products
  • Shop Settings - Configure how filters display to customers
  • Product Bulk Edit - Other bulk product update tools

Typical Workflow:

  1. Plan filter taxonomy in Filter Management
  2. Export product list from Product Catalog
  3. Prepare bulk upload CSV with filter assignments
  4. Upload via Shop Filter Bulk Upload
  5. Verify filters appear correctly on customer Shop
  6. Refine and update as needed

Permissions & Access

Required Access Level: Administrator or higher

Access Level Capabilities:

  • Administrator: Upload filters, create new filters via upload, modify all products
  • Kiva Admin: All features + access to advanced filter settings

Restricted Features:

  • Creating New Filters: May require specific permission
  • Bulk Filter Deletion: Requires Administrator confirmation

Best Practices

CSV Preparation

  1. Always start with template download
  2. Prepare data in Excel, export as CSV when ready
  3. Test with small file (10-20 rows) before large upload
  4. Keep backup of CSV file for reference
  5. Document filter assignments for future team members

Filter Taxonomy

  1. Plan consistent naming convention (e.g., "Contains [Allergen]" format)
  2. Use title case for consistency
  3. Avoid abbreviations customers won't understand
  4. Group related filters (all allergens use same pattern)
  5. Limit total number of filters (too many overwhelms customers)

Quality Control

  1. Review product filters on customer shop after upload
  2. Test filter functionality from customer perspective
  3. Verify accuracy of allergen and dietary claims
  4. Update filters as products or regulations change
  5. Audit filter assignments quarterly

Things to Avoid

  • Don't skip preview/verification step
  • Don't upload without backing up current state
  • Don't create redundant filters (check existing first)
  • Don't use filters for data that changes frequently
  • Don't make claims (organic, gluten-free) without verification

Quick Reference Card

Task Action/Location
Get CSV template Click "Download Template"
Upload filter CSV Select file, preview, process
Tag organic products Export SKUs, add "Organic" filter, upload
Remove wrong filters CSV with REMOVE action
Add dietary labels One row per product-filter combination
Test before big upload Upload 10-row test file first
Check results Review success count and error report
Fix errors Correct CSV and re-upload failed rows

FAQs

Can I update filters for products I didn't create?

Yes, with Administrator access, you can update filters on all products.

What happens if I upload a filter that doesn't exist?

Depends on system configuration. Some create the filter automatically, others return an error. Check with administrator.

Can I upload to remove all filters from products?

Yes, use REMOVE action for each filter, or use REPLACE action with empty filter name if supported.

How many products can I update at once?

Typically 1,000-5,000 per upload depending on system limits. Split large catalogs into batches.

Will this overwrite existing filters?

Depends on action: ADD adds to existing, REMOVE removes specific filter, REPLACE removes all and adds new ones.

Can I undo a bulk upload?

Not automatically. Keep backup CSV of previous state. To undo, upload REMOVE actions for all added filters.

Yes, in most systems filters improve search relevance and allow customer filtering in shop.

Can I schedule bulk uploads?

Not directly. Coordinate with technical administrator if automated recurring uploads needed.


Change Log

2026-03-01

  • Initial documentation created
  • All sections completed following template structure

End of Documentation

For additional help, contact your system administrator or Kiva Logic support.