Import / Export Module

If I get this module, will I be able to import from a .csv file? This is used because of the 255 character limit in excel otherwise I get a lot of carriage returns. Or is it limited to .xls? I have currently 89,000 products in my database and yet to have done the other 200,000 + and have no desire or time to put them in one at a time.

Also will it import my current SQL database so that I don't lose all customer information? We currently have a custom cart but it doesn't work with PHP 5.x.x and to become PCI Compliant we now need PHP 5.

The Export/Import only supports the XLS format. There is no more 255 character limit for text fields. However, the Import is quite memory hungry, and typically is used for no more than 5000 to 10 000 products.

In your case, you are probably better off using your PHPMyAdmin to upload your products and categories into the database. PHPMyAdmin allows imports from a CSV file for individual DB tables. And even with this solutio you should make sure to have sufficient values for your PHP settings:

memory_limit 512M
post_max_size
upload_max_filesize

Thanks for your response. But are you taking about a different version of Excel than I am? We are using Office 2003 which only allows 255 characters. We are already using MyAdmin to import so I guess that wouldn't be a problem. Hopefully our developer knows what they are doing, because I know nothing about PHP.

Booker wrote:Thanks for your response. But are you taking about a different version of Excel than I am? We are using Office 2003 which only allows 255 characters. We are already using MyAdmin to import so I guess that wouldn't be a problem. Hopefully our developer knows what they are doing, because I know nothing about PHP.

I am talking about the MS Excel 97/2000/XP (.xls) which should be supported just fine in Office 2003, too. It certainly works fine in OpenOffice 3.x. I assume you are using the latest Opencart 1.4.8b.

Anyway, as I said, you your large number of products the best way to get them into the DB is via PHPMyAdmin, using its Import from CSV files.