Magento Forum

   
Dev to Live install
 
PixelPerfection
Jr. Member
 
Avatar
Total Posts:  23
Joined:  2008-07-12
Hervey Bay, Australia
 

Magento ver. 1.3.2.4

We have finished developing a store on a “beta” sub-domain which we have tested in many ways including creating accounts and completing orders.
We now wish to launch the website on the full domain but do not want any of the orders we created whilst testing to be in the live site when launched. What is the best way to:
1) Move the site from the sub-domain to the full domain?
2) Retain all the stores settings and configurations but without the account and purchase data (similar to a fresh install)?

Many thanks,
Luke

 
Magento Community Magento Community
Magento Community
Magento Community
 
Brent W Peterson
Moderator
 
Avatar
Total Posts:  3215
Joined:  2009-02-26
Minneapolis MN
 

Your first question is easy

Go to System->Config->Web and modify your secure and unsecure URL\’s

BACKUP YOUR DATABASE FIRST

For #2 you can use this script

TRUNCATE `sales_order`;
TRUNCATE `sales_order_datetime`;
TRUNCATE `sales_order_decimal`;
TRUNCATE `sales_order_entity`;
TRUNCATE `sales_order_entity_datetime`;
TRUNCATE `sales_order_entity_decimal`;
TRUNCATE `sales_order_entity_int`;
TRUNCATE `sales_order_entity_text`;
TRUNCATE `sales_order_entity_varchar`;
TRUNCATE `sales_order_int`;
TRUNCATE `sales_order_text`;
TRUNCATE `sales_order_varchar`;
TRUNCATE `sales_quote`;
TRUNCATE `sales_quote_address`;
TRUNCATE `sales_quote_address_decimal`;
TRUNCATE `sales_quote_address_int`;
TRUNCATE `sales_quote_address_text`;
TRUNCATE `sales_quote_address_varchar`;
TRUNCATE `sales_quote_decimal`;
TRUNCATE `sales_quote_entity`;
TRUNCATE `sales_quote_entity_datetime`;
TRUNCATE `sales_quote_entity_decimal`;
TRUNCATE `sales_quote_entity_int`;
TRUNCATE `sales_quote_entity_text`;
TRUNCATE `sales_quote_entity_varchar`;
TRUNCATE `sales_quote_int`;
TRUNCATE `sales_quote_item`;
TRUNCATE `sales_quote_item_decimal`;
TRUNCATE `sales_quote_item_int`;
TRUNCATE `sales_quote_item_text`;
TRUNCATE `sales_quote_item_varchar`;
TRUNCATE `sales_quote_rule`;
TRUNCATE `sales_quote_text`;
TRUNCATE `sales_quote_varchar`;
TRUNCATE `sendfriend_log`;
TRUNCATE `tag`;
TRUNCATE `tag_relation`;
TRUNCATE `tag_summary`;
TRUNCATE `wishlist`;
TRUNCATE `log_quote`;
TRUNCATE `report_event`;

