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:
- Product SKU or Product ID: Unique identifier for product
- Filter Name: Name of filter to apply (e.g., "Gluten-Free", "Organic", "Local")
- 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:
- Click "Download Template" button
- Template downloads to computer
- Open in Excel or Google Sheets
- Fill in product and filter information
- 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:
- Prepare CSV file with product and filter data
- Click "Upload CSV" button
- Select file from computer
- Review preview of first 10 rows
- Verify data looks correct
- Click "Process Upload" button
- Wait for processing (may take 30-60 seconds for large files)
- Review results and error report
- 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:
- Include new filter names in CSV
- System detects filter doesn't exist yet
- Automatically creates new filter
- Applies filter to specified products
- Review newly created filters in filter management
- 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:
- Export current product list with SKUs
- Filter in Excel to organic products only (by name, vendor, or certification)
- Create CSV with:
- Column 1: Product SKUs of all organic items
- Column 2: "Organic" for all rows
- Column 3: "ADD" for all rows
- Upload CSV
- Verify all organic products now show "Organic" filter on shop
- 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:
- Review product catalog and identify dietary attributes
- Create spreadsheet categorizing each product:
- Gluten-Free: Yes/No
- Dairy-Free: Yes/No
- Vegan: Yes/No
- Keto-Friendly: Yes/No
- Paleo: Yes/No
- Convert to bulk upload CSV format (one row per product-filter)
- Example:
SKU-001,Gluten-Free,ADD SKU-001,Vegan,ADD SKU-001,Paleo,ADD SKU-002,Keto-Friendly,ADD SKU-002,Dairy-Free,ADD - Upload and process
- 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:
- Identify all summer seasonal products
- Create CSV tagging them with "Summer" filter
- Upload CSV
- Create "Summer Favorites" shop category filtered by this tag
- Products automatically appear in summer collection
- When season ends, upload REMOVE action CSV to clear tags
Use Case 4: Allergen Labeling¶
Goal: Add "Contains" warnings for common allergens
Steps:
- Review products for allergen content
- Create comprehensive CSV with all allergen filters:
- Contains Dairy
- Contains Eggs
- Contains Tree Nuts
- Contains Peanuts
- Contains Soy
- Contains Wheat/Gluten
- Contains Shellfish
- Upload CSV
- Customers can now filter to avoid allergens
- 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:
- Identify products with wrong filter (e.g., "Gluten-Free" on wheat pasta)
- Create CSV with REMOVE action:
PASTA-WHEAT-01,Gluten-Free,REMOVE BREAD-WHEAT-05,Gluten-Free,REMOVE - Upload and process
- Verify incorrect filters removed
- Add correct filters if needed
Troubleshooting¶
Upload Fails with "Invalid CSV Format"¶
Solutions:
- Ensure file is saved as CSV (not Excel .xlsx)
- Check that all required columns are present
- Verify column headers match exactly (case-sensitive)
- Remove any blank rows or columns
- Check for special characters that may break CSV format
- Try exporting template and copying data into it
Some Products Not Updated¶
Check Error Report for:
- Invalid Product SKU: SKU doesn't exist in catalog
- Verify SKU spelling
- Check if product was deleted
- Use Product ID instead of SKU if available
- Filter Name Doesn't Exist: For systems requiring pre-created filters
- Create filter first in filter management
- Check spelling of filter name
- Permissions Error: Insufficient access to modify these products
- Contact administrator
Filters Created But Don't Show on Shop¶
Check:
- Filter is marked "Active" in filter management
- Filter display is enabled for customer shop
- Enough products have filter to show in filter list (minimum threshold)
- Cache cleared (customer may see old shop version)
- Filter is assigned to correct product category/section
File Too Large Error¶
Solutions:
- Split CSV into smaller files (1,000 rows each)
- Upload in batches
- Process highest priority products first
- Contact administrator about file size limits
Related Pages¶
- 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:
- Plan filter taxonomy in Filter Management
- Export product list from Product Catalog
- Prepare bulk upload CSV with filter assignments
- Upload via Shop Filter Bulk Upload
- Verify filters appear correctly on customer Shop
- 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¶
- Always start with template download
- Prepare data in Excel, export as CSV when ready
- Test with small file (10-20 rows) before large upload
- Keep backup of CSV file for reference
- Document filter assignments for future team members
Filter Taxonomy¶
- Plan consistent naming convention (e.g., "Contains [Allergen]" format)
- Use title case for consistency
- Avoid abbreviations customers won't understand
- Group related filters (all allergens use same pattern)
- Limit total number of filters (too many overwhelms customers)
Quality Control¶
- Review product filters on customer shop after upload
- Test filter functionality from customer perspective
- Verify accuracy of allergen and dietary claims
- Update filters as products or regulations change
- 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.
Do filters affect product search?¶
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.