back to resources

SKU Number Lookup: Walmart, Home Depot, and More

By
Bradley Johnson
Table of Contents

Do you have a SKU and need more information about the product itself? Are you selling items on an online marketplace and need to make your own SKUs for warehousing? Perhaps you’re learning how a SKU number is structured by doing a SKU number lookup with other businesses? 

In any of these cases, you have information to look up. Because SKUs are an internal method of inventory management, you won’t have public access to look up SKUs in many cases. However, there are still ways to get the SKU itself or related information.

Of course, if you need to create new SKUs for your own purposes, there are many ways to do this. You can use a SKU generator to create your data strings and perform SKU rationalization every couple months to keep a streamlined product list. 

Keep reading for step-by-step instructions on SKU number lookup for several big-box retailers.

How to Locate a SKU

The instructions below assume that you’ve already done what’s possible to obtain a SKU. If you don’t have the SKUs you need yet, you can sometimes find them in the following locations: 

  • Product boxes, labels, and tags
  • Near the UPC barcode
  • On paper or emailed receipts
  • Packing slip

If you haven’t found the SKU yet, that’s okay. SKUs are difficult to track down because most of the people who use them are a company’s own employees. 

With the right information, you can find additional details on tens of thousands of products. You may not find the SKU itself, but you may find data that helps you in your search. 

Let’s look at how to conduct a SKU number lookup for large retail chains like Target, Lowe’s, West Elm, and more.

Walmart SKU Number Lookup

Walmart remains the largest retailer in the US. The company started in 1962 and sells thousands of everyday products. The Walmart digital catalog includes home essentials, cleaning supplies, groceries, books, and hundreds of other goods. 

Here’s how to find additional product details via a Walmart SKU number lookup: 

  1. Navigate to Walmart.com in your Internet browser. 
  2. Using the search bar at the top of the page, type in the SKU number or a detailed product title.
  3. Look at the products on the search results page. Select the item that matches your SKU or best fits what you’re looking for.
  4. Review the product’s detail page. Here you’ll find information like price, weight, size, and color. Return to the search results page and keep browsing if you haven’t found the item you’re looking for. 
  5. Once you’ve found the correct item, you can review the page for the info you need. Walmart’s Customer Q&A section helps buyers share information with each other, and at times, you may find a SKU number here. However, be advised that customer forums should not be treated as a source of authoritative information. 
screenshot of blanket on walmart.com


Home Depot SKU Number Lookup

Home Depot is one of America’s biggest home improvement retailers, only outpaced in number of stores by True Value and Ace Hardware. The company is known for their vast selection of products, ranging from HVAC and lighting to plumbing, gardening, and more. 

To find product details based on a Home Depot SKU, follow these steps: 

  1. In your web browser, navigate to HomeDepot.com. 
  2. Type in the product SKU if you have it, otherwise, type in a search query and hit enter.
  3. Once you’re on a product’s detail page, you’ll see three numbers in the upper left hand corner of the page. One is the Internet number, which is how the product is categorized on Home Depot’s website. The next is the model number, which identifies the specific product type. The final number is the store SKU, which is used for tracking and storing the item in retail stores. 
  4. You may also see a store SO SKU. SO stands for special order and is used when a customer orders a product that isn’t currently available at their local store. The number is used to signify a one-time product order that isn’t part of normal inventory tracking. Customers can later pick up their order once the store has had time to ship it in. 
  5. After finding the SKU, you can browse additional product information, like price, dimensions, features, and weight. 
screenshot of lightbulbs on homedepot.com



Home Depot also has a type of SKU number lookup for product ordering called Quick Add. Here is how to use that feature: 

  1. In your web browser, navigate to HomeDepot.com, then use the top-level search bar to type in “quick add”. Alternatively, you can search online for “home depot quick add”. 
  2. Once you’re on the Quick Add page, review the various methods for adding store SKUs to an upcoming order. This page includes information about optional steps for collecting SKUs in your preferred manner. 
  3. Near the bottom of the page, click on the orange “Quick Add” button. This takes you to the SKU entry page. 
  4. Once on the SKU entry page, begin adding SKUs to the empty fields. Add or edit information based on the quantity of items you need. A green inventory checkmark will display if your store has the item(s) in stock. 
  5. If you’d rather add several dozens or hundreds of SKUs at once, download Home Depot’s SKU Excel template. Fill out the template, save it, and upload it to the Quick Add page. 
  6. Click on Save to List or Add to Cart when you’re done. You can then review a larger list of SKUs or begin the checkout process, respectively. 

screenshot of Home Depot's quick add page

Menards SKU Lookup

Menards is a large home improvement and hardware retail chain founded by John Menard Jr. He started the company as a means of paying his way through college. Menards has grown to compete with the likes of Home Depot and Lowe’s and sells building materials, home equipment, gardening tools, and more. 

