I want to Down/Upload my OpenCart database so I can populate products in Excel. I host at BlueHost. What utility (i.e., phpMyAdmin) do I use to Down/Upload my products database, and which file(s) need to be downloaded so that I can populate database?
mich0417 wrote:I want to Down/Upload my OpenCart database so I can populate products in Excel. I host at BlueHost. What utility (i.e., phpMyAdmin) do I use to Down/Upload my products database, and which file(s) need to be downloaded so that I can populate database?
Login to your hosting cpanel.
Find phpmyadmin.
Choose your database name, and above you can found "export" tab.
Thick CSV for MS Excel or Microsoft Excel 2000 export option.
And then click "Go"
Your database will downloaded.
Check out Heidisql. It's free and works great for managing mysql databases. It gives you the capability of backing up entire databases or tables to file or you can backup to a local or remote backup database. Just make sure you do a full database backup to file before you start transferring files back and forth.
http://www.heidisql.com
http://www.heidisql.com
Product export import.
Great tool to bulk edit your product and categories from admin
http://www.opencart.com/index.php?route ... t%20export
Great tool to bulk edit your product and categories from admin
http://www.opencart.com/index.php?route ... t%20export
Koeltechnische deurrubbers eenvoudig online op maat bestellen.
Alle niet stekplichtige onderdelen zoals scharnieren, sloten, randverwarming en verlichting voor alle typen koelingen en vriezers.
https://koelcel-onderdelen.com
Who is online
Users browsing this forum: No registered users and 20 guests