TIPS & KNOWLEDGE BASE

E-COMMERCE SPECIALISTS SINCE 1996

Miva | Google Shopping API Import/Export Mapping

Items in bold are Miva import/export column headings.  Items in [ ] are associated Google Product Feed Specification mappings.

 [id]

  • Required for all items.
  • Automatically pulled from product code entered in Miva admin.

GOOGLE_SHOPPING:_TITLE [title]

  • Required for all items.

GOOGLE_SHOPPING:_DESCRIPTION [description]

  • Required for all items.

GOOGLE_SHOPPING:_PRODUCT_CATEGORY [google_product_category]

GOOGLE_SHOPPING:_PRODUCT_TYPE [product_type]

[link]

  • Required for all items.
  • Automatically pulled from URI settings in Miva.

[mobile_link]

  • Optional, though recommended if you have mobile-optimized versions of your landing pages.
  • Automatically pulled from URI settings in Miva.

[image_link]

  • Required for all items.
  • Automatically pulled from URI settings in Miva.  If you have a product with a lot of variants you can either assign images for each variant or on the master product there is a settings to set which image gets used for each of the variants called Variation Image Types. Setting this at the master product, will automatically use the image types selected on the variation products.

[additional_image_link]

  • Optional; for all items with multiple images.
  • Automatically pulled from URI settings in Miva.  If you have a product with a lot of variants you can either assign images for each variant or on the master product there is a settings to set which image gets used for each of the variants called Variation Image Types. Setting this at the master product, will automatically use the image types selected on the variation products.

GOOGLE_SHOPPING:_CONDITION [condition]

  • Required if your if your item is used or refurbished.
  • Optional for new products.
  • Accepted values
    • new
    • used
    • refurbished

GOOGLE_SHOPPING:_AVAILABILITY [availability]

  • Required; if Miva stock inventory feature is used, these values will automatically update accordingly, otherwise they must be specified manually.
  • Accepted values
    • preorder
    • in stock
    • out of stock

[availability_date]

  • Currently not support by Miva Google Shopping API. Contact us if you’d like to add this as a custom field.

[price]

  • Required for all items.
  • Automatically pulled from product price entered in Miva admin.
  • Prices must match what is displayed on your Miva store to shoppers. (Google does crawl to verify)

GOOGLE_SHOPPING:_SALE_PRICE [sale_price]

  • Optional, though recommended for items on sale. If your item is on sale and you don’t include this attribute, the sale price must be updated as the value in the ‘price’ attribute.
  • Price Groups Discounts via Miva’s Marketing features are not currently supported with Google Shopping API. If you have product prices on sale using specific sale price or some other price group discount you would need to import those prices into the “sale price” field under Google Shopping Settings for the correct price to be sent to Google.

[sale_price_effective_date]

  • Currently not available via import/export, must specify dates under each product’s Google Shopping Product Settings in the Miva admin. Contact us if you’d like to add this as a custom field.

GOOGLE_SHOPPING:_ITEM_NUMBER [gtin]

  • Required for all new products with a GTIN assigned by the manufacturer.
  • Optional, though strong recommended for all other products.
  • Refer to the Unique Product Identifier Rules for your target country.

GOOGLE_SHOPPING:_PART_NUMBER [MPN]

  • Required if your new product does not have a GTIN assigned by the manufacturer.
  • Optional for all other products.
  • Refer to the Unique Product Identifier Rules for your target country.

GOOGLE_SHOPPING:_BRAND [brand]

  • Required for all new products except movies, books, and musical recording brands.
  • Optional for all other products.
  • Refer to the Unique Product Identifier Rules for your target country.

[identifier_exists]

  • Optional
  • Refer to the Unique Product Identifier Rules for your target country.
  • Currently not support by Miva Google Shopping API. Contact us if you’d like to add this as a custom field.
  • Supported values:
    • no (wherein GTIN, MPN, or brand are NOT available)
    • yes (wherein GTIN, MPN, or brand ARE available)

