View Shopify product price history

You can use Mixtable’s Cell History feature to see product price changes over time. Here’s how.

Load the Shopify product price column in the spreadsheet

In a workbook, create a worksheet that shows your Shopify Product data.

1. Find a column not yet set up to show Shopify data. Click on the Link button in the column header.
2. In the dialog that opens, select the Standard Data Field radio button option. A dropdown menu will appear, prompting you to choose the field you want to sync. Find and select the Price field. Now, click on the Save Column button.
3. You'll now see the column populate with any existing Price data.

Track product price history in a spreadsheet

Once the data has loaded, Mixtable will track all changes to the cells in this column, whether they are made by you in the spreadsheet or are changed via an update from Shopify.

• To view the price changes for a particular product/variant, find the cell containing the current price and open its cell history.
• To access the cell’s history, right-click on the cell and select the View Cell History menu option.
• A visual panel will open on the right of your screen, showing you all the changes to the cell over time.

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:

• Bulk add products to collections, edit metafields, add or remove tags;
• Change product prices, including international prices, and review price history;
• Manage customers with a spreadsheet CRM for Shopify;
• Use Excel features like sort ascending or descending, find-replace, filter, and more.

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