Update Product with BigCommerce API on New Page in Database from Notion API

Pipedream makes it easy to connect APIs for BigCommerce, Notion and 2,400+ other apps remarkably fast.

Trigger workflow on

New Page in Database from the Notion API

Next, do this

Update Product with the BigCommerce API

No credit card required

▶

Watch us build a workflow

8 min

Watch now ➜

Trusted by 1,000,000+ developers from startups to Fortune 500 companies

Developers ♥ Pipedream

Getting Started#

This integration creates a workflow with a Notion trigger and BigCommerce action. When you configure and deploy the workflow, it will run on Pipedream's servers 24x7 for free.

Select this integration
Configure the New Page in Database trigger
1. Connect your Notion account
2. Configure timer
3. Select a Database ID
Configure the Update Product action
1. Connect your BigCommerce account
2. Select a Product Id
3. Configure Name
4. Select a Type
5. Optional- Configure SKU
6. Optional- Configure Description
7. Configure Weight
8. Optional- Configure Width
9. Optional- Configure Depth
10. Optional- Configure Height
11. Configure Price
12. Optional- Configure Cost Price
13. Optional- Configure Retail Price
14. Optional- Configure Sale Price
15. Optional- Configure Map Price
16. Optional- Select a Tax class id
17. Optional- Configure Product tax code
18. Optional- Select one or more Categories
19. Optional- Select a Brand Id
20. Optional- Configure Inventory Level
21. Optional- Configure Inventory Warning Level
22. Optional- Select a Inventory Tracking
23. Optional- Configure Fixed cost shipping price
24. Optional- Configure Is free shipping
25. Optional- Configure Is visible
26. Optional- Configure Is Featured
27. Optional- Select one or more Related Products
28. Optional- Configure Warranty
29. Optional- Configure Bin picking number
30. Optional- Configure Layout File
31. Optional- Configure UPC
32. Optional- Configure Seach keywords
33. Optional- Select a Availability
34. Optional- Configure Availability description
35. Optional- Select a Gift wrapping options type
36. Optional- Configure Gift wrapping options list
37. Optional- Configure Sort order
38. Optional- Select a Condition
39. Optional- Configure Is condition shown
40. Optional- Configure Order quantity minimum
41. Optional- Configure Order quantity maximum
42. Optional- Configure Page title
43. Optional- Configure Meta keywords
44. Optional- Configure Meta description
45. Optional- Configure View count
46. Optional- Configure Preorder release date
47. Optional- Configure Preorder message
48. Optional- Configure Is preorder only
49. Optional- Configure Is preorder hidden
50. Optional- Configure Price hidden label
51. Optional- Select a Open graph type
52. Optional- Configure Open graph title
53. Optional- Configure Open graph description
54. Optional- Configure Open graph use meta description
55. Optional- Configure Open graph use product name
56. Optional- Configure Open graph use image
57. Optional- Configure Brand name
58. Optional- Configure GTIN
59. Optional- Configure MPN
60. Optional- Configure Reviews rating sum
61. Optional- Configure Reviews count
62. Optional- Configure Total sold
63. Optional- Configure Images
Deploy the workflow
Send a test event to validate your setup
Turn on the trigger

Details#

This integration uses pre-built, source-available components from Pipedream's GitHub repo. These components are developed by Pipedream and the community, and verified and maintained by Pipedream.

To contribute an update to an existing component or create a new component, create a PR on GitHub. If you're new to Pipedream component development, you can start with quickstarts for trigger span and action development, and then review the component API reference.

Trigger#

New Page in Database on Notion

Description:Emit new event when a page in a database is created

Version:0.0.10

Key:notion-new-page

View on GitHub

Notion Overview#

Notion's API allows for the creation, reading, updating, and deleting of pages, databases, and their contents within Notion. Using Pipedream's platform, you can build workflows that connect Notion with various other services to automate tasks such as content management, task tracking, and data synchronization. With Pipedream's serverless execution, you can trigger these workflows on a schedule, or by external events from other services, without managing any infrastructure.

Trigger Code#

import notion from "../../notion.app.mjs";
import sampleEmit from "./test-event.mjs";
import base from "../common/base.mjs";
import constants from "../common/constants.mjs";

