amartinez

AMartinez_CustomImportExport

  • Popularity Score 4799 Popularity Score

    Popularity ScoreReferrals to Site/Downloads

    0 0 1+ 1+ 250+ 250+ 1000+ 1000+ 10000+ 10000+

Import/export products and customers from/to CSV file with a lot of custom options (~50000 products / min.)
Compatible with:
This extension is currently unavailable on Magento Connect. Please contact the developer.

You will be re-directed to the developer's website to complete your purchase.

You must be registered and logged in to get extension key.
In order to get this extension, you must be logged in to the Magento Community. Click here to login or register.
In order to get this extension, you must have active Magento Go Store. Click here to create Go store.

Magento Connect 2.0

Magento Connect 2.0

FREE
Previous Next
Overview

AMartinez_CustomImportExport

This extension can Import/Export products and customers from/to CSV file. Create categories, add attribute options, import images and media galleries, reindex, refresh cache, media and price rules automatically. In addition you can backup the entire database in SQL format.

    Imports:
        (products, customers)
            file.csv: multiple-row csv files, supports multiselect fields
        (products)
            file.csv1: single-row csv files, supports multiselect and multivalued fields
        
        Multivalued fields:
            Only with CSV1 files, these fields are automatically processed as multivalued:
                _store
                visibility
                _category
                _associated_sku
                _media_image
                _media_attribute_id
                _media_label
                _media_position
                _media_is_disabled
            To define your own ones, use * (this overrides default values)
                sku ,*_category      ,*_associated_sku
                TEST,"CAT1/CAT2,CAT3","ASSOCIATED1,ASSOCIATED2"
            
        Multiselect fields:
            Use commas to separate values, but make sure not to put asterisks in column header, ie:
                sku ,*_category      ,color
                TEST,"CAT1/CAT2,CAT3","red,yellow"
        
    Exports:
        (products, customers)
        file.csv: multiple-row new csv files (no support for multiselect)
        (database)
        backup all tables to SQL gz-compressed file


OPTIONS
    -h
    -help
                            print this usage and exit


    -a
    -all
                            same as -c -f -p -r options
                            
    -b
    -behavior
                            set import behavior for csv file: append|delete|replace (default)


    -c
    -cleancache
                            clean cache storage (html output, etc)


    -ce [file]
    -customersexport [file]
                            output customers to csv file, if output file not specified uses defined in config.xml


    -ci [file]
    -customersimport [file]
                            import customers from csv file, if source file not specified or not found uses defined in config.xml


    -db [file]
    -databasebackup [file]
                            output whole magento database to sql file and try to gzcompress it, if output file not specified uses time generated name


    -deleteallcustomers
                            delete all customers (NOT from csv, entire magento database!)
    
    -deleteallproducts
                            delete all products and non-root categories (NOT from csv, entire magento database!)
 
    -e [file]
    -export [file]
                            output products to csv file, if output file not specified uses defined in config.xml


    -i [file]
    -import [file]
                            import products from csv or csv1 file, if source file not specified or not found uses defined in config.xml. 


    -f
    -flushimages
                            flush catalog images cache


    -l 
    -linecount 
                            split import file into pieces of n lines length ($tmp_folder must be writable)
                            
    -p
    -applyrules
                            recalculate catalog price rules


    -r
    -reindex
                            reindex data by all indexers (attributes, prices, etc)


EXAMPLES
    import
                            php -f amartinez_customimportexport.php -- -all -import var/customimportexport/test_single_row_style.csv1
                            
    export
                            php -f amartinez_customimportexport.php -- -e   
                            
    reindex
                            php -f amartinez_customimportexport.php -- -a
 
    backup, import, reindex
                            php -f amartinez_customimportexport.php -- -databasebackup -import -all
                               
CRONTAB EXAMPLES
    # do tasks and send results by email
    00 03 * * * root php -f /magento_base_dir/amartinez_customimportexport.php -- -db -a -i /magento_base_dir/var/customimportexport/products.csv1 2>&1 | xargs -0 -I msg echo -e "Subject: MY STORE products daily update \\n\\n " msg | /usr/sbin/sendmail -f some@address.com some@address.com
                               
    # do tasks, append output to log file and send last results by email
    00 05 * * * root php -f /magento_base_dir/amartinez_customimportexport.php -- -db -a -i /magento_base_dir/var/customimportexport/products.csv1 2>&1 | tee -a /var/log/amartinez_customimportexport.log | echo -e "Subject: MY STORE products daily update \\n\\n `cat`" | /usr/sbin/sendmail -f some@address.com foo@address.com,bar@address.com

 

