Product Backup


https://forum.kartris.com/Topic657.aspx
Print Topic | Close Window

By kngdv341 - Wed 22 Jun 2011
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
By Mohammad - Wed 22 Jun 2011
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.
By dwavell - Fri 10 Jan 2014
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