Can't list products or import csv?

[HomeflairRov]

We use a module called "exportproducts" to export csv files, as we do not have the latest version of pretashop and there isn't one built in - we're using v1.3.7 (e tried to update to v1.4.7 but have since reverted back to the older version). Every time we try to import a csv, it comes up with 1868 errors (two errors for every item we have) all saying this:

 

Zone Loft CD Tower (ID 40) cannot be saved

Unknown column 'id_tax' in 'field list'

 

After trying to import the csv, it creates a bunch of random categories, as shown in the image

 

Also, I've tried to start listing everything manually, but I can't create a product, it just comes up with this vague error:

"1 error

an error occurred while creating object product"

 

I made a bunch of database backups before we tried the update - if there is a problem with the database, how do I replace it with one of the backups? We use phpMyAdmin but I'm no expert with SQL and the like.

 

I've attached a copy of one of our csv files productsstream.zip

 

Any help is appreciated! Our site has been down for 7 days now.

[phrasespot]

My (wild) guess is CSV produced by the module is not compatible with PS import. Also it is unlikely you will get an answer here as the issue is involved and may require access to you back office and the server. Talk to your developer or try at job offers and paid services forum if you don't have one and if you can afford it.

[PartsTrader]

I too have been looking for a module that imports csv files into prestashop.

 

As far as your database...When I save a copy of my database, (in cpanel php myadmin) I'll export the database and select "add drop tables"

 

My database was messed up (more than 7 times) when I tried uploading a csv so I had restore the database. The way that I restored it was:

 

I went to phpmyadmin in cpanel then I selected my database. Scroll all the way to the bottom and select "check all" then select "Drop" in the drop down menu to the right. That will wipe everything out. Then select import and choose your sql file.

 

This is the way that I've been restoring my database and everything seems to work fine but you might want to double in the forums.

 

I hope this helps you out, good luck!