ProductCatalog API

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

Please help me with this.

Parents Reply Children
  •  ,

    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

  • Ok Thank You.

    Does sugar have the pricebook related to the products?

  • 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.
  • 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"
    }