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 price lists making it simple for Contractors to apply their unique price offerings on Purchase Orders.
We’ve made enhancements in Kojo to automate ordering for you and the Contractor through our vendor integrations. The price list integration allows you to pass price lists to Kojo via email and receive orders with current pricing.
To send price lists into 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 -> Price Lists and follow the prompts on the page.
How does it work?
Kojo allows you to upload unique prices for each customer. These pricing lists are ingested into Kojo via email.
Our vendor partners typically set their ERP to send automated emails of price lists to respective customers on a regular basis. These lists are typically for their entire catalog.
Where do I get the email address?
Each of your customers will have a unique email address available in the “Customers” tab in Kojo under Options -> Copy Price List Email - this will be the address you will send their price lists to.
Note that the price file email column will not be visible until after you’ve completed [step 1] and [step 2] of the Price Lists integration setup.
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 a price list was successfully delivered?
In the Price Lists tab there will be three possible outcomes of a pricing file.
Success: Delivered, no errors detected
Warning - Content Issue: Delivered, line items are missing required data. Download the report to see what line items have errors.
Failed - Document Schema Issue: The header data of the file is not matching to what was set in [step 3]. Validate and resubmit the file.
What else should I know?
These price lists must be uploaded on a per customer basis, as offered pricing is often individual to specific companies
Files cannot contain multiple rows for the same UPC
Emails should be sent from an email associated with your organization's email domain. Example: <anyemail>@mycompanydomain.com.
If you need to send these price lists in from a different email domain, please contact us at vendor-integrations@usekojo.com.