Difference between revisions of "X-Cart:Google Base"

From X-Cart 4 Classic
Jump to: navigation, search
(How do I include Unique Product Identifiers in the Google/Froogle product feed?)
m (Redirected page to X-Cart:Google Shopping)
 
(72 intermediate revisions by 4 users not shown)
Line 1: Line 1:
== What Froogle/GoogleBase module does ==
+
#REDIRECT [[X-Cart:Google Shopping]]
  
X-Cart's <u>Froogle/GoogleBase</u> module provides a tool that allows you to submit product feeds to Google Base so the products sold by your store can be found by Internet users using Froogle, Google's shopping search engine.
+
== What the module does ==
  
Froogle is an extension of Google dedicated to helping shoppers quickly find products for sale on the Web. Data in Froogle comes from two sources: product feeds submitted by merchants and a crawl of web pages that identifies product offers. A Froogle product feed is a text file containing specially formatted information about the products offered for sale by a store. As a merchant, you can submit information about your products in the form of a product feed so your products get included into Froogle listings. Submitting a product feed to Froogle is free.
+
X-Cart's module <u>Google Shopping</u> provides a tool that allows you to submit product feeds to Google Shopping so the products sold by your store can be found by Internet users using Google Shopping, a Google's service that allows users to search for products on online shopping websites and compare prices between different vendors.
  
X-Cart's <u>Froogle/GoogleBase</u> module facilitates creation and submission of product feeds to Froogle. It pulls data from all of the products in your store database, creates a properly formatted product feed file and uses FTP to submit this file to Google Base. Google Base then places the submitted product information in Froogle.
+
Data in Google Shopping comes from two sources: product feeds submitted by merchants and a crawl of web pages that identifies product offers. A Google Shopping product feed is a text file containing specially formatted information about the products offered for sale by a store. As a merchant you can submit information about your products in the form of a product feed so your products will be listed in Google Shopping.
 +
 
 +
X-Cart's <u>Google Shopping</u> module facilitates creation and submission of product feeds to Google Shopping. It pulls data from all of the products in your store's database, creates a properly formatted product feed file and uses FTP to submit this file to Google Shopping.
  
 
You also have the option of downloading the product feed file to your local computer for manual submission or other usage.
 
You also have the option of downloading the product feed file to your local computer for manual submission or other usage.
  
Regularly submitting product feeds to Froogle ensures that the information about your products in Froogle's listings is accurate and up to date.
+
Regularly submitting product feeds to Google Shopping ensures that the information about your products in Google Shopping is accurate and up to date.
  
== Roles in Froogle/Google Base module management ==
+
== Roles ==
  
If you are an X-Cart GOLD administrator/provider or an X-Cart PRO administrator:
+
If you are an X-Cart GOLD or GOLD PLUS administrator/provider or an X-Cart PLATINUM or PRO administrator:
  
