The Shopping Content Service lets you use the
[Google Content API for Shopping](https://developers.google.com/shopping-content) in Google Apps Script.
This API gives Google Merchant Center users the ability to upload and manage
their product listings and manage their Merchant Center accounts.

For detailed information on this service, see the
[reference documentation](https://developers.google.com/shopping-content/v2/reference/v2) for the
Google Content API for Shopping. Like all advanced services in
Apps Script, the Shopping Content Service utilizes the same
objects, methods, and parameters as the public API.

This is an advanced service that must be
[enabled before use](https://developers.google.com/apps-script/guides/services/advanced).

## Reference

For detailed information on this service, see the
[reference documentation](https://developers.google.com/shopping-content/v2/reference/v2) for the
Google Content API for Shopping API. Like all advanced services in
Apps Script, the Shopping Content service uses the same objects,
methods, and parameters as the public API. For more information, see
[How method signatures are determined](https://developers.google.com/apps-script/guides/services/advanced#how_method_signatures_are_determined).

To report issues and find other support, see the
[Google Content API for Shopping support guide](https://developers.google.com/shopping-content/support/contact-us).

## Sample code

We now show how to use a few features of the Shopping Content Service.

### Insert product

This example demonstrates how to insert a single product into a given
merchant center account.
advanced/shoppingContent.gs [View on GitHub](https://github.com/googleworkspace/apps-script-samples/blob/main/advanced/shoppingContent.gs)

```javascript
/**
 * Inserts a product into the products list. Logs the API response.
 */
function productInsert() {
  const merchantId = 123456; // Replace this with your Merchant Center ID.
  // Create a product resource and insert it
  const productResource = {
    offerId: "book123",
    title: "A Tale of Two Cities",
    description: "A classic novel about the French Revolution",
    link: "http://my-book-shop.com/tale-of-two-cities.html",
    imageLink: "http://my-book-shop.com/tale-of-two-cities.jpg",
    contentLanguage: "en",
    targetCountry: "US",
    channel: "online",
    availability: "in stock",
    condition: "new",
    googleProductCategory: "Media > Books",
    productType: "Media > Books",
    gtin: "9780007350896",
    price: {
      value: "2.50",
      currency: "USD",
    },
    shipping: [
      {
        country: "US",
        service: "Standard shipping",
        price: {
          value: "0.99",
          currency: "USD",
        },
      },
    ],
    shippingWeight: {
      value: "2",
      unit: "pounds",
    },
  };

  try {
    response = ShoppingContent.Products.insert(productResource, merchantId);
    // RESTful insert returns the JSON object as a response.
    console.log(response);
  } catch (e) {
    // TODO (Developer) - Handle exceptions
    console.log("Failed with error: $s", e.error);
  }
}
```

### List products

This example demonstrates how to list your products for a given merchant
center account.
advanced/shoppingContent.gs [View on GitHub](https://github.com/googleworkspace/apps-script-samples/blob/main/advanced/shoppingContent.gs)

```javascript
/**
 * Lists the products for a given merchant.
 */
function productList() {
  const merchantId = 123456; // Replace this with your Merchant Center ID.
  let pageToken;
  let pageNum = 1;
  const maxResults = 10;
  try {
    do {
      const products = ShoppingContent.Products.list(merchantId, {
        pageToken: pageToken,
        maxResults: maxResults,
      });
      console.log(`Page ${pageNum}`);
      if (products.resources) {
        for (let i = 0; i < products.resources.length; i++) {
          console.log(`Item [${i}] ==> ${products.resources[i]}`);
        }
      } else {
        console.log(`No more products in account ${merchantId}`);
      }
      pageToken = products.nextPageToken;
      pageNum++;
    } while (pageToken);
  } catch (e) {
    // TODO (Developer) - Handle exceptions
    console.log("Failed with error: $s", e.error);
  }
}
```

### Batch insert products

This example uses
[Products.custombatch](https://developers.google.com/shopping-content/v2/reference/v2/products/custombatch)
to insert three products at the same time.
advanced/shoppingContent.gs [View on GitHub](https://github.com/googleworkspace/apps-script-samples/blob/main/advanced/shoppingContent.gs)

```javascript
/**
 * Batch updates products. Logs the response.
 * @param  {object} productResource1 The first product resource.
 * @param  {object} productResource2 The second product resource.
 * @param  {object} productResource3 The third product resource.
 */
function custombatch(productResource1, productResource2, productResource3) {
  const merchantId = 123456; // Replace this with your Merchant Center ID.
  custombatchResource = {
    entries: [
      {
        batchId: 1,
        merchantId: merchantId,
        method: "insert",
        productId: "book124",
        product: productResource1,
      },
      {
        batchId: 2,
        merchantId: merchantId,
        method: "insert",
        productId: "book125",
        product: productResource2,
      },
      {
        batchId: 3,
        merchantId: merchantId,
        method: "insert",
        productId: "book126",
        product: productResource3,
      },
    ],
  };
  try {
    const response = ShoppingContent.Products.custombatch(custombatchResource);
    console.log(response);
  } catch (e) {
    // TODO (Developer) - Handle exceptions
    console.log("Failed with error: $s", e.error);
  }
}
```

### Update account-level taxes

This sample code uses
[Accounttax](https://developers.google.com/shopping-content/v2/reference/v2/accounttax) to update the
account-level tax information for a Merchant Center account. See our
[API guide](https://developers.google.com/shopping-content/v2/how-tos/account-level-tax-shipping) for more
information about account-level tax and shipping.
advanced/shoppingContent.gs [View on GitHub](https://github.com/googleworkspace/apps-script-samples/blob/main/advanced/shoppingContent.gs)

```javascript
/**
 * Updates content account tax information.
 * Logs the API response.
 */
function updateAccountTax() {
  // Replace this with your Merchant Center ID.
  const merchantId = 123456;

  // Replace this with the account that you are updating taxes for.
  const accountId = 123456;

  try {
    const accounttax = ShoppingContent.Accounttax.get(merchantId, accountId);
    console.log(accounttax);

    const taxInfo = {
      accountId: accountId,
      rules: [
        {
          useGlobalRate: true,
          locationId: 21135,
          shippingTaxed: true,
          country: "US",
        },
        {
          ratePercent: 3,
          locationId: 21136,
          country: "US",
        },
        {
          ratePercent: 2,
          locationId: 21160,
          shippingTaxed: true,
          country: "US",
        },
      ],
    };

    console.log(
      ShoppingContent.Accounttax.update(taxInfo, merchantId, accountId),
    );
  } catch (e) {
    // TODO (Developer) - Handle exceptions
    console.log("Failed with error: $s", e.error);
  }
}
```