Google Trusted Stores

[agenius]

has anyone implemented the trusted stores badge and order information into the backend? Just starting to try to develop code for the order info area and not sure what the best way to go about it would be.
Thanks

[nottheusual1]

Re: Google Trusted Stores

Busiest site drop ships from about 25 manufacturers, and the shipping feed may be a real bear for us to manage right this minute, but we've been looking at it. The "details" needed on a product page are static or an available variable, so no problem.

Most of the variables needed for the order confirmation module "details" are available on the INVC page, so we'll populate them when the invoice page is generated.

The ORDER_EST_SHIP_DATE is a booger - we do store a "shipsin" custom field for how many business days it takes something to ship to show on the product page and the invoice (we have 15 different ranges) and use in an old "estimated delivery" javascript tool, now need to figure out whether we adapt the javascript or do it in the store somehow.

We've Emailed to ask about ORDER_DISCOUNTS, since that's rather nebulous. Our biggest "discount" is free ground shipping, but we have no idea what the value of free shipping is, customer-to-customer, but don't want to lose any "google goodness" because we can't reflect it.

That's where we are - not sure if this helps, so ask and I'll tell you anything I know.

[agenius]

Re: Google Trusted Stores

I got it on the invc main page using toolkits "order" function. using estimated ship date, today plus 4 by searching these forums.
Thanks

[agarvey]

Re: Google Trusted Stores

Can you enlighten me on how to use the order function in the toolkit for this purpose.

i want to grab:
order discounts
order shipping
order tax

And if possible
Estimated ship date (though I think I will have to use javascript or something else in order to get this)

I looked at the instructions:
Use order to retrieve values for several order variables on the invoice page, template emails, picklist, etc. The variables are: ordercount, orderweight, ordersubtotal, ordersubtotalF, orderother, orderotherF, ordershipping, ordershippingF, ordertax, ordertaxF, ordertotal, and ordertotalF. The 2nd parameter is a variable that you want to save the item count to. The 3rd parameter is the order id passed as a variable. That variable may be different on some pages, e.g. l.order:id, order:id, l.all_settings:order:id, l.all_settings:ordershipment:order:id, or even l.order_id.

 <mvt:item name="toolkit" param="order|ocount|l.all_settings:order:id" />
&mvte:toolkit:ordertotal;

I tried inserting this into the INVOICE page but it came up as empty. Before I try to use the variable that may be different on some pages, can someone tell me what the variable should be?

Thanks for your help.

[agenius]

Re: Google Trusted Stores

we are still awaiting google approval, but in short used toolkit functions for setting shipping 4 days ahead, and some other function like this on order contents tab of invc.

  <span id="gts-o-shipping-total"><mvt:item name="toolkit" param="order|ocount|l.all_settings:order:id" />
&mvte:toolkit:ordershipping;</span>
  <span id="gts-o-tax-total">&mvte:toolkit:ordertax;</span>
  <span id="gts-o-est-ship-date"><mvt:item name="toolkit" param="set_time_zone|our_time|92" />
<mvt:item name="toolkit" param="time_t_year|nyear|our_time" />
<mvt:item name="toolkit" param="time_t_month|nmonth|our_time" />
<mvt:item name="toolkit" param="time_t_dayofmonth|ndayofmonth|our_time" />
 
<mvt:item name="toolkit" param="sassign|usdate|%month%/%day%/%year%" />
<mvt:item name="toolkit" param="vglosub|usdate,%day%,ndayofmonth" />
<mvt:item name="toolkit" param="vglosub|usdate,%month%,nmonth" />
<mvt:item name="toolkit" param="vglosub|usdate,%year%,nyear" />
&mvt:global:usdate;</span>

[Manoj]

Re: Google Trusted Stores

Does any one have ideas on how to implement Orders Cancellation, & Shipping Feed

It would be great if we could use the data from Sebenza Ultimate Order Status module or maybe a simple toolkit page pulling the data

[Manoj]

Re: Google Trusted Stores

Have you setup the feed? if so how?

[agarvey]

Re: Google Trusted Stores

Just so that people have it here is what I did to start the process. I am still having a couple of issues:
1) How do I get the price to not be formatted for the item level details. I have &mvt:item:formatted_price;, which displays the right price, but it has the $ in it. Google doesn't want that
2) Our google shopping id is our item code - option code (this tells size). &mvt:item:code; - &mvt:option:opt_code; is what I put in there, but it displays another option. Does anyone know if the group_id that google requires in google shopping would be ok to put in here?