export default {
  ...base,
  key: "notion-new-page",
  name: "New Page in Database",
  description: "Emit new event when a page in a database is created",
  version: "0.0.10",
  type: "source",
  props: {
    ...base.props,
    databaseId: {
      propDefinition: [
        notion,
        "databaseId",
      ],
    },
  },
  hooks: {
    ...base.hooks,
    async deploy() {
      await this.processEvents(25);
    },
  },
  methods: {
    ...base.methods,
    async processEvents(max) {
      const pages = [];
      const lastCreatedTimestamp = this.getLastCreatedTimestamp();
      const lastCreatedTimestampDate = new Date(lastCreatedTimestamp);
      const lastCreatedTimestampISO = lastCreatedTimestampDate.toISOString();

      // Add a filter so that we only receive pages that have been created since the saved time.
      const params = {
        ...this.lastCreatedSortParam(),
        filter: {
          timestamp: "created_time",
          created_time: {
            after: lastCreatedTimestampISO,
          },
        },
      };

      // Get pages in created order descending until the first page edited after
      // lastCreatedTimestamp, then reverse list of pages and emit
      const pagesStream = this.notion.getPages(this.databaseId, params);

      for await (const page of pagesStream) {
        if (!this.isResultNew(page.created_time, lastCreatedTimestamp)
          || (max && pages.length >= max)) {
          break;
        }
        pages.push(page);
      }

      pages.reverse().forEach((page) => {
        const meta = this.generateMeta(
          page,
          constants.types.PAGE,
          constants.timestamps.CREATED_TIME,
          constants.summaries.PAGE_ADDED,
        );
        this.$emit(page, meta);
      });

      const lastCreatedTime = pages[pages.length - 1]?.created_time;
      if (lastCreatedTime) {
        this.setLastCreatedTimestamp(Date.parse(lastCreatedTime));
      }
    },
  },
  async run() {
    await this.processEvents(100);
  },
  sampleEmit,
};

Trigger Configuration#

This component may be configured based on the props defined in the component code. Pipedream automatically prompts for input values in the UI and CLI.

Label	Prop	Type	Description
Notion	`notion`	`app`	This component uses the Notion app.
N/A	`db`	`$.service.db`	This component uses `$.service.db` to maintain state between executions.
	`timer`	`$.interface.timer`
Database ID	`databaseId`	`string`	Select a value from the drop down menu.

Trigger Authentication#

Notion uses OAuth authentication. When you connect your Notion account, Pipedream will open a popup window where you can sign into Notion and grant Pipedream permission to connect to your account. Pipedream securely stores and automatically refreshes the OAuth tokens so you can easily authenticate any Notion API.

Pipedream requests the following authorization scopes when you connect your account:

About Notion#

Notion is a new tool that blends your everyday work apps into one. It's the all-in-one workspace for you and your team.

Action#

Update Product on BigCommerce

