Importing Min/Max Qty Per Product

Overview

This guide explains how to import the product settings for:

  • Configure Minimum Quantity Allowed in Shopping Cart, and
  • Configure Maximum Quantity Allowed in Shopping Cart

In the Admin, when enabled, these settings can be configured for each available customer group.

CSV Format

To export the available columns, navigate to Import & Export > Export Products then in the "Additional Column Selection" section, select Extended inventory data

The columns needed for the import of Min/Max Quantity Allowed are below:

min_sale_qty

Global Value for Minimum Qty Allowed In Shopping Cart. If there is no value set for a specific group, it will use this value.

use_config_min_sale_qty

0 = No - meaning the product will use the setting on the individual product rather than the global setting in Products > Settings > Inventory

1 = Yes - meaning the product will use the global setting in Products > Settings > Inventory
Set to 0 when using the min_sale_qty value per product.

max_sale_qty

Global Value for Maximum Qty Allowed In Shopping Cart. If there is no value set for a specific group, it will use this value.

use_config_max_sale_qty

0 = No - meaning the product will use the setting on the individual product rather than the global setting in Products > Settings > Inventory

1 = Yes - meaning the product will use the global setting in Products > Settings > Inventory
Set to 0 when using the max_sale_qty value per product.

Use this column header to set values for Min/Max Qty Allowed In Shopping Cart for the specified Customer Group. See below:

min/max_sale_qty_[Customer Group Name]

Use this column header to set values for Min/Max Qty Allowed In Shopping Cart for the specified Customer Group. See below: