Shopping campaigns. Automatically add new products

[Александр Великий]

Hi,

This question was asked several times before but I'm not sure that the answer is complete.

I have a shopping campaign with one ad group. In this ad groups I have to following structure of product groups:

All procducts

-- Brand 1

-- -- Product ID 1

-- -- Product ID 2

...

-- -- Product ID n

-- Brand 2

-- -- Product ID 1

-- -- Product ID 2

...

-- -- Product ID p

-- Brand 3

...

As new products are added to feed frequently, I'd like the script to automatically add new product id values under brands. So for example, if new product with id 777 and brand "Brand 2" is added to feed, I'd like it to be added like this:

-- Brand 1

-- -- Product ID 1

-- -- Product ID 2

...

-- -- Product ID n

--Brand 2

-- -- Product ID 1

-- -- Product ID 2

...

-- -- Product ID p

-- -- Product ID 777

-- Brand 3

...

What is the simplest way to accomplish this?

[Michael Cloonan]

Hello,

It will be a combination of these two code samples:

• Modify this example (https://developers.google.com/adwords/scripts/docs/examples/shopping#traverses-the-product-group-hierarchy) to fetch the correct ProductGroup node that you want to add a value to.
  
• See how this example (https://developers.google.com/adwords/scripts/docs/examples/shopping#create-a-shopping-product-group-hierarchy) adds a new child to the ProductGroup and emulate that.

Regards,

Mike, AdWords Scripts Team

[Александр Великий]

Hi, Michael. Thank you for response. Sorry, that I didn't make my question more clear. I know how to add new children to ProductGroup nodes. What I don't know is how to get the ids products that are missing. When you try to edit parent node from adwords interface you can do this with one button click. I'm trying to do similar thing with the script.

[Michael Cloonan]

Hello,

Sorry for the delay in responding. I was talking to a colleague who knows more about shopping specifically to see if he can provide any insights.

I don't think there exists a canonical full list in AdWords scripts that would let you know all product IDs.

There is a sample script for the ShoppingContent API, which you can enable for scripts, that fetches all product IDs which you may want to take a look at using: https://developers.google.com/apps-script/advanced/shopping-content.js

Take a look at this guide for more details on working with advanced APIs (like ShoppingContent): https://developers.google.com/adwords/scripts/docs/features/advanced-apis

You can use a list of product IDs generated from that in conjunction with walking the hierarchy looking for nodes that are missing certain product IDs.

Regards,

Mike, AdWords Scripts Team

[Александр Великий]

Thank you, Michael. I've just started to think about same solution. 

I'd like to suggest following feature to add to AdWords Scripts in future versions, that could be useful. 

To be able to get product ids, categories, brands etc. for each ProductGroup object. 

This is what I see in AdWords interface. When I try to edit ProductGroup node, I can see list of all possible child nodes.