How can I add SKU data to my product listing at admin level?

wazeer
Visitor
2 0 6

I want to add SKU data to the product listing at an admin level. Now at product listing just show product name, status, inventory, type, and vendor. So I want to add SKU. How to do that?

wazeer_0-1623212124209.png

 

Replies 25 (25)

Elias
Shopify Staff
2912 285 500

Hey, @wazeer.

This is Elias from Shopify Support. I'd be happy to lend a hand with this!

For individual products, you can add the SKU numbers by going into each product and adding them to the product details. However, if you're looking to add SKU numbers to multiple products, then you can use the bulk editor - this allows you to edit up to 50 products and its variants per page. After selecting the products and entering the bulk editor, the SKU columns is available by default. For any other product attributes, you can add the product properties to the bulk editor. 

Here's an example of the bulk editor from my test store:

09-20-10929-84013

I'd love to know if this is what you're looking for. Let me know!

Elias | Social Care @ Shopify 
 - Was my reply helpful? Click Like to let me know! 
 - Was your question answered? Mark it as an Accepted Solution
 - To learn more visit the Shopify Help Center or the Shopify Blog

wazeer
Visitor
2 0 6

Hi @Elias ,

Thanks for the detailed explanation about edit the SKU. My question is to show SKU at a product listing, you go to admin level click Products > All Products. Now at listing just show product title, status, inventory, type, and vendor. So I want add column SKU between product title and status. Can do like that?

Elias
Shopify Staff
2912 285 500

Hi, @wazeer.

Thank you for following up!

There isn't a way to add a SKU column to the All products section in the admin. However, as a workaround, you can view the SKU for your product listings through the bulk editor or by managing inventory. While we recommend using the bulk editor for editing the SKU numbers, the Inventory ('Products > Inventory') section is able to display the SKU numbers as well.

With that being said, I can also see how this can be a beneficial feature for our merchants, like yourself, and I'd be happy to share your suggestion with our developers. If Shopify moves forward with any changes or updates, you can find it on our changelog or updates page. 

If you have any other questions on this topic, don't hesitate to let me know!

Elias | Social Care @ Shopify 
 - Was my reply helpful? Click Like to let me know! 
 - Was your question answered? Mark it as an Accepted Solution
 - To learn more visit the Shopify Help Center or the Shopify Blog

dzorin
Visitor
2 0 4

I guess this is an absolute necessity to have such an ability in the admin product list.  Not only add the SKU, but any other column too, and even product metafields.  So, a list customization feature would be a great addition to Shopify functionality.

Design_Co-Mac
Shopify Partner
2 0 4

Having SKU visible on All Products would be very useful, I hope this suggestion is implemented.

Elias
Shopify Staff
2912 285 500

Greetings, @dzorin & @Design_Co-Mac.

 

Thank you both for joining the thread and sharing this feedback!

 

I understand that being able to add columns for attributes, such as SKUs or meta-fields, on the product list in the admin can be beneficial for our merchants and I'd be happy to submit this feedback as a feature request to our development team. If Shopify moves forward with any changes to the product list in the admin, then we'll be sure to announce them on the Shopify Changelog.

 

Though the bulk editor isn't on the front page of the product list, it does allow you to add columns, such as SKUs and meta descriptions. Did you two get a chance to see if the bulk editor can assist you with your tasks at hand?

 

Elias | Social Care @ Shopify 
 - Was my reply helpful? Click Like to let me know! 
 - Was your question answered? Mark it as an Accepted Solution
 - To learn more visit the Shopify Help Center or the Shopify Blog

Design_Co-Mac
Shopify Partner
2 0 4

Hi Elias,

I'm afraid the Bulk editor isn't helpful in this regard

dzorin
Visitor
2 0 4

Hi Elias,

Thanks for your reply.

Although the bulk editor may become useful in some cases, it is not in other ones.  Like, in case of my shop – we have 250+ products, most of them have variants, and some do not.  With variants, the SKU comes to the variant level and no longer available on the product level, so that in my case for some products it exists, and for some it does not.  Also, you cannot sort and filter your list by SKU or a set of SKUs.

To have a workaround we have created a metafield on the product level with the reference code that is unique for each product, but since it is a custom metafield, it has the same issues with the product list as SKU does.

The other thing is that I would like to hide certain columns that are in the list but that are not needed for my shop's purposes.  For example, in my shop we have one single product type, so having that column in the product list just wastes space.

Hope this response may help to understand the use cases.


Thanks,

Dmitry

