How to create xml google shop feed in mvc core

  1. תאריך23/02/2020 14:10:44
  2. על ידי Ori Slasi

In this article i will explain how we have implemented google feed in our system.
this article has being written for an existing customers or their marketing specialists that want to know how to manage the data in the back-end system and verify the implementation.
useful links:

The system creates dynamic xml file on the link: [domain0name]/googlefeed
for example: slasi.nl/googlefeed 
The xml feed is divided to two parts, the first part is the feed information and the second is the product data specification

Feed information:
title -   update the title can be done in: configuration>settings> search for: GoogleShopTitle
link -   update the title can be done in: configuration>settings> search for: GoogleShopLink
description -  update the title can be done in: configuration>settings> search for: GoogleShopDescription 

Product data specification 


Google shops
Slasi.Icms
Id: max 50 characters
Id: max 50 characters
Title - max 150 characters.
Product.Title if value exists. if not we use the Product.Name - can be changed in the Product details.
Description - max 5000 characters
Product.LongDescriptio: taking the first 5000 characters. Product details long description ta
Link
the item link is created automatically. cannot be changed
image_link
generated automatically:  'Settings.WebsiteUrl/'+'uploads/images/products/small/'+Product.PhotoPath. if product.PhotoPath is empty we set empty string.



Price & availability



availability: 'in stock', 'out of stock', 'preorder'
availability: automatically created by the filed Product.IsInStock. can be edited in the product details or the list of products checkbox. implemented options: 'in stock', 'out of stock'.
price - numeric ISO 4217 (price is numeric and you can select price unit from the link https://en.wikipedia.org/wiki/ISO_4217 ) 
Product.Price: can be updated in the product details -prices tab > Price peroperty
Currency: needs to be after the price in the same attribute
 https://support.google.com/merchants/answer/160637 
Product.Currency: can be changed in product details > price tab.


Product identifiers



brand: max 70 characters
Product.Producer.Name or "No value in db" if we have no data. you can update the product.Producer in product details > basic info tab.
gtin - (product’s Global Trade Item Number) max 50 numeric characters
Product.Gtin: can be updated in product details gshop tab > gtin textbox.
mpn: (product’s Manufacturer Part Number) max 70 alphanumeric characters
Product.Mpn: can be updated in product details gshop tab > Mpn textbox

remark: if your product doesn't have both a gtin and mpn set the attribute identifier_exists to no

Detailed product description



condition - 'new', 'refurbished', 'used'
Product.Condition: can be updated in product details gshop tab > condition textbox
adult - 'yes', 'no' => fill in 'yes' if your product contains nudity or sexually content. the default is no if the attribute is not submitted
Not implemented
multipack - Integer, greater than 1. if the attribute is not submitted the value is 0. use this attribute when you sell number of identical products  as a single unit
Not implemented


Shipping



Price + currency
Product.ShippingPrice + Product.Currency: can be updated in product details shipping tab.


Product categoryping

product_type

enerated automatically- bradcrumb 


השאר תגובה

כתובת האמייל לא תפורסם, שדות חובה מסומנות ב *

*
*
*

Ori Slasi

.NET Developer

23
POSTS


צור קשר

{{message}}