How do I bulk edit Microsoft Advertising related product fields? (BPE)
All Microsoft Advertising App fields are product metafields.
This table shows each field's namespace and key. They can all be edited in the Bulk Product Edit app.
| Field: | Namespace: | Key: | Value: |
| This is a custom product | msft_bingads | custom_product | true or false |
| Google product category | msft_bingads | bing_product_category | |
| Age | msft_bingads | age_group | newborn, infant, toddler, kids, adult |
| Gender | msft_bingads | gender | male, female, unisex |
| Condition | msft_bingads | condition | new, refurbished, used |
| Color | msft_bingads | color | |
| Material | msft_bingads | material | |
| Size | msft_bingads | size | |
| Size system | msft_bingads | size_system | AU, BR, CN, DE, EU, FR.... |
| Size type | msft_bingads | size_type | regular, petite, plus, big and tall, |
| Brand | msft_bingads | brand | |
| Manufacturer part number | msft_bingads | mpn | |
| Custom Label 0 | msft_bingads | custom_label_0 | |
| Custom Label 1 | msft_bingads | custom_label_1 | |
| Custom Label 2 | msft_bingads | custom_label_2 | |
| Custom Label 3 | msft_bingads | custom_label_3 | |
| Custom Label 4 | msft_bingads | custom_label_4 |
Method #1: Filter based bulk edit
Take Color for example:
Method #2: CSV file based bulk edit
Steps to edit Google Shopping Attributes:
- Select the column of your spreadsheet containing the attribute you wish to edit
- Select Product Metafield from the list of parameters to update
- Specify the Microsoft Bing Shopping Attribute using the format: namespace.key
Example:
To edit the age_group attribute, you would write: msft-bingads.age_group
To edit the gender attribute, you would write: msft-bingads.gender
The screenshot below provides an example of how to edit these two fields.
