shopify-matrixify

Solid

Use when a store owner is doing bulk data work through the Matrixify (formerly Excelify) app: bulk import/export, "migrate my catalog", "bulk update prices", "bulk edit metafields", CSV or Excel import, "my import deleted my metafields", "my import wiped my tags", MERGE vs REPLACE vs UPDATE, "how do I undo an import", building a Matrixify sheet by hand or programmatically, or a data migration between stores/platforms. Covers products, variants, metafields, collections, redirects, customers, and menus. Not for minting category (taxonomy) metafields, which Matrixify cannot do (use shopify-category-taxonomy); not for one-off single-record edits via the Admin API (use the relevant entity skill).

Data & Documents 46 stars 2 forks Updated 2 weeks ago MIT

Install

View on GitHub

Quality Score: 84/100

Stars 20%
56
Recency 20%
90
Frontmatter 20%
70
Documentation 15%
100
Issue Health 10%
80
License 10%
100
Description 5%
100

Skill Content

# Shopify Matrixify The bulk-data workhorse of the catalog-cleanup suite. Matrixify moves store data in and out as spreadsheets, so it is how you touch thousands of records at once instead of one at a time in the admin. Almost every destructive mistake here comes from one of two misunderstandings: what a *blank cell* means, and what *omitting a row* means. Internalize the safety doctrine below before you touch a production catalog. Canonical docs: [matrixify.app/documentation](https://matrixify.app/documentation/). This skill is the operational playbook the docs don't spell out. ## Store access Matrixify runs inside the store, not through the Admin API. You do the work in two places: - **The Matrixify app** (Shopify admin → Apps → Matrixify): run Export to pull a sheet, run Import to push one. Every import shows an **Analyze** preview and, after it runs, an **Import Results** file. - **A spreadsheet** you edit locally (Excel or any CSV editor) or generate with throwaway code. No token lives in this skill. To verify a write landed, re-export the affected records and inspect the cells, or read them back through the Admin API: the storefront is CDN-cached and lies about freshness. ## Safety doctrine Read this section twice. Every rule here was learned by someone breaking a live store. 1. **Back up first: the export IS the backup.** Before any bulk write, run a full export of the entity you're about to touch (Products, Collections, etc.) and save the file. If...

Details

Author
kgelster
Repository
kgelster/awesome-ecom-skills
Created
2 months ago
Last Updated
2 weeks ago
Language
Shell
License
MIT

Integrates with

Bundled in these plugins

Similar Skills

Semantically similar based on skill content — not just same category

Data & Documents Solid

shopify-category-taxonomy

Use when you assign the Shopify Standard Product Taxonomy category, "set the product category", "categorize the catalog", or fill the category / taxonomy metafields: the admin "Category metafields" panel (Color, Size, Material, Caffeine content), a.k.a. product category attributes / taxonomy attributes, including the attributes a Google feed asks for. Covers bulk classification, discovering a category's attributes and allowed values, minting the reserved value metaobjects, and writing them safely. Also: "category metafields show blank/null", "my Color attribute won't save". Not for bulk CSV data loads (Matrixify can't do this; see shopify-matrixify for bulk data).

46 Updated 2 weeks ago
kgelster
Data & Documents Solid

shopify-catalog-cleanup

Use when fixing the debris an audit found in a Shopify catalog: bulk-archive dead/discontinued/zero-inventory products, clean up catalog debris, kill ghost review stars (empty star ratings a theme still renders after a review app was uninstalled), remove orphaned metafields left by an uninstalled app, strip HTML artifacts from product descriptions (double-nested bold, fully-bold paragraphs, empty tags), or fix messed-up / mangled product descriptions in bulk. Mutating cleanup work: archive vs delete, metafieldsDelete, description rewrites. Not for FINDING what's wrong (use shopify-catalog-audit) or filling missing metadata like SEO titles and alt text (use shopify-seo-metadata).

46 Updated 2 weeks ago
kgelster
Data & Documents Solid

shopify-catalog-audit

Use when someone wants to find product-data problems across a Shopify catalog: "audit my catalog", "find PDP problems", "which products have missing photos / thin or missing descriptions / pricing anomalies", "$0 or compare-at-inverted prices", "products missing type or vendor", "catalog quality sweep", "product data health check", "which listings are broken", "run a catalog audit before a big sale". Read-only: it locates and ranks problems, it does not change anything. Not for FIXING the problems it finds (use shopify-catalog-cleanup for debris/archiving, shopify-seo-metadata for missing SEO meta, shopify-alt-text for missing image alt text).

46 Updated 2 weeks ago
kgelster