Copy catalog from one store to another?

[cgchris99]

How do I copy my catalog from one store to another.

I have Osx loaded as v2.2 but not MS1. I am building a MS1 test store with CRE5.

 

How do I copy my entire catalog over to the test store?

 

thx

[♥olby]

Hi cgchris99

Theres no easy way :(

One way to go, is to make a complete sql-dump of the excisting db, and then add the fields needed - I just did on my own site :)

 

Here's a list of what I had to do in mySQL - it's by no means complete and accounted for, but it might get you started (pardon my danish :D )

# ?ndringer til ny checkout-system og alt det andet n?dvendige :)

ALTER TABLE `orders` ADD `customers_company` VARCHAR(32);

ALTER TABLE `orders` ADD `delivery_company` VARCHAR(32);

ALTER TABLE `orders` ADD billing_name varchar(64) NOT NULL default '';

ALTER TABLE `orders` ADD billing_company varchar(32) default NULL;

ALTER TABLE `orders` ADD billing_street_address varchar(64) NOT NULL default '';

ALTER TABLE `orders` ADD billing_suburb varchar(32) default NULL;

ALTER TABLE `orders` ADD billing_city varchar(32) NOT NULL default '';

ALTER TABLE `orders` ADD billing_postcode varchar(10) NOT NULL default '';

ALTER TABLE `orders` ADD billing_state varchar(32) default NULL;

ALTER TABLE `orders` ADD billing_country varchar(32) NOT NULL default '';

ALTER TABLE `orders` ADD billing_address_format_id int(5) NOT NULL default '0';

ALTER TABLE `orders_status_history` CHANGE `orders_status_history_id` `orders_status_id` INT( 11 ) NOT NULL AUTO_INCREMENT;

ALTER TABLE `orders_status_history` ADD `comments` VARCHAR( 128 ) AFTER `date_added`;

INSERT INTO configuration VALUES ('', 'Mo Pics', 'CONFIGURATION_USE_MO_PICS', 'false', 'Do you want to use the MO pics add-on', 4, 7, '2002-12-03 00:49:10', '0000-00-00 00:00:00', '', 'tep_cfg_select_option(array('true', 'false'),');

INSERT INTO configuration VALUES ('', 'Display Prices with Tax', 'DISPLAY_PRICE_WITH_TAX', 'true', 'Display prices with tax included (true) or add the tax at the end (false)', 1, 21, '2003-03-11 00:17:45', '2003-02-15 20:10:43', NULL, 'tep_cfg_select_option(array('true', 'false'),');

INSERT INTO configuration VALUES ('', 'Gender', 'ACCOUNT_GENDER', 'false', 'Display gender in the custommers account', 5, 1, '2003-02-16 13:24:08', '2003-02-15 20:11:28', NULL, 'tep_cfg_select_option(array('true', 'false'),');

INSERT INTO configuration VALUES ('', 'Date of Birth', 'ACCOUNT_DOB', 'false', 'Display date of birth in the custommers account', 5, 2, '2003-02-16 13:24:24', '2003-02-15 20:11:28', NULL, 'tep_cfg_select_option(array('true', 'false'),');

INSERT INTO configuration VALUES ('', 'Company', 'ACCOUNT_COMPANY', 'false', 'Display company in the custommers account', 5, 3, '2003-02-16 13:24:39', '2003-02-15 20:11:28', NULL, 'tep_cfg_select_option(array('true', 'false'),');

INSERT INTO configuration VALUES ('', 'Suburb', 'ACCOUNT_SUBURB', 'false', 'Display suburb in the custommers account', 5, 4, '2003-02-16 13:24:56', '2003-02-15 20:11:28', NULL, 'tep_cfg_select_option(array('true', 'false'),');

INSERT INTO configuration VALUES ('', 'State', 'ACCOUNT_STATE', 'false', 'Display state in the custommers account', 5, 5, '2003-03-11 00:18:31', '2003-02-15 20:11:28', NULL, 'tep_cfg_select_option(array('true', 'false'),');

INSERT INTO configuration VALUES ('', 'Enable GZip Compression', 'GZIP_COMPRESSION', 'false', 'Enable HTTP GZip compression.', 15, 1, NULL, '2003-02-16 13:32:05', NULL, 'tep_cfg_select_option(array('true', 'false'),');

INSERT INTO configuration VALUES ('', 'Compression Level', 'GZIP_LEVEL', '5', 'Use this compression level 0-9 (0 = minimum, 9 = maximum).', 15, 2, NULL, '2003-02-16 13:32:05', NULL, NULL);

INSERT INTO configuration VALUES ('', 'Default ORDER Status For New Customers', 'DEFAULT_CUSTOMERS_STATUS_ID', '1', 'When a new customer is created, this customer status will be assigned to it.', 6, NULL, '2002-09-04 10:56:21', '2002-09-04 10:56:21', NULL, NULL);

# Tilf?jelser til configuration_group

INSERT INTO configuration_group VALUES (5, 'Medlems detaljer', 'Medlems konto konfiguration', 5, 1);

INSERT INTO configuration_group VALUES (15, 'GZip Compression', 'GZip compression options', 15, 1);

# More pictures

ALTER TABLE products ADD products_subimage1 VARCHAR(64) AFTER `products_bimage`;

ALTER TABLE products ADD products_bsubimage1 VARCHAR(64) AFTER `products_subimage1`;

ALTER TABLE products ADD products_subimage2 VARCHAR(64) AFTER `products_bsubimage1`;

ALTER TABLE products ADD products_bsubimage2 VARCHAR(64) AFTER `products_subimage2`;

ALTER TABLE products ADD products_subimage3 VARCHAR(64) AFTER `products_bsubimage2`;

ALTER TABLE products ADD products_bsubimage3 VARCHAR(64) AFTER `products_subimage3`;

ALTER TABLE products ADD products_subimage4 VARCHAR(64) AFTER `products_bsubimage3`;

ALTER TABLE products ADD products_bsubimage4 VARCHAR(64) AFTER `products_subimage4`;

ALTER TABLE products ADD products_subimage5 VARCHAR(64) AFTER `products_bsubimage4`;

ALTER TABLE products ADD products_bsubimage5 VARCHAR(64) AFTER `products_subimage5`;

ALTER TABLE products ADD products_subimage6 VARCHAR(64) AFTER `products_bsubimage5`;

ALTER TABLE products ADD products_bsubimage6 VARCHAR(64) AFTER `products_subimage6`;

# Thema option

INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) VALUES ('Site Thema Options', 'SITE_THEMA', '1', 'You can change site thema form here.', '1', '19', 'tep_cfg_select_option(array('1', '2', '3', '4', '5', '6', '7'), ', now());

Think of the above mentioned, as a guide-line no more - no less.

HTH