After July 2021, the 2.3.x release line will no longer receive quality fixes, or user guide updates. PHP 7.3 reaches end of support in December 2021 and Adobe Commerce 2.3.x reaches end of support in April 2022. We strongly recommend planning your upgrade now to Adobe Commerce 2.4.x and PHP 7.4.x to help maintain PCI compliance.

Order by SKU

Magento Commerce only. Learn more.

Order by SKU gives you the ability to add individual products to your cart by SKU and quantity, or import a list of products from a file.

Order by SKU

Use either or both of the following methods to add products by SKU:

Method 1: Add individual SKUs

  1. Enter the SKU and Qty of the product.

  2. For each additional product that you want to order, click the Add () icon. Then enter the SKU and Qty.

  3. When ready, click Add to Cart.

Method 2: Import a list of SKUs

  1. To prepare the list, do the following:

    • In a spreadsheet, create a file with the column headers sku and qty in lowercase characters.

    • Enter the sku and qty value of each product that you want to import.

    • Save it as a CSV (Comma Separated Value) file.

      SKUs to Import

      Microsoft Excel supports several CSVĀ formats, including CSV (Comma delimited), CSV (Macintosh), and CSV (MS-DOS).

  2. On the Order by SKU page, click Choose File and select your prepared CSV file.

  3. When complete, click Add to Cart.

    If any of the products have additional options, you will be prompted from the shopping cart that the product requires your attention.

    Product Requires Attention

    If you entered duplicate SKUs, the quantities will be combined into a single line item in the shopping cart. Before placing the order, check the quantity ordered to make sure that it is correct. If you change the quantity of any item, click Update Shopping Cart to recalculate the totals.

  4. When ready, click Proceed to Checkout.