ALTER TABLE `sales_orderAUTO_INCREMENT=1;
ALTER TABLE `sales_order_datetimeAUTO_INCREMENT=1;
ALTER TABLE `sales_order_decimalAUTO_INCREMENT=1;
ALTER TABLE `sales_order_entityAUTO_INCREMENT=1;
ALTER TABLE `sales_order_entity_datetimeAUTO_INCREMENT=1;
ALTER TABLE `sales_order_entity_decimalAUTO_INCREMENT=1;
ALTER TABLE `sales_order_entity_intAUTO_INCREMENT=1;
ALTER TABLE `sales_order_entity_textAUTO_INCREMENT=1;
ALTER TABLE `sales_order_entity_varcharAUTO_INCREMENT=1;
ALTER TABLE `sales_order_intAUTO_INCREMENT=1;
ALTER TABLE `sales_order_textAUTO_INCREMENT=1;
ALTER TABLE `sales_order_varcharAUTO_INCREMENT=1;
ALTER TABLE `sales_quoteAUTO_INCREMENT=1;
ALTER TABLE `sales_quote_addressAUTO_INCREMENT=1;
ALTER TABLE `sales_quote_address_decimalAUTO_INCREMENT=1;
ALTER TABLE `sales_quote_address_intAUTO_INCREMENT=1;
ALTER TABLE `sales_quote_address_textAUTO_INCREMENT=1;
ALTER TABLE `sales_quote_address_varcharAUTO_INCREMENT=1;
ALTER TABLE `sales_quote_decimalAUTO_INCREMENT=1;
ALTER TABLE `sales_quote_entityAUTO_INCREMENT=1;
ALTER TABLE `sales_quote_entity_datetimeAUTO_INCREMENT=1;
ALTER TABLE `sales_quote_entity_decimalAUTO_INCREMENT=1;
ALTER TABLE `sales_quote_entity_intAUTO_INCREMENT=1;
ALTER TABLE `sales_quote_entity_textAUTO_INCREMENT=1;
ALTER TABLE `sales_quote_entity_varcharAUTO_INCREMENT=1;
ALTER TABLE `sales_quote_intAUTO_INCREMENT=1;
ALTER TABLE `sales_quote_itemAUTO_INCREMENT=1;
ALTER TABLE `sales_quote_item_decimalAUTO_INCREMENT=1;
ALTER TABLE `sales_quote_item_intAUTO_INCREMENT=1;
ALTER TABLE `sales_quote_item_textAUTO_INCREMENT=1;
ALTER TABLE `sales_quote_item_varcharAUTO_INCREMENT=1;
ALTER TABLE `sales_quote_ruleAUTO_INCREMENT=1;
ALTER TABLE `sales_quote_textAUTO_INCREMENT=1;
ALTER TABLE `sales_quote_varcharAUTO_INCREMENT=1;
ALTER TABLE `sendfriend_logAUTO_INCREMENT=1;
ALTER TABLE `tagAUTO_INCREMENT=1;
ALTER TABLE `tag_relationAUTO_INCREMENT=1;
ALTER TABLE `tag_summaryAUTO_INCREMENT=1;
ALTER TABLE `wishlistAUTO_INCREMENT=1;
ALTER TABLE `log_quoteAUTO_INCREMENT=1;
ALTER TABLE `report_eventAUTO_INCREMENT=1;

-- 
reset customers
TRUNCATE 
`customer_address_entity`;
TRUNCATE `customer_address_entity_datetime`;
TRUNCATE `customer_address_entity_decimal`;
TRUNCATE `customer_address_entity_int`;
TRUNCATE `customer_address_entity_text`;
TRUNCATE `customer_address_entity_varchar`;
TRUNCATE `customer_entity`;
TRUNCATE `customer_entity_datetime`;
TRUNCATE `customer_entity_decimal`;
TRUNCATE `customer_entity_int`;
TRUNCATE `customer_entity_text`;
TRUNCATE `customer_entity_varchar`;
TRUNCATE `log_customer`;
TRUNCATE `log_visitor`;
TRUNCATE `log_visitor_info`;


ALTER TABLE `customer_address_entityAUTO_INCREMENT=1;
ALTER TABLE `customer_address_entity_datetimeAUTO_INCREMENT=1;
ALTER TABLE `customer_address_entity_decimalAUTO_INCREMENT=1;
ALTER TABLE `customer_address_entity_intAUTO_INCREMENT=1;
ALTER TABLE `customer_address_entity_textAUTO_INCREMENT=1;
ALTER TABLE `customer_address_entity_varcharAUTO_INCREMENT=1;
ALTER TABLE `customer_entityAUTO_INCREMENT=1;
ALTER TABLE `customer_entity_datetimeAUTO_INCREMENT=1;
ALTER TABLE `customer_entity_decimalAUTO_INCREMENT=1;
ALTER TABLE `customer_entity_intAUTO_INCREMENT=1;
ALTER TABLE `customer_entity_textAUTO_INCREMENT=1;
ALTER TABLE `customer_entity_varcharAUTO_INCREMENT=1;
ALTER TABLE `log_customerAUTO_INCREMENT=1;
ALTER TABLE `log_visitorAUTO_INCREMENT=1;
ALTER TABLE `log_visitor_infoAUTO_INCREMENT=1;

DID I MENTION: BACKUP YOUR DATABASE BEFORE YOU RUN THE SCRIPT!!

 
Magento Community Magento Community
Magento Community
Magento Community
 
PixelPerfection
Jr. Member
 
Avatar
Total Posts:  23
Joined:  2008-07-12
Hervey Bay, Australia
 

Thanks for the quick response. Everything has worked perfectly and the beta site is now live. It seems however that there is an issue with all the main product images. The small images are displayed correctly when viewing the catalogue pages and browsing the products, its only when you view a particular product do you see the place holder instead of the product photo.
To make matters worse, it is not on every product or in every category as l have found random photos to be displaying correctly for products.
Any help or guidance would be much appreciated.

 
Magento Community Magento Community
Magento Community
Magento Community
 
Brent W Peterson
Moderator
 
Avatar
Total Posts:  3215
Joined:  2009-02-26
Minneapolis MN
 

Have you refreshed your image cache?

 
Magento Community Magento Community
Magento Community
Magento Community
 
PixelPerfection
Jr. Member
 
Avatar
Total Posts:  23
Joined:  2008-07-12
Hervey Bay, Australia
 

Yes but it seems that the permissions on the image folders where not correct so when l cleared the image cache it actually wasn’t cleared. Thanks for the help though.

 
Magento Community Magento Community
Magento Community
Magento Community
Magento Community
Magento Community
    Back to top