Magento – Set Individual Product’s Minimum Qty Allowed in Shopping Cart for a particular customer group

magento2productqtyqty-incrementshopping-cart-price-rules

I'm looking to setup a particular product with a minimum order quantity but only for a single customer group ("Wholesale"). Is there a way to do this using the core Magento 2 functionality? Barring that, is there an extension out there available to get this accomplished?

I know that I can edit a particular product and under the Advanced Inventory set the Minimum Qty Allowed in Shopping Cart value, but this then applies to all customer groups, and I need to target just a single one instead.

CLARIFICATION::
I need to be able to set the minimum quantity for just one product and for just one customer group. Here is a screenshot of the Advanced Inventory window where the value is that I need to set based on the customer group:

Best Answer

Solution 1

Admin -> Stores -> Configuration

For individual settings, go to product details AND Click Advanced Inventory

go to Catalog > Inventory > Product Stock Options.

In Product Stock Options, find 2 sections: Maximum Qty Allowed in Shopping Cart and Minimum Qty Allowed in Shopping Cart.

In Maximum Qty Allowed in Shopping Cart, enter a number to determine the maximum quantity for products added to cart.

In Minimum Qty Allowed in Shopping Cart, pick customer group and assign the minimum order quantity to that group.

Solution 2 (extension)

Min/Max Order Quantity for Magento 2.

to set minimum and maximum order quantity for both customer groups and entire product category

Related Solutions

Magento 1.9 – Set Image Using Default for Particular Store View by Code

There is a store column in Magmi, which takes the Magento store view code, so use default.

And you can prefix the image source with a + sign to set it as default, e.g.

    store                                          image
   default               +http://foo.com/media/catalog/product/s/f/sfv9007a_front.jpg

Include the same for small_image and thumbnail attributes in CSV file above and it should work.

Also make sure you have the Image Attributes Processor plugin enabled within Magmi.

Magento2 – Create Collection of Products with Tier Price for Customer Group

It's possible to do this with the following collection:

protected function _getProductCollection()
{
    /** @var $collection \Magento\Catalog\Model\ResourceModel\Product\Collection */
    $collection = $this->_productCollectionFactory->create();
    $collection->setVisibility($this->_catalogProductVisibility->getVisibleInCatalogIds());

    $collection = $this->_addProductAttributesAndPrices(
        $collection
    )->setPageSize(
        $this->getProductsCount()
    )->setCurPage(
        1
    );

    $collection->getSelect()->join('catalog_product_entity_tier_price as tier', 'price_index.entity_id = tier.entity_id');

    $collection->addFinalPrice()
          ->addMinimalPrice()
          ->getSelect()
          ->where('tier.all_groups = 0')
          ->where('price_index.Tier_price < price_index.price');

    return $collection;
}

This gets all products with tier prices except for ones set in the all group so just the tier prices for that particular group are shown.

Since updating to 2.2.1 I'm not sure why but my Tier_Price column within price_index seems null for everything so returns an empty collection. For now i have overcome this by taking the tier price directly from the catalog_product_entity_tier_price. The where method now looks like below:

->where('tier.value < price_index.price');

Best Answer

Related Solutions

Magento 1.9 – Set Image Using Default for Particular Store View by Code

Magento2 – Create Collection of Products with Tier Price for Customer Group

Related Topic