[item_group_id]

  • Required for Brazil, France, Germany, Japan, the UK, and the US, for all items with variants that use these detailed product attributes: ‘color’, ‘size’, ‘pattern’, ‘material’, ‘age group’, ‘gender’, ‘size type’ and ‘size system’.
  • Optional, though recommended for all other countries.
  • Miva will automatically create a Group ID based on variant products, will not work with standard attributes.

GOOGLE_SHOPPING:_COLOR [color]

  • Required for all products in an item group that vary by color.
  • Required for all apparel items in feeds that target Brazil, France, Germany, Japan, the UK, and the US.
  • Optional, though recommended for all products for which color is an important, distinguishing attribute.

GOOGLE_SHOPPING:_GENDER [gender]

  • Required for all gender-specific products.
  • Required for all apparel items in feeds that target Brazil, France, Germany, Japan, the UK, and the US.
  • Optional, though recommended for all products for which gender is an important, distinguishing attribute.
  • Accepted values:
    • male
    • female
    • unisex

GOOGLE_SHOPPING:_AGE_GROUP [age_group]

  • Required for all age-specific products.
  • Required for all apparel items in feeds that target Brazil, France, Germany, Japan, the UK, and the US.
  • Optional, though recommended for all products for which age group is an important, distinguishing attribute.
  • Accepted values:
    • newborn
    • infant
    • toddler
    • kids
    • adult

GOOGLE_SHOPPING:_MATERIAL [material]

  • Required to distinguish between products in an item group that vary by material.
  • Optional, though recommended for all products for which material is an important, distinguishing attribute.

GOOGLE_SHOPPING:_PATTERN [pattern]

  • Required to distinguish between products in an item group that vary by pattern.
  • Optional, though recommended for all products for which pattern is an important, distinguishing attribute.

GOOGLE_SHOPPING:_SIZE [size]

  • Required for all products in an item group that vary by size.
  • Required for all apparel items in the ‘Apparel & Accessories > Clothing’ and ‘Apparel & Accessories > Shoes’ product categories in products that target Brazil, France, Germany, Japan, the UK, and the US.
  • Optional, though recommended for all products for which size is an important, distinguishing attribute.

GOOGLE_SHOPPING:_SIZE_TYPE [size_type]

  • Optional, though recommended for all apparel items. If the type is not specified, the default is “regular”.
  • Accepted values
    • regular
    • petite
    • oversize
    • maternity

GOOGLE_SHOPPING:_SIZE_SYSTEM [size_system]

  • Optional, though recommended for all apparel items.
  • Accepted values
    • US
    • UK
    • EU
    • DE
    • FR
    • JP
    • CN (China)
    • IT
    • BR
    • MEX
    • AU

GOOGLE_SHOPPING:_WEIGHT [shipping_weight]

  • Required if you set up a shipping method in the Merchant Center using a carrier-calculated rate, a table based on weight, or a rule based on weight.
  • Automatically pulled from product weight entered in Miva admin, however it can be overridden.
  • Supported units:
    • lb
    • oz
    • g
    • kg

[shipping_length] 

  • Required if you set up a shipping method in the Merchant Center using a carrier-calculated rate.
  • Automatically pulled from product shipping dimensions settings in Miva admin if populated.
  • Supported units:
    • in
    • cm

[shipping_width]

  • Required if you set up a shipping method in the Merchant Center using a carrier-calculated rate.
  • Automatically pulled from product shipping dimensions settings in Miva admin if populated.
  • Supported units:
    • in
    • cm

[shipping_height]

  • Required if you set up a shipping method in the Merchant Center using a carrier-calculated rate.
  • Automatically pulled from product shipping dimensions settings in Miva admin if populated.
  • Supported units:
    • in
    • cm

[shipping_label]

  • Currently not support by Miva Google Shopping API. Contact us if you’d like to add this as a custom field.

