Shopify Data Hacks You Can Do With a Spreadsheet App

Using a spreadsheet app to manage your Shopify data is a blessing. In a spreadsheet view, you see everything—from the product title and descriptions to inventory, tags, and metafields to prices and orders. You can find and replace, delete, edit, or copy-paste.

Here we’ve listed five hacks you should try for your Shopify store with a spreadsheet app:

Product Updates

Once you install the Mixtable spreadsheet app, you can sync your product data, which will appear in an Excel-like format.

You can view all products and variants from the Products - Complete (with Variants) worksheet and do whatever edits you need:

• Change product titles

• Find and replace specific word

• Improve the SEO titles

• Add tags and meta objects, etc.

• Update product status

• NEW: Add analytics per product (or product variant), such as:

  • number of orders
  • gross/net sales
  • refunds
  • discounts, etc.

From the Shopify admin, you would need to click on every single product variant to make an edit. Here, you have everything in front of you.

The best part is that all the changes sync back to Shopify seamlessly.

For more information, check the articles on product description edits and how to set product cost per item.

Metafields

Managing metafields with a spreadsheet is like a dream come true. If you want anything changed or updated within your metafields, using the Mixtable app will save you literally hours of work.

With the Mixtable spreadsheet app, you can edit

• Metafields with preset choices/list of values
• Product Reference metafields
• Variant reference metafields
• Page reference metafields

Copy-pastе, find-replace, and any other shortcuts you are used to from working with Google Sheets would work. You can find detailed instructions on how to edit metafields here.

Price, incl. Compare At Price

Price changes can be done quickly with the Mixtable spreadsheet app in Shopify, especially with the Bulk Number updater feature. You can

• Add and Subtract
• Increase or Decrease by percentage (%)
• Multiply or Divide

Most importantly, you can manage the Compare At prices for different markets, something that cannot be done via Shopify admin.

Tags

Tags are essential for managing categories in Shopify and enabling users to find your products through filters.

Adding, deleting, or editing tags can be done efficiently through Mixtable’s spreadsheet functionality. More info on editing Shopify tags

Blogs

If you are investing in content marketing and want to attract organic traffic to your store, you will enjoy this capability! With the Mixtable spreadsheet, you can edit blog posts’ titles and meta descriptions, and you even have WYSIWYG capabilities to edit your content within the spreadsheet.

1. You need to populate the blog posts into a worksheet
2. Select the row of the blog post you wish to edit
3. Open the Mixtable spreadsheet’s sidebar. It will show all editable fields and load a rich-text editor for the blog post content.

Check the article on how to manage blog posts in Shopify here.