Magento – Magento 2 API, catalog price rule is not applied

magento2

The catalog price rule is working in frontend. But when we get the product from REST API, we are getting the original price only.

Example:
Product price is 34, we were created catalog rule with 10% for all products, in frontend we are getting both prices 30.26 and 34. But from api, we are getting only 34.

Please help.

API EndPoint:

http://localhost/magento/rest/default/V1/products/24-MB01

Partial Response:
{
  "id": 1,
  "sku": "24-MB01",
  "name": "Joust Duffle Bag",
  "attribute_set_id": 15,
  "price": 34,
  "status": 1,
  "visibility": 4,
  "type_id": "simple",
  "created_at": "2017-01-10 07:50:47",
  "updated_at": "2017-01-10 07:50:47",
  "extension_attributes": [],
  "product_links": [],
  "options": [],
}

Best Answer

Special Price is a custom attributes so you will get its details response in Custom Attributes section.

So follow below steps :

Your Api end point should be - http://yourwebsitelink/index.php/rest/default/V1/products/24-MB01/
Pass Authorization Bearer your_access_token in the header
You will get the full response wit details of that product :
So over there at last you will find option "custom_attributes" like below :

"tier_prices": [],
  "custom_attributes": [
    {
      "attribute_code": "description",
      "value": "<p>The sporty Joust Duffle Bag can't be beat"
    },
    {
      "attribute_code": "special_price",
      "value": "30.0000"
    },
    {
      "attribute_code": "special_from_date",
      "value": "2017-02-07 00:00:00"
    },
    {
      "attribute_code": "special_to_date",
      "value": "2017-02-28 00:00:00"
    },
    {
      "attribute_code": "cost",
      "value": "30.0000"
    },
    {
      "attribute_code": "image",
      "value": "/m/b/mb01-blue-0.jpg"
    },
    {
      "attribute_code": "small_image",
      "value": "/m/b/mb01-blue-0.jpg"
    },
    {
      "attribute_code": "thumbnail",
      "value": "/m/b/mb01-blue-0.jpg"
    },
    {
      "attribute_code": "color",
      "value": "49"
    },
    {
      "attribute_code": "news_from_date",
      "value": "2017-02-15 00:00:00"
    },
    {
      "attribute_code": "custom_design_from",
      "value": "2017-02-15 00:00:00"
    },
    {
      "attribute_code": "category_ids",
      "value": [
        "3",
        "4"
      ]
    },

From there you will get attribute_code = special_price and its value

Related Solutions

Magento – Magento 2 API – Get list of products with Catalog Price Rule

When you create a catalog price rule, Magento creates some entries in catalogrule_product table. You can see which products are affected by the price rules created.

Unfortunately ProductRepository does not allow you to filter by catalog price rule. However, you can modify this class by extending it.

The only thing you need to add is the following line.

$collection->joinTable('catalogrule_product', 'product_id=entity_id', ['product_id'], null, 'inner');

Let's say create MyProductRepository as follows:

class MyProductRepository extends \Magento\Catalog\Model\ProductRepository
{
    public function getList(\Magento\Framework\Api\SearchCriteriaInterface $searchCriteria)
    {
        /** @var \Magento\Catalog\Model\ResourceModel\Product\Collection $collection */
        $collection = $this->collectionFactory->create();
        $this->extensionAttributesJoinProcessor->process($collection);

        foreach ($this->metadataService->getList($this->searchCriteriaBuilder->create())->getItems() as $metadata) {
            $collection->addAttributeToSelect($metadata->getAttributeCode());
        }
        $collection->joinTable('catalogrule_product','product_id=entity_id', ['product_id'],null, 'inner');
        $collection->joinAttribute('status', 'catalog_product/status', 'entity_id', null, 'inner');
        $collection->joinAttribute('visibility', 'catalog_product/visibility', 'entity_id', null, 'inner');

        //Add filters from root filter group to the collection
        foreach ($searchCriteria->getFilterGroups() as $group) {
            $this->addFilterGroupToCollection($group, $collection);
        }
        /** @var SortOrder $sortOrder */
        foreach ((array)$searchCriteria->getSortOrders() as $sortOrder) {
            $field = $sortOrder->getField();
            $collection->addOrder(
                $field,
                ($sortOrder->getDirection() == SortOrder::SORT_ASC) ? 'ASC' : 'DESC'
            );
        }
        $collection->setCurPage($searchCriteria->getCurrentPage());
        $collection->setPageSize($searchCriteria->getPageSize());
        $collection->load();

        $searchResult = $this->searchResultsFactory->create();
        $searchResult->setSearchCriteria($searchCriteria);
        $searchResult->setItems($collection->getItems());
        $searchResult->setTotalCount($collection->getSize());
        return $searchResult;
    }
}

Be careful, you cannot use \Magento\Catalog\Api\ProductRepositoryInterface anymore. You have to call your implementation.

$productRepository = $objectManager->get(\MyVendor\MyModule\Model\MyProductRepository::class);

Magento – GET or SET Product special price using REST API

you can achieve everything via rest/V1/products endpoint

// get token
$userData = array("username" => "MyUsername", "password" => "MyPassword");
$ch = curl_init("https://example.com/index.php/rest/V1/integration/admin/token");
curl_setopt($ch, CURLOPT_CUSTOMREQUEST, "POST");
curl_setopt($ch, CURLOPT_POSTFIELDS, json_encode($userData));
curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
curl_setopt($ch, CURLOPT_HTTPHEADER, array("Content-Type: application/json", "Content-Lenght: " . strlen(json_encode($userData))));

$token = curl_exec($ch);
$token = str_replace('"', '', $token);

// get product special price
$ch = curl_init("https://example.com/index.php/rest/V1/products/24-MB04");
curl_setopt($ch, CURLOPT_CUSTOMREQUEST, "GET");
curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
curl_setopt($ch, CURLOPT_HTTPHEADER, array("Content-Type: application/json", "Authorization: Bearer " . $token));

$result = curl_exec($ch);
$data = json_decode($result,true);
$specialPrice = $data['price'];

foreach ($data['custom_attributes'] as $attr) {
    if ($attr['attribute_code'] == 'special_price') {
        $specialPrice = $attr['value'];
    }
}
echo $specialPrice;


// update special price
$productUpdate = [
    'product' => [
        'sku' => '24-MB04',
        'custom_attributes' => [
            'special_price' => 20.99,
        ]
    ]
];
$productsJson = json_encode($productUpdate);

$ch = curl_init('https://example.com/index.php/rest/V1/products');
curl_setopt($ch, CURLOPT_CUSTOMREQUEST, "POST");
curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
curl_setopt($ch, CURLOPT_POSTFIELDS, $productsJson);
curl_setopt($ch, CURLOPT_HTTPHEADER, array("Content-Type: application/json", "Authorization: Bearer " . $token));
$result = curl_exec($ch);

Best Answer

Related Solutions

Magento – Magento 2 API – Get list of products with Catalog Price Rule

Magento – GET or SET Product special price using REST API

Related Topic