GOOGLE_SHOPPING:_MULTIPACK [multipack]

  • Required for multipack products for all countries except Austria, Belgium, Canada, Denmark, India, Mexico, Norway, Poland, Russia, Sweden, and Turkey.
  • Accepted values:
    • Integer, greater than 1 (multipacks cannot contain 1 item)

GOOGLE_SHOPPING:_BUNDLED [is_bundle]

  • Required for bundle products for all countries except Austria, Belgium, Canada, Denmark, India, Mexico, Norway, Poland, Russia, Sweden, and Turkey.
  • Accepted values
    • yes
    • no

GOOGLE_SHOPPING:_ADULT_PRODUCT [adult]

  • Required for all products that include sexually suggestive content.
  • Accepted values
    • yes
    • no

GOOGLE_SHOPPING:_ADWORDS_REDIRECT_URL [ads_redirect]

  • Optional; this attribute can be used in Shopping campaigns. Learn more about the ‘ads redirect‘ attribute.

GOOGLE_SHOPPING:_CUSTOM_LABEL_0 [custom_label_0]

  • Optional; use for custom grouping of items in a Shopping campaign (ie. seasonal, clearance, holiday, sale, etc.).

GOOGLE_SHOPPING:_CUSTOM_LABEL_1 [custom_label_1]

  • Optional; use for custom grouping of items in a Shopping campaign (ie. seasonal, clearance, holiday, sale, etc.).

GOOGLE_SHOPPING:_CUSTOM_LABEL_2 [custom_label_2]

  • Optional; use for custom grouping of items in a Shopping campaign (ie. seasonal, clearance, holiday, sale, etc.).

GOOGLE_SHOPPING:_CUSTOM_LABEL_3 [custom_label_3]

  • Optional; use for custom grouping of items in a Shopping campaign (ie. seasonal, clearance, holiday, sale, etc.).

GOOGLE_SHOPPING:_CUSTOM_LABEL_4 [custom_label_4]

  • Optional; use for custom grouping of items in a Shopping campaign (ie. seasonal, clearance, holiday, sale, etc.).

[excluded_destination]

  • Currently not support by Miva Google Shopping API. Contact us if you’d like to add this as a custom field.

GOOGLE_SHOPPING:_EXPIRATION_DATE [expiration_date]

  • Optional; if you would like an item to expire earlier than 30 days from the upload date of the feed.
  • Accepted formats:
    • YYYY-MM-DD
    • YYYY-MMDDThh:mm:ss
    • YYYY-MM-DDThh:mm:ssZ

GOOGLE_SHOPPING:_UNIT_PRICING_BASE_MEASURE [unit_pricing_measure]

  • Optional, except when required to provide this information based on local laws or regulations.
  • Strongly recommended that you submit unit pricing for applicable products (ie. Flooring, Business Cards, Perfume, Beverages, etc.).
  • Supported units:
    • Weight: oz, lb, mg, g, kg
    • Volume (US imperial): floz, pt, qt, gal
    • Volume (metric): ml, cl, l, cbm
    • Length: in, ft, yd, cm, m
    • Area: sqft, sqm
    • Per unit: ct

GOOGLE_SHOPPING:_UNIT_PRICING_BASE_MEASURE_VALUE [unit_pricing_base_measure]

  • Optional, except when required to provide this information based on local laws or regulations.
  • Recommended if you also submit the ‘unit pricing measure’ attribute.
  • Supported units:
    • Weight: oz, lb, mg, g, kg
    • Volume (US imperial): floz, pt, qt, gal
    • Volume (metric): ml, cl, l, cbm
    • Length: in, ft, yd, cm, m
    • Area: sqft, sqm
    • Per unit: ct

** Have questions or need assistance with Google Shopping for your Miva store? Contact us today!

Items in bold are Miva import/export column headings.  Items in [ ] are associated Google Product Feed Specification mappings.

Leave a Reply

Your email address will not be published. Required fields are marked *