Posting in the Magento forums has been disabled pending the implementation of a new and improved forum solution which should better serve the community.

For new questions please post at magento.stackexchange.com, the community-run support site for the Magento community. We will be providing updates on the new forum solution soon. For questions or concerns please email community@magento.com.

Magento Forum

Dev to Live install
 
ITALIC
Jr. Member
 
Avatar
Total Posts:  23
Joined:  2008-07-12
Sunshine Coast, 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:  3217
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
 
ITALIC
Jr. Member
 
Avatar
Total Posts:  23
Joined:  2008-07-12
Sunshine Coast, 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:  3217
Joined:  2009-02-26
Minneapolis MN
 

Have you refreshed your image cache?

 
Magento Community Magento Community
Magento Community
Magento Community
 
ITALIC
Jr. Member
 
Avatar
Total Posts:  23
Joined:  2008-07-12
Sunshine Coast, 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