Kojo allows suppliers to automate sending catalog and pricing files to enhance the ordering experience for their contractors in Kojo. 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 help make ordering for you more efficient between 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. The catalog integration allows you to send more robust part data from your system to Kojo. This allows your customers to see more data directly from you in Kojo!
Catalog Integration
You can copy the catalog email from your account and automate sending catalogs to Kojo to ensure that Kojo has your most up to date list of parts in your catalog. Click the Copy Catalog Email button to copy the email and begin sending your catalog file. The columns and format of your file will be the same as the pricing files you configure on this page.
Price Lists Integration
- 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.
- Visit Admin -> Setup -> Catalog & Pricing and configure the format of your pricing file.
g.
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)
UPC* | VPN* | UOM* | Price Per* | Unit Price* | Description* | Extended Description | Manufacturer PN | Manufacturer Name |
* 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.
NOTE: If your price list email fails, you can look at the error, make any necessary updates, and then upload it again to the same email that the file was originally sent to.
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.
Comments
0 comments
Please sign in to leave a comment.