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

Example feed for bundled products

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

This is in response to this post about how to sell sunglasses with a legitimate UPC which we have modified. We start with a pair of designer Kate Spade sunglasses (UPC: 716737437117) and we take out the original sunglass lenses and replace them with magnified and tinted lenses with powers between +1.00 and +4.00 going up in increments of 0.25. However I did not see any examples as to how bundles should be set up.

 

Reading Google's Data feed specification > Product Variant Info > Digital Camera's it looks like I should be adding the "bundle" property to the "section-name" column.

 

However the Sept 30, 2014 Google Product Feed Specification Update says to use the "is_bundle" attribute.

 

Which was correct, and which was the dated answer and were there any examples of how to set up the bundles? I take it each bundle should have it's own individual parent which describes the custom product and one child bundle with the actual lenses provided listed so that it's understood this UPC comes with different lenses than the original UPC.

1 Expert replyverified_user
1 ACCEPTED SOLUTION

Accepted Solutions
Marked as Best Answer.
Solution
Accepted by MosheTLV (Top Contributor)
September 2015

Re: Example feed for bundled products

[ Edited ]
Top Contributor
# 3
Top Contributor


product bundles and variants are two separate policies
and have two separate sets of rules and requirements.

(1) as to bundles -- the proper attribute is is_bundle

there is no such attribute as bundles or bundle --
these were mainly descriptive terms used to help explain
the rules and details concerning the attribute is_bundle

is_bundle is simply TRUE or FALSE depending on -- if the main
item-offer is being sold together with another product, or not.

for example, a frame sold alone, is_bundle would be FALSE
but, a frame bundled with a lens is_bundle would be TRUE

if an item-offer has is_bundle set to TRUE then,
the global-trade-data must be for the main-item
within the bundle -- for example, the frame.

there is no such concept of a customized-upc;
the gtin (upc value) must be directly from the
manufacturer for the exact item being sold --
in this example, the frame and only the frame.

 

for this specific example:
is_bundle is regardless of any lens-power --
is_bundle is simply if the lens is bundled
together with the frame, or not.

(2) as to variants (item groupings) --

generally, variant items (item-groupings) require a proper,
identical, item_group_id value and at least one unique variant
attribute and value -- for all items within a variant-group.

variant attributes are size, color, material, pattern

for example, the same frame sold in different colors and different lens-powers.

for example, a frame sold in red with a lens might have the attributes:

id,color,size,item_group_id,is_bundle
usframe1r1p1,red,+1.00 power,frame1,TRUE
usframe1r1p2,red,+2.00 power,frame1,TRUE
usframe1r1p3,red,+3.00 power,frame1,TRUE

 

the frame without the lenses:

usframe1r1p0,red,,,FALSE

global-trade-data does not change for variants
unless the original manufacturer has a separate
set of global-trade-data for the specific variant --
for example, the manufacturer might typically
have different global-trade-data for a red or blue
frame but not for different size (power) lenses.

merchants cannot self-assign, modify, or alter,
global-trade-data (mpn, gtin, brand) values --
only the manufacturer can assign such values.

one example of item-groupings (variants) is currently here:
https://support.google.com/merchants/answer/1347943

 
attributes for a tab-delimited (spreadsheet)
feed is simply the first-row, column, names.

that said, google is the final arbiter of all rules and policies.

View solution in original post

Re: Example feed for bundled products

[ Edited ]
Visitor ✭ ✭ ✭
# 2
Visitor ✭ ✭ ✭

Also if I do have a bundle with a parent being the customized UPC and the child being the lenses we were installing did there need to be two separate lines?

If so then the "id" columns should be unique, the "item group id" on the parent and child should match, the title of the parent should reflect the entire bundle, the title of the child should reflect only the lenses, but what about the other columns? Or was I approaching this all wrong?

 

I was able to verify my parent and child product setup on a test feed but it looks like I am unable to have $0.00 bundle, this was not an add-on that we charged for.

Marked as Best Answer.
Solution
Accepted by MosheTLV (Top Contributor)
September 2015

Re: Example feed for bundled products

[ Edited ]
Top Contributor
# 3
Top Contributor


product bundles and variants are two separate policies
and have two separate sets of rules and requirements.

(1) as to bundles -- the proper attribute is is_bundle

there is no such attribute as bundles or bundle --
these were mainly descriptive terms used to help explain
the rules and details concerning the attribute is_bundle

