Shopify Product Change History

One of the cool features that differentiate Mixtable from traditional Excel workbooks is that Mixtable tracks changes for each cell. When a cell’s content is changed by either a Mixtable user, or by new data syncing from Shopify, the changes in a cell’s history are recorded and can be accessed by you. As your product information evolves, this allows you to see granular changes for each field of a product over time, and who made the change. There are two ways to access product history in Mixtable:

• Change history for a specific field - This view shows you the changes to a specific product field over time (e.g., price and product name). This is accomplished via the View Cell History feature.
• Change history for the entire product - This view shows you the changes to all product fields that you have mapped into your product worksheet. This is accomplished via the View Row History feature.

View Product changes via Row History

Viewing a Row’s History will allow you to see the changes to all cells in the given row over time. This feature allows you to see the edit history of your product for the fields that you’ve mapped into your worksheet, all in one place.

Step 1: Sync Shopify products to Mixtable spreadsheet editor

Once you install and open the Mixtable workbook (spreadsheet), you can add a new Worksheet that is integrated with your Shopify product data.

Click the + sign to add a new worksheet and choose to create one that is integrated with Shopify data.

Step 2: View Product Change History

Find the row in your products’ worksheet that holds the data for the product whose history you’d like to see. Right-click on the row header and select the View Row History menu option. A visual panel will open on the right of your screen, showing you all the changes to the row’s cells over time.

View Product field changes via Cell History

Viewing a Cell’s History will allow you to see the changes to a cell over time. So, to view the changes to a particular field for a particular product find the cell that displays the relevant data.

View Product Field History

To access a cell’s history, simply 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.

In the example below we are able to see how the tags for a specific product have changed.

You can see how to check Shopify Product price history here.