After July 2021, the 2.3.x release line no longer received quality updates or user guide updates. PHP 7.3 reached end of support in December 2021, and Adobe Commerce 2.3.x reached end of support in September 2022. We strongly recommend upgrading to Adobe Commerce 2.4.x to help maintain PCI compliance.

Order by SKU

This site contains archived merchant documentation for a version of Adobe Commerce and Magento Open Source that has reached end-of-support. The documentation available here is intended for historical reference only and is not maintained. The Adobe Commerce Merchant Documentation for current releases is published on the Adobe Experience League.
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.