<!--get discount total stored in global variable difference3-->
<mvt:item name="toolkit" param="order|ocount|l.all_settings:order:id" />
<mvt:item name="toolkit" param="math_subtract|difference|l.all_settings:too lkit:ordertotal|l.all_settings:toolkit:ordershippi ng" />
<mvt:item name="toolkit" param="math_subtract|difference2|g.difference|l.al l_settings:toolkit:ordersubtotal" />
<mvt:item name="toolkit" param="math_subtract|difference3|g.difference2|l.a ll_settings:toolkit:ordertax" />

<!--Ship Date: find out what today is. If Friday or Saturday, adjust the ship date. Stored in variable usdate-->
<mvt:item name="toolkit" param="set_time_zone|current_time|-4" />
<mvt:item name="toolkit" param="time_t_dayofweek|ndayofweek|current_time" />
<mvt:if expr="g.ndayofweek EQ 5">
<mvt:item name="toolkit" param="set_time_zone|our_time|68" />
<mvt:elseif expr="g.ndayofweek EQ 6">
<mvt:item name="toolkit" param="set_time_zone|our_time|44" />
<mvt:else>
<mvt:item name="toolkit" param="set_time_zone|our_time|20" />
</mvt:if>

<mvt:item name="toolkit" param="time_t_year|nyear|our_time" />
<mvt:item name="toolkit" param="time_t_month|nmonth|our_time" />
<mvt:item name="toolkit" param="time_t_dayofmonth|ndayofmonth|our_time" />

<mvt:item name="toolkit" param="time_t_year|nyear|our_time" />
<mvt:item name="toolkit" param="time_t_month|nmonth|our_time" />
<mvt:item name="toolkit" param="time_t_dayofmonth|ndayofmonth|our_time" />

<mvt:item name="toolkit" param="sassign|usdate|%year%-%month%-%day%" />
<mvt:item name="toolkit" param="vglosub|usdate,%day%,ndayofmonth" />
<mvt:item name="toolkit" param="vglosub|usdate,%month%,nmonth" />
<mvt:item name="toolkit" param="vglosub|usdate,%year%,nyear" />

<!--get backordered items. Store in variable backorder-->
<mvt:item name="toolkit" param="sassign|backorder|N" />
<mvt:foreach iterator="item" array="order:items">
<mvt:if expr="NOT ISNULL l.settings:product:customfield_values:customfields :outofstockmessage">
<mvt:item name="toolkit" param="sassign|backorder|Y" />
</mvt:if>
</mvt:foreach>

Merchant order number &mvt:order:id; <br/>
Merchant order domain: yourdomainname.com <br />
Customer Email: &mvte:global:Basket:ship_email; <br />
Customer Country: &mvte:order:ship_cntry; <br />
Currency: USD <br/>
Order Total: &mvte:toolkit:ordertotal; <br />
Order Discounts : &mvt:global:difference3; <br />
Order Shipping: &mvte:toolkit:ordershipping; <br />
Order Tax: &mvte:toolkit:ordertax; <br />
Order Subtotal: &mvte:toolkit:ordersubtotal; <br />
Order Estimated Ship date: &mvt:global:usdate; <br />
Has Backorder: &mvt:global:backorder; <br />
Has Digital Goods: N <br />

<!--Give Item information-->
<mvt:foreach iterator="item" array="order:items">
item name: &mvt:item:name; <br />
item price: &mvt:item:formatted_price; <!--how to get this unformatted --><br />
item quantity: &mvt:item:quantity;<br />
item google shopping product search id: &mvt:item:code; - &mvt:option:opt_code; <!--not sure how to get this--><br />
</mvt:foreach>

[Manoj]

Re: Google Trusted Stores

For the price you can use <span class="gts-i-price">&mvt:item:price;</span>

[agarvey]

Re: Google Trusted Stores

I tried that, but it gave me 0. Not sure why--maybe it is an extension that I am using. We have the Attribute Prompt vs Code module installed--do you think that would cause the problem?

[alphabet]

Re: Google Trusted Stores

Make sure the module is assigned and installed on the INVC page the same way as the rest of the checkout pages.

[diana]

Re: Google Trusted Stores

Google Trusted Store > Invoice Page Test. Down to 2 errors & hoping someone can help.

1. Google Error: Incorrect number format: “gts-o-discounts” Required format: “-123.45”
Problem: Error if there is no discount. Instead of "0" it displays Discounts:0.00000000000000222045
Using Order Discounts : &mvt:global:difference3; (example in previous post above)

2. Google Error: Incorrect date format: “gts-o-est-ship-date” Required format: “YYYY-MM-DD”
Problem: toolkit format is d/mm/yy
Using toolkit's "dynamicattributebasket" for shipping date which displays in basket, but google doesn't see it.

