Create personalized prices

This document describes the steps to consider when implementing personalized prices for customer groups.

There are several steps to consider when implementing special prices based on which customer group the customer belongs to.

Extend the Customer module

The spy_customer table must be extended on the project side to include the group ID. For more information about extending the database schema, see Extend the database schema.

The spy_customer table must be extended on the project side to include the group ID. You can read more here on how to extend the database schema.

Extend the Price module

The spy_price table must be extended on the project side to include the group ID. The newly added column must not be mandatory.

Extend the Price module

The Price module must be extended so that you can query prices by SKU and group ID and retrieve the default price.

Import prices

The Importer module takes care of importing data to the SQL database.

Prices are imported by the ProductPriceImporter. If you use the Importer module to load initial data to the SQL database, update the ProductPriceImporter:importOne(array $data) to include the group ID for each price entry.

Adjust prices for cart

For the products in the cart, prices must be displayed according to the group the logged-in user belongs to (if the current user is a guest, the default price is displayed).

The prices for the products in the cart are added by the CartItemPricePlugin.

These values are used by the cart calculators.

You can implement a new plugin to retrieve the price based on the group ID and register it under the CartDependencyProvider:getExpanderPlugins(Container $container).

<?php
   /**
     * @param \Spryker\Zed\Kernel\Container $container
     *
     * @return \Spryker\Zed\Cart\Dependency\ItemExpanderPluginInterface[]
     */
    protected function getExpanderPlugins(Container $container)
    {
        return [
            new CartItemSpecialPricePlugin(),
            /..
        ];
    }

From the QuoteTransfer that is included in the CartChangeTransfer, you can get the customer data and the group ID:

<?php
namespace Pyz\Zed\PriceCartConnector\Communication\Plugin;

use Generated\Shared\Transfer\CartChangeTransfer;
use Spryker\Zed\Cart\Dependency\ItemExpanderPluginInterface;
use Spryker\Zed\Kernel\Communication\AbstractPlugin;

/**
 * @method \Pyz\Zed\PriceCartConnector\Business\PriceCartConnectorFacade getFacade()
 * @method \Pyz\Zed\PriceCartConnector\Communication\PriceCartConnectorCommunicationFactory getFactory()
 */
class CartItemSpecialPricePlugin extends AbstractPlugin implements ItemExpanderPluginInterface
{

    /**
     * @param \Generated\Shared\Transfer\CartChangeTransfer $cartChangeTransfer
     *
     * @return \Generated\Shared\Transfer\CartChangeTransfer
     */
    public function expandItems(CartChangeTransfer $cartChangeTransfer)
    {
        return $this->getFacade()->addGrossSpecialPriceToItems($cartChangeTransfer);
    }

}

Export prices

The special prices also must be exported to the client-side data storage to display the corresponding price to the customer. Data aggregation and export to client-side data storage are handled by the Collector module.

The ProductCollector collects the product data. The ProductCollector:collectItem($touchKey, array $collectItemData) must be modified to collect the prices for the current SKU.

<?php
 /**
     * @param string $touchKey
     * @param array $collectItemData
     *
     * @return array
     */
    protected function collectItem($touchKey, array $collectItemData)
    {
      $collectedItem= [
            'abstract_product_id' =>
            'abstract_attributes' => $this->getAbstractAttributes($collectItemData),
            'abstract_name' => $collectItemData[static::ABSTRACT_NAME],
            'abstract_sku' => $collectItemData[static::SKU], // FIXME
            'url' => $collectItemData[static::ABSTRACT_URL],
            'quantity' =>  (int)$collectItemData[static::QUANTITY],
            'available' => (int)$collectItemData[static::QUANTITY] > 0,
            'category' => $this->generateCategories($collectItemData[CollectorConfig::COLLECTOR_RESOURCE_ID]),
        ];
      $specialPrices = $this->getSpecialPricesBySku($collectItemData[static::ABSTRACT_SKU]),

      $collectedItem=$specialPrices;    

      return $collectedItem;
    }

Display price to customers

The ProductResourceCreator transforms the JSON containing product details stored in Redis into a more understandable format.

The price needs to be set according to the group that the customer belongs to when building the product using the data from Redis.

A controller action that’s called when a request on a product detail page is submitted lets you retrieve logged-in customer information by calling the getUser() method. Now that you know the ID of the group that the customer is a member of, you can set the price of the product according to the group.