Copy AbleCommerce Database from Dev to Live

[jaketheconsortium]

Is there a way to copy the products and categories and site map data from one AbleCommerce database to another using SQL.

We need to do this as all our products and categories are input on a development site first, we need to find an automated way to transfer all this data to the live environment. This will include the Catalog, Categories, Products and variants, and all the product attributes and images etc.

Help Please!

[mazhar]

You can use AbleCommerce DataPort utility to import/export between you live and dev environments. Please read following topic about DataPort for more details http://wiki.ablecommerce.com/index.php/ ... rt_Utility

[jaketheconsortium]

Hi,

Thanks. We have looked at this utility, the problem is is that of the many products we have some of them do not seem to import to the live site.
Category and product Ids change for some products on the import site and the menu structure is incorrect or repated in some areas. Is it possible to purge the database you wish to import data to first?

Jake.

[mazhar]

Please read following topic about moving from dev setup to live
http://wiki.ablecommerce.com/index.php/ ... _Live_site