Skipping Unchanged Rows on Spreadsheets
During any spreadsheet processing, Ablestar Bulk Product Editor will go through each product and call the Shopify API to update those products. Depending on the number of products and fields being modified, this can take a while.
Since our app has a copy of the Shopify product catalog in the database, we found it possible to skip any rows in the spreadsheet that are unchanged, while capturing and processing any new data more quickly.
This should significantly speed up edits where most of the values aren't different.
To skip unchanged rows:
- Click on Spreadsheet edit on the left menu and upload your spreadsheet
- From the 'Configure modifications' view, click on the 'Advanced options' link and select Skip unchanged rows
- Optionally: you could also click the Filter by vendor button to further limit the data being processed
- Once your data is mapped, filtered and confirmed, click on Run edit
Once Processing status is complete, a count of the rows processed and rows skipped will appear alongside your other upload information:
Click the Undo button if you need to start over and learn how to find a History of bulk edits.
✅ Tips and Troubleshooting
- A row will only be skipped if all values (including case) in the row are the same as what is currently in the Shopify database.
- The system is case-sensitive and will consider anything with a different case as changed data (ie 'TEST PRODUCT' or 'test product')
- Undoing bulk edits if you make a mistake is easy!
(03.228)