Skip to main content

Questions tagged [sku]

Question related to Magento products' SKUs. It is an identification code that helps track the item for inventory.

Filter by
Sorted by
Tagged with
6 votes
1 answer
2k views

How to get the product id and SKU code of the product selected

I am using a plugin to enable notify me (Out of stock) feature, the plugin is working properly but the problem is it is taking the core product id and storing it in the backend, even after I select a ...
2 votes
1 answer
2k views

Dynamically updating the sku on the product page of a configurable product based on selected options

I've successfully got the attributes to update dynamically for the SKU on the product page based on the simple product selected (through help found on the web). I'm now trying to apply this logic to ...
0 votes
2 answers
3k views

Product SKU requirements. What characters are restricted from a product SKU and can there be spaces in the middle of the SKU?

For product SKU's can there be spaces in the middle of the SKU? Are there any character restrictions that can not be used for a SKU ?
0 votes
2 answers
1k views

Get product using SKU with respect to the store data using Magento 2 REST API

I use the core API /V1/products/:sku to get the product using the SKU. for example, I have 2 stores, one in English and another in Japanese. My API Endpoint is like http://local.mystore.com/storefront/...
0 votes
2 answers
25 views

Order items, product with options set sku with custom delimeter

I have a simple product with options. When I add to the cart and buy, I have a new SKU with the delimiter '-'. I would like to change the delimiter, where can I do that? Example simple product SKU: ...
3 votes
1 answer
2k views

Dynamically update SKU of configurable product

I have a configurable product with many options. How can I update the sku based on selected options? I have followed this answer, but I am stuck at the JavaScript part. I try to get the this.config....
2 votes
1 answer
908 views

Search by SKU not working in magento 2.3

I am facing some problems while searching with SKU in the catalog search. I have already turned on "Use in Search" and "Visible in Advanced Search" fields for SKU product attribute. However, when I ...
0 votes
1 answer
2k views

Display Dynamic SKU on configurable product view Magento using Image Swatch

I've used the code from the answer in this thread: https://stackoverflow.com/questions/13444995/display-dynamic-sku-on-configurable-product-view-magento It works great when I'm using the drop down ...
2 votes
2 answers
2k views

Display Child Product SKU in Product Page

I am using Magento 2. I would like to display child product SKU in Main product page while user clicks on configurable Swatches. I am trying to gather information from below file. public_html\vendor\...
1 vote
1 answer
1k views

Get SKU of simple product after selecting options of configurable product

How can I get the SKU of a simple product on a configurable product, after options are selected? I tried this solution but I get various errors and issues which make me think it is outdated. Magento 2 ...
0 votes
1 answer
2k views

basic product repository save not work in cron - magento2

I tried the below code in custom controller and cron job method [just load and save] after that I felt some issues $product = $this->productRepository->getById(548); $this->productRepository-...
2 votes
2 answers
2k views

Passing sku code value to TrustPilot product review

hope someone can help. I'm trying to set up a 3rd party review platform (TrustPilot) for our Magento 1.9 CE store, using Ultimo theme. There is a product review box which will display individual ...
1 vote
1 answer
619 views

How do i create a stock level report in magento?

I need to get a stock report from Magento. what do we have in stock? what SKUs - what Qty. how do I do this?
0 votes
1 answer
25 views

how to update the SKU values

Magento Verrion: 2.4.3-p1 Problem: I tried to update the products weight value in the admin panel. I changed the weight value 1.2kgs(current) => 2.8kgs(preffereable) and press the save&exit ...
2 votes
2 answers
1k views

Why my bundle products return a different SKU?

I'm getting the SKU from my Bundle product and the products associated too, but the result bellow showed up. Bundle Product SKU: BundleQA-GT-5AHG30008P Simple Product SKU: GT-5AHG30008P It's ...
1 vote
0 answers
22 views

Search with - does not give results?

Magento 2.4.6 Searching a SKU like abc123 works ok, but as soon as a "-" is included like abc123-456, it does not find a single product. Why is that? I am using elasticsearch. Can the search ...
1 vote
1 answer
54 views

How to add a stock availabilty and sku next to price of the product on product page in magento 2?

