AdWords
2.2K members online now
2.2K members online now
For questions related to Google Shopping and Merchant Center. Learn to optimize your Shopping ads
Guide Me
star_border
Reply

How to add insurance rate to carrier rate for products in feed?

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

The webstore I am creating a feed for calculates shipping by adding the UPS carrier rate (which factors weight, length, width, height) + the UPS insurance rate (which is .009 of the declared value of the item).

At the account level, I figured out how to calculate the UPS carrier rate. How do I add the insurance fee (.009 of the item price) to the carrier rate?

For example, if the UPS ground carrier rate calculates shipping at $16.52 and the item price is $1,561.08, I need to be able to add $14.40 (which is .009 of 1561.08) to the shipping cost for a total shipping cost of $30.92.

1 Expert replyverified_user
1 ACCEPTED SOLUTION

Accepted Solutions
Marked as Best Answer.
Solution
Accepted by topic author Christopher B
October 2016

How to add insurance rate to carrier rate for products in feed?

Visitor ✭ ✭ ✭
# 3
Visitor ✭ ✭ ✭

Thank you for the reply. The problem with adding a .9% adjustment is that it calculates this based on the shipping cost (carrier rate) and not on the actual price of the item, which is how UPS' insurance works (at least what we use). 

 

Based on the other information you have given, I am going to need to simply overestimate the shipping by a lot. Because our products can vary in price rather drastically, if I double the price of the carrier rate (making a price adjustment of 200%), I will be sure to get approved. Hoping the user simply clicks on the ad and goes to our landing page, and doesn't see the shipping prices through Google Shopping.

 

View solution in original post

Re: How to add insurance rate to carrier rate for products in feed?

[ Edited ]
Top Contributor
# 2
Top Contributor

simply add 0.9 as a percentage adjustment.

 

carrier-calculated-rate settings within the merchant-center-account

allow for either a percentage or a dollar-amount rate-adjustment.

 

the shipping_label attribute may also be used for outliers to
help assign specific settings or adjustments outside the norm.

 

note that google requires shipping to be
either exactly accurate or an overestimate.

 

also, be certain that all shipping_weight, shipping_length, shipping_width,
and shipping_height, values are both accurate and valid for each item --

a valid value should include a number, space, and google-supported unit;
e.g
123.45 kg

 

also importantly, always verify the calculated and assigned shipping value, by
clicking on an item's title within the products-list tab of the merchant-center.

 

see also

https://support.google.com/merchants/answer/188494#shipping_weight

https://support.google.com/merchants/answer/188494#shipping_label

https://support.google.com/merchants/answer/6069284

https://support.google.com/merchants/answer/160162

 

Marked as Best Answer.
Solution
Accepted by topic author Christopher B
October 2016

How to add insurance rate to carrier rate for products in feed?

Visitor ✭ ✭ ✭
# 3
Visitor ✭ ✭ ✭

Thank you for the reply. The problem with adding a .9% adjustment is that it calculates this based on the shipping cost (carrier rate) and not on the actual price of the item, which is how UPS' insurance works (at least what we use). 

 

Based on the other information you have given, I am going to need to simply overestimate the shipping by a lot. Because our products can vary in price rather drastically, if I double the price of the carrier rate (making a price adjustment of 200%), I will be sure to get approved. Hoping the user simply clicks on the ad and goes to our landing page, and doesn't see the shipping prices through Google Shopping.

 

Re: How to add insurance rate to carrier rate for products in feed?

[ Edited ]
Top Contributor
# 4
Top Contributor

first, thank you for the clarification.

 

one possibility would be to use a shipping_label to put sets of items
into buckets and then apply an adjustment to (price) ranges of items,
so that the overestimates are somewhat limited.

 

if the tax is always applied, and there are no other shipping options,
another slight alternative would be to add the percentage to the price
of the item -- and make that the submitted and landing-page price.

 

regardless, if a %200 overestimate is assigned google may indeed use that
value within shopping-ads and may effect click-through-rates and quality --
that is, users will be able see tax and shipping prices on google-shopping,
depending on the context of the ad.