Prestashop - Product Import module - Importing 8000 products

[bibob]

Hello

Iam using Prestashop 1.4.7
I have trouble importing my csv file with 8000 products.

I need some module to import fast and also import the products correctly without missing any function.

Or other idea to import hose 8000 products?

[guest*]

Which troubles ?

I imported 22.000 products, but in 5 times, without problems.

There are a fast importer as paid module, but I don't know if it figures with 1.4. The best way is to ask developer:
http://www.prestashop.com/forums/viewthread/85662/job_offers_and_paid_services/turbo_boost_your_csv_imports_with_store_commander_for_prestashop

[myhero]

I am having an issue importing to 1.4.0.17, I wait an eternity to Upload 250 products and not a single one uploads. What cud cause this, this is my first import to 1.4.0.17.

Any suggestions?

[guest*]

Are you loading also pictures ? If yes, than load this before per FTP to the server and refer in your csv to new server-folder instead of your local-machine folder.

Perhaps your hoster also setted low loading permissions, i.e. time out after xxMB or xx time. Please check with your hoster error-logs.

[myhero]

Thanks, turns out it is my host. I will try that going forward!

[bibob]

Are you loading also pictures ? If yes, than load this before per FTP to the server and refer in your csv to new server-folder instead of your local-machine folder.

Perhaps your hoster also setted low loading permissions, i.e. time out after xxMB or xx time. Please check with your hoster error-logs.

Yes iam loading pictures i have refered to the picture like that : http://mysite.com/img/myimages/1.jpg and some of the products have more than 1 picture, someone have 10.

i have added those rules but still same problem.

php_value arg_separator.output "&"
php_value default_charset "utf-8"
php_value error_reporting 5
php_value key_buffer -1
php_value magic_quotes_gpc 0
php_value magic_quotes_runtime 0
php_value magic_quotes_sybase 0
php_value max_allowed_packet -1
php_value max_execution_time 0
php_value max_input_time -1
php_value memory_limit -1
php_value myisam_sort_buffer_size -1
php_value post_max_size 2000M
php_value query_cache_size -1
php_value read_buffer_size -1
php_value read_rnd_buffer_size -1
php_value register_globals 0
php_value session.name "AK_SESSID"
php_value sort_buffer_size -1
php_value table_cache 0
php_value thread_cache_size -1
php_value upload_max_filesize -1
LimitRequestBody 0

Actually the php_value memory_limit -1 helped a little bit, since i uploaded more products, but what is wrong else? i use servage.net as host.

[Dark-Graphics]

Below are steps I had to follow to get my items to import and for images to properly map or upload and then resize to thumbnails etc during import. I imported 6.5k via .csv(1 row in spreadsheet per product)

1. Did you refer to images as ..//img/myimages/1.jpg in your spread sheet if not it will never work.. Do not try to use absolute url's it just wont work i tried every possible method and this is the only way to do it..

*Multiple Images for same product* In the image column seperate each iamge location with a COMA
Example: ..//img/myimages/1.jpg,..//img/myimages/2.jpg (Notice the coma)
Make sure when you save your .csv coma is not used as a field delimiter or text delimiter as presta needs to use the COMA to tell it to if there are multiple values in that cell. **You can change this to whatever symbol you want on the import page however make sure its not a common one you might use in a description.

2. Do any of your products import? If not make sure you set the columns up to match (See Below), & make sure you save as .csv but use advanced save settings (*Edit Filter settings option in open office) and choose the proper field delimiter which prestashop default is = ; (Semi Colon). Make sure to save character type as Western Europe - ISO 8859-1. Click save > Upload, when choosing import type (Categories , Products, etc) check the check box for ISO-8859

3. Did you match each column up on the import page?

Again like they said above make sure those images are already uploaded to your specified folder. You can upload them with FileZilla a ftp program which is very fast, rather then using control panel or plesk. If you want to use this FTP program which basically just shows your source folders and your ftp folders side by side for drag and drop uploads make sure to make a FTP account with control panel at the /img/ directory so you can log in.


IF ANY BODY WANTS TO COMMENT ON THIS GUIDE OR HAS SIMPLER EXPLANATIONS LET ME KNOW I WILL CHANGE THIS POST TO MAKE IT EASIER FOR OTHERS WITH THE SAME ISSUES.

DARK-GRAPHIX

[Dark-Graphics]

Are you loading also pictures ? If yes, than load this before per FTP to the server and refer in your csv to new server-folder instead of your local-machine folder.

Perhaps your hoster also setted low loading permissions, i.e. time out after xxMB or xx time. Please check with your hoster error-logs.

Yes iam loading pictures i have refered to the picture like that : http://mysite.com/img/myimages/1.jpg and some of the products have more than 1 picture, someone have 10.

i have added those rules but still same problem.

php_value arg_separator.output "&"
php_value default_charset "utf-8"
php_value error_reporting 5
php_value key_buffer -1
php_value magic_quotes_gpc 0
php_value magic_quotes_runtime 0
php_value magic_quotes_sybase 0
php_value max_allowed_packet -1
php_value max_execution_time 0
php_value max_input_time -1
php_value memory_limit -1
php_value myisam_sort_buffer_size -1
php_value post_max_size 2000M
php_value query_cache_size -1
php_value read_buffer_size -1
php_value read_rnd_buffer_size -1
php_value register_globals 0
php_value session.name "AK_SESSID"
php_value sort_buffer_size -1
php_value table_cache 0
php_value thread_cache_size -1
php_value upload_max_filesize -1
LimitRequestBody 0

Actually the php_value memory_limit -1 helped a little bit, since i uploaded more products, but what is wrong else? i use servage.net as host.

When you upload and hit submit when its done what does prestashop tell you or be more specific what attributes of the products do not import? Or does nothing import..

Hopefully my POST above will help with any issues importing and letting prestashop generate thumbnails and map your images properly and or any issues you may have with the way you saved your .csv as you can not just save as .csv and have it work by default with most spreadsheet programs as they all have a deferent default setting..

[StoCo]

Hi,

Sorry for the late reply. Yes Store Commander is Prestashop 1.4 compatible indeed.