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
1 vote
1 answer
801 views

Shopping Cart Price Rule - By Using selected SKU Free Shipping Not Working?

I using default UPS, USPS, FEDEX, DHL Courier services, How can i give selected products sku free shipping, how to do that? Workout: Using selected sku's for free shipping not working? Note : In ...
zus's user avatar
  • 165
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 ...
QuestionsQuestions's user avatar
6 votes
3 answers
7k views

How to get specific sku product on search in magento 2?

In search bar when i am searching a product using sku (MY-PRODUCT-101), It displays all the product whose sku is having prefix (MY-PRODUCT-XXX) , But i only want it to fetch whose sku is (MY-...
Askit Raina's user avatar
4 votes
5 answers
6k views

How to get Magento2 product with REST if sku has slash?

Does anyone have an idea about how to get a product with slash through the rest api ? I have a product with sku 100/1. The closest I have gotten is to call: get /rest/V1/products/100%252f1 But it ...
TNordkvist's user avatar
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.
Kevin S's user avatar
  • 169
12 votes
4 answers
5k views

How to remove a duplicate sku via database?

I get this error when attempting to edit and save a few of my Magento products via admin: "The value of attribute "SKU" must be unique." When I view my products in Magento admin a duplicate sku is ...
Amanda's user avatar
  • 161
6 votes
1 answer
2k 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) ...
Aditya Shah's user avatar
  • 7,617
1 vote
2 answers
84 views

add php code to display sku in before error message [closed]

