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

Need a functioning Shipping Weight Feed Rule

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

The recent addition of a limit for shipping weight values has cause a small segment of our products to have a status of disapproved because the shipping weight value for those products (provided via an ftp feed) is greater than the new maximum of 2,000 lb (or 1,999 lb). I have attempted to setup a feed rule that will change the shipping weight value for those products so they can display, but nothing I have tried works.

 

Is there a way to change the shipping weight value for specific products with a feed rule?

 

The rule I have setup that is not working is:

If <shipping weight> is <greater than or equal to> <2,000>

Set the value for 'shipping weight' to <0> <lb>

Else, preserve any value you may have submitted for 'shipping weight'

 

With this rule active products that have an original value for shipping weights greater than 2,000 lb are not being given a processed value of 0 (or any other arbitrary weight value above zero that I have used when testing to see if zero was the problem).

1 Expert replyverified_user
1 ACCEPTED SOLUTION

Accepted Solutions
Marked as Best Answer.
Solution
Accepted by topic author William P
July

Need a functioning Shipping Weight Feed Rule

Visitor ✭ ✭ ✭
# 5
Visitor ✭ ✭ ✭

I ended up creating a rule that works but is not ideal.  The feed rule looks for shipping_weight values that are greater than 2,000, but I know from earlier attempts that it won't actually identify any products that fit that criteria.  If any do qualify the rule is supposed to set the shipping_weight value to 0 lb.  I then use an else statement to remove the shipping_weight values from all remaining products we have submitted, which is all of our products.

 

If we didn't offer free shipping this would likely not work as a solution, but it works for now for the goal of having all of our products (even the + 2,000 lb products) promoted via a Google Shopping AdWords campaign.

View solution in original post

Re: Need a functioning Shipping Weight Feed Rule

[ Edited ]
Top Contributor
# 2
Top Contributor

(a) numeric feed-rules must be based on a numeric value --
a valid shipping_weight is a mixed-value and must contain both
a number and a unit, so is currently not eligible for left-hand-side

numeric feed-rule tests, only a right-hand-side set value and unit.

one possibility would be to add a custom-label attribute --
to tag such items as heavy, outliers, etc.; then, use the
custom-label in the feed-rule, for a non-numeric test.

 

or, use multiple, exact, mixed-unit text-value tests;

e.g. shipping_weight equals/contains 2222.22 kg

 

however, if used as described these would likely result in a policy violation.

 

shipping_weight must include both a number and google-supported unit and

must be exactly accurate for the physical item-offer being sold and shipped.

(b) shipping for an item must be either exactly accurate
or an overestimate, or the highest possible shipping cost

a user may pay, or is otherwise a policy violation.

generally, items heavier than the new shipping_weight limits are assumed
to be incorrect and must be fixed to reflect the exact weight of the offer --
otherwise, such item-offers should be removed from the submitted (feed)
data, altogether, to avoid continual disapproval or a suspension.

setting an improper shipping_weight value, per google's rules --
such as lower than the actual weight of the physical item-offer --

or any resulting shipping that does not conform to the policies --
are grounds for disapproval or suspension, at any time.

 

Need a functioning Shipping Weight Feed Rule

Visitor ✭ ✭ ✭
# 3
Visitor ✭ ✭ ✭

Ok, so the combo of weight and unit of measurement prevents the rule I setup from working. Shipping_weight is not a required field though, correct? 

 

Will a custom label in conjunction with a feed rule theoretically allow me to assign a blank/empty shipping_weight value to certain products?

 

We offer free shipping on all products, so shipping_weight does not affect any product costs or violate any rules as I understand them if left blank (I do understand that a value of zero could be considered a violation).  I would prefer to provide shipping_weight values for all products that weigh less than 2000 lb, but will remove all shipping_weight values if no other options are available.

Need a functioning Shipping Weight Feed Rule

Top Contributor
# 4
Top Contributor

(a) yes.

shipping_weight is optional for most use-cases; however, shipping_weight
is required if carrier-calculated or a weight-table, is set within the account.

(b) no.

custom_label_0 would allow the test -- not an invalid value.

if submitted or set, an item's shipping_weight must be exactly accurate.

feed-rules are mainly transformational -- such as replacing field-names,
replacing values, adding missing values, creating attributes and values,
and sometimes removing values as part of a compound expression;

currently, feed-rules cannot explicitly delete attributes or assign invalid

values, for attributes that google verifies when a feed-rule is applied.

simply be certain that shipping is exactly accurate or an overestimate --
and the item can be shipped in a timely manner, per google's shipping
and on hand, physical inventory, stock availability, rules and policies.

google's shipping_weight rules are mainly to help catch outliers that
cannot meet the inventory, shipping, or related delivery requirements --
otherwise, there are other campaign-types/ad-formats for advertising

certain types of items.

 

Marked as Best Answer.
Solution
Accepted by topic author William P
July

Need a functioning Shipping Weight Feed Rule

Visitor ✭ ✭ ✭
# 5
Visitor ✭ ✭ ✭

I ended up creating a rule that works but is not ideal.  The feed rule looks for shipping_weight values that are greater than 2,000, but I know from earlier attempts that it won't actually identify any products that fit that criteria.  If any do qualify the rule is supposed to set the shipping_weight value to 0 lb.  I then use an else statement to remove the shipping_weight values from all remaining products we have submitted, which is all of our products.

 

If we didn't offer free shipping this would likely not work as a solution, but it works for now for the goal of having all of our products (even the + 2,000 lb products) promoted via a Google Shopping AdWords campaign.