Kojo is the leading materials procurement platform, used by Contractors across the country to connect with Vendors and order the construction materials they need. When a Contractor is using Kojo, Vendors have the opportunity to upload inventory availability making it simple for Contractors to see accurate inventory information during ordering.
We’ve made enhancements in Kojo to automate ordering for you and the Contractor through our vendor integrations. The inventory availability integration allows you to pass location-specific inventory data to Contractors through Kojo.
Pre-requisite:
Confirm that your branch/location is setup under your organization within the Kojo portal. If you do not see your branch/location please contact your IT department to have it created.
To set up inventory availability in Kojo, log in to the Vendor Portal with the credentials provided by Kojo. If you don't have access, contact vendor-integrations@usekojo.com for access to the Vendor Portal.
Visit Admin -> Setup -> Inventory and follow the prompts on the page.
If necessary you can adjust the header rows to match the data coming from your ERP. As indicated below:
Stock = Quantity on Hand
SKU = Vendors Internal Part Number
How does it work?
Kojo allows you to set up branch/location specific inventory feeds that are ingested into Kojo's catalog via scheduled email or through API integrations.
Our vendor partners typically set their ERP to send automated emails of branch/location-specific inventory files on a routine schedule (hourly, daily, etc.). These lists are typically location-specific and will only be shown to the customer who is ordering from that branch/location.
Where do I get the email address?
Each of your branch locations will have a unique email address available in the “Branches” tab in Kojo under Admin -> Company -> Branches. In the Inventory Availability, Email column, you can click "Copy to Clipboard" to grab the email for each branch that inventory can be sent to.
What should the email contain?
The subject and body of the email do not matter, however, the email must contain exactly one attachment.
This attachment must be a .csv or .txt file with pricing information dictated by consistent header data.
If your file's header rows don't match Kojo's, you can map them to Kojo's defaults in [step 3]. If all of your header data matches, then no adjustments need to be made.
Default CSV format (comma delimited)
How do I know if an inventory list was successfully delivered?
In the branches tab, there is a column called "Last Inventory File Received". If a timestamp is provided, that indicates that the inventory load was successful.
What else should I know?
These Inventory lists must be uploaded on a per-branch basis, as inventory is specific to location.
Files cannot contain multiple rows for the same SKU
Emails should be sent from an email associated with your organization's email domain. Example: <anyemail>@mycompanydomain.com.
If you need to send these inventory files in from a different email domain, please contact us at vendor-integrations@usekojo.com.