PipedreamHQ / pipedream

Connect APIs, remarkably fast. Free for developers.
https://pipedream.com
Other
8.96k stars 5.27k forks source link

[TRIGGER] #7276

Open Lev1SinkCo opened 1 year ago

Lev1SinkCo commented 1 year ago

Describe the event source. What app is this for, and what event does the trigger correspond to?

Please provide a link to the relevant API docs for the specific service / operation this trigger is tied to.

I am trying to have ZOHO Inventory work with Airtable. How do I get where I change a price or information about a specific sku to update in Airtable without having to update both?

This is what I would want updated automatically: Inventory Stock Status Standard Wholesale Price List Selling Price / MSRP Website Link

For only the items with the categories: Stainless, Granite Composite, Vitreous China, Vessels, Fireclay, Kitchen, Bathroom, Bar / Vessel, and Accessories.

^These are the wholesale items which have Standard Wholesale Price's and price levels associated with them, that are also for resale.

The primary purpose is to give customers a way to view updated SWP pricing without us having to enter this manually, then having the link they can click on to view any negotiated pricing (via logging into the website). Second purpose is to be able to create data sheets / catalogs through the AirTable extensions.

nurskurmanbekov commented 1 year ago

To achieve the desired integration between ZOHO Inventory and Airtable, you would need to use a combination of APIs and automation tools. Here's an overview of the process:

Event Source: The event source would be a change in the specific SKU (product) in ZOHO Inventory. When any updates are made to the SKU's price or information, it would trigger an event to initiate the synchronization process.

App and Trigger: You would need to use a workflow automation tool, such as Zapier or Integromat, to connect ZOHO Inventory and Airtable. These platforms allow you to create automated workflows between different apps.

Setting up the Integration: You can create a "Zap" (Zapier) or "Scenario" (Integromat) to define the integration workflow. The trigger for this workflow would be the event source mentioned earlier (changes in SKU information in ZOHO Inventory).

Data Mapping: Once the trigger is activated, you would configure the action to update the corresponding fields in Airtable. This would involve mapping the relevant fields in ZOHO Inventory (e.g., Stock Status, Wholesale Price, Selling Price, Website Link) to the appropriate fields in Airtable.

Filtering by Categories: To update only the items with specific categories (Stainless, Granite Composite, Vitreous China, etc.), you would need to add a filter or condition in your workflow. This would ensure that only the desired SKUs are updated in Airtable.

As for the specific API documentation for ZOHO Inventory and Airtable, here are the relevant links:

ZOHO Inventory API documentation: https://www.zoho.com/inventory/api/v1/ Airtable API documentation: https://airtable.com/api By using these APIs and the automation tools mentioned, you can set up a workflow that automatically updates the specified fields in Airtable whenever changes occur in ZOHO Inventory. This will enable you to have synchronized data between the two platforms without the need for manual updates.