Fill Missing Worksheet Data

If rows are accidentally removed from a Shopify-linked worksheet, the Fill Missing Worksheet Data dialog lets you restore them. Mixtable compares your worksheet against your Shopify store data and adds back any rows that are no longer present, without touching the rows that are already there.

When to use this

Common situations where this helps:

• You accidentally removed one or more rows from the worksheet, for example by right-clicking a row number and choosing Remove row from sheet, and want to get that data back
• A bulk removal was wider than intended and took out records you still need
• You want to make sure your worksheet is complete and reflects everything currently in your Shopify store

How to use it

1. Open the worksheet you want to restore data to
2. Click the Shopify Sync menu in the menu bar
3. Select Fill Missing Worksheet Data
4. In the dialog that appears, click the Fill Missing Worksheet Data button to confirm

Mixtable queues the repopulation in the background. You will see a confirmation message and can keep working in your spreadsheet while the restore runs. Once complete, any rows that were missing will reappear in the worksheet.

What this does not do

• It does not overwrite or revert changes you have made to existing rows. Only rows that are completely missing are restored
• It does not undo edits to cells within rows that are still present
• It does not bring back items that were deleted in Shopify, including items deleted from Mixtable with an option such as Delete product in Shopify…. Fill Missing Worksheet Data copies what’s in your Shopify store now, and a deleted item is no longer there
• It does not remove empty rows left behind when Shopify objects are deleted or stop matching a Conditional Worksheet. To clean those up, click the Worksheet menu and select Remove Empty Rows