Product Content - Creating/Updating Product Listings

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

mceclip0.png

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.

product_catalong_add_image.png

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

kb_mapping_catalog_image.png

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. 

primary_feed.png

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"

edit_mapping.png

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.

export_items___product_catalog.png

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

mceclip8.png

If you have a primary feed already created you will see it here.

mceclip11.png

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.

mceclip12.png

mceclip13.png

Take the Feed ID provided by Google, this will be used when you map your product fields to google within Logicbroker.

mceclip14.png

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.

attribute_mappings.png

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. 

export_reg.png

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.

feeds.png

Within the feed, click on the non-compliant products to edit and correct them.

edit_product_feed.png

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

feeds2.png

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

mceclip20.png

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.

mceclip21.png

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

Was this article helpful?
0 out of 0 found this helpful

Comments

0 comments

Please sign in to leave a comment.

Didn't find what you were looking for?

Submit a request