bacowarrior Posted November 26, 2014 Share Posted November 26, 2014 Hi all, To cut a long story short, I am trying to export customers from one shop (1.5) to another (1.6) but when I go to phpMyAdmin for the 1.5 shop, the database only shows 1 customer: the test customer. This is really annoying as we have 30 customers registered on the shop but I can't export them via sql. I can export them via csv but it won't import them on 1.6. I have really hit a dead end here and need some help/advice on why phpMyAdmin won't show the customers but it does in the Back Office. Many thanks Link to comment Share on other sites More sharing options...
mickeyboy1 Posted November 27, 2014 Share Posted November 27, 2014 If you have customers registered showing in bo then they will be in the database Link to comment Share on other sites More sharing options...
bacowarrior Posted November 27, 2014 Author Share Posted November 27, 2014 If you have customers registered showing in bo then they will be in the database That's what I thought but that's not the case I have 30 registered users in the BO but only 1 on the database. Could there be a bug somewhere that I am missing? Link to comment Share on other sites More sharing options...
bacowarrior Posted November 27, 2014 Author Share Posted November 27, 2014 To help explain it a little better, here is my issue. First the results in the Back Office (customer names hidden to protect their details). Now the results when I open the customer table in phpMyAdmin: Link to comment Share on other sites More sharing options...
mickeyboy1 Posted November 27, 2014 Share Posted November 27, 2014 (edited) Are all your db tables using the prefix cl???? BTW you should be able to import customers in back office using csv file in 1.6 Edited November 27, 2014 by mickeyboy1 (see edit history) Link to comment Share on other sites More sharing options...
bacowarrior Posted November 28, 2014 Author Share Posted November 28, 2014 Are all your db tables using the prefix cl???? BTW you should be able to import customers in back office using csv file in 1.6 Yeah they are Tried doing it via csv, but for some reason it won't import them. This is really bugging me as whatever I try for importing customers just doesn't work Link to comment Share on other sites More sharing options...
Recommended Posts