CREDITS I would be delighted to hear from you if you like this script. I also appreciate any donation you wish to contribute to the growth of this project (paypal: toniyecla [at] gmail [dot] com).


Thank you for your contribution!
Release Notes

Import/Export products/customers from/to CSV file. Create categories, add attribute options, import images and media galleries, reindex, refresh cache, media and price rules automatically. In addition you can backup the entire database in SQL format.

2012-02-06 05:05:30
  • Version number: 1.5.014
  • Stability: Stable
  • Compatibility: 1.5
You must be registered and logged in to get extension key.

Magento Connect 2.0

Magento Connect 2.0

This extension can Import/Export products and customers from/to CSV file. Create categories, add attribute options, import images and media galleries, reindex, refresh cache, media and price rules automatically. In addition you can backup the entire database in SQL format

Imports:
(products, customers)
file.csv: multiple-row csv files, supports multiselect fields
(products)
file.csv1: single-row csv files, supports multiselect and multivalued fields

Multivalued fields:
Only with CSV1 files, these fields are automatically processed as multivalued:
_store
visibility
_category
_associated_sku
_media_image
_media_attribute_id
_media_label
_media_position
_media_is_disabled
To define your own ones, use * (this overrides default values)
sku ,*_category ,*_associated_sku
TEST,"CAT1/CAT2,CAT3","ASSOCIATED1,ASSOCIATED2"

Multiselect fields:
Use commas to separate values, but make sure not to put asterisks in column header, ie:
sku ,*_category ,color
TEST,"CAT1/CAT2,CAT3","red,yellow"

Exports:
(products, customers)
file.csv: multiple-row new csv files (no support for multiselect)
(database)
backup all tables to SQL gz-compressed file

OPTIONS
-h
-help
print this usage and exit

-a
-all
same as -c -f -p -r options

-b
-behavior
set import behavior for csv file: append|delete|replace (default)

-c
-cleancache
clean cache storage (html output, etc)

-ce [file]
-customersexport [file]
output customers to csv file, if output file not specified uses defined in config.xml

-ci [file]
-customersimport [file]
import customers from csv file, if source file not specified or not found uses defined in config.xml

-db [file]
-databasebackup [file]
output whole magento database to sql file and try to gzcompress it, if output file not specified uses time generated name

-deleteallcustomers
delete all customers (NOT from csv, entire magento database!)

-deleteallproducts
delete all products and non-root categories (NOT from csv, entire magento database!)

-e [file]
-export [file]
output products to csv file, if output file not specified uses defined in config.xml

-i [file]
-import [file]
import products from csv or csv1 file, if source file not specified or not found uses defined in config.xml. 

-f
-flushimages
flush catalog images cache

-l 
-linecount 
split import file into pieces of n lines length ($tmp_folder must be writable)

-p
-applyrules
recalculate catalog price rules

-r
-reindex
reindex data by all indexers (attributes, prices, etc)

EXAMPLES
import
php -f amartinez_customimportexport.php -- -all -import var/customimportexport/test_single_row_style.csv1

export
php -f amartinez_customimportexport.php -- -e 

reindex
php -f amartinez_customimportexport.php -- -a

backup, import, reindex
php -f amartinez_customimportexport.php -- -databasebackup -import -all

CRONTAB EXAMPLES
# do tasks and send results by email
00 03 * * * root php -f /magento_base_dir/amartinez_customimportexport.php -- -db -a -i /magento_base_dir/var/customimportexport/products.csv1 2>&1 | xargs -0 -I msg echo -e "Subject: MY STORE products daily update \\n\\n " msg | /usr/sbin/sendmail -f some@address.com some@address.com

# do tasks, append output to log file and send last results by email
00 05 * * * root php -f /magento_base_dir/amartinez_customimportexport.php -- -db -a -i /magento_base_dir/var/customimportexport/products.csv1 2>&1 | tee -a /var/log/amartinez_customimportexport.log | echo -e "Subject: MY STORE products daily update \\n\\n `cat`" | /usr/sbin/sendmail -f some@address.com foo@address.com,bar@address.com

