The Shopify Data Guide

by mixtable

Shopify Sub Collections: Create and Manage
June 7, 2025
Shopify Sub Collections: Create and Manage
Shopify supports only one level of collections, and there are no official sub-levels of collections. Still, there are ways to present collections as subsets of other collections in menus and collection pages.
6 Shopify Product Description Improvements for SEO
May 7, 2025
6 Shopify Product Description Improvements for SEO
Pay special attention to the Product Titles; Make the product descriptions unique; Long-tail niche keywords; Alt tags; Metafields;
Excel Formulas For Your Shopify Store
February 28, 2025
Excel Formulas For Your Shopify Store
Use these formulas to manage your Shopify store data: COUNTIF, CONCAT, SUMIF, VLOOKUP, IF, AVERAGEIF, MAX/MIN
9 Product Bulk Editing Use Cases for Shopify
February 4, 2025
9 Product Bulk Editing Use Cases for Shopify
Bulk editing products in a collection. Mass-edit product prices. Bulk edit profit margins. Bulk editing variable prices
Shopify Dynamic Price
January 29, 2025
Shopify Dynamic Price
How to setup dynamic product pricing in Shopify?
How to Use Shopify Metafields for SEO
January 16, 2025
How to Use Shopify Metafields for SEO
Use Shopify metafields to include additional product information on your PDPs, attract more customers and rank better in the search results
How to Prepare Sale Campaigns in Shopify with a Spreadsheet App
January 13, 2025
How to Prepare Sale Campaigns in Shopify with a Spreadsheet App
Change prices in Shopify with a bulk editing spreadsheet app - filter products by tags, metafields or collections, discount prices by percentage or formula, use current price as Compare at price
Shopify Data Hacks You Can Do With a Spreadsheet App
October 17, 2024
Shopify Data Hacks You Can Do With a Spreadsheet App
Find and replace, copy and paste, change prices with formulas all with a Spreadsheet app for Shopify. Check how you can manage Product Updates, Metafields, Price, incl. Compare At price, Tags, Blogs
5 Proven Strategies to Boost Your Shopify Store's Conversion Rate and Drive More Sales
September 27, 2024
5 Proven Strategies to Boost Your Shopify Store's Conversion Rate and Drive More Sales
Optimize Your Store's User Experience. Implement Persuasive Elements. Use Metafields to Add Extra Product Information. Offer Multiple Payment Options. Utilize Abandoned Cart Recovery
Shopify Analytics for the 2024 Holiday Season
September 20, 2024
Shopify Analytics for the 2024 Holiday Season
Top products, trending products, most profitable products, top collections, stale inventory,
Effective Marketing Tactics for Shopify Stores [Updates for 2024 Holiday Season]
September 17, 2024
Effective Marketing Tactics for Shopify Stores [Updates for 2024 Holiday Season]
Start early by growing your email list. Personalize your campaigns with Shopify Segments. Test different strategies with Shopify Automation. Get ready with Countdown Sale, Limited-Time Offers, and Holiday Special tags:
Things That Go Wrong When Managing a Shopify Store With A Large Number Of Products – Challenges And Solutions
September 1, 2024
Things That Go Wrong When Managing a Shopify Store With A Large Number Of Products – Challenges And Solutions
5 Things That Go Wrong when Managing a Shopify Store with a Large Number of Products – Challenges and Solutions
4 Ways to Beat Temu in Their Own Game - Strategies for Shopify Merchants
July 9, 2024
4 Ways to Beat Temu in Their Own Game - Strategies for Shopify Merchants
Strategies to counteract Temu’s low prices, aggressive advertising, gamified shopping experience and consumer-to-manufacturer model
Mixtable is an online spreadsheet, designed from the ground up to bulk edit and analyze Shopify data.

Got a question? We're here to help! Reach out at [email protected], and we'll get back to you promptly.