* You can enable/disable the module <u>Froogle/GoogleBase</u> and adjust its configuration settings (See[[#Enabling and Configuring 'Froogle/GoogleBase']]).
+
* You can enable/disable the module <u>Google Shopping</u> and adjust its configuration settings (See [[#Enabling and configuring the module|Enabling and configuring the module]]).
* You can create Froogle/GoogleBase feeds that will include information about all the products in the store and submit them to Froogle via Google Base or download them onto your local computer (See [[#Using Froogle/GoogleBase Export]]).
+
* You can create Google Shopping feeds that will include information about all the products in the store and submit them to Google Shopping or download them onto your local computer (See [[#Google Shopping export|Google Shopping export]]).
  
If you are an X-Cart PRO provider:
+
If you are an X-Cart PLATINUM or PRO provider:
  
* You can create Froogle/GoogleBase feeds that will include information about your products and submit them to Froogle via Google Base or download them onto your local computer (See [[#Using Froogle/GoogleBase Export]]).
+
* You can create Google Shopping feeds that will include information about your products and submit them to Google Shopping or download them onto your local computer (See [[#Google Shopping export|Google Shopping export]]).
  
==Enabling and Configuring 'Froogle/Google Base'==
+
==Enabling and configuring the module==
  
To begin using the module enable <u>Froogle/GoogleBase</u> module (<u>Administration menu->Modules</u>). When the module is enabled, a section titled <u>Froogle/GoogleBase options</u> appears in <u>General settings/Modules options</u>.
+
<u>Google Shopping</u> is available as a built-in module in all X-Cart editions. It does not require installation and can be enabled in the <u>Modules</u> section of your store's Amin area.
  
Adjust the module settings via <u>General settings/Modules options->Froogle/GoogleBase options</u>:
+
When the module is enabled, a section titled <u>Google Shopping options</u> appears in <u>General settings/Modules options</u>.
  
: [[Image:googlebase_opts.gif|588px]]
+
Adjust the module settings via <u>General settings/Modules options->Google Shopping options</u>:
  
1. Provide the details of the FTP account which you are going to use for uploading data feed to Froogle/GoogleBase: enter your FTP account login and password into the '<u>Froogle/GoogleBase username</u>' and '<u>Froogle/GoogleBase password</u>' fields.
+
: [[File:google_shopping_config_settings.png|border]]
  
: To set up an FTP account for use with Froogle/Google Base:
+
1. Provide the details of the FTP account which you are going to use for uploading data feed to Google Shopping: enter your FTP account login and password into the '<u>Google Shopping username</u>' and '<u>Google Shopping password</u>' fields.
  
: a) If you haven't yet done so, set up a Google account and sign in (You can use the 'Sign in' link provided on the http://base.google.com/ page).
+
: To set up an FTP account for use with Google Shopping:
: b) Go to the 'Bulk upload files' section (http://base.google.com/base/bulkuploads).
 
: c) Follow Google's instructions to create an FTP account - http://base.google.com/support/bin/answer.py?answer=40051.
 
  
2. Specify the type of currency in which you wish product prices to be displayed in Froogle. You should select the type of currency that is accepted by your store.
+
: a) If you haven't yet done so, create a Google account and sign in to Google Merchant Center at http://www.google.com/merchants page.
 +
: b) Go to the 'Data feeds' section (http://www.google.com/merchants/bulkuploads).
 +
: c) Follow Google's instructions to create an FTP account - http://www.google.com/support/merchants/bin/answer.py?answer=160627.
  
3. If you wish the customers who will come to your store from Froogle to come directly to the HTTPS part of the store, select the check box '<u>Generate links to the HTTPS part of the store</u>'.
+
2. Specify the type of currency in which you wish product prices to be displayed in Google Shopping. You should select the type of currency that is accepted by your store.
  
4. Specify the payment methods that need to be listed in Froogle/GoogleBase as available for your products. You should only select the payment methods that are actually accepted by your store. Google requires that at least one of the following methods be included: "Cash," "Check," "Visa," "MasterCard," "AmericanExpress," "Discover," or "WireTransfer". If you accept more than one method, the names of the methods should be separated by commas.
+
3. If you wish the customers who will come to your store from Google Shopping to come directly to the HTTPS part of the store, select the check box '<u>Generate links to the HTTPS part of the store</u>'.
  
5. Provide additional instructions explaining your payment policies.
+
4. Specify, how many days the information about your products submitted to Google Shopping needs to be considered up-to-date.
  
6. Specify, how many days the information about your products submitted to Froogle/GoogleBase needs to be considered up-to-date.
+
5. Click the '''Apply changes''' button.
  
7. Click the '''Save''' button.
+
==Google Shopping export==
  
==Using Froogle/GoogleBase Export==
+
To create a product feed file for Google Shopping:
 
 
To create a product feed file for Froogle/GoogleBase:
 
  
 
1. Make sure your product thumbnail images are stored on the file system. This is essential because the resultant product feed file will only reference images stored on the file system. If no thumbnail image for a product is found on the file system, the default 'No Image Available' file will be used for the product.
 
1. Make sure your product thumbnail images are stored on the file system. This is essential because the resultant product feed file will only reference images stored on the file system. If no thumbnail image for a product is found on the file system, the default 'No Image Available' file will be used for the product.
  
2. Go to the '<u>Froogle/GoogleBase export</u>' section of the store's back end:
+
2. Go to the '<u>Google Shopping export</u>' section of the store's back end:
  
 
: a) Open the '<u>Import/export data</u>' section of the store's back end.
 
: a) Open the '<u>Import/export data</u>' section of the store's back end.
  
:* (If you are an X-Cart GOLD administrator/provider or an X-Cart PRO administrator): Click on <u>Import/Export</u> in the <u>Administration menu</u>.
+
:* Depending on your role and the version of X-Cart you are using, you will find the <u>Import/Export</u> item in the <u>Tools</u>, <u>Administration</u> or <u>Products</u> menu.
:* (If you are an X-Cart PRO provider): Click on <u>Import/Export</u> in the <u>Products menu</u>.
+
 
 +
: b) Click the '<u>Google Shopping export</u>' link on the 'In this section' menu:
  
: b) Click the '<u>Froogle/GoogleBase export</u>' link in the '<u>Import/export data</u>' section menu.
+
: [[File:google_shopping_export_link.png|border]]
  
: You should see a dialog box titled '<u>Froogle/GoogleBase export</u>'. This dialog box allows you to perform all the operations on Froogle product feeds (creation of product feed files, downloading of product feed files to your local computer or submission of product feeds to Froogle):
+
: You should see a dialog box titled '<u>Google Shopping export</u>'. This dialog box allows you to perform all the operations on Google Shopping product feeds (creation of product feed files, downloading of product feed files to your local computer or submission of product feeds to Google Shopping):
  
: [[Image:google_base.gif|518px]]
+
: [[File:google_shopping_export.png|border]]
  
 
3. Select a language to be used for export.
 
3. Select a language to be used for export.
  
4. Make sure the filename proposed by the '<u>Filename</u>' field is the name you wish to use for your Froogle product feed file (The filename is defined by default as username<u>.txt</u> - based on the Froogle/GoogleBase username you specified in <u>General settings->Froogle/GoogleBase options</u>; however, if you have more than one stores that send product feeds to Froogle, you might want to edit the filename so it includes your store ID - like yourstoreID_username<u>.txt</u>).
+
4. Make sure the filename proposed by the '<u>Filename</u>' field is the name you wish to use for your Google Shopping product feed file (The filename is defined by default as username<u>.txt</u> - based on the Google Shopping username you specified in <u>General settings->Google Shopping options</u>; however, if you have more than one stores that send product feeds to Google Shopping, you might want to edit the filename so it includes your store ID - like yourstoreID_username<u>.txt</u>).
  
{{Note1|Note: If the 'Filename' field says froogle.txt and you do not see the Upload button, it means you probably failed to provide your FTP account details in General settings / Froogle/GoogleBase options section or the current PHP configuration on your store server does not support FTP. Fix the problem to be able to submit product feeds to Froogle/GoogleBase using the module.}}
+
{{Note1|Note: If the 'Filename' field says froogle.txt and you do not see the Upload button, it means you probably failed to provide your FTP account details in <u>General settings->Google Shopping options</u> section or the current PHP configuration of your store server does not support FTP. Fix the problem to be able to submit product feeds to Google Shopping.}}
  
 
5. Click the '''Export''' button. The module should create a product feed.
 
5. Click the '''Export''' button. The module should create a product feed.
Line 83: Line 84:
 
To download the created product feed file onto your local computer, click the '''Download''' button.
 
To download the created product feed file onto your local computer, click the '''Download''' button.
  
To submit the product feed file to Froogle/Google Base directly, click the '''Upload''' button.
+
To submit the product feed file to Google Shopping directly, click the '''Upload''' button.
  
Learn how to upload export files using FTP here: http://base.google.com/support/bin/topic.py?topic=2928
+
Learn how to upload export files using FTP here: http://www.google.com/support/merchants/bin/answer.py?answer=160627
  
{{Note1|'''IMPORTANT''': Please be aware that Froogle/GoogleBase has some restrictions as to the format of tab-delimited bulk upload. A quote from http://base.google.com/base/help/tab_instructions.html says:
+
{{Note1|'''IMPORTANT''': Please be aware that Google Shopping has some restrictions as to the format of tab-delimited bulk upload. Google's article says:
  
 
* "Do not include tabs, carriage returns, or new line characters in the attributes. If any of these appear in an attribute, we will not be able to display that item."
 
* "Do not include tabs, carriage returns, or new line characters in the attributes. If any of these appear in an attribute, we will not be able to display that item."
Line 93: Line 94:
 
* "Do not include HTML tags, comments, and escape sequences. We will try to remove any HTML from your bulk upload, but for best appearance, you should not include HTML."}}
 
* "Do not include HTML tags, comments, and escape sequences. We will try to remove any HTML from your bulk upload, but for best appearance, you should not include HTML."}}
  
Because of the above restrictions, HTML tags and HTML entities are stripped from product names, descriptions, keywords and any other types of data being exported to Froogle/GoogleBase.
+
Because of the above restrictions, HTML tags and HTML entities are stripped from product names, descriptions, keywords and any other types of data being exported to Google Shopping.
  
 
== FAQs ==
 
== FAQs ==
  
=== What attributes are included in the Google/Froogle product feed by default? ===
+
=== How do I update the module to meet the latest Google's Product Feed Specification? ===
 +
 
 +
{{XC version|version=4.3.0-4.3.2, 4.4.0-4.4.3}}
 +
 
 +
'''Update instructions for versions 4.4.0-4.4.3 and 4.3.0-4.3.2'''
 +
 
 +
1. Download the [[File:Array_combine.php.txt]] file to your local computer, save it as "array_combine.php", then upload the "array_combine.php" file to the "include/lib/PEAR/Compat/Function/" directory in your X-Cart installation (create the directory first if it does not exist).
 +
 
 +
2. [[X-Cart:FAQs#How_to_install_patches.3F | Apply the changes]] described in the [[File:froogle_patch.443.diff]] or [[File:froogle_patch.432.diff]] patch to the files "modules/Froogle/froogle.php" and "modules/Extra_Fields/func.php" in your X-Cart installation.
 +
 
 +
3. [[X-Cart:Applying_Patches#Applying_SQL_Patches | Apply the changes]] described in the [[File:froogle_patch.sql]] patch to your X-Cart database.
 +
 
 +
{{Note1|NOTE: Patch [[File:froogle_patch.443.diff]] can be installed on 4.4.0-4.4.3 versions of X-Cart.}}
 +
 
 +
{{Note1|NOTE: Patch [[File:froogle_patch.432.diff]] can be installed on 4.3.0-4.3.2 versions of X-Cart.}}
 +
 
 +
{{Note1|NOTE: If you use a version older than 4.4.0-4.4.3 or 4.3.0-4.3.2, please contact our support team via your personal [https://secure.qtmsoft.com/ Helpdesk area] to get a custom solution for updating the module in your old version of X-Cart.}}
 +
 
 +
See also:
 +
 
 +
* [http://www.google.com/support/merchants/bin/answer.py?answer=188494 Products Feed Specification]
 +
* [http://www.google.com/support/merchants/bin/answer.py?answer=1344057 Summary of Attribute Requirements]
  
The below list shows attributes which are included in the Google/Froogle product feed by default, as well as correlation between the product feed attributes and X-Cart data:
+
=== What attributes are included in the Google Shopping product feed by default? ===
  
* id => product SKU (or variant SKU - if product has variants);
+
The list below shows the attributes included in the Google Shopping product feed by default as well as the correspondence between the product feed attributes and X-Cart data:
* item_group_id => main product SKU (optional, only if product has variants);
 
* title => product name;
 
* description => product short description;
 
* product_type => product main category's path.
 
* link => product URL;
 
* image_link => product image or thumbnail;
 
* condition => preset to 'new' value;
 
* availability => product availability, possible values: 'in stock' and 'out of stock';
 
* price => product (or variant) price (including currency as specified by the [[X-Cart:Google_Base#Enabling_and_Configuring_.27Froogle.2FGoogle_Base.27 | "Type of currency in which prices on your products need to be displayed in Froogle/GoogleBase..."]] option);
 
* shipping_weight => product weight;
 
* expiration_date => expiration date calculated in accordance to the [[X-Cart:Google_Base#Enabling_and_Configuring_.27Froogle.2FGoogle_Base.27 | "How many days the information on your products in Froogle/GoogleBase needs to be considered up-to-date"]] option;
 
* brand => [[X-Cart:Manufacturers#Assigning_Products_to_Manufacturers | product manufacturer]];
 
  
{{Note1 | NOTE: For 4.4.3 and older versions:
+
* id => product SKU (or variant SKU - if product has variants)
* 'id' attribute is correlated with X-Cart's product ID instead of product/variant SKU;
+
* item_group_id => main product SKU (optional, if product has variants)
* 'item_group_id' attribute is not supported (as product variants data is not exported into Google/Froogle product feed, but main product data only);
+
* title => product name
* 'weight' is used instead of 'shipping_weight'.}}
+
* description => product short description
 +
* product_type => product main category path
 +
* link => product URL
 +
* image_link => product image or thumbnail
 +
* condition => preset for the 'new' value
 +
* availability => product availability depending on the [[X-Cart:Adding_Products#Details | "Quantity in stock"]] option; if it is above zero, OR [[X-Cart:General_Options#Inventory_options | "Disable inventory tracking"]] option is turned ON, then 'in stock' is exported into product feed; otherwise - 'out of stock'.
 +
* price => product (or variant) price (including currency as specified by the [[X-Cart:Google_Base#Enabling_and_configuring_the_module | "Currency to be used in Google Shopping"]] option)
 +
* shipping_weight => product weight
 +
* expiration_date => expiration date calculated in accordance to the [[X-Cart:Google_Base#Enabling_and_configuring_the_module | "How many days the information on your products in Google Shopping needs to be considered up-to-date"]] option
 +
* brand => [[X-Cart:Manufacturers#Assigning_Products_to_Manufacturers | product manufacturer]]
  
Here is the list of bsolete attributes being exported in the Google/Froogle product feed in 4.4.3 and older versions:
+
{{Note1 | IMPORTANT: If you use 4.4.3 and older version, please pay attention to the information provided below.}}
  
* currency => currency as specified by the [[X-Cart:Google_Base#Enabling_and_Configuring_.27Froogle.2FGoogle_Base.27 | "Type of currency in which prices on your products need to be displayed in Froogle/GoogleBase..."]] option. Removed since 4.4.4;
+
Here is the list of attributes which are not supported in 4.4.3 and older versions, or differ from the attributes included in the Google Shopping product feed in version 4.4.4:
* payment_accepted => payment methods list as specified by the [[X-Cart:Google_Base#Enabling_and_Configuring_.27Froogle.2FGoogle_Base.27 | "Payment methods that need to be listed in Froogle/GoogleBase as available for your products..."]] option. Removed since 4.4.4;
+
 
* payment_notes => additional instructions as specified by the [[X-Cart:Google_Base#Enabling_and_Configuring_.27Froogle.2FGoogle_Base.27 | "Additional instructions to explain your payment policies"]] option. Removed since 4.4.4;
+
* 'id' corresponds to X-Cart's product ID instead of product/variant SKU;
* quantity => product quantity in stock.  Removed since 4.4.4;
+
* 'item_group_id' is not supported (4.4.3 and older versions do not support export of data for each specific product variant into Google Shopping product feed, only the data of the main product);
* manufacturer => [[X-Cart:Manufacturers#Assigning_Products_to_Manufacturers | product manufacturer]]. Removed since 4.1.5 and replaced with 'brand' since 4.1.7;
+
* 'availability' is not supported.
* manufacturer_id  => [[X-Cart:Manufacturers#Assigning_Products_to_Manufacturers | product manufacturer identifier]]. Removed since 4.1.5;
+
 
* weight => product weight. Replaced with 'shipping_weight' since 4.4.4;
+
Here is the list of obsolete attributes exported to Google Shopping product feed in 4.4.3 and older versions:
* labels => no data is provided for this attribute. Removed since 4.1.7.
+
 
 +
* currency => currency as specified by the [[#Enabling_and_configuring_the_module | "Type of currency in which prices on your products need to be displayed in Froogle/GoogleBase..."]] option; removed since 4.4.4
 +
* payment_accepted => payment methods list as specified by the [[#Enabling_and_configuring_the_module | "Payment methods that need to be listed in Froogle/GoogleBase as available for your products..."]] option; removed since 4.4.4
 +
* payment_notes => additional instructions as specified by the [[#Enabling_and_configuring_the_module | "Additional instructions to explain your payment policies"]] option; removed since 4.4.4
 +
* quantity => product quantity in stock; removed since 4.4.4
 +
* manufacturer => [[X-Cart:Manufacturers#Assigning_Products_to_Manufacturers | product manufacturer]]; removed since 4.1.5 and replaced with 'brand' since 4.1.7
 +
* manufacturer_id  => [[X-Cart:Manufacturers#Assigning_Products_to_Manufacturers | product manufacturer identifier]]; removed since 4.1.5
 +
* weight => product weight; replaced with 'shipping_weight' since 4.4.4
 +
* labels => no data is provided for this attribute; removed since 4.1.7
 +
 
 +
{{Note1 | IMPORTANT: If you are using a 4.4.3 or older version, it is highly recommended to update your Froogle module in order to meet the latest Google's requirements, as described in the section [[#How_do_I_update_the_module_to_meet_the_latest_Google.27s_Product_Feed_Specification.3F | How do I update the module to meed the latest Google's Product Feed Specification?]].}}
  
 
See also:
 
See also:
Line 136: Line 165:
 
* [http://www.google.com/support/merchants/bin/answer.py?answer=1344057 Summary of Attribute Requirements]
 
* [http://www.google.com/support/merchants/bin/answer.py?answer=1344057 Summary of Attribute Requirements]
  
=== How do I include Unique Product Identifiers in the Google/Froogle product feed? ===
+
=== How do I include Unique Product Identifiers in the Google Shopping product feed? ===
  
You can include [http://www.google.com/support/merchants/bin/answer.py?answer=160161&hl=en unique product identifiers] in the Google/Froogle product feed using [[X-Cart:Extra_Fields|Extra Fields]].
+
You can include [http://www.google.com/support/merchants/bin/answer.py?answer=160161&hl=en unique product identifiers] in the Google product feed using [[X-Cart:Extra_Fields|Extra Fields]].
  
Here is the list of unique product identifiers which can be added to your Google/Froogle product feed using [[X-Cart:Extra_Fields|Extra Fields]]:
+
Here is the list of unique product identifiers that can be added to your Google Shopping product feed using [[X-Cart:Extra_Fields|Extra Fields]]:
  
 
* gtin
 
* gtin
Line 149: Line 178:
 
* isbn
 
* isbn
  
{{Note1 | NOTE: Extra Fields for product variants are not supported at the moment. Thus, if you need to define unique product identifiers for each product variant individually, X-Cart needs to be customized. Please contact our support team for assistance via your personal [https://secure.qtmsoft.com/ Helpdesk area].}}
+
{{Note1 | NOTE: Extra Fields are not currently supported in product variants. If you need to define unique product identifiers for each product variant individually, your X-Cart needs to be customized. Please contact our support team for assistance via your personal [https://secure.qtmsoft.com/ Helpdesk area].}}
 +
 
 +
{{Note1 | NOTE: The data for the 'brand' attribute is exported from the [[X-Cart:Manufacturers#Assigning_Products_to_Manufacturers | product manufacturer]] field.}}
 +
 
  
 
See also:
 
See also:
Line 157: Line 189:
 
* [http://www.google.com/support/merchants/bin/answer.py?answer=1344057 Summary of Attribute Requirements]
 
* [http://www.google.com/support/merchants/bin/answer.py?answer=1344057 Summary of Attribute Requirements]
  
'''To include Unique Product Identifiers to your product feed for version 4.4.4'''
+
{{XC version|version=4.4.4}}
 +
 
 +
'''To include Unique Product Identifiers in your product feed for version 4.4.4:'''
  
Here is a brief guide to including [http://www.google.com/support/merchants/bin/answer.py?answer=160161&hl=en unique product identifiers] in a product feed by the example of MPN and ISBN:
+
Here is a brief guide on including [http://www.google.com/support/merchants/bin/answer.py?answer=160161&hl=en unique product identifiers] in a product feed on the example of MPN and ISBN:
  
 
1. [[X-Cart:Extra_Fields#Creating_extra_fields | Create the Extra Fields]] that would correspond with the unique product identifiers to be included in your product feed.
 
1. [[X-Cart:Extra_Fields#Creating_extra_fields | Create the Extra Fields]] that would correspond with the unique product identifiers to be included in your product feed.
  
Here is what Extra Fields would look like in case you need to include MPN and ISBN attributes to your product feed:
+
Here is what Extra Fields should look like if you decide to include the MPN and ISBN attributes in your product feed:
  
 
: [[Image:extra_feilds.jpeg]]
 
: [[Image:extra_feilds.jpeg]]
  
{{Note1|IMPORTANT: Make sure the service name of your extra fields coincide with the name of the corresponding attribute as specified in the [[X-Cart:Google_Base#See_also| Google's Products Feed Specification]]. In our example, the names are "mpn" and "isbn".}}
+
{{Note1|IMPORTANT: Make sure the service names of your extra fields match the names of the corresponding attributes as specified in Google's [http://www.google.com/support/merchants/bin/answer.py?answer=188494 Products Feed Specification]. In our example, the names are, respectively, "mpn" and "isbn".}}
  
 
2. [[X-Cart:Extra_Fields#Assigning_Values_to_Extra_Fields | Assign values]] to the Extra Fields that would correspond with the unique product identifiers for your products.
 
2. [[X-Cart:Extra_Fields#Assigning_Values_to_Extra_Fields | Assign values]] to the Extra Fields that would correspond with the unique product identifiers for your products.
  
'''To include Unique Product Identifiers to your product feed for version 4.4.3 and 4.3.2'''
+
{{XC version|version=4.3.0-4.3.2, 4.4.0-4.4.3}}
  
1. Download the <tt>[[File:Array_combine.php.txt]]</tt> file to your local computer, save it as "array_combine.php", then upload the "array_combine.php" file to the "include/lib/PEAR/Compat/Function/" directory in your X-Cart installation (make sure you create the directory first if does not exist).
+
'''To include Unique Product Identifiers in your product feed for earlier versions:'''
  
2. [[X-Cart:FAQs#How_to_install_patches.3F | Apply the changes]] described in the <tt>[[File:froogle_patch.443.diff]]</tt> or <tt>[[File:froogle_patch.432.diff]]</tt> patch to the files <tt><xcart_dir>/modules/Froogle/froogle.php</tt> and <tt>modules/Extra_Fields/func.php</tt>.
+
1. Install the update as suggested in the [[#How_do_I_update_the_module_to_meet_the_latest_Google.27s_Product_Feed_Specification.3F| How do I update the module to meet the latest Google's Product Feed Specification?]] section.
  
3. [[X-Cart:Applying_Patches#Applying_SQL_Patches | Apply the changes]] described in the <tt>[[File:froogle_patch.sql]]</tt> patch to your X-Cart database.
+
2. Follow steps 1-2 of the "To include Unique Product Identifiers in your product feed for version 4.4.4" section above.
  
4. Follow the steps 1-2 provided in the "To include Unique Product Identifiers to your product feed for version 4.4.4" section above.
+
{{Note1|NOTE: If you use a version older than 4.4.0 or 4.3.0, please contact our support team via your personal [https://secure.qtmsoft.com/ Helpdesk area] to get a custom solution for updating the module in your old version of X-Cart.}}
  
{{Note1|NOTE: If you use an older version than 4.4.3 or 4.3.2, please contact our support team via your personal [https://secure.qtmsoft.com/ Helpdesk area] in order to get a custom solution to update the module for your old X-Cart version.}}
+
=== How do I include additional attributes in Google/Froogle product feed? ===
  
=== How do I include additional attributes in the Google/Froogle product feed? ===
+
You can include additional attributes in the Google product feed using [[X-Cart:Extra_Fields|Extra Fields]].
  
You can include additional attributes in the Google/Froogle product feed using [[X-Cart:Extra_Fields|Extra Fields]].
+
Here is the list of additional attributes that can be added to your Google product feed using [[X-Cart:Extra_Fields|Extra Fields]]:
 
 
Here is the list of additional attributes which can be added to your Google/Froogle product feed using [[X-Cart:Extra_Fields|Extra Fields]]:
 
  
 
* google_product_category
 
* google_product_category
Line 202: Line 234:
 
* [http://www.google.com/support/merchants/bin/answer.py?answer=1344057 Summary of Attribute Requirements]
 
* [http://www.google.com/support/merchants/bin/answer.py?answer=1344057 Summary of Attribute Requirements]
  
'''To include additional attributes to your product feed for version 4.4.4'''
+
{{XC version|version=4.4.4}}
 +
 
 +
'''To include additional attributes in your product feed for version 4.4.4'''
  
Here is an example how to add "size", "color" and "google_product_category" attributes to your product feed:
+
Here is an example of how to add "size", "color" and "google_product_category" attributes to your product feed:
  
 
1. [[X-Cart:Extra_Fields#Creating_extra_fields | Create the Extra Fields]] that would correspond with the "size", "color" and "google_product_category" attributes to be included in your product feed.
 
1. [[X-Cart:Extra_Fields#Creating_extra_fields | Create the Extra Fields]] that would correspond with the "size", "color" and "google_product_category" attributes to be included in your product feed.
  
Here is what Extra Fields would look like in case you need to include "size", "color" and "google_product_category" attributes to your product feed:
+
Here is what the Extra Fields would look like in case you need to include the "size", "color" and "google_product_category" attributes in your product feed:
  
 
: [[File:Additional_attributes.jpg]]
 
: [[File:Additional_attributes.jpg]]
  
{{Note1|IMPORTANT: Make sure the service name of your extra fields coincide with the name of the corresponding attribute as specified in the [[X-Cart:Google_Base#See_also| Google's Products Feed Specification]]. In our example, the names are "size", "color" and "google_product_category".}}
+
{{Note1|IMPORTANT: Make sure the service names of your extra fields match the names of the corresponding attributes as specified in Google's [http://www.google.com/support/merchants/bin/answer.py?answer=188494 Products Feed Specification]. In our example, the names are, respectively, "size", "color" and "google_product_category".}}
  
 
2. [[X-Cart:Extra_Fields#Assigning_Values_to_Extra_Fields | Assign values]] to the Extra Fields that would correspond with the "size", "color" and "google_product_category" attributes for your products.
 
2. [[X-Cart:Extra_Fields#Assigning_Values_to_Extra_Fields | Assign values]] to the Extra Fields that would correspond with the "size", "color" and "google_product_category" attributes for your products.
  
'''To include additional attributes to your product feed for version 4.4.3 and 4.3.2'''
+
{{XC version|version=4.3.0-4.3.2, 4.4.0-4.4.3}}
 
 
1. Download the <tt>[[File:Array_combine.php.txt]]</tt> file to your local computer, save it as "array_combine.php", then upload the "array_combine.php" file to the "include/lib/PEAR/Compat/Function/" directory in your X-Cart installation (make sure you create the directory first if does not exist).
 
  
2. [[X-Cart:FAQs#How_to_install_patches.3F | Apply the changes]] described in the <tt>[[File:froogle_patch.443.diff]]</tt> or <tt>[[File:froogle_patch.432.diff]]</tt> patch to the files <tt><xcart_dir>/modules/Froogle/froogle.php</tt> and <tt>modules/Extra_Fields/func.php</tt>.
+
'''To include additional attributes in your product feed for earlier versions'''
  
3. [[X-Cart:Applying_Patches#Applying_SQL_Patches | Apply the changes]] described in the<tt>[[File:froogle_patch.sql]]</tt> patch to your X-Cart database.
+
1. Install the update as suggested in the [[X-Cart:Google_Base#How_do_I_update_the_module_to_meet_the_latest_Google.27s_Product_Feed_Specification.3F | How do I update the module to meet the latest Google's Product Feed Specification?]] section.
  
4. Follow the steps 1-2 provided in the "To include additional attributes to your product feed for version 4.4.4" section above.
+
2. Follow steps 1-2 of the "To include additional attributes in your product feed for version 4.4.4" section above.
  
{{Note1|NOTE: If you use an older version than 4.4.3 or 4.3.2, please contact our support team to get a custom solution to update the module for your old X-Cart version.}}
+
{{Note1|NOTE: If you are using a version older than 4.4.0 or 4.3.0, please contact our support team via your personal [https://secure.qtmsoft.com/ Helpdesk area] to get a custom solution for updating the module in your old version of X-Cart.}}
  
=== I have products which vary based on colors, materials, patterns, or sizes. How do I include my product variants data in the Google/Froogle product feed? ===
+
=== I have products that vary based on colors, materials, patterns, or sizes. How do I include my product variants data in the Google Shopping product feed? ===
  
You can include product variants data in the Google/Froogle product feed using [[X-Cart:Product_Options|Product Options]] and [[X-Cart:Extra_Fields|Extra Fields]] functionality.
+
You can include product variants data in the Google Shopping product feed using X-Cart's [[X-Cart:Product_Options|Product Options]] and [[X-Cart:Extra_Fields|Extra Fields]] features.
  
For more information about Product Variants attributes to be included in product feed please refer to:
+
For more information on the Product Variants attributes to be included in the product feed, please refer to:
  
 
* [http://www.google.com/support/merchants/bin/answer.py?answer=188494 Products Feed Specification]
 
* [http://www.google.com/support/merchants/bin/answer.py?answer=188494 Products Feed Specification]
 
* [http://www.google.com/support/merchants/bin/answer.py?answer=1344057 Summary of Attribute Requirements]
 
* [http://www.google.com/support/merchants/bin/answer.py?answer=1344057 Summary of Attribute Requirements]
  
'''To include additional attributes to your product feed for version 4.4.4'''
+
{{XC version|version=4.4.4}}
  
Here is an example how to include variants data for a product which only varies based on "size" and "color" to your product feed:
+
'''To include product variants data in your product feed for version 4.4.4'''
 +
 
 +
Here is an example of how to include variants data for a product which only varies based on "size" and "color" in your product feed:
  
 
1. Create a product with [[X-Cart:Product_Options|options of variant type]].
 
1. Create a product with [[X-Cart:Product_Options|options of variant type]].
  
Here is what product options would look like in case you need to include "size", "color" attributes to your product feed:
+
Here is what the product options should look like if you decide to include the "size" and "color" attributes in your product feed:
  
 
: [[File:Product_options_of_variant_type.png]]
 
: [[File:Product_options_of_variant_type.png]]
  
{{Note1|IMPORTANT: Make sure the name of your product option group (option class) coincide with the name of the corresponding variant attribute as specified in the [[X-Cart:Google_Base#See_also| Google's Products Feed Specification]]. In our example, the names are "Color" and "Size".}}
+
{{Note1|IMPORTANT: Make sure the name of your product option group (option class) matches the name of the corresponding variant attribute as specified in Google's [http://www.google.com/support/merchants/bin/answer.py?answer=188494 Products Feed Specification]. In our example, the names are, respectively, "Color" and "Size".}}
  
 
2. [[X-Cart:Extra_Fields#Creating_extra_fields | Create the Extra Fields]] that would correspond with the "size" and "color" attributes to be included in your product feed.
 
2. [[X-Cart:Extra_Fields#Creating_extra_fields | Create the Extra Fields]] that would correspond with the "size" and "color" attributes to be included in your product feed.
  
Here is what Extra Fields would look like in case you need to include "size" and "color" variant attributes to your product feed:
+
Here is what the Extra Fields should look like if you decide to include the "size" and "color" variant attributes in your product feed:
  
 
: [[File:Additional_attributes.jpg]]
 
: [[File:Additional_attributes.jpg]]
  
That is all. Now, all the product variations based on "size" and "color" will be exported into your product feed, one item per variant, including the required variant data being exported in the "size" and "color" attributes of your product feed.
+
That is all. Now, all the product variants based on "size" and "color" will be exported to your product feed, one item per variant, including the required variant data exported to the "size" and "color" attributes of your product feed.
 +
 
 +
{{XC version|version=4.3.0-4.3.2, 4.4.0-4.4.3}}
 +
 
 +
'''To include product variants data in your product feed for earlier versions'''
 +
 
 +
1. Install the update as suggested in the [[#How_do_I_update_the_module_to_meet_the_latest_Google.27s_Product_Feed_Specification.3F | How do I update the module to meet the latest Google's Product Feed Specification?]] section.
 +
 
 +
2. Follow steps 1-2 of the "To include product variants data in your product feed for version 4.4.4" section above.
 +
 
 +
{{Note1|NOTE: If you are using a version older than 4.4.0 or 4.3.0, please contact our support team via your personal [https://secure.qtmsoft.com/ Helpdesk area] to get a custom solution for updating the module in your old version of X-Cart.}}
 +
 
 +
=== I use MPN (Manufactuers Part Number) as the SKU in our system. How do I make the SKU export as the MPN in my product feed? ===
 +
 
 +
{{XC version|version=4.4.4}}
 +
 
 +
'''Instructions for version 4.4.4'''
 +
 
 +
Modify your X-Cart source files as described below:
 +
 
 +
1. Find this code in '<xcart_dir>/modules/Froogle/froogle.php' file:
 +
 
 +
<pre>
 +
/* Unique Product Identifiers */
 +
"brand"
 +
</pre>
 +
 
 +
and change it to:
 +
 
 +
<pre>
 +
/* Unique Product Identifiers */
 +
"mpn\t" .
 +
"brand"
 +
</pre>
 +
 
 +
2. Find this code in '<xcart_dir>/modules/Froogle/froogle.php' file:
 +
 
 +
<pre>
 +
func_froogle_convert($product['manufacturer'], 256).
 +
</pre>
 +
 
 +
and change it to:
 +
 
 +
<pre>
 +
$product['productcode']."\t".
 +
func_froogle_convert($product['manufacturer'], 256).
 +
</pre>
 +
 
 +
{{XC version|version=4.3.0-4.3.2, 4.4.0-4.4.3}}
 +
 
 +
'''Instructions for earlier versions'''
 +
 
 +
1. First, install the update as suggested in the [[#How_do_I_update_the_module_to_meet_the_latest_Google.27s_Product_Feed_Specification.3F | How do I update the module to meet the latest Google's Product Feed Specification?]] section.
 +
 
 +
2. Follow steps 1-2 of the "Instructions for version 4.4.4" section above.
 +
 
 +
{{Note1|NOTE: Feel free to contact our support team via your personal [https://secure.qtmsoft.com/ Helpdesk area] should you require assistance with customizing your Google Shopping product feed to meet your specific needs or with updating your Froogle/GoogleBase module in a version older than 4.3.0.}}
 +
 
 +
=== How do I export the 'refurbished' or 'used' condition in place of 'new' for my items? ===
 +
 
 +
:''When we generate a google data feed, it lists all products as "new". We have "new" as well as "refurbished" items. How do I populate the 'condition' attribute with the value specific for each individual item in my product feed?''
 +
 
 +
{{XC version|version=4.4.4}}
 +
 
 +
'''Instructions for version 4.4.4'''
 +
 
 +
1. [[X-Cart:Extra_Fields#Creating_extra_fields | Create the Extra Field]] that would correspond with the "condition" attribute to be included in your product feed. Make sure to define its service name as "condition".
 +
 
 +
2. [[X-Cart:Extra_Fields#Assigning_Values_to_Extra_Fields | Assign the values]] to the "condition" Extra Field for your products. Make sure the values assigned meet [http://www.google.com/support/merchants/bin/answer.py?answer=188494 Google's specifications].
 +
 
 +
3. Modify your X-Cart source files as described below:
 +
 
 +
3a) Find this code in '<xcart_dir>/modules/Froogle/froogle.php' file:
 +
 
 +
<pre>
 +
"condition\t" .
 +
</pre>
 +
 
 +
and change it to:
 +
 
 +
<pre>
 +
//"condition\t" .
 +
</pre>
 +
 
 +
3b) Find this code in '<xcart_dir>/modules/Froogle/froogle.php' file:
 +
 
 +
<pre>
 +
$tmbn."\t".
 +
"new\t".
 +
$availability."\t".
 +
</pre>
 +
 
 +
and change it to:
 +
 
 +
<pre>
 +
$tmbn."\t".
 +
//"new\t".
 +
$availability."\t".
 +
</pre>
 +
 
 +
The above changes remove the default "condition" attribute prepopulated with the "new" value from your product feed.
 +
 
 +
3c) Find this code in '<xcart_dir>/modules/Froogle/config.php' file:
 +
 
 +
<pre>
 +
/*
 +
* Add a new value below to use the extra_field with the respective service_name for froogle export
 +
*/
 +
$froogle_additional_attributes = array(
 +
/* Google's category of item */
 +
"google_product_category",
 +
</pre>
 +
 
 +
and change it to:
 +
 
 +
<pre>
 +
/*
 +
* Add a new value below to use the extra_field with the respective service_name for froogle export
 +
*/
 +
$froogle_additional_attributes = array(
 +
/* Google's category of item */
 +
"google_product_category",
 +
"condition",
 +
</pre>
 +
 
 +
The above changes add a new "condition" attribute, related to the respective extra field in your product feed.
 +
 
 +
{{XC version|version=4.3.0-4.3.2, 4.4.0-4.4.3}}
 +
 
 +
'''Instructions for earlier versions'''
 +
 
 +
1. First install the update as suggested in the [[#How_do_I_update_the_module_to_meet_the_latest_Google.27s_Product_Feed_Specification.3F | How do I update the module to meet the latest Google's Product Feed Specification?]] section.
 +
 
 +
2. Follow steps 1-3 of the "Instructions for version 4.4.4" section above. Please note that the changes described in step 3c) should be applied to the '<xcart_dir>/modules/Froogle/froogle.php' file.
 +
 
 +
{{Note1|NOTE: Feel free to contact our support team via your personal [https://secure.qtmsoft.com/Helpdesk area] should you require assistance with customizing your Google Shopping product feed to meet your specific needs or with updating your Froogle/GoogleBase module in a version older than 4.3.0.}}
 +
 
 +
=== How can I export both UPC and MPN for my variant products? ===
 +
 
 +
:''Some (most?) manufacturers use the same UPC for multiple products and change the part number (MPN), for instance if we have a shirt with a UPC of 1234567890987 but the MPN A1231 for white, A1232 for black, A1233 for blue, etc. Is there any way to add the MPN to each product variant?''
 +
 
 +
Unfortunately, additional fields, such as MPN, are not supported in product variants; besides, X-Cart does not allow adding Extra Fields to product variants. However, there is still a solution:
 +
 
 +
1) First, you can enter MPN into the SKU field for each variant, as well as for the main product (i.e. use MPN as the SKU in your store).
 +
 
 +
2) Second, make the SKU field exports as MPN to your product feed. For more details please refer to [[#I_use_MPN_.28Manufactuers_Part_Number.29_as_the_SKU_in_our_system._How_do_I_make_the_SKU_export_as_the_MPN_in_my_product_feed.3F| this section]];
 +
 
 +
3) Finally, create an Extra Field to add UPC for the main product, so that the same UPC would be used for all the product variants. For further details, please refer to [[#How_do_I_include_Unique_Product_Identifiers_in_the_Google.2FFroogle_product_feed.3F | this section]].
  
'''To include additional attributes to your product feed for version 4.4.3 and 4.3.2'''
+
:''What if there are multiple UPC codes for different product variants, can these be added as well?''
  
1. Download the <tt>[[File:Array_combine.php.txt]]</tt> file to your local computer, save it as "array_combine.php", then upload the "array_combine.php" file to the "include/lib/PEAR/Compat/Function/" directory in your X-Cart installation (make sure you create the directory first if does not exist).
+
Actually, Google does not require to provide both UPC and MPN for each product variant. Basically, you need to submit at least two attributes of 'brand', 'gtin' (which include UPC) and 'mpn'. So, you can provide either MPN or UPC for each product variant, for example using the variant's SKU field as described above.
  
2. [[X-Cart:FAQs#How_to_install_patches.3F | Apply the changes]] described in the <tt>[[File:froogle_patch.443.diff]]</tt> or <tt>[[File:froogle_patch.432.diff]]</tt> patch to the files <tt><xcart_dir>/modules/Froogle/froogle.php</tt> and <tt>modules/Extra_Fields/func.php</tt>.
+
See also:
  
3. [[X-Cart:Applying_Patches#Applying_SQL_Patches | Apply the changes]] described in the<tt>[[File:froogle_patch.sql]]</tt> patch to your X-Cart database.
+
* [http://www.google.com/support/merchants/bin/answer.py?answer=160161 Unique Product Identifiers].
 +
* [[#What_attributes_are_included_in_Google_Shopping_product_feed_by_default.3F | What attributes are included in Google Shopping product feed by default?]]
 +
* [[#How_do_I_include_Unique_Product_Identifiers_in_Google_Shopping_product_feed.3F| How do I include Unique Product Identifiers in Google Shopping product feed?]]
  
4. Follow the steps 1-2 provided in the "To include additional attributes to your product feed for version 4.4.4" section above.
+
{{Note1 | NOTE: If you still need to provide both UPC and MPN for each product variant in your product feed, you would need a custom modification. Feel free to contact our support team via your personal Helpdesk area should you require assistance with customizing your Google Shopping product feed to meet your specific needs.}}
  
{{Note1|NOTE: If you use an older version than 4.4.3 or 4.3.2, please contact our support team to get a custom solution to update the module for your old X-Cart version.}}
+
==Troubleshooting==
 +
 
 +
{{XC version|version=4.4.4}}
 +
===Google data feed empty & "Too many column delimiters" error===
 +
 
 +
The bug-fix for 4.4.4 can be found here:
 +
* https://bugtracker.qtmsoft.com/view.php?id=40487
 +
 
 +
{{XC version|version=4.4.4}}
 +
===Extra fields' default values are not exported into Google Shopping product feed===
 +
 
 +
The bug-fix for 4.4.4 can be found here:
 +
* https://bugtracker.qtmsoft.com/view.php?id=40558
  
 
==See also==
 
==See also==
Line 275: Line 470:
 
* [http://www.google.com/support/merchants/bin/answer.py?answer=160161 Unique Product Identifiers]
 
* [http://www.google.com/support/merchants/bin/answer.py?answer=160161 Unique Product Identifiers]
 
* [http://www.google.com/support/merchants/bin/answer.py?answer=160602 Defining Custom Attributes]
 
* [http://www.google.com/support/merchants/bin/answer.py?answer=160602 Defining Custom Attributes]
 
+
* [http://support.google.com/merchants/bin/answer.py?hl=en&answer=160081 Categorize your products (Google's product taxonomy)]
[[Category:X-Cart user manual]]
 
[[Category:X-Cart modules]]
 
 
 
[[Category:X-Cart user manual]]
 
[[Category:X-Cart modules]]
 
[[Category:X-Cart user manual]]
 
[[Category:X-Cart modules]]
 
[[Category:X-Cart user manual]]
 
[[Category:X-Cart modules]]
 
[[Category:X-Cart user manual]]
 
[[Category:X-Cart modules]]
 
[[Category:X-Cart user manual]]
 
[[Category:X-Cart modules]]
 
[[Category:X-Cart user manual]]
 
[[Category:X-Cart modules]]
 
[[Category:X-Cart user manual]]
 
[[Category:X-Cart modules]]
 
[[Category:X-Cart user manual]]
 
[[Category:X-Cart modules]]
 
[[Category:X-Cart user manual]]
 
[[Category:X-Cart modules]]
 
[[Category:X-Cart user manual]]
 
[[Category:X-Cart modules]]
 
[[Category:X-Cart user manual]]
 
[[Category:X-Cart modules]]
 
[[Category:X-Cart user manual]]
 
[[Category:X-Cart modules]]
 
[[Category:X-Cart user manual]]
 
[[Category:X-Cart modules]]
 
[[Category:X-Cart user manual]]
 
[[Category:X-Cart modules]]
 
[[Category:X-Cart user manual]]
 
[[Category:X-Cart modules]]
 
[[Category:X-Cart user manual]]
 
[[Category:X-Cart modules]]
 
[[Category:X-Cart user manual]]
 
[[Category:X-Cart modules]]
 
[[Category:X-Cart user manual]]
 
[[Category:X-Cart modules]]
 
[[Category:X-Cart user manual]]
 
[[Category:X-Cart modules]]
 
[[Category:X-Cart user manual]]
 
[[Category:X-Cart modules]]
 
[[Category:X-Cart user manual]]
 
[[Category:X-Cart modules]]
 
[[Category:X-Cart user manual]]
 
[[Category:X-Cart modules]]
 
[[Category:X-Cart user manual]]
 
[[Category:X-Cart modules]]
 
[[Category:X-Cart user manual]]
 
[[Category:X-Cart modules]]
 
[[Category:X-Cart user manual]]
 
[[Category:X-Cart modules]]
 
[[Category:X-Cart user manual]]
 
[[Category:X-Cart modules]]
 
[[Category:X-Cart user manual]]
 
[[Category:X-Cart modules]]
 
[[Category:X-Cart user manual]]
 
[[Category:X-Cart modules]]
 
[[Category:X-Cart user manual]]
 
[[Category:X-Cart modules]]
 
[[Category:X-Cart user manual]]
 
[[Category:X-Cart modules]]
 
[[Category:X-Cart user manual]]
 
[[Category:X-Cart modules]]
 
[[Category:X-Cart user manual]]
 
[[Category:X-Cart modules]]
 
[[Category:X-Cart user manual]]
 
[[Category:X-Cart modules]]
 
[[Category:X-Cart user manual]]
 
[[Category:X-Cart modules]]
 
[[Category:X-Cart user manual]]
 
[[Category:X-Cart modules]]
 
[[Category:X-Cart user manual]]
 
[[Category:X-Cart modules]]
 
[[Category:X-Cart user manual]]
 
[[Category:X-Cart modules]]
 
[[Category:X-Cart user manual]]
 
[[Category:X-Cart modules]]
 
[[Category:X-Cart user manual]]
 
[[Category:X-Cart modules]]
 
[[Category:X-Cart user manual]]
 
[[Category:X-Cart modules]]
 
[[Category:X-Cart user manual]]
 
[[Category:X-Cart modules]]
 
[[Category:X-Cart user manual]]
 
[[Category:X-Cart modules]]
 
[[Category:X-Cart user manual]]
 
[[Category:X-Cart modules]]
 
[[Category:X-Cart user manual]]
 
[[Category:X-Cart modules]]
 
[[Category:X-Cart user manual]]
 
[[Category:X-Cart modules]]
 
[[Category:X-Cart user manual]]
 
[[Category:X-Cart modules]]
 
[[Category:X-Cart user manual]]
 
[[Category:X-Cart modules]]
 
[[Category:X-Cart user manual]]
 
[[Category:X-Cart modules]]
 
[[Category:X-Cart user manual]]
 
[[Category:X-Cart modules]]
 
[[Category:X-Cart user manual]]
 
[[Category:X-Cart modules]]
 
[[Category:X-Cart user manual]]
 
[[Category:X-Cart modules]]
 
[[Category:X-Cart user manual]]
 
[[Category:X-Cart modules]]
 
[[Category:X-Cart user manual]]
 
[[Category:X-Cart modules]]
 
[[Category:X-Cart user manual]]
 
[[Category:X-Cart modules]]
 
[[Category:X-Cart user manual]]
 
[[Category:X-Cart modules]]
 
[[Category:X-Cart user manual]]
 
[[Category:X-Cart modules]]
 
[[Category:X-Cart user manual]]
 
[[Category:X-Cart modules]]
 
[[Category:X-Cart user manual]]
 
[[Category:X-Cart modules]]
 
[[Category:X-Cart user manual]]
 
[[Category:X-Cart modules]]
 
[[Category:X-Cart user manual]]
 
[[Category:X-Cart modules]]
 
[[Category:X-Cart user manual]]
 
[[Category:X-Cart modules]]
 
[[Category:X-Cart user manual]]
 
[[Category:X-Cart modules]]
 
[[Category:X-Cart user manual]]
 
[[Category:X-Cart modules]]
 
[[Category:X-Cart user manual]]
 
[[Category:X-Cart modules]]
 

Latest revision as of 17:10, 6 November 2014

What the module does

X-Cart's module Google Shopping provides a tool that allows you to submit product feeds to Google Shopping so the products sold by your store can be found by Internet users using Google Shopping, a Google's service that allows users to search for products on online shopping websites and compare prices between different vendors.

Data in Google Shopping comes from two sources: product feeds submitted by merchants and a crawl of web pages that identifies product offers. A Google Shopping product feed is a text file containing specially formatted information about the products offered for sale by a store. As a merchant you can submit information about your products in the form of a product feed so your products will be listed in Google Shopping.

X-Cart's Google Shopping module facilitates creation and submission of product feeds to Google Shopping. It pulls data from all of the products in your store's database, creates a properly formatted product feed file and uses FTP to submit this file to Google Shopping.

You also have the option of downloading the product feed file to your local computer for manual submission or other usage.

Regularly submitting product feeds to Google Shopping ensures that the information about your products in Google Shopping is accurate and up to date.

Roles

If you are an X-Cart GOLD or GOLD PLUS administrator/provider or an X-Cart PLATINUM or PRO administrator:

  • You can enable/disable the module Google Shopping and adjust its configuration settings (See Enabling and configuring the module).
  • You can create Google Shopping feeds that will include information about all the products in the store and submit them to Google Shopping or download them onto your local computer (See Google Shopping export).

If you are an X-Cart PLATINUM or PRO provider:

  • You can create Google Shopping feeds that will include information about your products and submit them to Google Shopping or download them onto your local computer (See Google Shopping export).

Enabling and configuring the module

Google Shopping is available as a built-in module in all X-Cart editions. It does not require installation and can be enabled in the Modules section of your store's Amin area.

When the module is enabled, a section titled Google Shopping options appears in General settings/Modules options.

Adjust the module settings via General settings/Modules options->Google Shopping options:

Google shopping config settings.png

1. Provide the details of the FTP account which you are going to use for uploading data feed to Google Shopping: enter your FTP account login and password into the 'Google Shopping username' and 'Google Shopping password' fields.

To set up an FTP account for use with Google Shopping:
a) If you haven't yet done so, create a Google account and sign in to Google Merchant Center at http://www.google.com/merchants page.
b) Go to the 'Data feeds' section (http://www.google.com/merchants/bulkuploads).
c) Follow Google's instructions to create an FTP account - http://www.google.com/support/merchants/bin/answer.py?answer=160627.

2. Specify the type of currency in which you wish product prices to be displayed in Google Shopping. You should select the type of currency that is accepted by your store.

3. If you wish the customers who will come to your store from Google Shopping to come directly to the HTTPS part of the store, select the check box 'Generate links to the HTTPS part of the store'.

4. Specify, how many days the information about your products submitted to Google Shopping needs to be considered up-to-date.

5. Click the Apply changes button.

Google Shopping export

To create a product feed file for Google Shopping:

1. Make sure your product thumbnail images are stored on the file system. This is essential because the resultant product feed file will only reference images stored on the file system. If no thumbnail image for a product is found on the file system, the default 'No Image Available' file will be used for the product.

2. Go to the 'Google Shopping export' section of the store's back end:

a) Open the 'Import/export data' section of the store's back end.
  • Depending on your role and the version of X-Cart you are using, you will find the Import/Export item in the Tools, Administration or Products menu.
b) Click the 'Google Shopping export' link on the 'In this section' menu:
Google shopping export link.png
You should see a dialog box titled 'Google Shopping export'. This dialog box allows you to perform all the operations on Google Shopping product feeds (creation of product feed files, downloading of product feed files to your local computer or submission of product feeds to Google Shopping):
Google shopping export.png

3. Select a language to be used for export.

4. Make sure the filename proposed by the 'Filename' field is the name you wish to use for your Google Shopping product feed file (The filename is defined by default as username.txt - based on the Google Shopping username you specified in General settings->Google Shopping options; however, if you have more than one stores that send product feeds to Google Shopping, you might want to edit the filename so it includes your store ID - like yourstoreID_username.txt).

Note: If the 'Filename' field says froogle.txt and you do not see the Upload button, it means you probably failed to provide your FTP account details in General settings->Google Shopping options section or the current PHP configuration of your store server does not support FTP. Fix the problem to be able to submit product feeds to Google Shopping.

5. Click the Export button. The module should create a product feed.

Note: The product feed file will be saved to the directory files (if you are a store administrator) or to the directory files/your_provider_name (if you are a provider).

You should see an Information box with a confirmation message.

To download the created product feed file onto your local computer, click the Download button.

To submit the product feed file to Google Shopping directly, click the Upload button.

Learn how to upload export files using FTP here: http://www.google.com/support/merchants/bin/answer.py?answer=160627

IMPORTANT: Please be aware that Google Shopping has some restrictions as to the format of tab-delimited bulk upload. Google's article says:
  • "Do not include tabs, carriage returns, or new line characters in the attributes. If any of these appear in an attribute, we will not be able to display that item."
  • "Do not include HTML tags, comments, and escape sequences. We will try to remove any HTML from your bulk upload, but for best appearance, you should not include HTML."

Because of the above restrictions, HTML tags and HTML entities are stripped from product names, descriptions, keywords and any other types of data being exported to Google Shopping.

FAQs

How do I update the module to meet the latest Google's Product Feed Specification?

X-Cart 4.3.0-4.3.2, 4.4.0-4.4.3

Update instructions for versions 4.4.0-4.4.3 and 4.3.0-4.3.2

1. Download the File:Array combine.php.txt file to your local computer, save it as "array_combine.php", then upload the "array_combine.php" file to the "include/lib/PEAR/Compat/Function/" directory in your X-Cart installation (create the directory first if it does not exist).

2. Apply the changes described in the File:Froogle patch.443.diff or File:Froogle patch.432.diff patch to the files "modules/Froogle/froogle.php" and "modules/Extra_Fields/func.php" in your X-Cart installation.

3. Apply the changes described in the File:Froogle patch.sql patch to your X-Cart database.

NOTE: Patch File:Froogle patch.443.diff can be installed on 4.4.0-4.4.3 versions of X-Cart.
NOTE: Patch File:Froogle patch.432.diff can be installed on 4.3.0-4.3.2 versions of X-Cart.
NOTE: If you use a version older than 4.4.0-4.4.3 or 4.3.0-4.3.2, please contact our support team via your personal Helpdesk area to get a custom solution for updating the module in your old version of X-Cart.

See also:

What attributes are included in the Google Shopping product feed by default?

The list below shows the attributes included in the Google Shopping product feed by default as well as the correspondence between the product feed attributes and X-Cart data:

IMPORTANT: If you use 4.4.3 and older version, please pay attention to the information provided below.

Here is the list of attributes which are not supported in 4.4.3 and older versions, or differ from the attributes included in the Google Shopping product feed in version 4.4.4:

  • 'id' corresponds to X-Cart's product ID instead of product/variant SKU;
  • 'item_group_id' is not supported (4.4.3 and older versions do not support export of data for each specific product variant into Google Shopping product feed, only the data of the main product);
  • 'availability' is not supported.

Here is the list of obsolete attributes exported to Google Shopping product feed in 4.4.3 and older versions:

IMPORTANT: If you are using a 4.4.3 or older version, it is highly recommended to update your Froogle module in order to meet the latest Google's requirements, as described in the section How do I update the module to meed the latest Google's Product Feed Specification?.

See also:

How do I include Unique Product Identifiers in the Google Shopping product feed?

You can include unique product identifiers in the Google product feed using Extra Fields.

Here is the list of unique product identifiers that can be added to your Google Shopping product feed using Extra Fields:

  • gtin
  • mpn
  • upc
  • ean
  • jan
  • isbn
NOTE: Extra Fields are not currently supported in product variants. If you need to define unique product identifiers for each product variant individually, your X-Cart needs to be customized. Please contact our support team for assistance via your personal Helpdesk area.
NOTE: The data for the 'brand' attribute is exported from the product manufacturer field.


See also:

X-Cart 4.4.4

To include Unique Product Identifiers in your product feed for version 4.4.4:

Here is a brief guide on including unique product identifiers in a product feed on the example of MPN and ISBN:

1. Create the Extra Fields that would correspond with the unique product identifiers to be included in your product feed.

Here is what Extra Fields should look like if you decide to include the MPN and ISBN attributes in your product feed:

Extra feilds.jpeg

Note

2. Assign values to the Extra Fields that would correspond with the unique product identifiers for your products.

X-Cart 4.3.0-4.3.2, 4.4.0-4.4.3

To include Unique Product Identifiers in your product feed for earlier versions:

1. Install the update as suggested in the How do I update the module to meet the latest Google's Product Feed Specification? section.

2. Follow steps 1-2 of the "To include Unique Product Identifiers in your product feed for version 4.4.4" section above.

NOTE: If you use a version older than 4.4.0 or 4.3.0, please contact our support team via your personal Helpdesk area to get a custom solution for updating the module in your old version of X-Cart.

How do I include additional attributes in Google/Froogle product feed?

You can include additional attributes in the Google product feed using Extra Fields.

Here is the list of additional attributes that can be added to your Google product feed using Extra Fields:

  • google_product_category
  • color
  • size
  • material
  • pattern
  • gender
  • age_group

See also:

X-Cart 4.4.4

To include additional attributes in your product feed for version 4.4.4

Here is an example of how to add "size", "color" and "google_product_category" attributes to your product feed:

1. Create the Extra Fields that would correspond with the "size", "color" and "google_product_category" attributes to be included in your product feed.

Here is what the Extra Fields would look like in case you need to include the "size", "color" and "google_product_category" attributes in your product feed:

Additional attributes.jpg

Note

2. Assign values to the Extra Fields that would correspond with the "size", "color" and "google_product_category" attributes for your products.

X-Cart 4.3.0-4.3.2, 4.4.0-4.4.3

To include additional attributes in your product feed for earlier versions

1. Install the update as suggested in the How do I update the module to meet the latest Google's Product Feed Specification? section.

2. Follow steps 1-2 of the "To include additional attributes in your product feed for version 4.4.4" section above.

NOTE: If you are using a version older than 4.4.0 or 4.3.0, please contact our support team via your personal Helpdesk area to get a custom solution for updating the module in your old version of X-Cart.

I have products that vary based on colors, materials, patterns, or sizes. How do I include my product variants data in the Google Shopping product feed?

You can include product variants data in the Google Shopping product feed using X-Cart's Product Options and Extra Fields features.

For more information on the Product Variants attributes to be included in the product feed, please refer to:

X-Cart 4.4.4

To include product variants data in your product feed for version 4.4.4

Here is an example of how to include variants data for a product which only varies based on "size" and "color" in your product feed:

1. Create a product with options of variant type.

Here is what the product options should look like if you decide to include the "size" and "color" attributes in your product feed:

Product options of variant type.png

Note

2. Create the Extra Fields that would correspond with the "size" and "color" attributes to be included in your product feed.

Here is what the Extra Fields should look like if you decide to include the "size" and "color" variant attributes in your product feed:

Additional attributes.jpg

That is all. Now, all the product variants based on "size" and "color" will be exported to your product feed, one item per variant, including the required variant data exported to the "size" and "color" attributes of your product feed.

X-Cart 4.3.0-4.3.2, 4.4.0-4.4.3

To include product variants data in your product feed for earlier versions

1. Install the update as suggested in the How do I update the module to meet the latest Google's Product Feed Specification? section.

2. Follow steps 1-2 of the "To include product variants data in your product feed for version 4.4.4" section above.

NOTE: If you are using a version older than 4.4.0 or 4.3.0, please contact our support team via your personal Helpdesk area to get a custom solution for updating the module in your old version of X-Cart.

I use MPN (Manufactuers Part Number) as the SKU in our system. How do I make the SKU export as the MPN in my product feed?

X-Cart 4.4.4

Instructions for version 4.4.4

Modify your X-Cart source files as described below:

1. Find this code in '<xcart_dir>/modules/Froogle/froogle.php' file:

/* Unique Product Identifiers */
"brand"

and change it to:

/* Unique Product Identifiers */
"mpn\t" .
"brand"

2. Find this code in '<xcart_dir>/modules/Froogle/froogle.php' file:

func_froogle_convert($product['manufacturer'], 256).

and change it to:

$product['productcode']."\t".
func_froogle_convert($product['manufacturer'], 256).
X-Cart 4.3.0-4.3.2, 4.4.0-4.4.3

Instructions for earlier versions

1. First, install the update as suggested in the How do I update the module to meet the latest Google's Product Feed Specification? section.

2. Follow steps 1-2 of the "Instructions for version 4.4.4" section above.

NOTE: Feel free to contact our support team via your personal Helpdesk area should you require assistance with customizing your Google Shopping product feed to meet your specific needs or with updating your Froogle/GoogleBase module in a version older than 4.3.0.

How do I export the 'refurbished' or 'used' condition in place of 'new' for my items?

When we generate a google data feed, it lists all products as "new". We have "new" as well as "refurbished" items. How do I populate the 'condition' attribute with the value specific for each individual item in my product feed?
X-Cart 4.4.4

Instructions for version 4.4.4

1. Create the Extra Field that would correspond with the "condition" attribute to be included in your product feed. Make sure to define its service name as "condition".

2. Assign the values to the "condition" Extra Field for your products. Make sure the values assigned meet Google's specifications.

3. Modify your X-Cart source files as described below:

3a) Find this code in '<xcart_dir>/modules/Froogle/froogle.php' file:

"condition\t" .

and change it to:

//"condition\t" .

3b) Find this code in '<xcart_dir>/modules/Froogle/froogle.php' file:

$tmbn."\t".
"new\t".
$availability."\t".

and change it to:

$tmbn."\t".
//"new\t".
$availability."\t".

The above changes remove the default "condition" attribute prepopulated with the "new" value from your product feed.

3c) Find this code in '<xcart_dir>/modules/Froogle/config.php' file:

/*
* Add a new value below to use the extra_field with the respective service_name for froogle export
*/
$froogle_additional_attributes = array(
/* Google's category of item */
"google_product_category",

and change it to:

/*
* Add a new value below to use the extra_field with the respective service_name for froogle export
*/
$froogle_additional_attributes = array(
/* Google's category of item */
"google_product_category",
"condition",

The above changes add a new "condition" attribute, related to the respective extra field in your product feed.

X-Cart 4.3.0-4.3.2, 4.4.0-4.4.3

Instructions for earlier versions

1. First install the update as suggested in the How do I update the module to meet the latest Google's Product Feed Specification? section.

2. Follow steps 1-3 of the "Instructions for version 4.4.4" section above. Please note that the changes described in step 3c) should be applied to the '<xcart_dir>/modules/Froogle/froogle.php' file.

NOTE: Feel free to contact our support team via your personal area should you require assistance with customizing your Google Shopping product feed to meet your specific needs or with updating your Froogle/GoogleBase module in a version older than 4.3.0.

How can I export both UPC and MPN for my variant products?

Some (most?) manufacturers use the same UPC for multiple products and change the part number (MPN), for instance if we have a shirt with a UPC of 1234567890987 but the MPN A1231 for white, A1232 for black, A1233 for blue, etc. Is there any way to add the MPN to each product variant?

Unfortunately, additional fields, such as MPN, are not supported in product variants; besides, X-Cart does not allow adding Extra Fields to product variants. However, there is still a solution:

1) First, you can enter MPN into the SKU field for each variant, as well as for the main product (i.e. use MPN as the SKU in your store).

2) Second, make the SKU field exports as MPN to your product feed. For more details please refer to this section;

3) Finally, create an Extra Field to add UPC for the main product, so that the same UPC would be used for all the product variants. For further details, please refer to this section.

What if there are multiple UPC codes for different product variants, can these be added as well?

Actually, Google does not require to provide both UPC and MPN for each product variant. Basically, you need to submit at least two attributes of 'brand', 'gtin' (which include UPC) and 'mpn'. So, you can provide either MPN or UPC for each product variant, for example using the variant's SKU field as described above.

See also:

NOTE: If you still need to provide both UPC and MPN for each product variant in your product feed, you would need a custom modification. Feel free to contact our support team via your personal Helpdesk area should you require assistance with customizing your Google Shopping product feed to meet your specific needs.

Troubleshooting

X-Cart 4.4.4

Google data feed empty & "Too many column delimiters" error

The bug-fix for 4.4.4 can be found here:

X-Cart 4.4.4

Extra fields' default values are not exported into Google Shopping product feed

The bug-fix for 4.4.4 can be found here:

See also