Overview
Products listings through Logicbroker, will create new product listings, update existing ones and re-list any expired listings.
For all products updated the listing will stay active for 30 days, to re-list or extend the time, you would need to update the product, to do this, it will require you to update from the primary feed on a regular cadence. For updates to pricing and quantity available, you can use the inventory process.
For setup and additional details see the following sections below:
Content Flow
Setup Process
Step 1: Create your Product Catalog
The first step is to create your product catalog in Logicbroker. This will be used to send all your content created and manged in Logicbroker to the Google Merchant Center.
Products can be added manually in the portal under Products > Product Catalog > New Item.
All the fields in the standard and any custom attributes created will be available through the portal.
Images can be uploaded and hosted in the LB system, once uploaded the URL will be provided to the channel or can be viewed by downloading the CSV/XLSX. If you need to provide your own hosted URL, it can be uploaded using the CSV Upload.
For CSV:
In the portal navigate to Products > Product Catalog > Click the Download button to get the CSV template and Upload your content with the column names as the fields.
For more details on the specification see this article. It is recommended to use as many defaulted system fields/attributes as possible. If you need to submit custom attributes specific to your products, see this article.
Step 2: Mapping your Catalog
Once your product catalog is created in Logicbroker, you can create a mapping to publish your catalog to Logicbroker's channels or retailers. Navigate to Products > Product Catalog > Click Send to Retailer
Creating New Products Using Primary Feed
If you do not have an existing content integration in the Google Merchant Center, you can create your products in Logicbroker and create them in Google Shopping, keeping your content in sync.
Google recommends using one primary feed for creating and updating products, as multiple feeds will overwrite your existing product data, therefore having one source will limit any overwriting issues.
Primary feeds are sent from Logicbroker by default, if no feedId is provided. Sending a new feed will overwrite product data for the SKUs sent, for example if you send your first feed with a Description value, then another one with Description empty, the second feed will overwrite the Description to an empty value.
Sending a primary feed will validate in Logicbroker to ensure you are providing all compliant information to create your products. On the Catalog Mapping and Export page you can use default mappings shared with you to leverage the Logicbroker catalog standard to Google's required fields; see Field Descriptions below for more details on the requirements.
Selecting the profile, will auto-populate common default mappings from the Product Catalog standard. You can edit, some mappings to include rules to properly map categories or other fields to match the Google Requirements. For example, in this case we are updating the Google Product Category, if the Logicbroker Category is "Clothing, Shoes, and Jewelry"
Once you update your mapping profile you can save it for future use. Click Save As and enter the profile name and it will be saved under your user. If you need to share across your organization, click Share.
Tip:
If you want to only process specific products, use the Product Filter to create a rule to export products that meet your specific condition. By default, Logicbroker will export all products that have a status Enabled.
Once complete Export to send your mapped catalog to Google.
Updating Existing Products using a Supplemental Feed
If you already have an existing content feed processing to the Google Merchant Center, used for Shopping Ads or other Google services, it is recommended to continue using it as your primary feed. You should then use a supplemental feed to update your products and destinations to activate your products for the different channels like Google Shopping Actions.
Supplemental feeds will update only the fields sent, without interrupting the existing data provided on the primary feed that it is linked to. For example, if your primary feed is only setup for Google Shopping Ads as your destination, you can add a supplemental feed to update destination to include Shopping Actions. When sending the supplemental feed with Shopping Actions, it will not overwrite the Shopping Ads destination (like the primary feed would) and will add the Shopping Actions destination.
It is recommended to use the supplemental feed through Logicbroker to control which products are activated for Google Shopping. Using the rule engine you can add or remove the products to properly list them
For more details on how the supplemental feed works see this article from Google.
To setup a new a supplemental feed follow these steps:
1. Login to Merchant Center > Products > Click Feeds
If you have a primary feed already created you will see it here.
2. Under Supplemental Feeds, click the ADD SUPPLEMENTAL FEED to add the feed.
Enter the feed name, select Content API and select the primary feed that will link to this supplemental feed.
Take the Feed ID provided by Google, this will be used when you map your product fields to google within Logicbroker.
3. Map your supplemental feed
Here you will select which products you will be sending to update and enable for Google Shopping Actions.
When creating your mapping, you will need to make sure you set the Feed ID that was created in the previous step; see the example below.
Step 3: Review and Send your Product Feed
Once exported, you will need to go to the Product Feeds page to review all your items that were exported.
On the product feed page you will see the latest feed that was exported in the New status. You will only be able to Send your product feed when all items are compliant. Here you can edit the items for the invalid fields processed, or correct your mapping in the previous step.
To edit your items click View on the latest feed.
Within the feed, click on the non-compliant products to edit and correct them.
Once all products are corrected and are compliant, you can then send your feed to Google.
Note:
Before processing your feed, all content must be pointed to the Production Google Environment. This can be found under Settings > Connections > Google Shopping Actions
Sending the feed will process through Google's Content API and your products will get created or update if you used a primary or supplemental feed. This can take up to 30 minutes to update in the Google Merchant Center.
Step 4: Google Content Moderation
Once your feed is processed into the Google Merchant Center, Google will run through it's own content moderation process to validate your products are ready to be listed.
To view your products, in the Merchant Center click Products > All Products
You can review the status for all you products sent here, and clicking into each individual product will provide you details on why your product was not approved.
Here you can see the details, in this case the setup was not complete for Shopping Actions. You can follow the link to correct any shopping actions setup issues.
Setup Tips
When creating your products a lot of the data that is processed when listing your products in Shopping Actions can be done by default in the Shopping Actions setup within the Merchant Center. This allows you to apply tax, shipping and return settings on your products when importing.
- Tax Settings: you can setup your default tax rates that you charge your customers. This can be setup per state or locality, flat rate, or based on a product tax category. This will enable you to automatically apply a tax rate to your products, avoiding per product configuration. For more information see this article.
- Shipping Settings: you can setup default settings for different shipping services, delivery times, rates and costs automatically when creating your products. When setting this up, you won't have to provide those details on the individual product when creating them. For more information see this article.
- Return Settings: you can setup your default return policy for all your products or for specific product groups. This will allow you to automatically apply those policies when your products are imported. For more information see this article.
Field Descriptions
Listed below are all the fields that will map to you Google Merchant Center Product Feed. Also, included are the recommended maps to the Logicbroker standard catalog. For more information on the product feed specifications from Google, see this article.
Google Field |
Google Friendly Name |
Recommended Catalog Field |
Description |
Additional Notes |
Requirement |
offerId |
Offer ID (SKU) |
sku |
Use a unique value for each product. Use the product's SKU where possible Offer ID (SKU) must have length less than 51. |
Required for both primary and supplemental feeds. |
Required |
title |
Title |
name |
The name of the product Title is required for primary feed. Title must have length less than 151. |
Not required if sending a supplemental feed. |
Required |
description |
Description |
description |
Use formatting (for example, line breaks, lists, or italics) to format your description Description must have length less than 5000. Description is required for primary feed. |
Not required if sending a supplemental feed. |
Required |
link |
Link |
product_url |
The landing page for the product. Start with http or https Not a valid URL |
Optional |
|
mobileLink |
Mobile Link |
mobile_url |
The landing page for the product. Start with http or https Not a valid URL |
Optional |
|
imageLink |
Image Link |
image |
The URL of the product's main image. Start with http or https Not a valid URL; must begin with HTTP or HTTPS Image Link is required for primary feed. |
Not required if sending a supplemental feed. |
Required |
additionalImageLink_1 |
Additional Image Link 1 |
image2 |
The URL of an additional product image. Start with http or https Not a valid URL; must begin with HTTP or HTTPS |
Optional |
|
additionalImageLink_2 |
Additional Image Link 2 |
N/A |
The URL of an additional product image. Start with http or https Not a valid URL; must begin with HTTP or HTTPS |
Optional |
|
additionalImageLink_3 |
Additional Image Link 3 |
N/A |
The URL of an additional product image. Start with http or https Not a valid URL; must begin with HTTP or HTTPS |
Optional |
|
additionalImageLink_4 |
Additional Image Link 4 |
N/A |
The URL of an additional product image. Start with http or https Not a valid URL; must begin with HTTP or HTTPS |
Optional |
|
additionalImageLink_5 |
Additional Image Link 5 |
N/A |
The URL of an additional product image. Start with http or https Not a valid URL; must begin with HTTP or HTTPS |
Optional |
|
additionalImageLink_6 |
Additional Image Link 6 |
N/A |
The URL of an additional product image. Start with http or https Not a valid URL; must begin with HTTP or HTTPS |
Optional |
|
additionalImageLink_7 |
Additional Image Link 7 |
N/A |
The URL of an additional product image. Start with http or https Not a valid URL; must begin with HTTP or HTTPS |
Optional |
|
additionalImageLink_8 |
Additional Image Link 8 |
N/A |
The URL of an additional product image. Start with http or https Not a valid URL; must begin with HTTP or HTTPS |
Optional |
|
additionalImageLink_9 |
Additional Image Link 9 |
N/A |
The URL of an additional product image. Start with http or https Not a valid URL; must begin with HTTP or HTTPS |
Optional |
|
availability |
Availability |
N/A |
Indicate whether product is in stock, out of stock, or preorder Supported values are "in stock", "out of stock", and "preorder" Availability is required for primary feed. |
Not required if sending a supplemental feed. Must default with a mapping rule if pulling from catalog. |
Required |
availabilityDate |
Availability Date |
N/A |
Use this attribute if you submit availability as "preorder". Must be ISO 8601 format, e.g. 2016-02-24T11:07:31+0100 Availability Date must have length less than 26. Must provide Availability Date if availability is set to "preorder" Must be in ISO8601 format, e.g. 2016-02-24T11:07:31+0100 |
Optional |
|
expirationDate |
Expiration Date |
N/A |
Date when product will stop being availaibe. Must be ISO 8601 format, e.g. 2016-02-24T11:07:31+0100 Expiration Date must have length less than 26. Must be in ISO8601 format, e.g. 2016-02-24T11:07:31+0100 |
Optional |
|
priceValue |
Price |
price |
The numerical value of the price Price is required for primary feed. Value must be a decimal. |
Not required if sending a supplemental feed. |
Required |
priceCurrency |
Price Currency |
currency |
Need to provide a valid ISO 4217 currency code. Need to provide a valid ISO 4217 currency code. Price Currency is required for primary feed. |
Not required if sending a supplemental feed. |
Required |
salePriceValue |
Sale Price |
sale_price |
Price when product is on sale Value must be a decimal. |
Optional |
|
salePriceCurrency |
Sales Price Currency |
currency |
Need to provide a valid ISO 4217 currency code. Need to provide a valid ISO 4217 currency code. salePriceCurrency is required when salePriceValue is provided. |
Optional |
|
salePriceEffectiveDate |
Sales Price Effective Date |
sale_price_effective_date |
Dates when product is on sale. Includes a start and end range seperated by "/" e.g. 2016-02-24T11:07:31+0100 / 2016-02-29T23:07:31+0100 |
Optional |
|
unitPricingMeasureValue |
UOM Value |
uom_value |
The measure and dimension of your product as it is sold Value must be a decimal. |
Optional |
|
unitPricingMeasureUnit |
UOM |
unit_of_measure |
Required UOM values include - oz,lb,mg,g,kg,floz,pt,qt,gal,ml,cl,l,cbm,in,ft,yd,cm,m,sqft,sqm,ct UOM must be one of these options: oz, lb, mg, g, kg, floz, pt, qt, gal, ml, cl, l, cbm, in, ft, yd, cm, m, sqft, sqm, ct. |
Optional |
|
googleProductCategory |
Google Product Category |
subcategory |
Value from the Google product taxonomy, either the numerical category ID or the full path to the category, e.g. Apparel & Accessories > Clothing > Outerwear > Coats & Jackets For a list of valid taxonomies visit https://support.google.com/merchants/answer/1705911 Google Product Category is required for primary feed. |
Not required if sending a supplemental feed. |
Required |
productType |
Product Type |
product_type |
Use the product_type attribute to include your own product categorization system in your product data. Unlike the google_product_category attribute, you choose which value to include. The values you submit for product_type can be used to organize the bidding and reporting in your Google Ads Shopping campaign. Product Type must have length less than 751. |
Optional |
|
brand |
Brand Name |
brand |
Your product’s brand name Required (For all new products, except movies, books, and musical recording brands) Brand Name must have length less than 71. |
Optional |
|
gtin |
GTIN |
gtin |
Global Trade Item Number, UPC, EAN, JAN, or ISBN GTIN must have length less than 51. Required if MPN is not provided. |
Required if no MPN is provided. |
Conditional |
mpn |
MPN |
mpn |
Manufacturer Part Number: use most specific MPN possible MPN must have length less than 71. Required if gtin is missing. |
Required if no GTIN is provided. |
Conditional |
identifierExists |
Identifier Exists? |
N/A |
Use to indicate whether or not the unique product identifiers (UPIs) GTIN, MPN, and brand. Select "no" if MPN is used over GTIN are available for your product. Identifier Exists? must be one of these options: yes, no. |
Optional |
|
condition |
Condition |
condition |
The condition of your product at time of sale Supported values are "new", "refurbished", and "used" |
Optional |
|
adult |
Adult Product? |
adult_product |
Indicate a product includes sexually suggestive content Adult Product? must be one of these options: yes, no. |
Optional |
|
multipack |
MultiPack Count |
multipack |
The number of identical products sold within a merchant-defined multipack Value must be an integer. |
Optional |
|
isBundle |
Is Bundle? |
is_bundle |
Indicates a product is a merchant-defined custom group of different products featuring one main product Is Bundle? must be one of these options: yes, no. |
Optional |
|
ageGroup |
Age Group |
age_group |
The demographic for which your product is intended Supported values are "newborn", "infant", "toddler", "kids", and "adult" Required if product category is Apparel. |
Optional |
|
color |
Color |
color |
Your product’s color(s) Color must have length less than 101. Required when Apparel is provided. |
Optional |
|
gender |
Gender |
gender |
The gender for which your product is intended Supported values are "male", "female", and "unisex" Required for apparel items. |
Optional |
|
material |
Material |
material |
Your product’s fabric or material Material must have length less than 201. |
Optional |
|
pattern |
Pattern |
pattern |
Your product’s pattern or graphic print, e.g. striped Pattern must have length less than 101. |
Optional |
|
sizes |
Sizes |
size |
Comma separated list of sizes Sizes must have length less than 101. Required if Shoes are provided |
Optional |
|
sizeType |
Size Type |
size_type |
The cut of the item. Recommended for apparel items. Size Type must be one of these options: big and tall, maternity, oversize, petite, plus, regular. |
Optional |
|
sizeSystem |
Size System |
size_country |
The country of the size system used by your product Size System must be one of these options: AU, US, UK, EU, DE, FR, JP, CN, IT, BR, MEX. |
Optional |
|
itemGroupId |
Item Group ID |
parent_sku |
Used when a product has a variant. A parent SKU must be used when the following mutliple attributes are used: color, size, pattern, material, age group, gender Item Group ID must have length less than 51. |
Optional |
|
shippingPriceValue |
Shipping Cost |
shipping |
Your product's shipping cost Value must be a decimal. |
Can be setup as a default calculation in Google Merchant Cener |
Optional |
shippingPriceCurrency |
Shipping Cost Currency |
currency |
Currency associated with the shipping cost. Shipping Cost Currency must be one of these options: USD, EUR, JPY, GBP, AUD, CAD. shippingPriceCurrency is required if shippingPriceValue is provided. |
Can be setup as a default calculation in Google Merchant Cener |
Optional |
shippingLabel |
Shipping Label |
N/A |
Use a value that you'll recognize in your account shipping settings, e.g. Sameday Oversize Only FedEx Shipping Label must have length less than 101. |
Optional |
|
shippingWeightValue |
Shipping Weight |
shipping_weight |
Total weight used to calculate shipping cost. Value must be a decimal. |
Optional |
|
shippingWeightUnit |
Shipping Weight UOM |
shipping_weight_uom |
Unit of measure associated with the shipping weight Shipping Weight UOM must be one of these options: lb, oz, g, kg. Required if shippingWeightValue is provided. |
Optional |
|
shippingLengthValue |
Shipping Length |
shipping_length |
Length used to calculate shipping cost. Value must be a decimal. |
Optional |
|
shippingWidthValue |
Shipping Width |
shipping_width |
Width used to calculate shipping cost. Value must be a decimal. |
Optional |
|
shippingHeightValue |
Shipping Height |
shipping_height |
Height used to calculate shipping cost. Value must be a decimal. |
Optional |
|
shippingLengthUnit |
Shipping Length UOM |
shipping_dim_uom |
Shipping dimensional unit of measure Shipping Length UOM must be one of these options: in, cm. shippingLengthUnit is required when shippingLengthValue is provided. |
Optional |
|
shippingWidthUnit |
Shipping Width UOM |
shipping_dim_uom |
Shipping dimensional unit of measure Shipping Width UOM must be one of these options: in, cm. shippingWidthUnit is required when shippingWidthValue is provided. |
Optional |
|
shippingHeightUnit |
Shipping Height UOM |
shipping_dim_uom |
Shipping dimensional unit of measure Shipping Height UOM must be one of these options: in, cm. shippingHeightUnit is required when shippingHeightValue is provided. |
Optional |
|
maxHandlingTime |
Max Handling Time |
max_handling_time |
The longest amount of time between when an order is placed for a product and when the product ships. Value must be an integer. |
Can be setup as a default calculation in Google Merchant Cener |
Optional |
minHandlingTime |
Min Handling Time |
min_handling_time |
The shortest amount of time between when an order is placed for a product and when the product ships. Value must be an integer. |
Can be setup as a default calculation in Google Merchant Cener |
Optional |
taxesRate |
Tax Rate |
N/A |
The percentage of tax rate that applies to the item price. Value must be a decimal. |
Can be setup as a default calculation in Google Merchant Cener |
Optional |
includedDestinations |
Included Destination |
N/A |
Include what program your products should be listed to include. Supported values include: Shopping Ads, Shopping Actions, Display Ads, Local Shopping,Surfaces across Google,Local surfaces across Google |
Must create in mapping rule if pulling from the product catalog. |
Optional |
excludedDestinations |
Excluded Destination |
N/A |
Include what program your products should not be listed. Supported values include: Shopping Ads, Shopping Actions, Display Ads, Local Shopping,Surfaces across Google,Local surfaces across Google |
Must create in mapping rule if pulling from the product catalog. |
Optional |
feedId |
Feed ID |
N/A |
Used for configuring a supplemental feed. Use the Feed ID when creating your supplemental feed within Google's Merchant Center. |
Must create in mapping rule if pulling from the product catalog. |
Optional |
custom_newAttribute1 |
Test Custom Attribute |
N/A |
The value of the custom attribute Test Custom Attribute must have length less than 101. |
Optional |
Comments
Please sign in to leave a comment.