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
1answer
774 views

use SKU in stead of Product_name in URL

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? I am beginner of magento.but i have too many existing products.
0
votes
1answer
403 views

Rewrite URL with SKU

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 ?I am beginner of magento. Thank you.
0
votes
1answer
179 views

Issue with adding SKU field to Orders

I'm using the code below to add an SKU field to the Orders page in the Magento Backend. For the most part, the code works fine. SKU's are displayed in a column in the Orders page. However, I've ...
1
vote
0answers
187 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' && $...
0
votes
1answer
174 views

Filtering Sales Grid by SKU - SQL Error

When trying to filter the sales order grid by sku i get the following SQL error: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that ...
1
vote
1answer
51 views

Magento 1.7 Help with pulling values from array

I am trying to get some values from an array. my code below i need to get a comma separated values the values from the sku KEY, i am just not sure how to do it. Example output I need: sku,sku,sku $...
0
votes
1answer
1k 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 ...
0
votes
2answers
37 views

Delete SKU in .phtml file

i want to disable SKU in .phtml-file and i don't know where i can find the phtml-file that includes SKU. Please can somebody tell me whats the path to the file that includes phtml with SKU. Or if you ...
2
votes
1answer
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
1answer
71 views

SKU search not always working [duplicate]

I have an issue where depending on the SKU it depends on what comes back. I have 2 products SKU - AFB SKU - TUR If I search for AFB it the search results only show that 1 product. If I search for ...
0
votes
1answer
346 views

Will product model numbers change based on product variants/attributes like size,color

Will product model numbers change based on product variants/attributes like size,color. As in an early discussion , I understand every product will have a unique SKU to identify the product So how ...
2
votes
1answer
3k views

Get sku of selected custom option

I want SKU value of product's selected custom option on onepage. Can somebody help me on this ? Thank you.
0
votes
1answer
34 views

Check Bulk SKUs against existing Product's Skus during import

How can we check Bulk SKUs(in custom DB table) against existing Product SKUs , and if SKU from custom table is not present in product collection than need to create a product with that SKU. What ...
1
vote
1answer
36 views

Product SKU contained in another SKU causing problems