CREDITS
I would be delighted to hear from you if you like this script. I also appreciate any donation you wish to contribute to the growth of this project (paypal: toniyecla [at] gmail [dot] com).

This extension can Import/Export products and customers from/to CSV file. Create categories, add attribute options, reindex, refresh cache, images and price rules automatically. In addition you can backup the entire database in SQL format.

2011-06-29 15:13:04
  • Version number: 1.5.013
  • Stability: Stable
  • Compatibility: 1.5
You must be registered and logged in to get extension key.

Magento Connect 2.0

Magento Connect 2.0

This extension can Import/Export products and customers from/to CSV file. Create categories, add attribute options, reindex, refresh cache, images and price rules automatically. In addition you can backup the entire database in SQL format.

Imports:
(products, customers)
file.csv: multiple-row csv files, supports multiselect fields
(products)
file.csv1: single-row csv files, supports multiselect and multivalued fields

Multivalued fields:
You can define your own multivalued column names simply by putting an asterisk as a prefix, ie:
sku ,*_category ,*_associated_sku
TEST,"CAT1/CAT2,CAT3","ASSOCIATED1,ASSOCIATED2"

Multiselect fields:
Use commas to separate values, but make sure not to put asterisks in column header, ie:
sku ,*_category ,color
TEST,"CAT1/CAT2,CAT3","red,yellow"
Exports:
(products, customers)
file.csv: multiple-row new csv files (no support for multiselect)
(database)
backup all tables to SQL gz-compressed file

OPTIONS
-h
-help
print this usage and exit

-a
-all
same as -c -f -p -r options

-b
-behavior
set import behavior for csv file: append|delete|replace (default)

-c
-cleancache
clean cache storage (html output, etc)

-ce [file]
-customersexport [file]
output customers to csv file, if output file not specified uses defined in config.xml

-ci [file]
-customersimport [file]
import customers from csv file, if source file not specified or not found uses defined in config.xml

-db [file]
-databasebackup [file]
output whole magento database to sql file and try to gzcompress it, if output file not specified uses time generated name

-deleteallcustomers
delete all customers (NOT from csv, entire magento database!)

-deleteallproducts
delete all products and non-root categories (NOT from csv, entire magento database!)

-e [file]
-export [file]
output products to csv file, if output file not specified uses defined in config.xml

-i [file]
-import [file]
import products from csv or csv1 file, if source file not specified or not found uses defined in config.xml.

-f
-flushimages
flush catalog images cache

-l <n>
-linecount <n>
split import file into pieces of n lines length ($tmp_folder must be writable)

-p
-applyrules
recalculate catalog price rules

-r
-reindex
reindex data by all indexers (attributes, prices, etc)

EXAMPLES
import
php -f amartinez_customimportexport.php -- -all -import var/customimportexport/test_single_row_style.csv1

export
php -f amartinez_customimportexport.php -- -e

reindex
php -f amartinez_customimportexport.php -- -a

backup, import, reindex
php -f amartinez_customimportexport.php -- -databasebackup -import -all

CRONTAB EXAMPLES
# do tasks and send results by email
00 03 * * * root php -f /magento_base_dir/amartinez_customimportexport.php -- -db -a -i /magento_base_dir/var/customimportexport/products.csv1 2>&1 | xargs -0 -I msg echo -e "Subject: MY STORE products daily update \n\n " msg | /usr/sbin/sendmail -f some@address.com some@address.com

# do tasks, append output to log file and send last results by email
00 05 * * * root php -f /magento_base_dir/amartinez_customimportexport.php -- -db -a -i /magento_base_dir/var/customimportexport/products.csv1 2>&1 | tee -a /var/log/amartinez_customimportexport.log | echo -e "Subject: MY STORE products daily update \n\n `cat`" | /usr/sbin/sendmail -f some@address.com foo@address.com,bar@address.com

CREDITS
I would be delighted to hear from you if you like this script. I also appreciate any donation you wish to contribute to the growth of this project (paypal: toniyecla [at] gmail [dot] com).

This extension can Import/Export products and customers from/to CSV file. Create categories, add attribute options, reindex, refresh cache, images and price rules automatically. In addition you can backup the entire database in SQL format.

