Announcement:Materials and articles for ProductCart 5 can be found at our brand new support center.

Create an account to edit articles | See Formatting Syntax for Wiki syntax | We look forward to your contribution!

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

productcart:marketing-generate_google_base_file [2011/06/06 15:44]
earlyimpact
productcart:marketing-generate_google_base_file [2013/07/12 14:44] (current)
Line 3: Line 3:
 ===== Posting Products to Google Product Search ===== ===== Posting Products to Google Product Search =====
  
-In a nutshell, "​Products Search"​ is a product index within the larger Google Base database, and powers the results that you see when you click on the //​Shopping//​ link on Google. You will need a Google Merchant account to submit products and content to Google Base. [[http://www.google.com/​base/help/sellongoogle.html|More information about uploading data to Google Products Search]]. ​+In a nutshell, "​Products Search"​ is a product index within the larger Google Base database, and powers the results that you see when you click on the //​Shopping//​ link on Google. You will need a Google Merchant account to submit products and content to Google Base. [[https://support.google.com/​merchants/answer/188494?​hl=en|More information about uploading data to Google Products Search]]. ​
  
-ProductCart contains a feature that allows you to quick generate a Google Product Search data feed. You will then need to [[http://www.google.com/​base/register.html|register it with Google]] and provide the data feed by uploading it manually or letting Google automatically "fetch it" from your Web store.+ProductCart contains a feature that allows you to quick generate a Google Product Search data feed. You will then need to [[https://support.google.com/​merchants/answer/​188475?​hl=en|register it with Google]] and provide the data feed by uploading it manually or letting Google automatically "fetch it" from your Web store.
  
 ===== Unique Product Identifiers ===== ===== Unique Product Identifiers =====
Line 33: Line 33:
 If your items do not have unique identifiers (e.g. custom-created products, services, etc.), you can [[http://​www.google.com/​support/​merchants/​bin/​request.py?​contact_type=unique_id_exemption|requests a special exemption]]. If your items do not have unique identifiers (e.g. custom-created products, services, etc.), you can [[http://​www.google.com/​support/​merchants/​bin/​request.py?​contact_type=unique_id_exemption|requests a special exemption]].
  
-For example, on the Early Impact ​software store we sell digital goods (our software) for which unique identifiers are not available. We requested an exemption and it was granted by Google within a couple of days of submitting the request.+For example, on the ProductCart ​software store we sell digital goods (our ecommerce ​software) for which unique identifiers are not available. We requested an exemption and it was granted by Google within a couple of days of submitting the request.
  
-Note that even after the request has been approved, you might still see "​Missing Unique Product Identifiers"​ error messages in the your Google Merchant Center. We have contacted Google on this matter and they indicated that those messages can be ignored (June 2011).+Note that even after the request has been approved, you might still see "​Missing Unique Product Identifiers"​ error messages in the your Google Merchant Center. We contacted Google on this matterand they indicated that those messages can be ignored ​once the exemption has been approved ​(June 2011)
 + 
 +==== Feature Limitation: Apparel products (US only) ====  
 + 
 +In the summer of 2011 Google Product Search introduced additional required attributes for Apparel products ([[http://​www.google.com/​support/​merchants/​bin/​answer.py?​hl=en&​answer=188494#​US|see sections 4 and 5 of the Google Product Search data feed specifications]]). These additional requirements apply only to US merchants at this time.  
 + 
 +The additional attributes are '​gender',​ 'age group',​ '​size'​ and '​color',​ plus the 'item group id' attribute if there are product variants, and the '​pattern'​ and '​material'​ attributes if the variants vary by pattern or material, plus the corresponding product image for each variant. 
 + 
 +As you can see, these new requirements are quite extensive, and will require several database and code changes to ProductCart. We will be reviewing the project again after the release of ProductCart v4.5.  
 + 
 +As of now (October 2011), the data feed generator will not support apparel products for US merchants. This is to be considered a feature limitation at this time.
  
 ===== Setting up Tax and Shipping at the Account level ===== ===== Setting up Tax and Shipping at the Account level =====
Line 85: Line 95:
 ===== Submitting your Product Search Data Feed ===== ===== Submitting your Product Search Data Feed =====
  
-There are [http://​www.google.com/​support/​merchants/​bin/​answer.py?​hl=en&​answer=188477|three ways to submit your data feed to Google Product Search].+There are [[http://​www.google.com/​support/​merchants/​bin/​answer.py?​hl=en&​answer=188477|three ways to submit your data feed to Google Product Search]].
  
   * Direct Upload (Files under 20 MB in size)   * Direct Upload (Files under 20 MB in size)
Line 93: Line 103:
 Take advantage of the scheduling feature to automate the posting of the data feed: [http://​www.google.com/​support/​merchants/​bin/​answer.py?​answer=1219255|more information on this feature]. Take advantage of the scheduling feature to automate the posting of the data feed: [http://​www.google.com/​support/​merchants/​bin/​answer.py?​answer=1219255|more information on this feature].
  
-Additional notes:+Once your data feed has been registered by Google Product Search, your items will become searchable in the Google Product Search database. However, remember that they will expire in 30 days from the date of the last upload, so remember to either use the scheduling feature or upload a new version of your bulk upload file regularly. 
 + 
 +Also note: 
 + 
 +  * the file name for your Google Product Search Data Feed must remain the same if you want to update existing items. However, you can also register a new bulk upload file 
 +  * do not include the date in the name of the file.  
 + 
 +===== Troubleshooting ===== 
 + 
 +==== Data feed rejected due to Google Product Category attribute being required ==== 
 + 
 +The Google Product Category (google_product_category) attribute is Google'​s category of the item. It has nothing to do with the item category in ProductCart,​ which is submitted as part of the data feed as the "​Product Type" attribute (product_type). 
 + 
 + You can find detailed information on this attribute on the [[http://​www.google.com/​support/​merchants/​bin/​answer.py?​answer=188494|Products Feed Specifications]] page.  It is only applicable to a small subset of categories, and must use exactly the category definition included in [[http://​www.google.com/​support/​merchants/​bin/​answer.py?​answer=160081|Google’s taxonomy]].  
 + 
 +Automatically filling in this information in ProductCart would require substantial changes to the system, as you would have to specify a mapping between a ProductCart category and the Google taxonomy at the category or item level. 
 + 
 +Therefore, at this time, if you are getting an error indicating that this attribute is required, you have two options: 
 + 
 +  - **Contact Google** and explain that your products do not fall into one of the categories for which this attribute is required 
 +  - **Manually Edit the File" as follows: 
 +    - Download the data feed to your computer 
 +    - Open it in MS Excel (it is a tab-delimited file) 
 +    - Add a column with the value "​google_product_category"​ in the first row (the header row) 
 +    - Add the values to the products for which this attribute is required, consistent with the [[http://​www.google.com/​support/​merchants/​bin/​answer.py?​answer=160081|Google’s taxonomy]].  
 +    - Save the file in its current (*.txt) format. 
 +    - Submit the edited data feed
  
-  * The file name for your Google Product Search Data Feed must rename ​the same if you want to update existing items. However, you can also register a new bulk upload file.   +We understand that manually editing the data feed is certainly not an ideal solution, and we are looking ​for the best way to automate this process ​in ProductCartAs mentioned abovethis will require changes both at the source code and database ​levelso it is not something ​that can be implemented immediately.
-  * Do not include the date in the name of the file +
-  * Once your data feed has been registered by Google Product Searchyour items will become searchable in the Google Product Search ​database. Howeverremember ​that they will expire in 30 days from the date of the last upload, so remember to either use the scheduling feature or upload a new version of your bulk upload file regularly.+

QR Code
QR Code Google Products Search data feed generator (Google Base) (generated for current page)