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
0
votes
0answers
8 views

how to increase sku 64 symbols to be 255 symbols at magento 2.3.2

how to increase sku 64 symbols to be 255 symbols at magento 2.3.2 the below image https://i.imgur.com/MaWo0Qo.jpg i did this solution but still same issue any advice set "const SKU_MAX_LENGTH = ...
1
vote
0answers
28 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
0answers
9 views

sort order as newest product first option in products in category in category edit does not showing in magento 2.3.2

I want to sort category default sort as newly added SKU at top and oldest at last , this means new to old (SKU) default sorting in frontend of magento 2. But i am not able to see option => sorting ...
0
votes
1answer
36 views

Magento 2 How to Insert sku in product title

run this sql query but nothing happened:: UPDATE `catalog_product_entity_text` as pt LEFT JOIN `catalog_product_entity` as p ON p.`entity_id` = pt.`entity_id` SET pt.`value` = CONCAT(pt.`value`,' (',...
0
votes
1answer
18 views

Magento 2.2.3 How to export products with SKU filter in admin?

Hi, I need to export products with .csv file. But I need to export products with specific SKU. For example, I wanted to export the products which SKU was 60010, 60012 and 45580 I know I should apply ...
0
votes
1answer
48 views

Magento2.3: Product level validation in cart price rule is not working

I want to apply coupon for a particular product, so I have set the coupon is valid for SKU basis and selected the product which I wanted that the coupon has to apply. Please see the below screenshot. ...
0
votes
2answers
56 views

Display related products on sidebar

I want to display related products if they exist on the sidebar on product page over featured products. Please advise EDIT ADDED catalog_product_view.xml code <referenceBlock ...
0
votes
1answer
12 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 ...
0
votes
1answer
23 views

Magento 2: Disable search by SKU storefront

I would like disable the storefront search by SKU. I changed but it still shows results by sku. Any idea?
0
votes
1answer
39 views

How to disable sku from dashboard ? Magento 2

I need to disable Sku from the dashboard and not from the code, is this possible?
0
votes
0answers
33 views

Search Product by SKU programatically using search criteria

I need to search product programatically using search_criteria public function search($storeId, $searchTerm, $searchOrder, $searchDir, $page, $pageSize, &$totalSearchResults, &$attrs_applied, ...
0
votes
0answers
9 views

Is it possible to create a product without assigning a sku?

as a bundle item, need to crete a product that a display layout is pulliung from that consisets of several ite,ms that DO have part numbers, but i need the core product to not contain a product number....
1
vote
1answer
27 views

How to add SKU in the attribute list in the More Information tab of the product view page?

I have added the following code to catalog_product_view.xml to show the SKU in the list of attributes inside the "More information" tab <referenceBlock name="product.info.details"> <...
0
votes
1answer
41 views

Magento 2 SKU and URL Key is not generating unique by default

When I create multiple product with same SKU and same URL Key it is creating, as I know Magento do not allow this. I googled alot but didn't find any configuration for this, Please guide me what is ...
0
votes
1answer
96 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
0answers
11 views

Updating configurlabe product sku in observer

I am trying to update a configurable product SKU and it is children SKU in observer after this event catalog_product_save_after. When I update the SKU the association between parent and child product ...
1
vote
0answers
53 views

Magento 2 exclude products from catalog price rules

I'm facing this problem. I have around 70 products in different categories and different attributes sets, but with the same common attribute (SKU). I have 3 catalog price rules which applies ...
2
votes
1answer
29 views

Add a 2 character prefix to the SKU on the product detail page

I've been trying without success to prepend the the SKU on the product detail page with 2 characters - R9. I've already added some customisations to the page using a catalog_product_view.xml but I ...
0
votes
1answer
74 views

Magento2.3: How to move sku above product title?

I want to move the sku above the product title. But the problem I'm facing is that I can see two of the sku's in the product page(one is under product title and another is parallel to price). Please ...
0
votes
0answers
21 views

Custom sku for product based on category break configurable relations

I am trying to develop a module to change the SKU for the product if the product SKU contain auto keyword I created events.xml file and added <event name="catalog_product_save_before"> &...
1
vote
1answer
45 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\...
0
votes
0answers
24 views

Create Simple products with Configurable Product name instead of SKU

When you create simple products in Magento 2.1.18 they inherit the SKUs name from the Configurable product. But we want it to be the Product name instead of the SKUs. Is this easy code change or ...
1
vote
4answers
83 views

How to use Split or explode Function in Observer?

Observer File : <?php class Gta_MatchProductOrder_Model_Observer { public function checkproductinorder($Observer) { $order = $Observer->getEvent()->getOrder(); $items ...
0
votes
1answer
19 views

SKU codes problems while uploading bulk products

I am having problem while uploading bulk products. Let suppose I am uploading 3 products having SKU following: SFP-10G-AOC1.5M-AO SFP-10G-AOC1-5M-AO SFP-10G-AOC1/5M-AO While uploading ...
0
votes
1answer
31 views

Create a script to update the SKU and set SKU using CSV

How To Create a script For Update Product SKU Using Custom Script.
1
vote
0answers
31 views

How does SKU number is generating in Magento 2?

I would like to know how Magento 2 generates SKU number? While checking Mask for SKU in admin, there is filled as {{name}}. So when I create a product, the SKU automatically filled with the product ...
0
votes
2answers
239 views

Magento 2 How to update SKU after saving product from admin panel?

I want to update product sku after save product. I had used this event :- catalog_product_save_after In Observer, public function execute(\Magento\Framework\Event\Observer $observer) { ...
0
votes
1answer
51 views

Magento 2 - Cannot edit or update SKU Value

When I try to update SKU from the admin catalog page in Magento 2. It throws error "Validation failed" and in exception log, it shows the following error. main.CRITICAL: Validation Failed {"exception"...
2
votes
2answers
123 views

Load Product Qty by sku in Magento 2 Controller

public function execute() { // Product Colletion $collection = $this->_productCollectionFactory->create(); $collection->addAttributeToSelect(['name', 'special_price', 'entity_id']...
0
votes
1answer
171 views

Magento 2 this is possible to set different SKU store wise on a same product

I want to set different SKUs for different store wise. This is Possible? Example, I have an ABC Product. For the English Store, I want 'En-Abc' SKU. For the Arabic Store, I want 'Ar-Abc' SKU....
2
votes
1answer
149 views

How to remove SKU column from order details in My account page

I wish to remove SKU from order details. Open my account page in frontend 2.Go to My Orders 3.Click View Orders link from the list of orders How to remove the SKU colum and its associated details. ...
0
votes
1answer
91 views

How does Magento 2 sku generated automatically?

I want to know how does Magento 2 sku generated automaticlly. I wonder when I type product name while creating new product in admin then its sku is automatically typed in sku field. I researched ...
0
votes
2answers
42 views

Magento 2 url key includes SKU number, how to remove?

The big problem with Magento somehow amending the url key to include the SKU where /product-title-stec00778.html should be /product-title.html and the SKU is SKU STEC00778 Any ideas? Not ...
0
votes
1answer
55 views

Magento 1.9 Suddenly will not accept an SKU starting with a letter

I'm currently running a staging copy of a live Magento 1.9 site. On this staging site I have noticed that if I attempt to add a new product with an SKU that begins with a letter (character between A-Z)...
0
votes
1answer
98 views

How to replace SKU with a custom attribute on the frontend

our product has SKU and P/N number. All product's SKU has the same, but the P/N will depend on the country, so I've created an attribute "P/N" and want to show P/N on the product page instead of SKU. ...
0
votes
1answer
47 views

Magento - Owebia - Apply conditions for specific list of skus

Using Owebia, I need to apply a specific fee for certain product skus (from 001 to 099). I know the function I need to use with Owebia, but I don't know how to set the array of skus in the cart: { ...
0
votes
0answers
47 views

Magento 2 connection reset error when processing large datas

I am using Magento 2.3 in ubuntu 16.4 with apache server. I am syncing data from Dropbox csv into Magento 2 attributes. Everything working fine, but I have more than 17,000 SKU's and need to process ...
0
votes
1answer
57 views

Echo SKU to product page (from Mageworx Advanced Product Options Suite) M2.3

Not sure if anyone can help, but basically I am trying to find a way to echo the SKU of the selected custom option (using Mageworx Advanced Product Options Suite) to the product page, either in the ...
0
votes
0answers
25 views

Sku format : Illegal sku com.ibm.as400.access

I've got this error with my Sku : com.ibm.as400.access.ExtendedIllegalArgumentException: javaValue (33005-Ambiance sobre): Length is not valid. [] [] what could cause the error? (it's on a custom ...
1
vote
0answers
12 views

Divide orders based on order number and items ordered

I'm trying to figure out a way to do this: Compare order if it has multiple items with this same SKU it will be given a different status. for instance order : 555 has 3 items all with sku 565 < ...
0
votes
0answers
24 views

how to deduce the name of product from sku when creating a product magento 2

I have disabled the auto generated SKU so SKU is independent from name but in advance I want a new functionality when adding the sku 10014100 for example i will do a request in some table to ...
1
vote
0answers
100 views

Magento 2.2: How to display price block on product detail page in a custom theme

I want to display the price and SKU in the product detail page. I've set luma as a parent theme. I am getting SKU under product-info-price div on frontend but not getting price. here is my layout file ...
2
votes
3answers
60 views

How to export all customers based on ordered items SKU?

How to find all customers who ordered a certain SKU ?
1
vote
0answers
37 views

how to display product sku in custom admin grid in magento2

hello everyone I want to display the product SKU in custom admin grid I have column displaying in it now I want to display the data of it index.xml <column name="sku"> <argument ...
1
vote
0answers
133 views

Magento 2 catalog search for SKU with dot not working

our SKU's have dot's like: "120.00085" If I search this string I get all products with "120.XXXX". But the product with exact this SKU is not at the first position in the results. Is there any ...
1
vote
1answer
92 views

How to remove SKU from product name in search results?

How can I remove SKU from product name in search results? In category view, product name is without SKU but when I search for some product, the results is including SKU in product name.
5
votes
1answer
525 views

Magento 2 REST - SKU to items on cart totals API response is not available, How to get SKU in response API

Magento 2 Rest API of cart totals doesn't provide SKU, Which is necessary for any operation like extension_attributes /rest/V1/carts/mine/totals The return array of Items is array (size=21) ...
1
vote
2answers
988 views

Magento 2: How to move breadcrumbs and sku before product title?

I am trying to move breadcrumb and SKU to show above the product title using xml. Like <move element="breadcrumbs" destination="product.info.main" before="page.title.wrapper" /> But ...
0
votes
2answers
176 views

Magento2, How to pass product data as query string in Url using JSON template? Custom Module

I am trying to get product name, product SKU, Quantity in Url such that when I write 1 in Url 1-50 products should display, when writing 2 as page number 51-100 products should display. And data goes ...
1
vote
1answer
880 views

Undefined variable: /vendor/magento/module-catalog/Controller/Adminhtml/Product/Save.php while save configurable product in magento2

When I save configurable product with big length sku then error showing "0":"Notice: Undefined variable: product in /MASKED_DIR/2018-08-06_12-56-07/htdocs/vendor/magento/module-catalog/...

1
2 3 4 5