Product List Export
Overview
This workflow describes how to use the Products API in n8n to get full list of products/variants and their stock level.
Potential use cases:
Using it as stock level report or simple sales analytics by comparing it with past data
Using it as a way to manage stock levels on OFN (by exporting the product list in the format of OFN product upload template) (To be added soon)
This work flow can be run manually or scheduled to run or can be triggered by web hooks (Button Click in Airtable, OFN webhook for OC close)
Description
In the given workflow, the CSV file will contain fields:
Product Name
Variant Name
On_hand value
Price
Product Unit
Variant Unit Type
Producer Name
Prerequisites
To set up this integration you will need:
OFN API Authentication Gmail account linked in n8n
Workflow
Find the workflow code for download and import here.
Trigger: Can be manual/scheduled/webhook
HTTP Module (Get Bulk Products): Add/use existing OFN credentials. By default it will give all the products the user has access to. To filter by enterprise, use “q[supplier_id_in]=” in the query parameters as shown below
Set module: Here you can select what fields you want in the CSV
Email: Where do you want to send the CSV (email address)
Workflow
Variations/Adaptations:
Can be used as a way to manage stock level if the output CSV is in the format of OFN product upload template
To do this, we would need to convert few fields (units and values), map category ids, tax categories etc. (Workflow coming soon)
Last updated