Vendor Price List Integration

Learn how Kojo automates the buyer's order experience when integrated with a vendor directly via vendor integration.

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.

1. To send price lists to 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.
2. 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 regularly. 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)

* indicates required

• UPC - Universal Product Code
• VPN - Vendor/Supplier Internal Part number.  (the number in your system that you identify the product with.
• UOM - Unit of Measure  (EA, FT, Box)
• Price per - E, C, M.  Also known as Cost Unit of Measure.
• Unit Price
• Description
• Extended Description
• Manufacturer Pn - Manufacturer Specific Part Number
• Manufacturer Name

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 which line items have errors.
• Failed - Document Schema Issue: The header data of the file does not match 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 from a different email domain, please contact us at vendor-integrations@usekojo.com.