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

From X-Cart 4 Classic
Jump to: navigation, search
(FAQ)
(FAQ)
Line 114: Line 114:
 
* condition => preset to 'new' value;
 
* condition => preset to 'new' value;
 
* product_type => product main category's path.
 
* product_type => product main category's path.
 
=== How do I include additional attributes in the Google/Froogle product feed? ===
 
 
{{Template:XC_4.4}}
 
Since 4.4.4, it is possible to include additional attributes in the Google/Froogle product feed using [[X-Cart:Extra_Fields|Extra Fields]].
 
1.
 
  
 
=== How do I include Unique Product Identifiers and Custom Attributes in the Google/Froogle product feed? ===
 
=== How do I include Unique Product Identifiers and Custom Attributes in the Google/Froogle product feed? ===
  
{{Template:XC_4.4}}
 
 
'''To include Unique Product Identifiers to your product feed for version 4.4.4'''
 
'''To include Unique Product Identifiers to your product feed for version 4.4.4'''
  
Line 196: Line 189:
 
* <u>"store_department"</u> - service name, set for the respective Extra Field.
 
* <u>"store_department"</u> - service name, set for the respective Extra Field.
  
'''See also:'''
+
=== How do I include additional attributes in the Google/Froogle product feed? ===
 +
 
 +
Since 4.4.4, it is possible to include additional attributes in the Google/Froogle product feed using [[X-Cart:Extra_Fields|Extra Fields]].
 +
 
 +
Here is an example how to add "google_product_category" attribute to your product feed:
 +
 
 +
1. In <xcart_dir>/modules/Froogle/config.php file, find this code:
 +
<pre>
 +
$froogle_additional_attributes = array(
 +
    "gtin",
 +
    "mpn",
 +
    "upc",
 +
    "ean",
 +
    "jan",
 +
    "isbn",
 +
    "c:custom_attr",
 +
);
 +
</pre>
 +
 
 +
2. Modify the code as follows:
 +
 
 +
<pre>
 +
$froogle_additional_attributes = array(
 +
    "gtin",
 +
    "mpn",
 +
    "upc",
 +
    "ean",
 +
    "jan",
 +
    "isbn",
 +
    "c:custom_attr",
 +
    "google_product_category",
 +
);
 +
 
 +
</pre>
 +
