 |
|
Restoring Product Information
Please see Saving Product Information for information on how to save your product information.
This procedure works exactly the same for the US and EU/GB versions of ClickCartPro. The only difference between them is the name of the database table that is used when restoring (importing) your product information.
* * * * * WARNING * * * * *
Restoring your product information requires deleting ALL of your existing product information in the database.
Make sure you have a backup copy of your product information BEFORE you start this procedure.
In admin under:
Home > Kryptronic Hybrid X Core > Database: Connections, Backups and Raw Admin > Raw Database Admin
then click on SQL Statement: Submit a Raw SQL Statement
For the US version of ClickCartPro enter the following statement in the SQL Statement field:
DELETE FROM ccp0_prod
For the EU/GB version of ClickCartPro enter the following statement in the SQL Statement field:
DELETE FROM gbu0_prod
At this point you no longer have any products in your database or store.
In admin under:
Home > Kryptronic Hybrid X Core > Database: Connections, Backups and Raw Admin > Raw Database Admin
locate the ccp0_prod table (US version of ClickCartPro) or gbu0_prod table (EU/GB version of ClickCartPro) then click on Import. Click on Browse in the CVS File field and locate your product CSV file on your computer. Click Submit to load your product CSV file into the database.
If the Import succeeds you will see a message that says "The CSV file you uploaded was successfully loaded and used to import data into the selected table."
ClickCartPro - Administration
ClickCartPro - Products