Description:Update a product by Id. [See the docs here](https://developer.bigcommerce.com/api-reference/6f05c1244d972-update-a-product)

Version:0.0.3

Key:bigcommerce-update-product

View on GitHub

BigCommerce Overview#

The BigCommerce API enables merchants to seamlessly manage their e-commerce operations by automating tasks, syncing data, and integrating with a plethora of other services. With Pipedream, you can tap into the BigCommerce API to create custom workflows that handle everything from order processing to customer relationship management. The result is a more efficient, personalized shopping experience for customers and less manual work for store owners.

Action Code#

import common from "../common/product.mjs";

const { app } = common.props;

export default {
  ...common,
  key: "bigcommerce-update-product",
  name: "Update Product",
  description:
    "Update a product by Id. [See the docs here](https://developer.bigcommerce.com/api-reference/6f05c1244d972-update-a-product)",
  version: "0.0.3",
  type: "action",
  props: {
    app,
    productId: {
      propDefinition: [
        app,
        "productId",
      ],
    },
    ...common.props,
  },
  methods: {
    ...common.methods,
    updateProduct({
      productId, ...args
    }) {
      return this.app._makeRequest({
        method: "PUT",
        path: `/catalog/products/${productId}`,
        ...args,
      });
    },
    getRequestFn() {
      return this.updateProduct;
    },
    getRequestFnArgs(args = {}) {
      return {
        ...args,
        productId: this.productId,
      };
    },
    getSummary(response) {
      return `Successfully updated product with ID \`${response.data.id}\``;
    },
  },
};

Action Configuration#

This component may be configured based on the props defined in the component code. Pipedream automatically prompts for input values in the UI.

Label	Prop	Type	Description
BigCommerce	`app`	`app`	This component uses the BigCommerce app.
Product Id	`productId`	`integer`	Select a value from the drop down menu.
Name	`name`	`string`	The product name. >= 1 characters <= 250 characters
Type	`type`	`string`	Select a value from the drop down menu:`physicaldigital`
SKU	`sku`	`string`	User defined product code/stock keeping unit (SKU). >= 0 characters <= 255 characters Example: SM-13
Description	`description`	`string`	The product description, which can include HTML formatting.
Weight	`weight`	`any`	Weight of the product, which can be used when calculating shipping costs. This is based on the unit set on the store >= 0 and <= 9999999999
Width	`width`	`any`	Width of the product, which can be used when calculating shipping costs. >= 0 and <= 9999999999
Depth	`depth`	`any`	Depth of the product, which can be used when calculating shipping costs. >= 0 and <= 9999999999
Height	`height`	`any`	Height of the product, which can be used when calculating shipping costs. >= 0 and <= 9999999999
Price	`price`	`any`	The price of the product. The price should include or exclude tax, based on the store settings. >= 0
Cost Price	`cost_price`	`any`	The cost price of the product. Stored for reference only; it is not used or displayed anywhere on the store. >=0
Retail Price	`retail_price`	`any`	The retail cost of the product. If entered, the retail cost price will be shown on the product page. >=0
Sale Price	`sale_price`	`any`	If entered, the sale price will be used instead of value in the price field when calculating the product's cost. >=0
Map Price	`map_price`	`integer`	Minimum Advertised Price
Tax class id	`tax_class_id`	`integer`	Select a value from the drop down menu.
Product tax code	`product_tax_code`	`string`	Accepts AvaTax System Tax Codes, which identify products and services that fall into special sales-tax categories. By using these codes, merchants who subscribe to BigCommerce's Avalara Premium integration can calculate sales taxes more accurately. Stores without Avalara Premium will ignore the code when calculating sales tax. Do not pass more than one code. The codes are case-sensitive. For details, please see Avalara's documentation. >= 0 characters <= 255 characters
Categories	`categories`	`integer[]`	Select a value from the drop down menu.
Brand Id	`brand_id`	`integer`	Select a value from the drop down menu.
Inventory Level	`inventory_level`	`integer`	Current inventory level of the product. Simple inventory tracking must be enabled (See the inventory_tracking field) for this to take any effect. >= 0 and <= 1000000000
Inventory Warning Level	`inventory_warning_level`	`integer`	Inventory warning level for the product. When the product's inventory level drops below the warning level, the store owner will be informed. Simple inventory tracking must be enabled (see the inventory_tracking field) for this to take any effect. >= 0 and <= 1000000000
Inventory Tracking	`inventory_tracking`	`string`	Select a value from the drop down menu:`noneproductvariant`
Fixed cost shipping price	`fixed_cost_shipping_price`	`any`	A fixed shipping cost for the product. If defined, this value will be used during checkout instead of normal shipping-cost calculation. >= 0
Is free shipping	`is_free_shipping`	`boolean`	Flag used to indicate whether the product has free shipping. If true, the shipping cost for the product will be zero.
Is visible	`is_visible`	`boolean`	Flag to determine whether the product should be displayed to customers browsing the store. If true, the product will be displayed. If false, the product will be hidden from view.
Is Featured	`is_featured`	`boolean`	Flag to determine whether the product should be included in the featured products panel when viewing the store.
Related Products	`related_products`	`integer[]`	Select a value from the drop down menu.
Warranty	`warranty`	`string`	Warranty information displayed on the product page. Can include HTML formatting. >= 0 characters and <= 65535 characters
Bin picking number	`bin_picking_number`	`string`	The BIN picking number for the product. >= 0 characters and <= 255 characters
Layout File	`layout_file`	`string`	The layout template file used to render this product category. This field is writable only for stores with a Blueprint theme applied. >= 0 characters and <= 500 characters
UPC	`upc`	`string`	The product UPC code, which is used in feeds for shopping comparison sites and external channel integrations. >= 0 characters and <= 255 characters
Seach keywords	`search_keywords`	`string`	A comma-separated list of keywords that can be used to locate the product when searching the store. >= 0 characters and <= 65535 characters
Availability	`availability`	`string`	Select a value from the drop down menu:`availabledisabledpreorder`
Availability description	`availability_description`	`string`	Availability text displayed on the checkout page, under the product title. Tells the customer how long it will normally take to ship this product, such as: 'Usually ships in 24 hours.' >= 0 characters and <= 255 characters
Gift wrapping options type	`gift_wrapping_options_type`	`string`	Select a value from the drop down menu:`anynonelist`
Gift wrapping options list	`gift_wrapping_options_list`	`string[]`	A list of gift-wrapping option IDs.
Sort order	`sort_order`	`integer`	Priority to give this product when included in product lists on category pages and in search results. Lower integers will place the product closer to the top of the results. >= -2147483648 and <= 2147483647
Condition	`condition`	`string`	Select a value from the drop down menu:`NewUsedRefurbished`
Is condition shown	`is_condition_shown`	`boolean`	Flag used to determine whether the product condition is shown to the customer on the product page.
Order quantity minimum	`order_quantity_minimum`	`integer`	The minimum quantity an order must contain, to be eligible to purchase this product. >= 0 and <= 1000000000
Order quantity maximum	`order_quantity_maximum`	`integer`	The maximum quantity an order can contain when purchasing the product. >= 0 and <= 1000000000
Page title	`page_title`	`string`	Custom title for the product page. If not defined, the product name will be used as the meta title. >= 0 characters and <= 255 characters
Meta keywords	`meta_keywords`	`string[]`	Custom meta keywords for the product page. If not defined, the store's default keywords will be used.
Meta description	`meta_description`	`string`	Custom meta description for the product page. If not defined, the store's default meta description will be used. >= 0 characters and <= 65535 characters
View count	`view_count`	`integer`	The number of times the product has been viewed. >= 0 and <= 1000000000
Preorder release date	`preorder_release_date`	`string`	Pre-order release date. See the availability field for details on setting a product's availability to accept pre-orders.
Preorder message	`preorder_message`	`string`	Custom expected-date message to display on the product page. If undefined, the message defaults to the storewide setting. Can contain the %%DATE%% placeholder, which will be substituted for the release date. >= 0 characters and <= 255 characters
Is preorder only	`is_preorder_only`	`boolean`	If set to true then on the preorder release date the preorder status will automatically be removed. If set to false, then on the release date the preorder status will not be removed. It will need to be changed manually either in the control panel or using the API. Using the API set availability to available.
Is preorder hidden	`is_price_hidden`	`boolean`	False by default, indicating that this product's price should be shown on the product page. If set to true, the price is hidden. (NOTE: To successfully set is_price_hidden to true, the availability value must be disabled.)
Price hidden label	`price_hidden_label`	`string`	By default, an empty string. If is_price_hidden is true, the value of price_hidden_label is displayed instead of the price. (NOTE: To successfully set a non-empty string value with is_price_hidden set to true, the availability value must be disabled.) >= 0 characters and <= 200 characters
Open graph type	`open_graph_type`	`string`	Select a value from the drop down menu:`productalbumbookdrinkfoodgamemoviesongtv_show`
Open graph title	`open_graph_title`	`string`	Title of the product, if not specified the product name will be used instead.
Open graph description	`open_graph_description`	`string`	Description to use for the product, if not specified then the meta_description will be used instead.
Open graph use meta description	`open_graph_use_meta_description`	`boolean`	Flag to determine if product description or open graph description is used.
Open graph use product name	`open_graph_use_product_name`	`boolean`	Flag to determine if product name or open graph name is used.
Open graph use image	`open_graph_use_image`	`boolean`	Flag to determine if product image or open graph image is used.
Brand name	`brand_name`	`string`	It performs a fuzzy match and adds the brand. eg. "Common Good" and "Common good" are the same. Brand name does not return as part of a product response. Only the brand_id.
GTIN	`gtin`	`string`	Global Trade Item Number
MPN	`mpn`	`string`	Manufacturer Part Number
Reviews rating sum	`reviews_rating_sum`	`any`	The total rating for the product.
Reviews count	`reviews_count`	`integer`	The number of times the product has been rated.
Total sold	`total_sold`	`integer`	The total quantity of this product sold.
Images	`images`	`string[]`	Array of image strings. They can be either local paths or URLs. Limit of 8MB per file. If it is a URL it has a 255 character limit. Supported image file types are BMP, GIF, JPEG, PNG, WBMP, XBM, and WEBP. If it is a local path it should be previously downloaded to Pipedream E.g. (`/tmp/my-image.png`). Download a file to the `/tmp` directory

Action Authentication#

BigCommerce uses API keys for authentication. When you connect your BigCommerce account, Pipedream securely stores the keys so you can easily authenticate to BigCommerce APIs in both code and no-code steps.

Navigate to Settings > API > Store-level API accounts
Name the account (it will only be visible to store users)
In the OAuth Scopes section, select the minimum scopes the app will require
Press Save.

The base API path will look something like this: https://api.bigcommerce.com/stores/123456/

In example above, the store_hash is 123456. Enter this and the access token below.

About BigCommerce#

Ecommerce for a New Era

More Ways to Connect BigCommerce + Notion#

Other Popular Integrations#

Append Block to Parent with Notion API on New Custom Events from BigCommerce API

BigCommerce + Notion

Update Product with BigCommerce API on New Page in Database from Notion API

Pipedream makes it easy to connect APIs for BigCommerce, Notion and 2,400+ other apps remarkably fast.

Trusted by 1,000,000+ developers from startups to Fortune 500 companies

Developers ♥ Pipedream

1-24of2,400+apps by most popular

1
-
24
of
2,400+
apps by most popular