Magento

If you want to export products (csv) and you have a lot of options, you can with this script export all options as simple products.
option sku become real sku and the name of product is real name + title option.
simple products with no options are exported normaly.
it can be useful for ebay or another market place.
copy file on root. CSV will be save on root too as test.csv (move script after test!)
Thanks to chiefair for code! (see a list of products with options)
http://www.magentocommerce.com/boards/viewthread/216551/

export-options.php  (File Size: 8KB - Downloads: 232)

Thank you for this script.  I’ve been searching for something like this forever.  I even posted on stackoverflow, but no help.  I’ll test it and let you know.

Hmmm.  doesn’t seem to work.  Not getting any file.

define(’SAVE_FEED_LOCATION’,’test.csv‘);
it saves a csv file at the same level as your script
what appened when you launch the php file?

Fatal error: Call to a member function getName() on a non-object in export-options.php on line 153

Please help..

it seems something is not correct in your code. getname ? for what, product? option? is the same sybtaxe that others parameters?

try to comment this with /* and */

/*
$product_data[’CATEGORY’]=’’;
foreach($product->getCategoryIds() as $_categoryId){
$category = Mage::getModel(’catalog/category’)->load($_categoryId);}
$product_data[’CATEGORY’].=$category->getName().’, ‘;
$product_data[’CATEGORY’]=rtrim($product_data[’CATEGORY’],’, ‘);
*/

line 150 to 154

pb is for category. Are you sure your products have categories?

Thanks! It works for me.

Although, I am not getting any SKU for the products with custom options. Also, would you should me how I could replace the space between the product name and custom option value with a character such as a dash “-” rather than a space?

Hello, the script is working for me, Thank You, the only problem i have is that the script also export inactive categories,
// to exclude some categories
/*if($mcategory->getId()==194 || $mcategory->getId()==169 )
continue;*/

i put this like:

if($mcategory->getId()==194 || $mcategory->getId()==169 )
continue;

still, this two categories apear in the file.

what can i do ?

Thank You

try this?!
if (!$mcategory->getIsActive()) continue;

Hi,

To start Export Custom Options you need to click on Store->Import/Export->Import/Export Custom Options button which calls the Import/Export Wizard.

Import/Export Wizard of Custom Options section is similar to Products Import/Export Wizard. To export custom options from Magento store follow up several steps listed below:

1. Select “Export” and click “Next >” button to continue

2. Store Manager can export custom options to .csv file. You should enter the file name or select one (using browse [...] button) to replace the existing file. Here you can also load or save export settings (configuration).

Note--Also you can load previously saved Export Settings to use them now.

3. On the next page you can see some general Magento Custom Options export options.

4. Fields Delimiter page has some important settings. Check them to ensure proper configuration.

5. Preview export file and proceed.

Choose what action to perform after saving export data, use “None” option and Wizard will be closed automatically. If you wish to open a directory containing result file, please, check the corresponding option. Open result file option allows you to see export file opened in Excel. Also you can Save Export Settings for future or load the settings you’ve saved previously in the process of export.

NOTE! When you press “Export” Button, Magento custom options export process will start! You can save all your Export Settings or Load the ones you’ve saved previously

Hope this will help you. If you need any kind of help you can contact us as we are one of best Magento extensions developer.

Thanks

Monty
iLoveMage

Get 25% discount all our Magento Extensions..

rrroulio - 08 March 2013 11:40 AM

try this?!
if (!$mcategory->getIsActive()) continue;

Thank you, but it doesn’t work, inactive categories are still there.
I will keep trying