2011-05-24 13:11:19
  • Version number: 1.5.011
  • Stability: Stable
  • Compatibility: 1.5
You must be registered and logged in to get extension key.

Magento Connect 2.0

Magento Connect 2.0

This extension can Import/Export products and customers from/to CSV file. Create categories, add attribute options, reindex, refresh cache, images and price rules automatically. In addition you can backup the entire database in SQL format.

It extends Mage_ImportExport class, so it is the most SCALABLE, SAFER and FASTER method exists.

Imports:
(products, customers)
file.csv: multiple-row new csv files
(products)
file.csv1: single-row csv files, with some multivalued fields ("CAT1/CAT2,CAT3","ASSOCIATED1,ASSOCIATED2"...), you can define your own multivalued column names with * prefix ("sku","name","*_category","*_associated_sku"...)

Exports:
(products, customers)
file.csv: multiple-row new csv files
(database)
backup all tables to SQL gz-compressed file

To daily automatize imports, you must call "run.php" via crontab or similar.

USE:
php -f app/code/community/AMartinez/CustomImportExport/shell/run.php

php -f app/code/community/AMartinez/CustomImportExport/shell/run.php [-- [OPTIONS...]]

OPTIONS
-h
-help
print this usage and exit

-a
-all
same as -c -f -p -r

-b
-behavior
set import behavior: append|delete|replace (default)

-c
-cleancache
clean cache storage (html output, etc)

-ce [file]
-customersexport [file]
output customers to csv file, if output file not specified uses defined in config.xml

-ci [file]
-customersimport [file]
import customers from csv file, if source file not specified or not found uses defined in config.xml

-db [file]
-databasebackup [file]
output whole magento database to sql file and try to gzcompress it, if output file not specified uses time generated name.

-e [file]
-export [file]
output products to csv file, if output file not specified uses defined in config.xml

-i [file]
-import [file]
import products from csv file, if source file not specified or not found uses defined in config.xml

-f
-flushimages
flush catalog images cache

-l <n>
-linecount <n>
split import file into pieces of n lines length

-p
-applyrules
recalculate catalog price rules

-r
-reindex
reindex data by all indexers (attributes, prices, etc)

EXAMPLES
php -f app/code/community/AMartinez/CustomImportExport/shell/run.php -- -import var/importexport/products.csv
php -f app/code/community/AMartinez/CustomImportExport/shell/run.php -- -all
php -f app/code/community/AMartinez/CustomImportExport/shell/run.php -- -a -i var/importexport/products.csv
php -f app/code/community/AMartinez/CustomImportExport/shell/run.php -- -e var/importexport/products.csv
php -f app/code/community/AMartinez/CustomImportExport/shell/run.php -- -databasebackup -import -all

CREDITS
I would be delighted to hear from you if you like this script. I also appreciate any donation you wish to contribute to the growth of this project (paypal: toniyecla [at] gmail [dot] com).

This extension can Import/Export products and customers from/to CSV file. Create categories, add attribute options, reindex, refresh cache, images and price rules automatically. In addition you can backup the entire database in SQL format.

2011-05-18 15:19:44
  • Version number: 1.5.010
  • Stability: Stable
  • Compatibility: 1.5
You must be registered and logged in to get extension key.

Magento Connect 2.0

Magento Connect 2.0

This extension can Import/Export products and customers from/to CSV file. Create categories, add attribute options, reindex, refresh cache, images and price rules automatically. In addition you can backup the entire database in SQL format.

It extends Mage_ImportExport class, so it is the most SCALABLE, SAFER and FASTER method exists.

Imports:
(products, customers)
file.csv: multiple-row new csv files
(products)
file.csv1: single-row csv files, with some multivalued fields ("CAT1/CAT2,CAT3","ASSOCIATED1,ASSOCIATED2"...), you can define your own multivalued column names with * prefix ("sku","name","*_category","*_associated_sku"...)

Exports:
(products, customers)
file.csv: multiple-row new csv files
(database)
backup all tables to SQL gz-compressed file

To daily automatize imports, you must call "run.php" via crontab or similar.

USE:
php -f app/code/community/AMartinez/CustomImportExport/shell/run.php

