Order by SKU

Adobe Commerce feature {width="20"} Exclusive feature only in Adobe Commerce (Learn more)

A ‘SKU’ is a ‘Stock Keeping Unit’. SKUs generally help online sellers identify the most important product characteristics such as: size, color, price, and material. Product IDs are different from SKUs:

  • The Product ID is sequential series of numbers that are used internally to identify products and are not available to customers.
  • The SKU is generated by the seller, normally based on the product name and attributes for marketing or internal tracking. For example: A blue, cotton T-shirt, size medium: T-COT-MED-BL. The SKU may be changed by the seller if necessary.

Normally, a SKU includes a set of abbreviations indicating the distinguishing characteristics of the product. The maximum SKU length is 64 characters. SKUs are important to effectively track and manage inventory, so setting them up correctly is critical for e-commerce.

Order by SKU is a widget that can be displayed in the store as a convenience for all shoppers, or made available to only the shoppers in specific customer groups. Shoppers can either enter the SKU and quantity information directly into the Order by SKU block, or upload a csv file from their customer account. Regardless of the configuration, order by SKU is always available to store administrators.

Order by SKU in the Storefront

Configure order by SKU

  1. On the Admin sidebar, go to Stores > Settings > Configuration.

  2. In the left panel, expand the Sales section and choose Sales underneath.

  3. Expand Expansion selector the Order by SKU Settings section.

  4. Set Enable Order by SKU on my Account in Storefront to one of the following:

    • Yes, for Everyone – The Order by SKU block is available in the store for every shopper.
    • Yes, for Specified Customer Groups – Order by SKU is available only to members of a specific customer group, such as Wholesale.
    • No – The Order by SKU block does not appear in the storefront, and the Order by SKU page is not available in the customer account.

    Order by SKU Settings {width="600" modal="regular"}

  5. Click Save Config.

Adobe Commerce B2B (Adobe Commerce B2B only) To enable the Order by SKU function, disable the Quick Order function:

  1. Go to Stores > Settings > Configuration.

  2. In the left panel under General, choose B2B Features

  3. Expand Expansion selector the B2B Features section.

  4. Set Enable Quick Order to No.

    The Quick Order feature allows customers and guests to quickly place orders based on SKU or product name.

Storefront experience

When the functionality is configured for the store, customers can order by SKU from any page that includes the Order by SKU widget or from their account dashboard.

Order by SKU from the page block

  1. In the Order by SKU block, the customer enters the SKU and Qty of the item to be ordered.

  2. To add another item, clicks Add Row and repeat the process.

  3. Clicks Add to Cart.

Order by SKU from a customer account

  1. From the storefront, the customer logs in to their account.

  2. In the panel on the left, chooses Order by SKU.

  3. Adds individual items according to preference:

    Adds each item by SKU:

    • Enters the SKU and Qty of the item to be ordered.

    • To add additional items as needed, clicks Add Row Plus sign button and repeats for as many items as necessary.

    • Clicks Add to Cart.

    Uploads a CSV file of multiple items:

    • Prepares an import data CSV (Comma-Separated Value) file that includes columns for SKU and Qty.

    SKUs to Import {width="500" modal="regular"}

    • To upload the CSV file, clicks Choose File and select the file to upload.

    • Clicks Add to Cart.

    If any of the products have additional options, the customer is prompted from the shopping cart that the product requires attention.

    Product Requires Attention {width="600" modal="regular"}

    note note
    If there are duplicate SKUs, the quantities are combined into one line item in the shopping cart. The customer can change the quantity of any item and click Update Shopping Cart to recalculate the totals.