Elias
Shopify Staff
2912 285 500

Hey, @dzorin.

 

Thank you for following up and sharing the additional context!

 

I can see there are some key features, such as being able to sort/filter the product attributes and hiding certain columns, that can be beneficial to improving the bulk editor and I'd be happy to add them as a feature request to our development team. While feature requests isn't something that I can provide a timeframe on, you can keep an eye on our changelog for any upcoming changes or updates to our platform as previously mentioned. 

 

If you have any other questions on this topic, don't hesitate to let me know!

 

Elias | Social Care @ Shopify 
 - Was my reply helpful? Click Like to let me know! 
 - Was your question answered? Mark it as an Accepted Solution
 - To learn more visit the Shopify Help Center or the Shopify Blog

MCOFA
Excursionist
29 0 9

Please submit this request. SKU is basic retail management data and must be a column on the product list page. 

Elias
Shopify Staff
2912 285 500

Hey, @MCOFA.

 

Thanks for joining the thread and voicing your support for this feature!

 

I understand that you also use SKUs as part of your store's basic management data, and I'd be more than happy to add you to this feature request. While I wouldn't be able to provide an update on feature requests, we will announce any changes or new features on the Shopify Changelog.

 

If you have any other questions or feedback, please don't hesitate to get in touch with us! 

 

Elias | Social Care @ Shopify 
 - Was my reply helpful? Click Like to let me know! 
 - Was your question answered? Mark it as an Accepted Solution
 - To learn more visit the Shopify Help Center or the Shopify Blog

Lin_RelationsJP
Excursionist
12 0 2

Hi Elias,

We have the same issue,
would like to display the barcode and SKU on the product list page.
or add other columns to the order listing page.

The bulk editor is not helpful yet.

Do you have any estimated schedule for this feature update?

Elias
Shopify Staff
2912 285 500

Hi, @Lin_RelationsJP.

 

Thank you for joining the thread.

 

I understand that you're also looking to have the barcode and SKU on the product list in the admin, and I'd be happy to add you to this feature request. However, while feature requests can help our developers prioritize the development of new features, we're unable to provide an estimated schedule for when the feature will be added. If Shopify moves forward with new features or changes, then we'll be sure to announce them on the Shopify Changelog.

 

If you've any other questions on this topic, then don't hesitate to let me know!

 

 

Elias | Social Care @ Shopify 
 - Was my reply helpful? Click Like to let me know! 
 - Was your question answered? Mark it as an Accepted Solution
 - To learn more visit the Shopify Help Center or the Shopify Blog

LePatty
Visitor
1 0 0

Just joining the thread. With over 6.500 products it is absolutely necessary for us to display a SKU column. 

Elias
Shopify Staff
2912 285 500

Hey, @LePatty.

 

Thank you for joining the thread and sharing the additional context.

 

I can see how important it is for you to display a SKU column with 6,500 products (and variants) in the Shopify admin, and I'd be happy to share your feedback as a feature request with our development team. While there isn't a timeframe that I can share for developing features or making changes to the platform, you can see announcements of new features and platform changes on our Shopify Changelog

 

That being said, I'd love to hear more about your business and I'd be happy to share some resources to help you get started. 

 

Elias | Social Care @ Shopify 
 - Was my reply helpful? Click Like to let me know! 
 - Was your question answered? Mark it as an Accepted Solution
 - To learn more visit the Shopify Help Center or the Shopify Blog

JR-TMR
Visitor
1 0 0

Yet another company here looking for the SKU in the product list... Coming from other platforms, I'm very surprised this is not implemented. I'm just starting to put together a site on this platform so I'm using the Inventory list to navigate products by SKU, but I'm wondering when I'll find an issue with that method. It would be nice to just view the overall product listings by SKU, instead of perusing an even longer list of all SKU's in the inventory. A customizable column sort would be a nice touch, but a static SKU column at the very least seems like a no brainer.


One other area that seems to be affected by this missing feature is the App market. I've found a good product options editor that should do what I need for complicated products, but it also does not have a way to search by SKU, likely because it's searching from the product category list that doesn't show SKU... So this is a hurdle because I can't easily find the right product to edit options, because I have many product lines that all have the same product name but with different SKU's, that then go into different product categories for vehicle fitment. So, I can't help but wonder if Shopify had SKU's on their product list, if it would also help Apps like these with their own functionality...

 

FYI, the  Bulk Edit "workaround" doesn't help because I can't actually click on a product to open and edit it.

 

I am curious about the Chrome Extension, will look into that.

 

