Shopify Catalog Operations & Automation

CSV builds, bulk updates, metafields, filters, and inventory automations.

Overview

This case study demonstrates end-to-end Shopify catalog operations in a live store: product and variant setup, admin enrichment, and scalable bulk updates using CSV exports and re-imports. It includes metafields used for storefront filtering, rule-based smart collections, Search & Discovery configuration (faceted filters and product recommendations), and automations that keep low-stock and out-of-stock tagging accurate. The goal is clean, repeatable workflows that reduce manual upkeep and keep storefront merchandising signals reliable.

Sections

1. Catalog Setup and Enrichment

This section covers the foundation of the Shopify catalog. Products were first structured in a CSV and imported, then enriched in the Shopify admin with consistent attributes, variant options, and standardized categories. Every detail—from taxonomy choices to SEO metadata—was set up to support data consistency, search visibility, and automation-ready workflows.

1a. Catalog Import File

Source CSV used to create products and variants with clean option sets, handles, SKUs, and categories.

Download Source File

1b. All Products List

Products created from the CSV are live, consistently named, categorized, and published to sales channels.

1c. Inventory View

Inventory view confirming each variant has a unique SKU and tracked on-hand quantity.

1d. Product Admin Page

One product shown end-to-end: title, description, images, variant options, pricing, category, metafields, and search details.

1e. Smart Collection Rules

Rule-based collection setup that groups items by tag for automatic organization and clean collection URLs.

2. Automated Inventory Tagging and Merchandising Rules

To reduce manual catalog upkeep, I built automations that apply and clear inventory-status tags in real time. These automations keep product status labels accurate, surface low-stock items for action, and remove products from promotional collections once they sell out. This supports a cleaner customer experience and faster, data-driven merchandising decisions.

2a. Low-Stock Tag Automation

Monitors variant inventory and tags products as low-stock when quantity drops to five or fewer units. Sends an internal alert and applies a temporary notified-low-stock tag that clears after 24 hours to prevent duplicate notifications. This keeps catalog signals and internal actions aligned without manual checks.

2b. Out-of-Stock Handling

When a variant reaches zero inventory, applies an out-of-stock tag, removes the item from the Last Pieces collection, and clears any low-stock tags. This ensures sold-out products are labeled immediately and removed from last-chance merchandising as soon as they run out.

2c. Restock Tag Cleanup

When inventory rises above the low-stock threshold, automatically removes low-stock and out-of-stock tags and removes the product from Last Pieces. This prevents items from staying incorrectly flagged and keeps availability signals accurate site-wide.

3. Bulk Product CSV Build and Import

I built a new product (Oversized V-Neck T-Shirt) and its variants in a CSV using Shopify’s sample import template, then imported it into Shopify. After import, I enriched the product with categories, tags, images, and SEO fields, verified variant data and inventory, and published it. This section shows clean data structure, accurate variant creation, and a storefront-ready result from a spreadsheet build.

3a. Shopify Product CSV

Shopify-formatted CSV defining product title, variant rows, SKUs, pricing, and inventory fields for accurate bulk upload and scalable updates.

Download Import File

3b. Import Preview

Import preview confirming fields, variants, and pricing before publishing.

3c. Draft Admin View After Import

Product created as a draft with images, options, and a seeded variant grid from the CSV.

3d. Final Admin View

Completed setup with variants, pricing, inventory, category mapping, tags, and SEO metadata.

3e. Storefront View

Published product on the storefront with correct variant selection, pricing display, and imagery.

4. Bulk Variant Price Update via CSV Export and Re-Import

Pricing updates often need to be applied across multiple variants at once. This example demonstrates the scalable CSV method: export current variant rows, update only the price and compare-at price fields, then re-import the file. Linen variants were reduced from $69.99 to $64.99 and new compare-at pricing was added, preserving SKU integrity and enabling a controlled, reversible update at scale.

4a. Edited CSV for Price Update

Exported variant file with only price and compare-at price updated, while preserving SKUs, options, and inventory columns to avoid overwrites.

4b. Storefront Before View

Product page before update, showing original price.

4c. Storefront After View

Storefront after import showing updated pricing and the compare-at strike-through value.

4d. Audit Check

Spot-check confirming compare-at pricing populated correctly for linen variants only.

5. Bulk Inventory Update via CSV Export and Re-Import

This section updates inventory in bulk by exporting live variant stock levels, editing the On hand (new) field in the inventory CSV, and re-importing the updated file. It shows scalable, auditable control over stock accuracy without manual variant edits in the Shopify admin.

5a. Admin View — Inventory Before Update

Inventory view before the update. Selected variants show On hand = 50 across sizes and materials.

5b. CSV File — Inventory Update

Exported inventory file with On hand (new) updated to 120, while preserving SKUs and handles to avoid mismatches.

5c. Admin View — Inventory After Update

Inventory after import. Linen variants now show On hand = 120, confirming a clean update.

6. Site Filters & Product Recommendations (Search & Discovery)

To support product discovery, I configured Shopify’s Search & Discovery app. I connected the Fabric metafield to storefront filters, confirmed values, and published faceted filtering on the collection page. I also set up complementary and related product recommendations on the product page to support cross-sell paths. The result is clear material-based filtering and product recommendations that scale as the catalog expands.

6a. Admin View — Filter Setup

Filter built from the Fabric metafield. Cotton, Linen, and Wool surfaced as selectable values with OR logic.

6b. Frontend Filter Display

Shopper-facing Fabric filter active on the collection page for material-based narrowing.

6c. Admin View — Product Recommendations

Recommendations configured for the Oversized V-Neck: skirt set as complementary; tops and dresses mapped as related items.

6d. Frontend PDP Product Recommendations

Recommendations displayed on the PDP (Product Detail Page) to support cross-sell behavior.

Conclusion

This case study shows end-to-end control of a Shopify catalog from spreadsheet build to live merchandising. Products were structured in CSV files, imported cleanly, enriched with metadata, and verified in the Shopify admin and storefront. Price and inventory updates were executed through exports and controlled CSV edits. Automations handled low-stock, out-of-stock, and restock tagging without manual intervention. Filters and product recommendations were configured to support product discovery and cross-sell behavior.

The result is a scalable catalog setup with reliable automations, efficient merch workflows, and a storefront experience built on accurate data.