Google Shopping Feed & Live Checkout Pricing

Google Shopping Feed & Live Checkout Pricing

Google Shopping Ads require people that run advertising to provide a shipping price for each of their products when they upload their SKU list into their platform.

They do this so that people can't list their product for a lower price to make the advert more attractive, but then charge higher shipping to make up for it later.

If you provide inaccurate rates to Google Shopping, and they do check, then your adverts can be blocked or banned.

The Problem

If you're offering free shipping, or a simple flat rate, then giving Google your freight rates is easy.
But, if you move to a live rate system where you're dynamically generating your freight costs based on the product and all your available carriers - such as using a Machship Live Pricing integration - then it becomes more challenging as every single product has a different shipping price to every postcode, and these prices are changing whenever your rates change.

The Solution

The solution to this issue is to use the Machship Bulk Quote Report function.
This report allows you to update a spreadsheet, where each line contains:
  1. From Location
  2. To Location
  3. Items
It will then produce an output file for you that includes the cheapest price you have available across all your carriers and services.
To generate a file for your use case, you would need to:
  1. Generate a template from with your FROM warehouse, and a TO Location in every zone
  2. Replicate these lines for every SKU you offer
If you had 500 zones, and 1,000 products, then your sheet would end up with 500,000 rows.

This can be uploaded to Machship, ideally outside of business hours, and the output with be a rate table you could upload to Google Shopping for your products.

For more information on how to use the Bulk Quote Report, see our help article here:
    • Related Articles

    • Live Pricing - Packing Rules

      In the below video we cover the packing rules available in live pricing integrations in depth, and cover the pros cons and features of the available methods. Underneath the video, the data has been summarised should you wish to read instead. 1:50 - ...
    • Live Pricing - Overview

      In this video I discuss in-depth how live pricing integrations work and the options and features that are available. This data that is contained in this video applies to the in-house integrations we offer at MachShip. 0:00 - 1:50 - Overview & Live ...
    • Live Pricing - Carrier Grouping

      Background When a client reaches the checkout, the items in the users cart, as well as their location are sent to us to quote against the carriers in your Machship account. Rather than showing customers all of the potential carriers, services and ...
    • [Woocommerce] Client - How to Edit Product Dimensions for Live Rates

      How to Edit Product Dimensions for Live Rates Login to your website and go to Products > All Products Select a product to edit Under Product Quote Settings Customisation, supply the correct dimensions accordingly. You also need to add dimensions to ...
    • Shopify Integration Demo

      In this video we cover an end to end demo of our live pricing and order syncing integrations for Shopify. Below this video will be links to further articles that cover some of the topics mentioned in further detail. In order in install third party ...