How to add a stock availabilty and sku next to price of the product on product page in magento 2 ? Please answer this briefly because i am new in magento 2. Also do we have to create a particular ...
3 votes
4 answers
7k views

SQL Query to fetch all child SKUs by using the configurable SKU

I am trying to create a SQL query that will display all the SKUs of a simple product that are related to a configurable product. I will add the configurable SKU via a form field that I want to query. ...
0 votes
1 answer
1k views

add the sku to the url key Magento 2

I want to rewrite the url of product from www.example.com/product-name.html To www.example.com/SKU.html Someone can help me? The products we sell are unique, but share the same name. So when we add ...
0 votes
3 answers
934 views

Unable to get Stock Item via REST API

I have a product with a very weird SKU (which is valid in Magento 2.3.2): Although, REST API requires using SKU as a part of URL to get the stock item info. How is it possible to use that SKU as a ...
0 votes
2 answers
71 views

Is there a script that would identify records with spaces in SKU via PhpMyAdmin?

Magento 2.4.5-p1 I am getting the Error when browsing products which I think has to do with the fact that some of the products I imported from Magento 1.x have SKUs with spaces. Is there a script I ...
0 votes
2 answers
72 views

Update SKU using entity ID in import

I am trying to update sku using entity id and it's working but issue is when i try to order that product from the front-end it shows "There are no source items with the in stock status". ...
3 votes
2 answers
2k views

increase length of sku in magento 2

We use magento 2.2.2 and we need a longer SKU. We set "const SKU_MAX_LENGTH = 255;" in the file module-catalog/Model/Product/Attribute/Backend/Sku.php but it does not work
0 votes
1 answer
42 views

return special price to blank value

I am trying to return the special price that some products have to the value that they had by default "blank value" or eliminating the value that these have, I want to do it loading template ...
0 votes
1 answer
33 views

Upgraded to Magento 2.4.5-p1. Our SKUs are 13 digits. Search won't return anything unless SKU length is 9 or less. Any ideas?

Search won't return anything unless SKU length is 9 or less. Any ideas ?
0 votes
2 answers
421 views

Magento 2.4.3 - How to show SKU on category page?

Is there a way to make SKU show on the Category page?
0 votes
1 answer
285 views

what does this error mean and how to solve it "message":"Products \"%1\" and \"%2\" have the same set of attribute values.","parameters"

I did an upload and the simple skus were created, but the configurable sku shows this error and is not created. What does it mean and how can I fix it?
1 vote
1 answer
665 views

New Order Email Template for Specific Product Type / Sku in Magento 2

We are looking for a solution whereby if a customer orders a specific product or product type, they will receive a different order confirmation (new order) email. The standard confirmation emails ...
0 votes
1 answer
646 views

how can we export SKU with ID in magento2

I want to export sku with magento id. https://prnt.sc/njkYD1jkJrH0 I am trying to find how to export Product ID with a matching SKU
0 votes
2 answers
116 views

Stock update Issue

Running into a problem when updating stock on a configurable product. Basically when one of my stock hits 0 and I do a mass stock update the qty will change but the simple product will remain out of ...
2 votes
2 answers
462 views

How to change the Product NAME and SKU permanently in quote_item table when it is added to cart?

How to do this? I am using checkout_cart_product_add_after event. EDIT: After I did it like this <?xml version="1.0"?> <config xmlns:xsi="http://www.w3.org/2001/XMLSchema-...
2 votes
1 answer
438 views

How to get product custom attribute by using sku or ID in Magento 2?

