Magento – Get SKU for Item with Custom Options

itemsorderssku

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 stripped out the javascript echoes for simplicity). And this works.

But I've got a bunch of items on the site that have custom options, so they're reporting (for example) as three separate skus 12345-red, 12345-green, 12345-blue.

And we'd prefer to strip off the custom option info, and just have the single parent sku of 12345.

$order = Mage::getModel('sales/order')->loadByIncrementId(Mage::getSingleton('checkout/session')->getLastRealOrderId());

$items = $order->getAllItems();

foreach($items as $item) {
    $_sku = $item->getSku();
    $_itemprice = $item->getPrice();
    $_itemqty = $item->getQtyOrdered();
}

What call do I make instead of $item->getSku(); to get the sku without the custom-options info attached to it?

Best Answer

Try $item->getProduct()->getSku() :)

Cheers

Related Solutions

Magento – Custom cron causing one page checkout deadlocks

Adding a sleep(3) to allow the db to settle in between cancel transactions could be a good workaround.

SKU Character Limit – Increase Sales Flat Order Item SKU Limit

If you run the following query against the database you can find all of the tables which have an sku column:

SELECT DISTINCT TABLE_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE COLUMN_NAME IN ('sku') AND TABLE_SCHEMA = 'your_database';

You will find the following returned:

catalog_product_entity - varchar(64)
catalog_product_flat_1 - varchar(64)
catalog_product_flat_2 - varchar(64)
catalog_product_flat_x // as many flat tables as there are stores
catalog_product_option - varchar(64)
catalog_product_option_type_value - varchar(64)
sales_flat_creditmemo_item - varchar(255)
sales_flat_invoice_item - varchar(255)
sales_flat_order_item - varchar(255)
sales_flat_quote_address_item - varchar(255)
sales_flat_quote_item - varchar(255)
sales_flat_shipment_item - varchar(255)

So a fair few tables. Although making the sku field longer is not something I have tried, I don't see any particular reason why it won't work, but you should approach the task carefully with plenty of testing.

No idea why but it seems sku is stored as a 64 character long field in relation to products, and a 255 character long field in relation to ordered items - so you are essentially restricted to 64 characters by default.

My advice would be to write an install script to change these columns, something along the lines of the following:

<?php
$installer = $this;
$installer->startSetup();

$installer->getConnection()->changeColumn(
    $installer->getTable('module/table'),
    'sku',
    'sku',
    array(
        'type' => Varien_Db_Ddl_Table::TYPE_TEXT,
        'length' => '64k',
        'comment' => 'SKU'
    )
);

// more changeColumn() calls for each table

$installer->endSetup();

A few gotcha's I would look out for:

There may be some PHP based restrictions on the length of content saved to these fields, have to test to be sure
Watch out if you upgrade the store, some of these columns could be reset to 64/255 characters and data will irrecoverably be lost in the process if this is the case
Be careful when adding new stores as a new flat product table will be created so you will need to check the field is of the correct length.

Best Answer

Related Solutions

Magento – Custom cron causing one page checkout deadlocks

SKU Character Limit – Increase Sales Flat Order Item SKU Limit

Related Topic