Bulk upload price extensions

[Pascal]

Hi,

I'm currently working on a script to automatically setup and update price extensions. Creating price extensions is quite easy, but updating is a hassle since you can't edit price items, only remove them.

That's why I wanted to work with a bulk upload, which would not only be much easier but also faster. I've tried manually uploading price extensions through 'Business Data -> Price Extension Feed', which worked perfectly.

However, when I use AdsApp.bulkUpload() it won't upload the price extensions properly, most likely since it isn't using the default bulk upload interface while it should be using the feed upload interface.

Is there any way to update price extensions based on extension ID via Google Ads Scripts with bulk uploads? Thanks in advance.

[Google Ads Scripts Forum Advisor]

Hi Pascal,

Thanks for reaching out. Harry here, from the Google Ads Scripts Team.

I regret to inform you that price extensions are currently not supported through AdsApp.​BulkUploads; hence, why you are not able to batch upload price extensions properly. On the other hand, you may update price extensions using the setPriceQualifier and setPriceType among other methods.

Let me know if you would need anything else.

Thanks,

Harry Cliford Rivera Google Ads Scripts Team

ref:_00D1U1174p._5004Q2JC7Q0:ref

[Pascal]

Hi Harry,

Unfortunately I'm looking to update price items individually. Is this currently only possible by removing existing items and then adding new ones? Or is there any way to do a bulk upload for price extensions through the Google Ads API?

Would it be possible to add bulk upload functionality for price extensions to AdsApp.BulkUploads? I would really appreciate it if you could request this feature from your team. I feel this would be a very useful features for script users since price extensions change quite often and automating the uploading process could save a lot of time. Thanks!

[Google Ads Scripts Forum Advisor]

Hi Pascal,

Thanks for coming back. For Google Ads API questions, you can relay them to their team through the AdWords API and Google Ads API Forum instead as I can only provide insights in the Google Ads scripts' perspective.

On the other hand, yes, I absolutely can file a feature request for you, but can you kindly provide which price extensions attribute you would like to specifically update via the bulk upload function through scripts? I would appreciate it if you can provide screenshot showing the attribute.

Looking forward to your reply.

[Pascal]

Hi Harry,

I would like the functionality to bulk upload changes for price extensions based on the default Google Ads Bulk Upload Template for price extensions, as found here: https://support.google.com/google-ads/answer/10702525?hl=en#zippy=%2Cad-extensions.

I've tried to use this template with an additional column for the extension ID via the upload functionality in 'Business data -> Price extension feed', which worked perfectly. If this could be translated to the AdsApp.BulkUpload method that would be great. Hopefully this provides you with sufficient information. If not, please let me know. Thanks!

[Google Ads Scripts Forum Advisor]

Hi Pascal,

Thanks for explaining further. I have now filed the request on your behalf and as you would already know, all requests are not guaranteed to be supported anytime soon via scripts. I would recommend that you keep track of our blog instead in the meantime.

Let me know if there's anything else I can assist you with.

Regards,

[Pascal]

Thank you Harry. I will keep an eye out for future updates.

[Robin]

+1 this. I'm in the process of automating updating price items for products with prices that change daily due to exchange rates, and it's still running okay for now (in terms of execution time) at around 20 products, but I suspect that once I hit around a 100 price extensions, I'll be timing out and in need of something that runs multiple times a day and uses some form of administration. 

[Google Ads Scripts Forum Advisor]

Hi,

Thanks for providing your insights here. I have provided them in the feature request for further justification. Kindly follow our blog and release notes page for new updates and releases in the meantime.

Thanks,

[Deepak Thirumurugan]

Hi I am also looking to automate price extensions by reading data from sheets. It would also helpful if you could provide me with the script you are currently using for the same. 
Thanks in Advance!

[Google Ads Scripts Forum Advisor]

Hi Deepak,

I've responded to you in this thread.

Regards,

Teejay Wennie Google Ads Scripts Team

 

ref:_00D1U1174p._5004Q2JC7Q0:ref