Thread Details
  • State Suggested Answer
  • Replies 9 replies
  • Answers 1 answer
  • Subscribers 368 subscribers
  • Views 1991 views
  • Users 0 members are here
Forum Actions

ProductCatalog API

Richard Jenkins

I am not able to find the Rest API endpoint for the Product catalog.

Please help me with this.

  • 0

    The endpoint GET /ProductTemplates/tree may be useful.

    André Lopes
    Lampada Global
    Skype: andre.lampada
  • 0 in reply to André Lopes

    and what could be the endpoint for the creation of the product?

  • 0 in reply to Richard Jenkins

    POST /ProductTemplates/tree does the job

    André Lopes
    Lampada Global
    Skype: andre.lampada
  • 0 in reply to André Lopes

    ok thank you.

    and is there any end point for price book?

  • 0 in reply to André Lopes

    also do you have any specific link for the producttemplate endpoint check?

  • 0 Sugar Employee Badge in reply to Richard Jenkins

     ,

    the best way to check which APIs are being triggered is to use Sugar UI itself.

    You can open your Developer Console, navigate to the screen you want, and see which API endpoint Sugar is triggering in the Network tab.

    SugarCRM | Principal Developer Advocate

  • 0 in reply to Rafael Fernandes

    Ok Thank You.

    Does sugar have the pricebook related to the products?

  • 0 in reply to Richard Jenkins

    Sugar OOTB has no pricebooks included, only prices as fields in the ProductTemplates records like

                "cost_price": "547.000000",
                "discount_price": "795.960000",
                "list_price": "804.000000",
    and a field for the price calculation like
                "pricing_formula": "PercentageDiscount",
    Pricebooks must be handled by additional (CPQ) packages.
  • 0 in reply to Richard Jenkins

    GET {{url}}rest/v10/ProductTemplates - read all products

    POST {{url}}rest/v10/ProductTemplates with JSON payload - create product

    PUT {{url}}rest/v10/ProductTemplates/{{product}} with JSON payload - update product

    GET {{url}}rest/v10/ProductTemplates/tree - read category tree

    POST {{url}}rest/v10/ProductTemplates/tree - read category tree

    payload like this:

    {
        "name": "API product 1234",
        "description": "Product created and updated by API calls from POSTMAN",
        "deleted": false,
        "type_id": "",
        "manufacturer_id": "6759641c-15aa-11ee-879e-54ee7593936c",
        "manufacturer_name": "TekWare Inc.",
        "category_id": "6e9ec258-15aa-11ee-b24b-54ee7593936c",
        "category_name": "Tullos Widgets",
        "type_name": "",
        "mft_part_num": "API part no. 700001234",
        "vendor_part_num": "API Vendor Part 1234",
        "date_cost_price": "2023-06-28",
        "cost_price": "547.000000",
        "discount_price": "795.960000",
        "list_price": "804.000000",
        "status": "Available",
        "tax_class": "Taxable",
        "active_status": "Active",
        "date_available": "2004-10-15",
        "website": "",
        "weight": 21,
        "qty_in_stock": 23,
        "support_name": "",
        "support_description": "",
        "support_contact": "",
        "support_term": "",
        "pricing_formula": "PercentageDiscount",
        "pricing_factor": 1,
        "service_duration_value": null,
        "service_duration_unit": "",
        "renewable": false,
        "service": false,
        "lock_duration": false,
        "currency_id": "-99"
    }