Also - No idea how to include other ship dates from custom field "baskmessage", as google is not seeing the info in the basket.
I had to add the code directly in the google script below.

<!-- START Trusted Stores Order -->
<div id="gts-order" style="display:none;">
<!-- start order and merchant information -->
<span id="gts-o-id">&mvt:order:id;</span>
<span id="gts-o-domain">###</span>
<span id="gts-o-email">&mvte:global:Basket:ship_email;</span>
<span id="gts-o-country">&mvte:order:ship_cntry;</span>
<span id="gts-o-currency">USD</span>
<span id="gts-o-total">&mvte:order:total;</span>
<!--get discount total stored in global variable difference3-->
<span id="gts-o-discounts"><mvt:item name="toolkit" param="order|ocount|l.all_settings:order:id" />
<mvt:item name="toolkit" param="math_subtract|difference|l.all_settings:toolkit:ordertotal|l.all_settings:toolkit:ordershipping" />
<mvt:item name="toolkit" param="math_subtract|difference2|g.difference|l.all_settings:toolkit:ordersubtotal" />
<mvt:item name="toolkit" param="math_subtract|difference3|g.difference2|l.all_settings:toolkit:ordertax" />&mvt:global:difference3;</span>
<span id="gts-o-shipping-total">&mvte:toolkit:ordershipping;</span>
<span id="gts-o-tax-total">&mvte:toolkit:ordertax;</span>
<span id="gts-o-est-ship-date"><mvt:if expr="NOT ISNULL l.settings:product:customfield_values:customfields:baskmessage">&mvt:product:customfield_values:customfields:baskmessage;
<mvt:else> 
<mvt:item name="toolkit" param="set_time_zone|our_time|92" />
<mvt:item name="toolkit" param="time_t_year|nyear|our_time" />
<mvt:item name="toolkit" param="time_t_month|nmonth|our_time" />
<mvt:item name="toolkit" param="time_t_dayofmonth|ndayofmonth|our_time" /> 
<mvt:item name="toolkit" param="sassign|usdate|%month%/%day%/%year%" />
<mvt:item name="toolkit" param="vglosub|usdate,%day%,ndayofmonth" />
<mvt:item name="toolkit" param="vglosub|usdate,%month%,nmonth" />
<mvt:item name="toolkit" param="vglosub|usdate,%year%,nyear" />&mvt:global:usdate;</mvt:if>
</span>
<span id="gts-o-has-preorder">&mvt:global:backorder;</span>
<span id="gts-o-has-digital">N</span>
<!-- end order and merchant information -->
<!-- start repeated item specific information -->
<!-- item example: this area repeated for each item in the order -->
<span class="gts-item">
<span class="gts-i-name">&mvt:item:name;</span>
<span class="gts-i-price">&mvt:item:price;</span>
<span class="gts-i-quantity">&mvt:item:quantity;</span>
<span class="gts-i-prodsearch-id">&mvt:item:code;</span>
<span class="gts-i-prodsearch-store-id">###</span>
<span class="gts-i-prodsearch-country">US</span>
<span class="gts-i-prodsearch-language">EN</span>
</span>
<!-- end item 1 example -->
<!-- end repeated item specific information -->
</div>
<!-- END Trusted Stores -->

[wcw]

Re: Google Trusted Stores

Change
<mvt:item name="toolkit" param="sassign|usdate|%month%/%day%/%year%" />
to
<mvt:item name="toolkit" param="sassign|usdate|%year%-%month%-%day%/" />

Then lookup the padl function in the tool kit. You can add a 0 to the left of the number if it is not long enough. So you can turn 8 into 08 for the MM or DD format. You would do that before the line above so that the vglosub would replace the %month% token with 08 instead of 8.

[diana]

Re: Google Trusted Stores

Thank you Bill! Just 1 error left...
Any idea why the formula below creates Discounts:0.00000000000000222045 instead of just "0" when there is no discount?
Any idea on a solution? Thank you again.

<mvt:item name="toolkit" param="order|ocount|l.all_settings:order:id" />
<mvt:item name="toolkit" param="math_subtract|difference|l.all_settings:too lkit:ordertotal|l.all_settings:toolkit:ordershippi ng" />
<mvt:item name="toolkit" param="math_subtract|difference2|g.difference|l.al l_settings:toolkit:ordersubtotal" />
<mvt:item name="toolkit" aram="math_subtract|difference3|g.difference2|l.al l_settings:toolkit:ordertax" />&mvt:global:difference3;

[wcw]

Re: Google Trusted Stores

I added some lines to the example to get YYYY-MM-DD format. See #140 at http://www.emporiumplus.com/1AA00223.html