I have created a custom attribute for product in Magento 2. But how to get that value by sku or id in Magento 2 ? I have got the product id by $product = $this->productRepository->get($...
0 votes
2 answers
1k views

How can I stop Magento from appending SKU?

So I have a bunch of products with custom options and I would like to stop Magento from appending those other SKUS for these orders. This is how it shows: SKU1-CUSTOMOPTION1SKU-CUSTOMOPTION2SKU How ...
2 votes
2 answers
1k views

Can we show Sku in shopping cart in magento 2

I wan to display the sku in the shopping cart. https://prnt.sc/lYQhd5uqcTo-
1 vote
0 answers
42 views

Search filter for SKU

In search bar when I search with SKU at that time suggetion popup appears. Please guide me how can I overwrite search auto suggetion popup with new filter about SKU search
3 votes
3 answers
700 views

Search by SKU in Magento not working properly

Over 3000 of our SKUs contain special characters such as "-", "/", "&". The problem is when we try to search regular SKU (e.g. ABC123) on the front end it returns the ...
0 votes
1 answer
465 views

Magento 2 : Create comma seperated sku filter for custom product grid

I am using Magento ver. 2.4.4. I have a custom grid, displaying the below fields data. item_id, rma_id ,product_sku ,order_item_id ,reason_id resolution_id ,condition_id. I want to create a ...
0 votes
1 answer
154 views

Magento 2 - Adding part number to Invoice and sales > orders > view page

I am trying to added part numbers into the invoice and order view pages. SKU numbers are pretty useless when picking stock when its all part numbers. I have not been able to find someone who has been ...
1 vote
0 answers
418 views

Magento 2 - Fulltext search Product SKU / Product Name in Sales Order Grid

I'm a newbie, new to magento 2. Please guide me here: I want to search fulltext product sku and product id in grid order. I have now added the product sku and product id to the grid, the filter is ...
0 votes
1 answer
780 views

How can we resolve the sales order filter with sku gaves "Something went wrong with processing for sku colum....." in Mageto 2

The Sales Order Grid Not Working And It's Gives this kind of error when search by sku "Something went wrong with processing the default view and we have restored the filter to its original state....
0 votes
1 answer
19 views

Forced rename update function (sku number input > url key input)

How do I code a function that force sku input data into url-key input data everytime I update a simple product or groupe product? This code work only on product creation but I want it to work on ...
13 votes
9 answers
29k views

Delete multiple products in Magento

Is there any way to delete multiple products by filtering with SKU? I have around 1000 products that I want to delete.
1 vote
3 answers
814 views

How To Add Item Sku's and Product Names To Magento 2.2.7 Sales Order Grid

I have modified the order grid layout by adding this code in: vendor/magento/module-sales/view/adminhtml/ui_components/salesordergrid.xml <column name="order_items" class="Magento\Sales\Ui\...
2 votes
1 answer
2k views

Following products with requested skus were not found:

I'm using Magento 2.4.3 and have sold an item, but when I go to ship it, I get this error "Following products with requested skus were not found: Prod-P1234". The product exists with that ...
0 votes
1 answer
431 views

How to get product list by multiple categories with multiple SKUs in Magento 2.3.5

I'm trying to get product collection by Multiple Category Ids with Multiple SKUs. The result has been coming wrong. I can't understand where I'm wrong. The code is given below <?php namespace ...
1 vote
1 answer
62 views

Magento2 - 2 catalogs with the same SKU products

Is it possible to create 2 independent catalogs that will have products with the same SKU? Store1 - catalog1 (SKU1, SKU2, SKU3) Store2 - catalog2 (SKU1, SKU2, SKU3) Or it's never going to work? SKU ...
0 votes
1 answer
68 views

Magento 2 Get Product By First 6 digit SKU

As stated in the title, I want to be able to get Product by only the first 6 digit SKU no Full SKU No : 1350022021000 First 6 Digit SKU : 135002 I have done the code below to test if able to get the ...
0 votes
1 answer
43 views

Admin input value is not accessible after adding the order increment ID while executing the command

I created a custom CLI command where I have to delete the order Items using the Order Increment ID, Item SKU. I used the ask() method after executing the command php bin/magento webkul:orderDelete ...
12 votes
7 answers
15k views

Magento 2 - Why do SKU not change dynamically in configurable product view page

When you change an attribute in a configurable product the product image changes dynamically but the SKU doesn't change. Also, if you add a configured product to your basket it gives you the image of ...
3 votes
2 answers
7k views

What is sku? Should I use it?

Can I defined SKU in this way: let's say I got a lot of M&M chocolates products, all the same chocolates product, and they got different bar code. Can I say that the sku works like the bar code, ...

1
2 3 4 5 6