Is there any way to view progress on feature requests? Or maybe a vote area to help promote likelihood of feature implementation?

Elias
Shopify Staff
2912 285 500

Hey, @JR-TMR.

 

Thanks for joining the thread and posting this question!

 

I understand that you're also looking for a way to manage products using the SKU, and I'd be happy to add you this feature request. However, while there isn't a way to view progresses on feature requests, we'll be sure to announce any new features or upcoming changes on the Shopify Changelog

 

If you have any other feature requests, improvement suggestions, or feedback, then feel free to get in touch with us via the Shopify Help Center and we'd be happy to assist you through live chats.

 

If you have any other questions, then don't hesitate to let me know!

 

Elias | Social Care @ Shopify 
 - Was my reply helpful? Click Like to let me know! 
 - Was your question answered? Mark it as an Accepted Solution
 - To learn more visit the Shopify Help Center or the Shopify Blog

anatchim
Tourist
10 0 4

Heya all!

Just jumping in here, to join my voice to this request...

I see this is beeing asked since 2021!!

I wonder howcome Shopify hasn't implemented this yet?


It is absolutely necessary o display a SKU column on an admin leved on the listed products...

Looking forward for updates on this!

MCOFA
Excursionist
29 0 9

Yeah, for example, I want to sort my product list by SKU. Not possible in the Products tab. Very disappointing. Also it is disappointing that I cannot save a preferred and default Product List view. For example, sort by created date. Instead, I need to filter every time.

 

Dean28
Visitor
1 0 0

Hi Elias

How can I add a SKU and Product Code in Collections?

Cheers

Dean

Elias
Shopify Staff
2912 285 500

Hi, @Dean28.

 

Thanks for joining the thread.

 

My apologies for the late response as your post was a follow-up on this thread, and it may have been overlooked previously. Just to confirm, are you looking to add the SKU and Product type columns to the Collections of the Shopify admin? 

 

24-16-qcni9-5ynqe

 

If so, then there isn't a way to do this at the moment. However, I'd be happy to share your feedback as a feature request with our development team. If Shopify moves forward with any changes to how the collections are managed in the admin, then we'll be sure to announce them on the Shopify Changelog.

 

I noticed that you're a new member of our Shopify Community and I'd love to hear more about your business! What types of products are you selling? Do you have a marketing plan prepared for your store?

 

Elias | Social Care @ Shopify 
 - Was my reply helpful? Click Like to let me know! 
 - Was your question answered? Mark it as an Accepted Solution
 - To learn more visit the Shopify Help Center or the Shopify Blog

SoCalMacGuy
Tourist
4 0 4

It's been years and there are still the same basic columns. If Shopify is not going to do anything they need to tell us.

RHM
Shopify Partner
30 0 19

This is a necessary features with shops with many products like us ( 9000+ products ). 
As for the order page, would be nice to be able to customise the columns on the product list.
For us SKU barcode and price are key parameters we need to be able to see when we search products.

At the moment we solved it by creating a Chrome extension that parse all the products ID , make an API request to Shopify and modify the page. 
But this solution is far from being perfect: 
- the process is a bit slow 
- every time shopify updates the admin we need to update the parsing 
The bulk editor and the inventory view don't fit our use case, because the inventory still limited to SKU, and it's by variant, no Product. 

The bulk editor doesn't have a search features, which means we need to search first and then edit, but we actually need extra information to find the right products
Attached an example of how we solved the issue, with SKU , CODE , PRICE and STATUS  being injected dynamically by the chrome extension. 
Screenshot 2021-12-15 at 14.19.42.png

Robots Hate Monkeys
galtt
Shopify Partner
1 0 0

Like you, I am managing a large inventory and find the current tools available in Shopify, such as the bulk editor and inventory view, not entirely fitting our requirements. The ability to have additional information, like the SKU and price, readily available during product searches would significantly streamline our workflow.

Would you be willing to share the Chrome extension you developed? This tool seems like it could be a great asset to our process, and I believe many others in the Shopify community could benefit from such a solution as well.

Thank you for considering my request. I look forward to hearing from you soon.

Best regards,

Gal

RHM
Shopify Partner
30 0 19
Hello, we stopped using the chrome extension because the Shopify page code
changes so often that it were forced to constantly update our code.

With the new searchable Metafields we adjusted out data to be able to
search the products by other parameters, which makes things a bit easier.

The next improvement would be to being able to add the Product Metafields
as columns in the product listing page.
Robots Hate Monkeys