QCQ Configuration
      Back to home
      1. LearnCQ
      2. QuoteCQ
      3. QCQ Configuration

      CalcuQuote: How to set up your Manex API

      Interested in connecting CalcuQuote and Manex?

      Here is the values you can pull in on your BOM:

      • Part Number

      • Description

      • UOM

      • Purchase UOM

      • Order policy

      • Package

      • Inventory note

      • Buyer type

      • On hand stock

      • Doc lead time

      • Standard cost

      • Standard cost date

      • Minimum order

      • Order multiple

      • User cost

      • Abc value

      • Panel count

      • Status

      • PCBlayer

      • Part specs

      • Inspection req

      • Certification req

      • Certification type

      • Customer rev

      • User feedback

      • Part last changed date

      • Part last changed by

      • Target price

      • Target price date

      • Material type

      • Part created date

      • Instore part

      • Part class

      • Part type

      • Customer pn

      • Attrition %

      • Lead qty

      Here are instructions to generate an API key in Manex:

      You'll need to have access to SQL Server Management Studio, your Manex Database, and your network firewall settings.

      1. Create a manex user and assign permissions (currently, only inventory permissions are needed)

      2. Go to SQL database, and enter query "Select * from aspnet_profile" to identify the user

      3. Note the UserId for the user you just created.

      4. Run the following transaction in sql database to enter the API key:

      "Update ASPNET_Profile set ApiKey = 'YOUR API KEY' where UserId = 'USER ID VALUE';"

      We will need you to send:

      • Web manex url

      • API key

      The IP address that may access your servers to synchronize the data are:

      ------------------------------------

      Production IPs

      52.165.80.100

      52.176.56.232

      52.173.199.235

      52.173.20.190

      40.86.120.149

      52.173.202.93

      168.61.179.235

      104.43.204.174

      104.43.226.250

      168.61.178.33

      23.99.253.155

      52.126.182.232

      20.141.98.84

      ------------------------------------

      Therefore, you'll need to open up your firewall to that IP address for the web port which web manex is using.

      Once we do this, we'll be able to look up your manex part numbers based on the MPN you enter into CalcuQuote.