search

How to use the Mixtable sidebar to edit Shopify data

Mixtable’s workbook sidebar is a great tool for viewing and editing Shopify data. The sidebar can be shown/hidden by using the Sidebar toggle in the workbook menu at the top of your screen.

Shopify spreadsheet sidebar

Why use the sidebar?

  • The Mixtable spreadsheet sidebar is useful when you want to see an entire Shopify object, including fields that are not currently mapped to columns in your worksheet. This helps you view data on an ad-hoc basis as needed.
  • The sidebar also allows you to edit data within your Shopify objects.

How to show the sidebar?

To view data in the Sidebar, first toggle it to show. Then, click on a cell in your worksheet. The sidebar will automatically detect the row the cell is in and load the data for the appropriate object.

shopify spreadsheet data sidebar

What data can be edited via the sidebar?

For products, via the sidebar you can edit:

  • Product name,
  • Product description, incl. HTML via a WYSIWYG editor,
  • Product handle,
  • Tags,
  • Vendor,
  • Metafields,
  • Images, and more.


You're ready!

Mixtable is an online spreadsheet designed to sync data with Shopify. It looks, feels, and behaves like Excel (including formulas), but runs in your browser. With Mixtable you can:

Best of all, you can sync changes back to Shopify with a single click. Find out more about the Mixtable suite of products here.

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.