we are using an extension to import the products. This is the code we are using to display some error message. we are using this file to display error message : $errors[] = Mage::helper('...
Baby in Magento's user avatar
1 vote
1 answer
1k views

Set product sku as product id

i'm working on a website which doesn't need product sku. Is it possible to set the sku=product_id whenever a new product is created? Any side effect doing that? thanks
apedic's user avatar
  • 923
1 vote
1 answer
416 views

How to display Name, Thumbnail Image, Price, Add-to-cart Button On CMS PAGE?

I need to display all my products like, Sku Name Price Thumbnail Add-to-cart(Button) How can i get all above details on CMS Page? Note : Add-To-Cart Error
zus's user avatar
  • 165
1 vote
1 answer
353 views

How to get similar kind of sku in catalog search result?

I have to create new feature such as did you mean, which is shown in google search engine. I have multiple similar product sku like G HT2, G HT3 and G HT4. And When I am going to search product with ...
Prashant Parekh's user avatar
1 vote
5 answers
10k views

load by attribute sku not working some times

For Loading product by sku i'm using following function. For some skus its working fine where as for some sku's not working.And these sku products existed in back end. $_product = Mage::getModel('...
sivakumar's user avatar
  • 267
0 votes
0 answers
155 views

Magento2 admin , how can create new custom product field "sku,"price", "sale price" and a button for "update price" dynamically

I want when admin select custom field product sku, able to Change price, sale price and a button for update price dynamically. I created only field by etc/adminhtml/system.xml but unable to its ...
Ahmad Magento player's user avatar
0 votes
1 answer
202 views

Line No 1 Skipping import row, required field "sku" is not defined

Hi can any one help me to fix this error I am not able to upload any product I am gating this error (Line No 1 Skipping import row, required field "sku" is not defined.) I am uploading the Sku like ...
Irfan shaikh's user avatar
6 votes
1 answer
3k views

Which characters are allowed (by default) in a SKU?

A simple question with no hits on Google. What are the characters that are allowed in a SKU? The entire UTF-8 character set?
Luke A. Leber's user avatar
5 votes
2 answers
11k views

Display simple product SKU for configurable products

How can I include the simple product sku to display for configurable products which have more than two or more drop down options ( two or more attributes)? I would like the SKU to display after all ...
user2213058's user avatar
4 votes
4 answers
2k views

How to get product images based on its sku?

I implemented a custom module Company/Module. In the controller folder i have upload.php file. I need to modify this file to display the output in a tabular form with sku and product image. Please ...
charan's user avatar
  • 45
4 votes
1 answer
8k views

Magento 2.1 Update Product Stock in Cron Job

I need to be able to programmatically update product stock in my Cron job. I have an array that contains both the SKU of the product needing updating and the Stock value of that product. How can I ...
opqr549's user avatar
  • 125
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. ...
chrisb123's user avatar
2 votes
2 answers
2k views

Product collection sort order by custom skus string, when the sku has a hyphen in it, it will result a error

Product collection sort order by skus could use $collection->getSelect()->order(new /Zend_Db_Expr("FIELD(e.sku, $skus)")); (Magento 2: Order product collection by the order string(skus, ids etc) ...
Key Shang's user avatar
  • 3,415
2 votes
2 answers
5k views

Update product sku with customs options skus on product pages and cart

How can I dynamically update the sku of a product on the product page when users select its custom options? Also, how could it then be passed into the cart page? Example: A product with sku XXX has ...
Dustin's user avatar
  • 45
2 votes
2 answers
3k views

Adding a Product to the Cart via Querystring using SKU

I know that we can adding a product to cart via querystring. but how do we add sku to cart via querystring in url without including product id like this : domain/checkout/cart/add?sku=ABC or domain/...
Andhi Irawan's user avatar
2 votes
1 answer
215 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.
Bobo's user avatar
  • 33
1 vote
2 answers
2k 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 ...
Shoaib Saleem's user avatar
1 vote
0 answers
261 views

Push an array of all sku's on a category page into my $data = array();

I want to list all sku's on a category page in a data array. Currently if i'm on a product detail page i can push the sku into my data array like this: if ($module === 'catalog' && $...
Head's user avatar
  • 177
1 vote
2 answers
5k views

How to allow same SKU for different products? [closed]

I need add same SKU for different product. Example:SKU xyz-1 will be common for product_1, Product_2, and product_3
Mangesh Gomkar's user avatar
1 vote
1 answer
2k views

how to filter sku from renderer in grid?

so I have a renderer for orders and here is the code: the sku renderer is working fine I have problem with search and filtering the skus $this->addColumn('sku', array( 'header'=>...
Nickool's user avatar
  • 1,069
1 vote
2 answers
5k views

Auto Generate SKU

I would like to auto generate SKU with 6 or 8 digits which will consist of first 2 digits for manufacturer, next 1 digit for Colour, next 1 digit for Supplier and last 2 or 4 random numbers or auto ...
harry's user avatar
  • 197
1 vote
2 answers
461 views

Auto-increment when generate SKU with Observer

I have created an observer for auto-generating SKU when admin add product. This is my Custom_Module/Model/Observer.php class Bookandgo_AutoSku_Model_Observer { public function autoGenerateSku($...
Seventh St's user avatar
1 vote
2 answers
3k views

Remove SKU Column from Transactional Emails

I would like to know how to remove the SKU column from transactional emails my store sends. The email template contains {{var order.shipping_description}} but I don't know where this block is pulled ...
Baby in Magento's user avatar
0 votes
1 answer
2k views

"Product with specified super products SKU not found in rows:..." when reimporting just exported products to empty database

I exported all my single and configurable products to .csv and emptied my database of all products afterwards. I am now trying to reimport those same products using the just created .csv file. ...
Vladimir Despotovic's user avatar
0 votes
1 answer
1k views

Include SKU within Product Drop-Down (Bundle Options)

When dealing with a bundled product, the associated bundle items when in the drop-down option, will display the product title along with the additional price. I have been tinkering yet unable to ...
ne0nlight's user avatar
  • 207
0 votes
1 answer
524 views

How to get product images which are associate with its sku?

I want to upload a csv file which contains product sku and i want to get product images which are associated with that sku.please help me out.thanks in advance.
charan's user avatar
  • 45