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

Feed Structure: Merging different product sizes under parent item

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

Hi guys, 

 

I have a question on the best feed structure to use

 

I currently have the feed at variant size and colour level as shown below:

 

ItemID            Color      Price     Size        Link                                                                       Availability

258369_M       Blue         119         M          http://merchant.com/blue/product=258369           In Stock

258369_L        Blue         119         L           http://merchant.com/blue/product=258369           Out of Stock

258370_S        Black       119         S          http://merchant.com/black/product=258370          In Stock

258370_XS      Black       119        XS        http://merchant.com/black/product=258370          In Stock

258371_XL      Pink          119       XL         http://merchant.com/pink/product=258371           Out of Stock  

258371_L         Pink         119         L          http://merchant.com/pink/product=258371           In Stock

 

(Others attribute in feed are exactly the same)

 

Also, the merchant have unique landing pages per colour and they are listing all available sizes on the LP 

Some sizes are in stock and other out of stock 

 

Therefore, I wanted to use a different feed structure to manage more efficiently the feed, as I realized that less than 0.5% of search queries are mentioning a size 

 

So my idea was to use the structure below

 

I will end up with less items in the feed, which will make it easier to manage performance

 

Example: 

ItemID            Color      Price     Size               Link                                                                  Availability

258369           Blue         119      XS-XL             http://merchant.com/blue/product=258369       In Stock 

258370           Black        119     XS-XL             http://merchant.com/black/product=258370      In Stock

258371           Pink          119     XS-XL             http://merchant.com/pink/product=258371        In Stock

 

I am just worried that some products might be rejected as all sizes are not in stock 

 

Example: ItemID 258369_L have sizes L which is out of stock. So can I still group variant sizes this way? Or is there a best workaround you are using?

 

Thanks in advance,

Adel

1 Expert replyverified_user

Feed Structure: Merging different product sizes under parent item

Rising Star
# 2
Rising Star

The first structure is correct and the most effective method for submitting products to Google Shopping, your second example is incorrect because you can not submit multiple sizes within 1 value. All your product will get disapproved.

 

 

As I'm guessing you want the easier management in Adwords, than simply use custom labels to organize everything

More info : https://support.google.com/merchants/answer/6324473

 

If you want easier management in the data feed, than I recommend instead of using a spreasdsheet is to use a plugin or management tool to organize everything.

 

The easiest way is to Google to see what is available for your platform.

 

Hope it helps.

Twitter | Linkedin | Community Profile | Shopping Feed Tips From FeedArmy
Did you find any helpful responses or answers to your query? If yes, please click on ‘Accept As Solution’