I recently had a database crash on my server that corrupted the backup. I lost around 2000 sales data from my cart. Fortunately I have a copy of the sales emails that has all of the data in them. Customer name, address, city, State, zip, phone, items they bought, etc...
Does anyone have or know of a way or a script that will extract the data from the emails, allow me to clean it and then import it back into my database and not alter the inventory count.
I just want to add the sales data, customer data back.
Ver. OC 3.0.3.2
Any help or suggestions would be greatly appreciated!
OC version. These types of requests seem to be quite specific. I would suggest creating a new service request in the Commercial Support section of the forum to get this done as a custom job unless an extension would specifically provide such features.
Dedication and passion goes to those who are able to push and merge a project.
Regards,
Straightlight
Programmer / Opencart Tester
As above it sounds very specific, so if you can't find an free solution here, you could pay a developer such as ourselves or post a job in the Commercial Support Forum.Gilmore wrote: ↑Wed Nov 30, 2022 3:04 amI recently had a database crash on my server that corrupted the backup. I lost around 2000 sales data from my cart. Fortunately I have a copy of the sales emails that has all of the data in them. Customer name, address, city, State, zip, phone, items they bought, etc...
Does anyone have or know of a way or a script that will extract the data from the emails
UK OpenCart Hosting | OpenCart Audits | OpenCart Support - please email info@antropy.co.uk
Guru Member
You could use something like G-Lock Email Processor but as Paul says; it may be better to post in the commercial forum.Gilmore wrote: ↑Wed Nov 30, 2022 3:04 amI recently had a database crash on my server that corrupted the backup. I lost around 2000 sales data from my cart. Fortunately I have a copy of the sales emails that has all of the data in them. Customer name, address, city, State, zip, phone, items they bought, etc...
Does anyone have or know of a way or a script that will extract the data from the emails, allow me to clean it and then import it back into my database and not alter the inventory count.
I just want to add the sales data, customer data back.
Ver. OC 3.0.3.2
Any help or suggestions would be greatly appreciated!
Opencart 1.5.6.5/OC Bootstrap Pro/VQMOD lover, user and geek.
Affordable Service £££ - Opencart Installs, Fixing, Development and Upgrades
Plus Ecommerce, Marketing, Mailing List Management and More
FREE Guidance and Advice at https://www.ecommerce-help.co.uk