Product Backup

Posted By kngdv341 Wed 22 Jun 2011
Add to Favorites0
Author Message
kngdv341
 Posted Wed 22 Jun 2011
Supreme Being

Supreme Being - (789 reputation)Supreme Being - (789 reputation)Supreme Being - (789 reputation)Supreme Being - (789 reputation)Supreme Being - (789 reputation)Supreme Being - (789 reputation)Supreme Being - (789 reputation)Supreme Being - (789 reputation)Supreme Being - (789 reputation)

Group: Forum Members
Last Active: Thu 23 Jun 2011
Posts: 1, Visits: 195
789
I go to database admin and export products to a CSV file however all it gives me

P_ID P_Live P_Featured P_OrderVersionsBy P_VersionsSortDirection P_VersionDisplayType P_Reviews P_SupplierID P_Type P_CustomerGroupID P_AverageRating P_DateCreated P_LastModified
11 TRUE 0 d A l y s 27/03/2011 19:41 27/03/2011 19:42
anyone got any way of backing up the actual products with the name and prices on
Many Thanks
Mohammad
 Posted Wed 22 Jun 2011
Kartris Expert

Kartris Expert - (80,771 reputation)Kartris Expert - (80,771 reputation)Kartris Expert - (80,771 reputation)Kartris Expert - (80,771 reputation)Kartris Expert - (80,771 reputation)Kartris Expert - (80,771 reputation)Kartris Expert - (80,771 reputation)Kartris Expert - (80,771 reputation)Kartris Expert - (80,771 reputation)

Group: Administrators
Last Active: Sun 27 Sep 2015
Posts: 115, Visits: 706
Hi,

For backing up your data, its recommended to use the "Tools" tab in the database admin page, if you are in shared hosting, you should be able to backup the whole database from the UI the host is providing.

If you are planning to have a copy of your products only, and you may use it in the data tool in the future, follow the below instructions:

1. Database Admin Page >> Data Export Tab >> Saved Exports Tab.
2. If you find a saved export named "Products Data For DataTool", then you can click export in the same row, if you didn't find it then, go to "Custom Export" tab to create a new one with the below query:
EXEC _spKartrisDB_ExportProductRelatedData @LanguageID = 1

If you want the complete list of products/versions with pricing use the below query instead:
SELECT     P_ID, P_Name, P_Desc, V_Name, V_Desc, V_CodeNumber, V_Price
FROM         vKartrisProductsVersions

3. Now you can find your saved export in the "Saved Exports" Tab, and its ready to export to CSV.
dwavell
 Posted Fri 10 Jan 2014
Supreme Being

Supreme Being - (4,591 reputation)Supreme Being - (4,591 reputation)Supreme Being - (4,591 reputation)Supreme Being - (4,591 reputation)Supreme Being - (4,591 reputation)Supreme Being - (4,591 reputation)Supreme Being - (4,591 reputation)Supreme Being - (4,591 reputation)Supreme Being - (4,591 reputation)

Group: Forum Members
Last Active: Thu 30 Apr 2015
Posts: 8, Visits: 17
Hi Medz,

Is there any way to do this but getting all products (both shown on front end and not)? And only giving me each product once, not once per category that it's in?

Cheers,

Dan

Similar Topics

Expand / Collapse

Reading This Topic

Expand / Collapse

Back To Top