Shop Unusable After Csv Import

[1sweetman]

Hi, not sure if this is something I am doing wrong or a bug in Prestashop.

 

I use version 1.5.3.1

 

I have only tried this on my test site (runs on a standalone laptop) so as not to corrupt my shop

 

My 'shop' contains circa 2000 items and works fine but I have added a new supplier and need to add another 4000+ items to db, not wanting to do this one item at a time I created a .csv file with all the relevant headings and data.

 

First problem I encountered was 'Unknown column redirect_type in field list' I worked around this by adding

 

alter table ps_product add column redirect_type int (10);

alter table ps_product_shop add column redirect_type int (10);

 

I then retried the csv file and "successfully" added the data....it is indeed there I know have a db with 6000+ items however when I try to edit any of the products I cannot change from information to price, seo, associations, shipping etc if I change anything in description I cannot 'save' the changes.......

 

My questions are did the alter tables command do this? If so is there another workaround to the Unknown column error .....

 

and if it was not the alter tables command where else did I go wrong?

 

 

Any assistance would be gratefully accepted.

[1sweetman]

UPDATE....

 

I tested the csv file in a 'blank' unadulterated test shop (a fresh install without test products) and it worked fine.........so I can assume it is not the csv file that is faulty.......why then adding it to an existing shop does it create errors........anyone?

 

Alternatively as I now have the data in PS format in the testshop I am prepared to do it the slower way and use INSERT INTO DB1.TABLE1 SELECT * FROM DB2.TABLE1 for each and every necessary table....question is which ones are necessary? Obviously ps_product*, ps_supplier* ?????

 

The testshop has nothing else set up...no carriers, no weight ranges, no modules, nothing....just product data

 

Any help very gratefully accepted......