Follow the steps below for a Menards SKU lookup: 

  1. Using your web browser, navigate to Menards.com. 
  2. Type your SKU number into the search bar at the top of the page and hit enter. The website will pull up the product. If you don’t have a SKU, enter a detailed product title in the search bar and press enter.
  3. Look through the search results page for the product you need. Menards’ website displays a product’s SKU or model number near the price. 
  4. Click on the product that you’re interested in. On the product detail page, the SKU will be displayed beneath the product title. 
  5. Keep browsing the product’s detail page for any other information you need. 

screenshot of adjustable wrench on Menards.com

Target SKU Lookup

Target is a well-known retailer in North America, selling products like household essentials, groceries, and clothing. They also relabel products created by other manufacturers, so they’re a great resource for researching white label vs private label

If you need product information based on SKU, here is how to do a Target SKU lookup: 

  1. Navigate to Target.com in your web browser. 
  2. Type the SKU number into the search bar at the top of the page and press enter. 
  3. Review the products that pop up. If there is more than one product, select the item that appears to be the closest match. 
  4. View the information on the product detail page. You’ll be able to see any product variations, whether or not the product is in stock, and its price. You can also find info like product dimensions, weight, material, and basic features. 
screenshot of product details on Target.com

Lowe’s SKU Number Lookup

Lowe’s is one of the largest home improvement retail chains in the world, second only to Home Depot in the United States. Lucius Lowe founded the company 100 years ago in North Carolina. Originally the store sold products beyond hardware and tools but has since consolidated to solely home improvement and construction products.

Here is how to look up SKU information on the Lowe’s website: 

  1. In your web browser, navigate to Lowes.com. 
  2. Type in the SKU number of the product you need in the top-level search bar and press enter. If you don’t have the SKU, type in the closest product details you have available and hit enter. 
  3. Review the search results page for the right product. If you see the product you’re looking for, click on it. Otherwise, continue browsing until you find the correct item.
  4. Once you’re on the product’s detail page, you can find the item and model number. This is on the right-hand side of the page below the product title. 
  5. Lowe’s doesn’t usually list SKU numbers on their website, but their model numbers are useful alternatives. Remember that a model number is not the same as a SKU, but in many instances, it’s the closest public info you’ll be able to uncover.
  6. Similar to Walmart, Lowe’s has a customer Q&A section near the bottom of product pages where buyers can ask questions. On occasion, you may find a SKU number here, but remember that it shouldn’t be treated as an authoritative source of info. 
screenshot of electrical outlets on Lowes.com

West Elm SKU Lookup

West Elm is a Williams-Sonoma-owned brand of furniture, home goods, and other high demand products. The brand’s products are known for their modern aesthetics and simple colors. West Elm has storefronts throughout the United States, including Minnesota, Georgia, Michigan, California, and Indiana. 

Here is how to look up a SKU on West Elm:

  1. Navigate to WestElm.com while using your web browser. 
  2. Once you’re on the website, type your SKU number into the search bar at the top and hit enter. If you don’t have a SKU yet, use their top-level menu to select a product category, or enter a product title in the search bar and press enter.
  3. Review your search results pages. Select the right product or the item that looks most like the one you need. 
  4. West Elm SKUs are found directly beneath the quantity selector on product detail pages. If you select a product that doesn’t have any variations, the SKU will be visible right away. 
  5. If you select a product that has one or more variations, you’ll need to select the product variation you’re interested in first. After your selection is made, the SKU should become visible beneath the quantity selector. 
screenshot of patio umbrella on WestElm.com

What to Do If You Can’t Find a SKU

If you’ve already tried looking on a company’s website and the product’s own labeling for the SKU but don’t have an answer, you can try a few other methods. The first is calling the store closest to you on the phone and mentioning that you’re looking for a SKU number. 

Some companies may have additional questions before they offer that information, and some may not offer SKU data at all. This is never something to take personally; it simply means that’s the company’s policy. 

A second backup method is physically going into a store and picking up products, though this requires time and energy. If no other options exist, consider writing down product item or model numbers, going into the store, and speaking with an employee about the SKUs. 

SKU Lookup Tools

A third backup method is using online inventory checkers. These websites allow you to pull up inventory information from many big box retailers. As long as you have a UPC, model number, DPCI, or Internet number, you can gather further inventory information. 

Here are some sites that offer inventory lookup tools: 

  • Brickseek
  • NowInStock
  • ZooLert
  • Popfindr
  • Hip2Save
  • StockTrack

SKU, I’ve Got Your Number

Doing a SKU number lookup can be monotonous at first but has important ramifications for your business. An organized SKU plan saves you time, keeps your warehouse organization in great shape, and ensures your warehouse management system is up to date.

Having accurate SKUs is always helpful, whether you use an eCommerce website builder or BlueCart eCommerce. You can order new supplies knowing you have the correct type of item. Be persistent in your search and you’ll find the information you need.