I've encountered a problem where I have imported a set of products from another website and in cases where a product's SKU is also the start of anothers, it causes problems where it pulls in sizes ...
3
votes
3answers
4k 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. ...
1
vote
2answers
77 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('...
12
votes
4answers
3k 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 ...
0
votes
1answer
230 views

Magento - Put barcode items in email order

I wish put near SKU also a barcode for any items that my customer order in the email with order. is it possible? thaks
5
votes
2answers
1k views

Getting SQLSTATE[HY000]: General error

I'm running CE 1.9 on a VPS. Have a problem with the category, which contains more than 350'000 SKUs. When I try to open this category in the backend, nothing happens, so I cannot edit any category ...
0
votes
1answer
794 views

How do I add the product ID/SKU to my search results?

I want to show the SKU code on search result listing page. Like this https://support.3dcart.com/knowledgebase/article/View/269/6/how-do-i-add-the-product-idsku-to-my-search-results Thanks everyone.
0
votes
2answers
85 views

sku is not taking more than 64 charactars

we are uploading a sku i.e having more than 64 charactars. but if we enter the sku with more than 64 charactars, its not taking in the backend I want to increase the value to more than 64 cahractars....
0
votes
2answers
41 views

Allow products to be bought by specific users

I've a configurable product with options every option has its own sku I need to let this sku to be available to buy only by a specific USER or USER GROUP. Is this possible to do in some way? With ...
0
votes
2answers
841 views

Display free shipping if specific sku magento on product page

I need to display a "Free Shipping" line of text below the price on the product page if the SKU starts with certain characters -- how do I got about doing this?
0
votes
1answer
2k views

get Sku for item with custom options

I'm adding some tracking code on my order confirmation page. But I'd like it to change what it reports for items with custom options. Below is what my PHP code looks like now to get the variables (i ...
0
votes
1answer
191 views

Adding product SKU into existing Cart Price rule Magento 1.7.0.2

I want to add/remove applicable product sku to/from already defined price rules programmatically when ever it is needed. How can I do that?
1
vote
1answer
939 views

Creating a coupon code for product with custom options

I need to generate coupon codes for products with specific custom options. My sales rules have conditions for product SKU's and quantities. However, I don't know a good way to obtain the SKU for a ...
1
vote
1answer
133 views

Echo SKU Option to front-end Magento Syntax

I'm Hannah a jeweller from Kent, United Kingdom. I am developing my website and I have hit a roadblock, I was wondering if anyone could point me in the right direction please? I am using the latest ...
5
votes
4answers
7k views

Magento - Display SKU on Category Page

I would like to display the product SKU on the category pages. I managed to plant it in the short description on every product page using: <div class="std"> <h5><?php echo $this-...
0
votes
1answer
233 views

Set SKU automaticaly in multi vendor website [duplicate]

I extended my Magento website with a multi vendor module. Vendors are having problems assigning SKU numbers while creating new products because it often happens that the choosed SKU has already be ...
2
votes
2answers
4k views

Get flat product table name

First, I wanted to ask for the fastest way to get a list of all existing SKUs in the shop (Magento 1.9.0.1), but while writing the post, I already managed to write a good deal of the solution. This is ...
2
votes
1answer
147 views

Can't send sku on contact form

My intention is to send the sku as a hidden variable when applying for the contact form but only after having visited a product. It works fine with localhost, where the cache is disabled, but not ...
5
votes
1answer
2k 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?
3
votes
2answers
15k views

Why SKU's need to be unique for each product, don't we have product id for that?

Question : How product nos/item number/part number different from SKU? From what I understand, SKU groups all the attributes that applies to a product and assigns a fixed number/value to it so that ...
3
votes
3answers
6k views

different inventory levels for same SKU multi store

We have a Canadian website and a US website. All products are shared. But we have two warehouses, one in each country. Therefore we need different stock levels for our websites. Any ideas?
1
vote
1answer
414 views

Change product quantity having a list of SKUs and quantities

I have product SKU. using that i have to change product quantity As stock so how to do this. I am getting a SKU and quantity like this Array ( [minimalVS] => 1 [seaglassin] => 0 [...
0
votes
1answer
200 views

Truncate SKU in invoice

How can I use substr to truncate the SKU of Magento's invoices? The relevant code is: // draw SKU $lines[0][] = array( 'text' => Mage::helper('core/string')->str_split($this->...
2
votes
1answer
6k 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, ...
0
votes
1answer
215 views

Buy 1 Sku, get 2 for a fixed amount

I need to create a rule that states: Buy 1 product sku at full price and get 2 product skus for fixed discounted amounts.
1
vote
0answers
177 views

Pull Configurable SKU instead of Simple Product SKU in Transactional Emails and Invoices

Is it possible to have Magento pull the SKU of a configurable product instead of the individual simple product SKU in transactional emails and on invoices?
1
vote
1answer
918 views

Remove SKU from the email

I want to remove SKU from all email to customer 1) I create folder and copy file to not edit core /app/design/frontend/my-theme/default/template/email/order/items.phtml 2) Delete this code <th ...
2
votes
1answer
5k views

Check if SKU exists

I'm logging a bunch of stuff in our database. Is there a quick and easy way to check if a SKU exists or not? This way I can remove anything malformed from our import process.
0
votes
1answer
49 views

Increasing collection use efficiency (getting product quantities from a collection of skus)

I have read that one shouldn't use the load() method within a for loop as this is a performance killer, however, i'd like to know how to more efficiency retrieve this information. Below is the ...
2
votes
1answer
306 views

How to modify search so when input “GM321” it shows the “GM-321” sku number?

Currently if the customer search by SKU, he need to enter the precise part number. For example, for part number DMS-212, customer must search DMS-212, if he input DMS212, search doesn't work. Is there ...
2
votes
1answer
641 views

Magento - 1 x SKU covering multiple SKU's - How to?

I'm struggling a bit on how to sell a product that is sold individually, but also in a package including more products. Let me illustrate it as a real example: Sample pack e-liquid (including 1x ...
1
vote
2answers
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 ...
0
votes
1answer
1k views

add external .csv files to magento to update product details

I want to add an extra attribute value to all products. so we are planning to update through import products using .csv please give me the procedure to add only one attribute values. thanks in ...
0
votes
2answers
90 views

give some ideas for giving sku values in magento site

give some ideas for giving sku values in magento site we are devoloping magento sites. so we are in confusion about on what basis, we have to decide sku values. we planning for products name or bar ...
2
votes
0answers
903 views

frontend search by custom option sku

I know out of the box the Magento search allows you to search by product sku. This is working fine on our site. However, if you have a product with a custom option that appends to the sku, searching ...
0
votes
1answer
368 views

Shipping based on SKU - Magento CE 1.9.1.0

I need a solution to a problem that I've been struggling with for some time now. I need some sort of shipping rule that changes price dependent on the END of an SKU. For example, if a SKU ended xxxx-...
3
votes
1answer
939 views

How can we display SKU in URL structure?

How can we display SKU in URL structure? e.g domain/Product name kws/industry/SKU-product type. I'm also using SKU auto generator to generate SKU's.