Upgrading to 1.6 as an import just customers and orders -- is this possible?

[Naldinho]

I was wondering if it is possible to do a clean install of the current PrestaShop 1.6.x.x and import customers and orders from a 1.5.6.x store but not the products or anything else?

 

[NemoPS]

No, orders use product ids, so you need them if you don't want everything to crash

[bellini13]

and products need to exist in categories, and customers/orders need addresses, and the carriers that were used...

 

the point being, there are many database relationships that exist, and you cannot simply attempt to migrate only a handful of records

[El Patron]

what you want to accomplish is not detailed in existing PrestaShop documentation.

 

so to hopefully answer your 'wondering', no unless you are an advanced user.

[Naldinho]

Thanks I assumed that orders were stored as relying on other data but figure maybe a small chance they were stored as completely self-contained and complete. I figured out a solution that doesn't need this now but good to know for the future.

[jdgojariya]

How to possible import order in PS 1.6. I have already imported category, product and customers from PS 1.5 using CSV.

[El Patron]

How to possible import order in PS 1.6. I have already imported category, product and customers from PS 1.5 using CSV.

 

with you experience, product customers, you could probably also do orders, but if the product/cust id's (and possibly other db id's) changed it will be more difficult.

[jdgojariya]

with you experience, product customers, you could probably also do orders, but if the product/cust id's (and possibly other db id's) changed it will be more difficult.

Thanks

But in PS back office there is no any option for import order using csv.

[El Patron]

Thanks

But in PS back office there is no any option for import order using csv.

 

you can look at importing using phpmyadmin yes?

[jdgojariya]

you can look at importing using phpmyadmin yes?

Yes. But how to do this.?

[El Patron]

Yes. But how to do this.?

 

ah, now you get to learn new things yes?

 

from hosting control panel, look for access to you mysql db using phpmyadmin, if you can not find then contact your hosting company.

 

one can import directly into mysql db, it's good to know about phpmyamdin and your db for future.

 

there are loads of topics on mysql, search outside of ps as well for best results.

 

please let us know how you get along with this.

[jdgojariya]

ah, now you get to learn new things yes?

 

from hosting control panel, look for access to you mysql db using phpmyadmin, if you can not find then contact your hosting company.

 

one can import directly into mysql db, it's good to know about phpmyamdin and your db for future.

 

there are loads of topics on mysql, search outside of ps as well for best results.

 

please let us know how you get along with this.

No. Problem to occur import csv file "Invalid column count in CSV input on line 1."

[El Patron]

No. Problem to occur import csv file "Invalid column count in CSV input on line 1."

 

what you are doing is done by 'advanced users', this is just what it means, so you will be increasing your skill set and pretty much means you are on your own.

 

back up back up back up, (use phpmyadmin export to back up db)

[jdgojariya]

what you are doing is done by 'advanced users', this is just what it means, so you will be increasing your skill set and pretty much means you are on your own.

 

back up back up back up, (use phpmyadmin export to back up db)

I just want import order from PS 1.5 to 1.6 in any way. I already import all the things except order.

[Naldinho]

The question I would have is why go this route? I considered it because all my products need to be redone from scratch so I thought it was easier but if you are just trying to replicate a 1.6 database using data extracted from a 1.5 database why not just do a traditional upgrade?

[El Patron]

I just want import order from PS 1.5 to 1.6 in any way. I already import all the things except order.

 

I understand the original question.

 

why are you not just using official update process?

http://doc.prestashop.com/display/PS16/Updating+PrestaShop

[jdgojariya]

I understand the original question.

 

why are you not just using official update process?

http://doc.prestashop.com/display/PS16/Updating+PrestaShop

I have new theme and want to setup in fresh PS. old ps have many bug.so..

[El Patron]

I have new theme and want to setup in fresh PS. old ps have many bug.so..

 

sorry, that is not much of an explanation, if you create a test shop from production you can see how it goes.  that is the recommended path way to new versions.