is_bundle is simply TRUE or FALSE depending on -- if the main
item-offer is being sold together with another product, or not.

for example, a frame sold alone, is_bundle would be FALSE
but, a frame bundled with a lens is_bundle would be TRUE

if an item-offer has is_bundle set to TRUE then,
the global-trade-data must be for the main-item
within the bundle -- for example, the frame.

there is no such concept of a customized-upc;
the gtin (upc value) must be directly from the
manufacturer for the exact item being sold --
in this example, the frame and only the frame.

 

for this specific example:
is_bundle is regardless of any lens-power --
is_bundle is simply if the lens is bundled
together with the frame, or not.

(2) as to variants (item groupings) --

generally, variant items (item-groupings) require a proper,
identical, item_group_id value and at least one unique variant
attribute and value -- for all items within a variant-group.

variant attributes are size, color, material, pattern

for example, the same frame sold in different colors and different lens-powers.

for example, a frame sold in red with a lens might have the attributes:

id,color,size,item_group_id,is_bundle
usframe1r1p1,red,+1.00 power,frame1,TRUE
usframe1r1p2,red,+2.00 power,frame1,TRUE
usframe1r1p3,red,+3.00 power,frame1,TRUE

 

the frame without the lenses:

usframe1r1p0,red,,,FALSE

global-trade-data does not change for variants
unless the original manufacturer has a separate
set of global-trade-data for the specific variant --
for example, the manufacturer might typically
have different global-trade-data for a red or blue
frame but not for different size (power) lenses.

merchants cannot self-assign, modify, or alter,
global-trade-data (mpn, gtin, brand) values --
only the manufacturer can assign such values.

one example of item-groupings (variants) is currently here:
https://support.google.com/merchants/answer/1347943

 
attributes for a tab-delimited (spreadsheet)
feed is simply the first-row, column, names.

that said, google is the final arbiter of all rules and policies.

Re: Example feed for bundled products

[ Edited ]
Visitor ✭ ✭ ✭
# 4
Visitor ✭ ✭ ✭

Thank you for your extremely helpful response and for clarifying about there not being a "bundles or bundle" attribute and to use "is_bundle." I do agree and understand that a UPC needs to reflect the item as-is from the manufacturer which is why we are trying to bundle our lenses with the original UPC. 

 

At this point it looks like the feed works excluding the bundled lens listing having a price of $0.00 which is only allowed for mobile phone or tablets bundled with service contracts. I guess at this point I might have to reduce the parent price and compensate for that reduction in the child price. Were there any other ways?

 

 

id  item_group_id   title                       color  size  gtin          price  is_bundle
1 ks-1-bundle125 Kate Spade Sunglasses Black 1.25 716737437117 100 TRUE
2 ks-1-bundle125 1.25 Power Sunglass Lenses Black 1.25 0 TRUE
3 ks-3-bundle150 Kate Spade Sunglasses Black 1.50 716737437117 100 TRUE
4 ks-3-bundle150 1.50 Power Sunglass Lenses Black 1.50 0 TRUE

 

 

Re: Example feed for bundled products

[ Edited ]
Top Contributor
# 5
Top Contributor

 

first, you're welcome and thank you for the detailed example --
and for using the new community-forum insert-code feature.

price must be for the exact item (variant) being sold and
must exactly match the link landing-page displayed price.

gtin should normally be for the main item-offer in the bundle;
in this case, gtin should (must) be included, and identical, for
all variants with the same frame.

title should be for the entire item, including a common title for all variants;
e.g.
Kate Spade Black Frame
Kate Spade Black Frame with 1.25 Power Sunglass Lenses
Kate Spade Black Frame with 1.50 Power Sunglass Lenses

also, there is absolutely no requirement to submit all variant items
that are physically in stock -- however, all variants submitted must
be currently, physically, in stock.

as an aside, a best practice is for id values
to be a mix of both numbers and letters; e.g.
abc123us
especially if a spreadsheet is being used.

 

Re: Example feed for bundled products

Visitor ✭ ✭ ✭
# 6
Visitor ✭ ✭ ✭
You the man (or woman) Celebird, Google needs to put you on the payroll! Granted you appear to offer some complementary services yourself but really thank you again for your help! Hopefully some other people find this and are able to resolve their issues as well.

Have a great day!

Re: Example feed for bundled products

Top Contributor
# 7
Top Contributor

you're welcome and thank you for the kind words.