 |
|
Most recent edit on 2007-03-17 09:04:02 by KryptronicWebmaster
Additions:
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.
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:
For the EU/GB version of ClickCartPro enter the following statement in the SQL Statement field:
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
Deletions:
Kryptronic Hybrid X Core > Database: Connections, Backups and Raw Admin > Raw Database Admin
Database Admin
Scroll Down to :
gbu0_prod
Click Browse
Find and select the file you want to upload
Click Submit
You should get conformation of files uploaded.
Done
Check site.
Wiki: Pending Inclusion
Edited on 2007-03-11 09:17:13 by KryptronicWebmaster
Deletions:
Backing Up Your Products: GBU
Then Click Export
Check or Change the [CSV Filename* ]
Make sure all the [Columns to Export* ] are ticked
Click submit
You should get message
[A CSV file has been created and is ready for download.]
Click download
Click on [Save(Right click)]
Click on [save to]
Decide where you want to download it to your computer
(Say mydocs\newbackup\)
Check out and correct your file
You can look at this file with Excel
You can edit it if you want to change something (Just say some wrong settings)
but dont delete any lines or add any lines.
but remember to save it as a modified file and keep the original down loaded just in case you do something wrong.
Restoring Your Products: GBU
Edited on 2007-03-11 07:31:03 by KryptronicWebmaster
Additions:
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 exported when restoring your product information.
Deletions:
From -- LewAff (2007-02-28 13:39:15) in the forums
Oldest known version of this page was edited on 2007-03-11 07:30:03 by KryptronicWebmaster [Cloned from SavingProductInformation]
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 exported when saving your product information.
From -- LewAff (2007-02-28 13:39:15) in the forums
Backing Up Your Products: GBU
Kryptronic Hybrid X Core > Database: Connections, Backups and Raw Admin > Raw Database Admin
Database Admin
Scroll Down to :
gbu0_prod
Then Click Export
Check or Change the [CSV Filename* ]
Make sure all the [Columns to Export* ] are ticked
Click submit
You should get message
[A CSV file has been created and is ready for download.]
Click download
Click on [Save(Right click)]
Click on [save to]
Decide where you want to download it to your computer
(Say mydocs\newbackup\)
Done
Check out and correct your file
You can look at this file with Excel
You can edit it if you want to change something (Just say some wrong settings)
but dont delete any lines or add any lines.
but remember to save it as a modified file and keep the original down loaded just in case you do something wrong.
Restoring Your Products: GBU
Kryptronic Hybrid X Core > Database: Connections, Backups and Raw Admin > Raw Database Admin
Database Admin
Scroll Down to :
gbu0_prod
Click Browse
Find and select the file you want to upload
Click Submit
You should get conformation of files uploaded.
Done
Check site.
Wiki: Pending Inclusion
Additions:
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
Deletions:
Incomplete - This entry is not complete or tested yet. Do not use.
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 exported when restoring your product information.Kryptronic Hybrid X Core > Database: Connections, Backups and Raw Admin > Raw Database Admin
Database Admin
Scroll Down to :
gbu0_prod
Click Browse
Find and select the file you want to upload
Click Submit
You should get conformation of files uploaded.
Done
Check site.
Wiki: Pending Inclusion
Edited on 2007-03-11 09:17:13 by KryptronicWebmaster
Deletions:
Backing Up Your Products: GBU
Then Click Export
Check or Change the [CSV Filename* ]
Make sure all the [Columns to Export* ] are ticked
Click submit
You should get message
[A CSV file has been created and is ready for download.]
Click download
Click on [Save(Right click)]
Click on [save to]
Decide where you want to download it to your computer
(Say mydocs\newbackup\)
Check out and correct your file
You can look at this file with Excel
You can edit it if you want to change something (Just say some wrong settings)
but dont delete any lines or add any lines.
but remember to save it as a modified file and keep the original down loaded just in case you do something wrong.
Restoring Your Products: GBU
Edited on 2007-03-11 07:31:03 by KryptronicWebmaster
Additions:
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 exported when restoring your product information.
Deletions:
Saving And Restoring 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 exported when saving your product information.From -- LewAff (2007-02-28 13:39:15) in the forums
Oldest known version of this page was edited on 2007-03-11 07:30:03 by KryptronicWebmaster [Cloned from SavingProductInformation]
Page view:
Saving And Restoring Product Information
Incomplete - This entry is not complete or tested yet. Do not use.
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 exported when saving your product information.
From -- LewAff (2007-02-28 13:39:15) in the forums
Backing Up Your Products: GBU
Kryptronic Hybrid X Core > Database: Connections, Backups and Raw Admin > Raw Database Admin
Database Admin
Scroll Down to :
gbu0_prod
Then Click Export
Check or Change the [CSV Filename* ]
Make sure all the [Columns to Export* ] are ticked
Click submit
You should get message
[A CSV file has been created and is ready for download.]
Click download
Click on [Save(Right click)]
Click on [save to]
Decide where you want to download it to your computer
(Say mydocs\newbackup\)
Done
Check out and correct your file
You can look at this file with Excel
You can edit it if you want to change something (Just say some wrong settings)
but dont delete any lines or add any lines.
but remember to save it as a modified file and keep the original down loaded just in case you do something wrong.
Restoring Your Products: GBU
Kryptronic Hybrid X Core > Database: Connections, Backups and Raw Admin > Raw Database Admin
Database Admin
Scroll Down to :
gbu0_prod
Click Browse
Find and select the file you want to upload
Click Submit
You should get conformation of files uploaded.
Done
Check site.
Wiki: Pending Inclusion