Nov 23, 2015 - 01:38 PM
You are required to provide product id or spider url in order to run this update. If you go to products > export > export full feed you will end up with Product ID. If you updating your spreadsheet without product id, you can go to Products > Data Mapper > (on top menu) Parsing Tools > Merge CSV and merge the exported product id spreadsheet with your spreadsheet using the part # as the merging column. If you need a tutorial on this please request it via Skype
Once you have a spreadsheet that has all the required columns for the update, you can run the update. Note that besides the required columns, you should only add THOSE COLUMNS THAT YOU WANT TO UPDATE. DO NOT UPDATE THE WHOLE EXPORT as you might end up overwriting something that you were not intending to update.
Here is a link to all required columns for the update to work https://docs.google.com/spreadsheet/pub?key=0Aiv9QpDVbwf9dG5CcHQyQ2JQOFpYSmRCM0
Here is a sample spreadsheet that successfully changed the titles for another clienthttps://www.dropbox.com/s/tv1ej9g0r1xgh8l/merge.csv
(Note: Title updates will only be used for page title not search results. You need to update anchor text to update search result.
UPDATE: Please also see the answer on this link