3. [[X-Cart:Extra_Fields#Creating_extra_fields | Create the Extra Field]] that would correspond with the "google_product_category" attribute to be included in your product feed.
  
 +
4. [[X-Cart:Extra_Fields#Assigning_Values_to_Extra_Fields | Assign values]] to the Extra Field that would correspond with the "google_product_category" attribute for your products.
 +
 +
 +
==See also==
 +
 +
* [http://www.google.com/support/merchants/bin/answer.py?answer=188494&hl=en Products Feed Specification]
 
* [http://www.google.com/support/merchants/bin/answer.py?answer=160161&hl=en Unique Product Identifiers]
 
* [http://www.google.com/support/merchants/bin/answer.py?answer=160161&hl=en Unique Product Identifiers]
 
* [http://www.google.com/support/merchants/bin/answer.py?answer=160602&hl=en Defining Custom Attributes]
 
* [http://www.google.com/support/merchants/bin/answer.py?answer=160602&hl=en Defining Custom Attributes]
* [http://www.google.com/support/merchants/bin/answer.py?answer=188494&hl=en Products Feed Specification]
 
  
 +
[[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 user manual]]
 
[[Category:X-Cart modules]]
 
[[Category:X-Cart modules]]
Line 235: Line 299:
 
[[Category:X-Cart modules]]
 
[[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 user manual]]
 
[[Category:X-Cart modules]]
 
[[Category:X-Cart modules]]

Revision as of 20:11, 22 September 2011

What Froogle/GoogleBase module does

X-Cart's Froogle/GoogleBase 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.

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 Froogle/GoogleBase 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.

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.

Roles in Froogle/Google Base module management

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

If you are an X-Cart 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).

Enabling and Configuring 'Froogle/Google Base'

To begin using the module enable Froogle/GoogleBase module (Administration menu->Modules). When the module is enabled, a section titled Froogle/GoogleBase options appears in General settings/Modules options.

Adjust the module settings via General settings/Modules options->Froogle/GoogleBase options:

Googlebase opts.gif

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 'Froogle/GoogleBase username' and 'Froogle/GoogleBase password' fields.

To set up an FTP account for use with Froogle/Google Base:
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).
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.

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 'Generate links to the HTTPS part of the 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.

5. Provide additional instructions explaining your payment policies.

6. Specify, how many days the information about your products submitted to Froogle/GoogleBase needs to be considered up-to-date.

7. Click the Save button.

Using Froogle/GoogleBase Export

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.

2. Go to the 'Froogle/GoogleBase export' section of the store's back end:

a) Open the 'Import/export data' section of the store's back end.
  • (If you are an X-Cart GOLD administrator/provider or an X-Cart PRO administrator): Click on Import/Export in the Administration menu.
  • (If you are an X-Cart PRO provider): Click on Import/Export in the Products menu.
b) Click the 'Froogle/GoogleBase export' link in the 'Import/export data' section menu.
You should see a dialog box titled 'Froogle/GoogleBase export'. 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):
Google base.gif

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 Froogle product feed file (The filename is defined by default as username.txt - based on the Froogle/GoogleBase username you specified in General settings->Froogle/GoogleBase options; 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.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 / 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.

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 Froogle/Google Base directly, click the Upload button.

Learn how to upload export files using FTP here: http://base.google.com/support/bin/topic.py?topic=2928

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:
  • "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 Froogle/GoogleBase.

FAQ

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

The below list shows attributes which are included in the Google/Froogle product feed by default, as well as correlation between the attributes and X-Cart data:

How do I include Unique Product Identifiers and Custom Attributes in the Google/Froogle product feed?

To include Unique Product Identifiers to your product feed for version 4.4.4

Since 4.4.4, it is possible to include unique product identifiers and custom attributes in the Google/Froogle product feed using Extra Fields.

Here is the list of unique product identifiers which can be added to your Google/Froogle product feed:

  • gtin
  • mpn
  • upc
  • ean
  • jan
  • isbn

Here is a brief guide to including unique product identifiers in a product feed by 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 would look like in case you need to include MPN and ISDN to your product feed.

Extra feilds.jpeg

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

To include Unique Product Identifiers and Custom Attributes to your product feed for version 4.4.3 and earlier

Here is a brief guide to including unique product identifiers and custom attributes in a product feed by the example of MPN, ISBN and Custom Attribute:

1. Apply the changes described in the File:Froogle patch.diff patch to the file <xcart_dir>/modules/Froogle/froogle.php

Having the patch applied, you then will be able to add different types of unique product identifiers, as well as one custom attribute to your product feed using Extra Fields functionality (see step 2).

Here is the list of unique product identifiers that is added by the patch:

  • gtin
  • mpn
  • upc
  • ean
  • jan
  • isbn

2. Create the Extra Fields that would correspond with the additional attributes to be included in your product feed.

Here is what Extra Fields would look like in case you need to include "mpn", "isbn" and a custom attribute "c:custom_attr" to your product feed.

Extra feilds.jpeg


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

4. If you need to add more custom attributes to your product feed, for example "c:store_department:string":

a) Create a new Extra Field having an unique Service Name, for example: "store_department".

b) Add a new element into the $default_additional_attributes array as follows:

$default_additional_attributes = array(
"gtin" => "gtin",
"mpn" => "mpn",
"upc" => "upc",
"ean" => "ean",
"jan" => "jan",
"isbn" => "isbn",
"c:custom_attr" => "custom_attr",
"c:store_department:string" => "store_department"

where:

  • "c:store_department:string" - name of the attribute, as set according to Defining Custom Attributes.
  • "store_department" - service name, set for the respective Extra Field.

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

Since 4.4.4, it is possible to include additional attributes in the Google/Froogle product feed using Extra Fields.

Here is an example how to add "google_product_category" attribute to your product feed:

1. In <xcart_dir>/modules/Froogle/config.php file, find this code:

$froogle_additional_attributes = array(
    "gtin", 
    "mpn", 
    "upc", 
    "ean", 
    "jan", 
    "isbn", 
    "c:custom_attr",
);

2. Modify the code as follows:

$froogle_additional_attributes = array(
    "gtin", 
    "mpn", 
    "upc", 
    "ean", 
    "jan", 
    "isbn", 
    "c:custom_attr",
    "google_product_category",
);

3. Create the Extra Field that would correspond with the "google_product_category" attribute to be included in your product feed.

4. Assign values to the Extra Field that would correspond with the "google_product_category" attribute for your products.


See also