php -f app/code/community/AMartinez/CustomImportExport/shell/run.php [-- [OPTIONS...]]

OPTIONS
-h
-help
print this usage and exit

-a
-all
same as -c -f -p -r

-b
-behavior
set import behavior: append|delete|replace (default)

-c
-cleancache
clean cache storage (html output, etc)

-ce [file]
-customersexport [file]
output customers to csv file, if output file not specified uses defined in config.xml

-ci [file]
-customersimport [file]
import customers from csv file, if source file not specified or not found uses defined in config.xml

-db [file]
-databasebackup [file]
output whole magento database to sql file and try to gzcompress it, if output file not specified uses time generated name.

-e [file]
-export [file]
output products to csv file, if output file not specified uses defined in config.xml

-i [file]
-import [file]
import products from csv file, if source file not specified or not found uses defined in config.xml

-f
-flushimages
flush catalog images cache

-l <n>
-linecount <n>
split import file into pieces of n lines length

-p
-applyrules
recalculate catalog price rules

-r
-reindex
reindex data by all indexers (attributes, prices, etc)

EXAMPLES
php -f app/code/community/AMartinez/CustomImportExport/shell/run.php -- -import var/importexport/products.csv
php -f app/code/community/AMartinez/CustomImportExport/shell/run.php -- -all
php -f app/code/community/AMartinez/CustomImportExport/shell/run.php -- -a -i var/importexport/products.csv
php -f app/code/community/AMartinez/CustomImportExport/shell/run.php -- -e var/importexport/products.csv
php -f app/code/community/AMartinez/CustomImportExport/shell/run.php -- -databasebackup -import -all

CREDITS
I would be delighted to hear from you if you like this script. I also appreciate any donation you wish to contribute to the growth of this project (paypal: toniyecla [at] gmail [dot] com).

This extension can Import/Export products and customers from/to CSV file. Create categories, add attribute options, reindex, refresh cache, images and price rules automatically. In addition you can backup the entire database in SQL format.

2011-05-12 11:21:51
  • Version number: 1.5.009
  • Stability: Stable
  • Compatibility: 1.5
You must be registered and logged in to get extension key.

Magento Connect 2.0

Magento Connect 2.0

This extension can Import/Export products and customers from/to CSV file. Create categories, add attribute options, reindex, refresh cache, images and price rules automatically. In addition you can backup the entire database in SQL format.

It extends Mage_ImportExport class, so it is the most SCALABLE, SAFER and FASTER method exists.

Imports:
(products, customers)
file.csv: multiple-row new csv files
(products)
file.csv1: previous single-row with multiple values csv files ..."CAT1,CAT2,CAT3","ASSOCIATED1,ASSOCIATED2"...

Exports:
(products, customers)
file.csv: multiple-row new csv files
(database)
backup all tables to SQL gz-compressed file

To daily automatize imports, you must call "run.php" via crontab or similar.

USE:
php -f app/code/community/AMartinez/CustomImportExport/shell/run.php

php -f app/code/community/AMartinez/CustomImportExport/shell/run.php [-- [OPTIONS...]]

OPTIONS
-h
-help
print this usage and exit

-a
-all
same as -c -f -p -r

-b
-behavior
set import behavior: append|delete|replace (default)

-c
-cleancache
clean cache storage (html output, etc)

-ce [file]
-customersexport [file]
output customers to csv file, if output file not specified uses defined in config.xml

-ci [file]
-customersimport [file]
import customers from csv file, if source file not specified or not found uses defined in config.xml

-db [file]
-databasebackup [file]
output whole magento database to sql file and try to gzcompress it, if output file not specified uses time generated name.

-e [file]
-export [file]
output products to csv file, if output file not specified uses defined in config.xml

-i [file]
-import [file]
import products from csv file, if source file not specified or not found uses defined in config.xml

-f
-flushimages
flush catalog images cache

-l <n>
-linecount <n>
split import file into pieces of n lines length

-p
-applyrules
recalculate catalog price rules

-r
-reindex
reindex data by all indexers (attributes, prices, etc)

