Magento

I am confused by this MPN part.  What is the MPN?  Is it something that is already in a product?  Do I have to create it myself?  Is it a custom attribute?  Does it matter what I name it?

Thanks

I got it working eventually despite errors mentioned in this post and http://www.magentocommerce.com/boards/viewthread/8627/#

benau - 22 July 2008 12:00 AM

So many problems with the import/export feature at present...but as I am not a coder, all I can do is encourage the Magento team who are doing such a fantastic job!

I got the import/export business working by:

1. Using the default Export All Products profile and making sure to set the file name ending to .XML not .XLS
2. Using Excel to edit the file.
3. Using the default Import All Products profile to import.

Local/Remote Server was my Data Transfer Setting. Pushing the files to var/export and pulling them from var/import worked for me.



B

oh, to answer my own question:

The MPN (manufacturer’s part number) is a custom attribute that you only your simple products. I set mine up as an optional text field.  Since I already had all of my products loaded, I simply reloaded them with the new column added for this attribute. The field holds the configurable products sku id. The function will go through each simple product and relate it to the configurable product id in it’s MPN field. I had already associated the attributes to the configurable product, so did not use that portion of the Class; I commented it out.

You can rename it, but must do so as well in the Class object. The Class looks for the attribute named ‘mpn’.

the311guy - 22 July 2008 12:16 AM

oh, to answer my own question:

The MPN (manufacturer’s part number) is a custom attribute that you only your simple products. I set mine up as an optional text field.  Since I already had all of my products loaded, I simply reloaded them with the new column added for this attribute. The field holds the configurable products sku id. The function will go through each simple product and relate it to the configurable product id in it’s MPN field. I had already associated the attributes to the configurable product, so did not use that portion of the Class; I commented it out.

You can rename it, but must do so as well in the Class object. The Class looks for the attribute named ‘mpn’.

Right, sorry about that, I wasn’t watching this thread but you got it.  It wasn’t very clear in my post.  I used MPN as the key between simple and configurable products because the SKU is usually based off a product’s MPN.  Any sort of key will work, though, but yes it is a custom field.

Also, since my initial post, you don’t have to set your store to anything different.  If you leave it as the base store “Admin”, it turns out you just have to use “admin” as your store name in the csv.

@gabrielk

Thanks so much for uploading that script, got it all sorted, just had to make a minor change to make the actual selection box display, but apart from that, its great!.

Much Appreciated,
Samith_nzl

PS

The lines I added were

At line about line 151 after