Google Trusted Stores program

[DML73]

Google Trusted Stores program has officially been launched. Since this is a brand new program I suppose there is no available add-on module for this (yet)?

The integration details are here:

http://support.google.com/trustedsto...answer=2609862

Thought it could be an interesting module to make.

[BlessIsaacola]

This link: https://support.google.com/trustedst...9888&ctx=topic provides detail information on what needs to happen. It would be great if someone can provide a mod to pass the values needed to make this happen.

Thanks!

[Picturemom]

Has anyone had any luck with this? I am far from a programmer and have not been able to find much information on how to do this. The "for dummies" version of specifically how to integrate this code would really be helpful.

[DML73]

Has anyone had any luck with this? I am far from a programmer and have not been able to find much information on how to do this. The "for dummies" version of specifically how to integrate this code would really be helpful.

The integration information is located at the links above. If you/we are not a programmer(s) then I think its not easily done.
So.. we can just start learning how to program or hope some of the brilliant brains here can find time and interest to create a module at some point

[wisehoot]

I have installed the Google Trusted Stores Badge Code by adding the JavaScript to html_header.php and it is working fine.
The problem is with the Order Confirmation Module Code:
I added the code at the end of tpl_checkout_success_default.php, which I customized by adding a couple of lines to pass the variables required in the Order Confirmation module:
$MERCHANT_ORDER_ID = $zv_orders_id;
$ITEM_NAME = $notifications['products_name'];
Those are the only two variables that i can pass since they are already declared in that page.
I guess one could run a query like the one in admin/invoice.php that looks like this:
<?php
$order_check = $db->Execute("select cc_cvv, customers_name, customers_company, customers_street_address,
customers_suburb, customers_city, customers_postcode,
customers_state, customers_country, customers_telephone,
customers_email_address, customers_address_format_id, delivery_name,
delivery_company, delivery_street_address, delivery_suburb,
delivery_city, delivery_postcode, delivery_state, delivery_country,
delivery_address_format_id, billing_name, billing_company,
billing_street_address, billing_suburb, billing_city, billing_postcode,
billing_state, billing_country, billing_address_format_id,
payment_method, cc_type, cc_owner, cc_number, cc_expires, currency,
currency_value, date_purchased, orders_status, last_modified
from " . TABLE_ORDERS . "
where orders_id = '" . (int)$oID . "'");

the problem is I have tried unsuccessfully to run that query from the page tpl_checkout_success_default.php, since there are some "require" pages that point to the /admin directory.
Anyone can help to finish this task?

[wisehoot]

This link: https://support.google.com/trustedst...9888&ctx=topic provides detail information on what needs to happen. It would be great if someone can provide a mod to pass the values needed to make this happen.

Thanks!

This is what I've done so far. It works fine:
adding to the end of MY_TEMPLATES/TEMPLATES/tpl_checkout_success_default.php

<!-- MY CODE-->
<?php
$MERCHANT_ORDER_ID = $zv_orders_id;
global $db;
/**$sql = "select * from " . TABLE_ORDERS . " where orders_id = $zv_orders_id";*/
$sql = "SELECT . TABLE_ORDERS .*, . TABLE_ORDERS_PRODUCTS.*\n"
. "FROM " . TABLE_ORDERS . " INNER JOIN . TABLE_ORDERS_PRODUCTS. ON . TABLE_ORDERS .orders_id = . TABLE_ORDERS_PRODUCTS.orders_id\n"
. "WHERE (((. TABLE_ORDERS . orders_id)=$zv_orders_id)) LIMIT 0, 30 ";
$result = $db->Execute($sql);


if ($result->RecordCount() > 0) {
$CUSTOMER_EMAIL = $result->fields['customers_email_address'];
$ORDER_TOTAL= $result->fields['order_total'];
$ORDER_SHIPPING = '0';
$ORDER_TAX = $result->fields['order_tax'];
$ORDER_EST_SHIP_DATE = mktime(0,0,0,date("m"),date("d")+10,date("Y"));
$ITEM_PRICE = $result->fields['products_price'];


$ITEM_QUANTITY = $result->fields['products_quantity'];


} else {
echo 'Sorry, no record found for product number ' . $theProductId;
}
====================
DO NOT USE THIS CODE, SINCE THE TABLE NAMES MIGHT BE REFERENCED WRONG. I use the real name of tables in my query.

Hope this gives some ideas to those interested.
Thanks
wisehoot

[ThePhish]

This is what I've done so far. It works fine:
adding to the end of MY_TEMPLATES/TEMPLATES/tpl_checkout_success_default.php

<!-- MY CODE-->
<?php
$MERCHANT_ORDER_ID = $zv_orders_id;
global $db;
/**$sql = "select * from " . TABLE_ORDERS . " where orders_id = $zv_orders_id";*/
$sql = "SELECT . TABLE_ORDERS .*, . TABLE_ORDERS_PRODUCTS.*\n"
. "FROM " . TABLE_ORDERS . " INNER JOIN . TABLE_ORDERS_PRODUCTS. ON . TABLE_ORDERS .orders_id = . TABLE_ORDERS_PRODUCTS.orders_id\n"
. "WHERE (((. TABLE_ORDERS . orders_id)=$zv_orders_id)) LIMIT 0, 30 ";
$result = $db->Execute($sql);


if ($result->RecordCount() > 0) {
$CUSTOMER_EMAIL = $result->fields['customers_email_address'];
$ORDER_TOTAL= $result->fields['order_total'];
$ORDER_SHIPPING = '0';
$ORDER_TAX = $result->fields['order_tax'];
$ORDER_EST_SHIP_DATE = mktime(0,0,0,date("m"),date("d")+10,date("Y"));
$ITEM_PRICE = $result->fields['products_price'];


$ITEM_QUANTITY = $result->fields['products_quantity'];


} else {
echo 'Sorry, no record found for product number ' . $theProductId;
}
====================
DO NOT USE THIS CODE, SINCE THE TABLE NAMES MIGHT BE REFERENCED WRONG. I use the real name of tables in my query.

Hope this gives some ideas to those interested.
Thanks
wisehoot

Well , I've gotten to the point where I need to create a feed for my shipping and cancellation ... I've searched high and low , this is the best info I've gotten , unfortunately for me it is beyond my capacity to understand.

Have most developers gone away from zen cart because of theres no easy way to create a feed for the required data for google ?

I enter the shipping information manually to the customers via the update order status comment box ...

I just don't understand how to create the right feeds.

Have developers been abandoning google for this reason ( their slogan don't be evil is quit contradicting as this has made the shopping tab painful for developers and customers alike )

All I want to do is drive traffic to my store The business model would work if they had henchman of coders around to supplement the gimps around here with the code and tutorials ...

Maybe it's easier than I think and theres some magical module I am missing ????

[ThePhish]

Any thoughts out there ? About to dump zen cart because theres no shipping feed or customer order feed mods available for google shopping requirement.

Only the largest populated popular shopping web search outlet in the world.........



It's been fun guys , such a great cart for so many things... Just don't think I can wait for it to catch up to the rest of the world..

Maybe google shopping doesn't get the traffic I would want anyway , but something tells me other wise according to Google statistics.

[divinelighting]

If it is "beyond your capacity to understand" then you could hire a developer here to help you out. You also could probably modify a different feed program like Easy Populate to send post sale data to google.

[Stuff4Toys]

Just signed up for "Google Trusted Stores" and when I cut n pasted the Java Script into a text banner or the main_page_define nothing shows up.

There are several variables that it looks like they are looking for, but have to be keyed to the merchant center account.

Has anyone written a mod or sidebox to utilize the code?

JOhn ><>