Ecommerce developers with Magento

I haven’t been able to find this out either way, but if you are using Configurable Products – do you have to submit the Configurable and Simple Products or just the Configurable Products?

At the moment I am just submitting all products as it is difficult to quickly submit just the Configurable Products.

I don’t think it sends a price when you submit Grouped or Configurable products. Have you successfully used this for Grouped/Config items?

I con’t get it to work! Why it’s so complicated?

I followed all of the steps for the first known issue but continue to receive the error when I try to add my products in Google Base > Manage Items. What could I be doing wrong? To start, I have only added condition and price as attributes. Do I have to add more?

Expected response code 200, got 400. Type: data. Field: condition. Reason: The item is missing a required attribute.

@David,

I’ve seen your e-mail, you probably missed this step:

“Step 2: Go to Catalog > Attributes > Manage Attribute Sets and drag the attribute “Condition” from the right column to the appropriate place in the left column. Make sure you have dragged it into the attribute set you’re using with Google Base if you have more then one attribute set defined.”

Great!

I just followed your guide and did a test product and finally managed to get it up on GoogleBase!

Is there a way of making the default option “YES” as it doesn’t seem to do that in my store?

Hi Toni

I tried that to no avail. For some reason i have to go in and set each product up as the default is blank, Neither Used or New is selected.

@David,

You most likely don’t see it because you skipped the Step 2:

Step 2: Go to Catalog > Attributes > Manage Attribute Sets and drag the attribute “Condition” from the right column to the appropriate place in the left column. Make sure you have dragged it into the attribute set you’re using with Google Base if you have more then one attribute set defined.

Are you sure your products are using that attribute set? Because if they are, there is no reason why the new condition value wouldn’t appear in these products.

@David:

If you go to Catalog > Manage Products, you will see a row that defines which attribute set is each of the products using.

It is most likely your products are using default attribute set. If so, make sure you’ve dragged the condition attribute into the default attribute set.

Lovely Video quality from Magento you can’t even see anything.

@David: Try setting the field as required and default value to “New” and then go and rebuild the catalog.

Have you figured out a way to get the special price to map to the price attribute when submitting to Google Base? I’ve tried mapping ‘Special Price’ and ‘Minimal Price’ to ‘Price’ however none of those work.

I set the field as required and default value to “New” but all products still do not show as New. Does it make a difference if this setting is Global, website, etc?

Finally got the Magento/Base integration to work! Thanks for your help. Now the store wants to change prices on a number of products. How do I update my items in Google Base to reflect the changes in the shopping cart?

Great got it working. Thanks!!

Here are the queries from a PHP script I wrote :
SELECT entity_id FROM catalog_product_entity WHERE sku = ‘???’

The above query gets the entity_id from the product you need.

INSERT INTO catalog_product_entity_int (entity_type_id, attribute_id, store_id, entity_id, value) VALUES (4, 535, 0, ‘entity_id’, 312)

Here is the insert for the attribute value.
Description of fields:
entity_type_id : Always 4 in my system – this comes from the eav_entity_type table. You need to look for the record where entity_type_code is ‘catalog_product’ and take the id from there.

Attribute ID : Look in the table eav_attribute for the attribute you created. You can search on the attribute_code field for the name you gave when you created the attribute. Probably the last field in the table – take the attribute ID from there.

Store_id : Look in table core_store and take the store_id from the ADMIN store. Usually 0

Entity_id : From the product table (see the first query)

Value : The numerical value allocated to the attribute value. This one is a little more tricky to locate. First search the eav_attribute_option table on the attribute_id field and use the value for attribute_id as determined above. Make a note of the option_id values. Now search the eav_attribute_option_value table for those option_id values. The TEXT you entered for the possible values comes up in the value field. When you finf the right text, use the correct option_id.

I hope this guides you all but as always DONT fiddle unless you are SURE you know what you are doing and always TEST IT FIRST on a copy database.

Expected response code 200, got 400. Type: data. Field: description. Reason: Duplicate description

I attempted all the directions above and got the following message. I ran a test using just one product

Does anybody know why in Magento, when I try to add an Attribute Mapping for Google Base, the following error occurs:

Notice: Undefined offset: 1 in /home/loviecom/public_html/app/code/core/Mage/GoogleBase/Model/Service/Feed.php on line 120

@Toni…Thanks for your answer.

I have searched everywhere and I cannot see where the information is mapped per your response..” two different Magento’s attributes mapped to Google base’s description attribute”

Where can I search for where the atrributes are mapped

can anyone help with this url issue on google base ?___store=default ?

Toni – This is a great help to me.
I would never have got this working without your input.
Thanks for putting in your valuable time!
Best regards,
John

I was experiencing problems with products with no description. Google Base refuses to accept them.

I simply copied the file : /app/code/core/Mage/GoogleBase/Model/Service/Item.php
to: /app/code/local/Mage/GoogleBase/Model/Service/Item.php

and added these lines after:
if ($object->getDescription()) {
$content = $service->newContent()->setText( $object->getDescription() );
$entry->setContent($content);
}

I added:
else
{
$content = $service->newContent()->setText( $object->getName() );
$entry->setContent($content);
}

Change getName() to whichever attribute you want in the description.

In Magento Admin, select System -> Configuration -> Web

There’s a section for ‘Url Options’. Change this setting to No.

amazing thanks guys! will try this now

hi jenny
I get the same promble as you,”Expected response code 200, got 404. Type: request. Reason: Service not found.”,i don`t know why,If you have solves,please tell me,thank you,my email cawords66@yahoo.com