To help make management easier, Google has added bulk uploads for Shopping Campaigns to AdWords. You can make mass changes to Shopping campaigns’ product groups, bids, tracking templates and custom parameters with bulk uploads.
To get started, from the Product Groups tab in Adwords, select all the columns you want in your report (you cannot use segments). Then click the download button.
Save a copy of the original in case you need to go back to the original setup. Then make your changes in another copy of the exported document (saved as a .xlsx, .tsv or .csv file). Each product group is shown on a separate row with a partition type and the path of subdivisions in that product group.
Google says, “For tracking templates and custom parameters, you can make changes to all product groups that aren’t subdivided, except for those marked Excluded.” Below is a breakdown of the ways product groups are divided in a bulk export.
Once the changes are all made, upload the spreadsheet back into your account to have them automatically applied.
For more details on using bulk uploads for Shopping campaigns, check out the support page here.