EXAMPLES
php -f app/code/community/AMartinez/CustomImportExport/shell/run.php -- -import var/importexport/products.csv
php -f app/code/community/AMartinez/CustomImportExport/shell/run.php -- -all
php -f app/code/community/AMartinez/CustomImportExport/shell/run.php -- -a -i var/importexport/products.csv
php -f app/code/community/AMartinez/CustomImportExport/shell/run.php -- -e var/importexport/products.csv
php -f app/code/community/AMartinez/CustomImportExport/shell/run.php -- -databasebackup -import -all

CREDITS
I would be delighted to hear from you if you like this script. I also appreciate any donation you wish to contribute to the growth of this project (paypal: toniyecla [at] gmail [dot] com).
1 2 3
Reviews

About the Developer

This extension was developed by and is supported by amartinez

AMartinez_CustomImportExport 4.8 5 19 19
1.5.005 worked fine, but after upgrading to 1.5.014 our whole importfunction (mag 1.5.1) isn't working anymore. So we uninstalled this extension and waiting for a new version to test. November 21, 2011
please tell us how to use this module realy not unsderstand the use of it please provide the breaf discription of it October 25, 2011
Hi, It works in version 1.4.1.1? Regards! August 13, 2011
It did an 7mb export eith no problems (duid take a while though), but the format of the file puzzles me. Lots of empty lines and lines with only some fields filled. Any way to just export - &gt; edit/update -&gt; import again the easy way? Or is this the easy way and is it just a matter of a good setup? July 15, 2011
I use magento 1.5.1 June 12, 2011
New 1.5.010 release! - Create full path child categories (CAT/SUBCAT1,CAT2) - Bugs fixed, solved some special combination of new multi-attribute options problem - Minor improvements... Regards! May 18, 2011
HI! I apologize, I assumed that you would find the forum (http://www.magentocommerce.com/boards/viewthread/227005/) Don't worry :) about extension use: For now, this is a command line extension. You must use it via linux shell or windows command line: cd /your/magento/root/path/ php -f app/code/community/AMartinez/CustomImportExport/shell/run.php -- -h This script works together var/customimport .csv / .csv1 files, and of course media/catalog/product/ image (.jpg) ones Please tell me any suggestions or problems! May 16, 2011
Classic Magento. Supposedly great extension with no obvious documentation on what to do with it once installed... any help appreciated May 10, 2011
I don really understand how to use your module , when installed May 4, 2011
<<prev2
Q&A
(2 Questions : 1 Answer)

Product Q&A

Ask your questions. Share your answers.

 
 
« Back
 
 
Sort by
Avatar Image Url:: http://www.magentocommerce.com/images/avatars/uploads/avatar_26911930
Customer avatar
I have installed the plug how do I use it. Where is it located in the dashboard?
by
preciousltd
-
1 year, 5 months ago
+4points
5out of 6found this question helpful.
Was this helpful?Yes5No1

Answers

Avatar Image Url:: http://www.magentocommerce.com/images/avatars/uploads/avatar_26249098
Customer avatar
Answer: 
It is meant to be used from the command line..

php -f app/code/community/AMartinez/CustomImportExport/shell/run.php

according the very limited documentation I found here ... http://www.magentocommerce.com/boards/viewthread/227005/
by
davidfarrington
-
9 months ago
0points
0out of 0found this answer helpful.
Was this helpful?Yes0No0
 
0 answers

will this be updated

Avatar Image Url:: http://www.magentocommerce.com/images/avatars/uploads/avatar_26526372
Customer avatar
Will this be updated or can i just use it as is with version 1.8?
by
prycuk
-
4 months, 2 weeks ago
0points
0out of 0found this question helpful.
Was this helpful?Yes0No0
1 of 1
1 of 1
Get Help

Support for This Extension

The best place to start if you need help with a specific extension is to contact the developer. All Magento developers have both a contact email and a support email listed.

Magento Platform Support

If you need support for a Magento platform, there are different options for support depending on which Magento platform you are using. Below are links for specific platforms.

In order to upload extension, you must be logged in to the Magento Community. Click here to login or register.

Close

Register

* Required Fields

Close window

Forgot Your Password?

Please enter your email below and we'll send you a new password.

* Required Fields

Close window

Login

To upload extension you must be logged in.

* Required Fields

Close window

You are using an outdated browser

We built Magento Connect using the latest techniques and technologies.
This makes Magento Connect faster and easier to use.
Unfortunately, your browser doesn't support those technologies.
Use the links below to download a new browser or upgrade your existing browser.