Post by duartemv » Wed Aug 07, 2019 6:11 pm

Hi,

I performed a backup from the existing store, restored it to a new store for tests, and now I intend to set the test store as the main store.
The problem is that I had some new purchases in the meanwhile, and would like to update the test store with the sales, orders, customers, etc info, without affecting the new filters, products, categories, etc of the test store.
I tried exporting the database items that I think are important for this procedure, but when I try to restore to the new store through the Save/Restore in Setting, I get the "Internal Server Error".

A little bit more context.
Regarding the test webstore, I erased all original products and created new ones, so products item numbers have changed/are different/don't exist anymore.
Deleted filters, categories, and created new ones.
These are the fields I'm trying to import:
`ocrg_address`;
`ocrg_cart`;
`ocrg_customer`;
`ocrg_customer_activity`;
`ocrg_customer_ip`;
`ocrg_customer_login`;
`ocrg_order`;
`ocrg_order_history`;
`ocrg_order_option`;
`ocrg_order_product`;
`ocrg_order_total`;
`ocrg_paypal_order`;
`ocrg_paypal_order_transaction`;

My main questions is, is it even possible to perform this procedure?

If yes, what could be the issue?

Thank you!

Newbie

Posts

Joined
Wed Aug 07, 2019 5:56 pm

Post by letxobnav » Wed Aug 07, 2019 8:55 pm

well, everything with an product_id in them would be a problem.

so this is not a smart strategy.

Crystal Light Centrum Taiwan
Extensions: MailQueue | SUKHR | VBoces

“Data security is paramount at [...], and we are committed to protecting the privacy of anyone who is associated with our [...]. We’ve made a lot of improvements and will continue to make them.”
When you know your life savings are gone.


User avatar
Expert Member

Posts

Joined
Fri Aug 18, 2017 4:35 pm
Location - Taiwan

Post by wrick0 » Wed Aug 07, 2019 9:09 pm

Use this:
https://www.opencart.com/index.php?rout ... n_id=25966

Its the easiest way, but like the person above me, you gonna have problems with the product id's, you might be able to edit them manually in the database to get everything in place

Active Member

Posts

Joined
Fri Jan 18, 2019 10:00 pm
Location - 127.0.0.1 @ The Netherlands
Who is online

Users browsing this forum: No registered users and 153 guests