Add-ons > Google Merchant Center > Upload Sheet

Upload your products to the Google Merchant Center with Google Sheets

To upload your products to the Google Merchant Center using Google Sheets, you lot'll demand to manually enter your product data. Luckily, Google Sheets gives you full command over the information you upload and offers a familiar spreadsheet interface.

Log into your Google Merchant Heart
Go to Products > Feeds and so click on the plus symbol in the blue circle every bit shown below:
Select Google Sheets every bit your Principal feed name and input method
Under Setup, select Generate a new Google spreadsheet from a template
Exercise Non create an upload schedule:
Doing and so would prompt Google to regularly update your inventory based on this sheet, overwriting what you input through GeekSeller.
You lot can notice the link to your Google Sheet in your Merchant Centre. Notation that yous can create multiple feeds.
The template has a few tabs at the lesser which you should review advisedly.
Here is some basic data on the values in this template. Withal, we strongly suggest that you get familiar with the full details:
- id – This is your SKU, which must match the SKU in GeekSeller and on other marketplaces to ensure that inventory is synched properly.
- title – (150 characters max) Don't include promotional text but do include distinguishing attributes such as color and/or size.
- description – (5000 characters max.) Just include data describing the product. Don't include promotional text, links to your store, sales information, details about competitors, other products, or accessories. This field allows simple HTML formatting (for instance, line breaks, lists, or italics).
- link – The link to the product'southward list on your website. It must link to a page on your verified domain name; Declining to fulfill this requirement volition cause your account to be banned.
- condition – (New, Refurbished, or Used) Note that Google Limited currently only lists "New" products.
- price – The price and currency in this format: xv.00 USD. Never submit a toll of 0.
  Don't include the tax in the price for the U.Southward. and Canada. For all other countries, include value-added tax (VAT) or Goods and Services Revenue enhancement (GST) in the cost.
- availability – (in stock, out of stock, preorder) Keep in mind that the values "in stock" or "out of stock" will exist submitted automatically by GeekSeller based on your inventory levels.
- image link – The URL of your product's main image. Accepted formats are: non-blithe GIF (.gif), JPEG (.jpg/.jpeg), PNG (.png), BMP (.bmp), and TIFF (.tif/.tiff).
  For not-apparel products utilise an image of at least 100 10 100 pixels. For clothes products apply an paradigm of at least 250 10 250 pixels. Don't submit an prototype larger than 64 megapixels, or a file larger than 16MB. Don't include promotional text, watermarks, or borders. Don't submit a placeholder or a generic image.
- gtin – Accepted product IDs are UPC, EAN, JAN, ISBN, and ITF-14. For multipacks utilise the multipack's ID. This value is required for all new products with a gtin assigned by the manufacturer.
- mpn – (seventy alpha-numeric characters max.) Required only if your new product does not have a manufacturer assigned gtin.
- brand – (70 characters max.) Required for all new products except for movies, books, and musical recording brands.
- google product category – Required only for Apparel & Accessories (166), Media (783), and Software (2092) categories.
  Example "Apparel & Accessories > Article of clothing > Outerwear > Coats & Jackets" or "371". To download a list of all Google product categories visit this folio.
Go back to your feeds list and click on the name of the file.
You can now manually transfer information from the Google Sheet to the Google Merchant Middle.
Notice that under settings, in the fetch schedule department, your schedule is paused.
This is right; GeekSeller will automatically sync your quantities to Google, so go on information technology paused.