zionlion Posted July 9, 2014 Share Posted July 9, 2014 In a multistore configuration, I have added over 300 items and have the following issues: 2nd and 3rd store do not have pricing on some of the items. 2nd and 3rd store have invalid product URLs "-.html" that result in "page not found" errors. 2nd and 3rd store have missing images and bad url and no pricing almost like a ghost product - nothing, not even a name, but still takes up space on the page. I have spent a lot of time trying to manipulate the database directly, and have only successfully resolved a few issues, like missing images. The major issue remains the invalid product URL which seems to affect the entire product leaving it "blank". The database table that seems to handle the product associations does not seem to affect the URL, so no luck there... Any help appreciated. Thank you Ver: 1.6.0.8 Link to comment Share on other sites More sharing options...
zionlion Posted July 23, 2014 Author Share Posted July 23, 2014 On 7/9/2014 at 6:56 AM, zionlion said: In a multistore configuration, I have added over 300 items and have the following issues: 2nd and 3rd store do not have pricing on some of the items. 2nd and 3rd store have invalid product URLs "-.html" that result in "page not found" errors. 2nd and 3rd store have missing images and bad url and no pricing almost like a ghost product - nothing, not even a name, but still takes up space on the page. I have spent a lot of time trying to manipulate the database directly, and have only successfully resolved a few issues, like missing images. The major issue remains the invalid product URL which seems to affect the entire product leaving it "blank". The database table that seems to handle the product associations does not seem to affect the URL, so no luck there... Any help appreciated. Thank you Ver: 1.6.0.8 No one? Link to comment Share on other sites More sharing options...
zionlion Posted July 24, 2014 Author Share Posted July 24, 2014 This is a serious issue I have not been able to find the cause but we had to stop marketing because of it... Any help appreciated! Link to comment Share on other sites More sharing options...
NemoPS Posted July 25, 2014 Share Posted July 25, 2014 Hi, could you perhaps share your site's url? Are your other stores set to use the same domain, or others, or subdomains? Link to comment Share on other sites More sharing options...
zionlion Posted July 25, 2014 Author Share Posted July 25, 2014 On 7/25/2014 at 8:05 AM, Nemo1 said: Hi, could you perhaps share your site's url? Are your other stores set to use the same domain, or others, or subdomains? Thank you for the reply, I have located what I think to be the issue... We had entered products and some (not sure why) were showing in all stores as we need them to, but some were not. We edited the table ps_product_shop to reflect all products to be assigned to all shops (add a row containing a duplicate of the original row from shop 1 with the id_shop of 2 and 3 for the additional shops).... There obviously is more that needs to be done to assign a product to a store ... Not sure where in the database, I could not find it, but I guess currently our database is pretty messed up since we have been adding products and there is no way to determine which ones were the ones we manually edited, they are spread out over categories. the store is citylifeusa.com (no www - Since I have not found the right way to solve the rewriting... the solutions in the forum all resulted in loops or server errors still need a solution on that too...) It would be really great to know all the tables in the database that need to be changed in order for a product to be properly assigned to a shop... I tried going through the database structure and researching with no luck so far. Thank you, 1 Link to comment Share on other sites More sharing options...
zionlion Posted July 31, 2014 Author Share Posted July 31, 2014 We have decided to rebuild the database from scratch... SO the issue with the products intermittently showing up is no longer an issue... But we still have the URL rewriting issue... Our main Domain is higuchionline.com and one of the add-on domains is citylifeusa.com where we can reach it properly with via "citylifeusa.com" but not through "www.citylifeusa.com" this is multistore.... all additional add-on domains act the same... without www fine, with www redirects to the main higuchionline.com site. THank you for the help... Link to comment Share on other sites More sharing options...
El Patron Posted July 31, 2014 Share Posted July 31, 2014 you can add this to .htaccess # Redirect non-www to www: RewriteCond %{HTTP_HOST} !^www\. [NC] RewriteRule ^(.*)$ http://www.%{HTTP_HOST}/$1 [R=301,L] then any non-www will become www.somedomain Link to comment Share on other sites More sharing options...
zionlion Posted July 31, 2014 Author Share Posted July 31, 2014 On 7/31/2014 at 4:39 PM, El Patron said: you can add this to .htaccess # Redirect non-www to www: RewriteCond %{HTTP_HOST} !^www\. [NC] RewriteRule ^(.*)$ http://www.%{HTTP_HOST}/$1 [R=301,L] then any non-www will become www.somedomain Link to comment Share on other sites More sharing options...
zionlion Posted July 31, 2014 Author Share Posted July 31, 2014 On 7/31/2014 at 5:46 PM, zionlion said: On 7/31/2014 at 4:39 PM, El Patron said: you can add this to .htaccess # Redirect non-www to www: RewriteCond %{HTTP_HOST} !^www\. [NC] RewriteRule ^(.*)$ http://www.%{HTTP_HOST}/$1 [R=301,L] then any non-www will become www.somedomain Thanks for the reply El Patron... Got a redirect loop Link to comment Share on other sites More sharing options...
El Patron Posted July 31, 2014 Share Posted July 31, 2014 holy molly, I've never seen that directive do that...sorry about that did you put this in the top of .htaccess? it should be top... otherwise, I'm not sure how to proceed. Link to comment Share on other sites More sharing options...
zionlion Posted July 31, 2014 Author Share Posted July 31, 2014 On 7/31/2014 at 5:55 PM, El Patron said: holy molly, I've never seen that directive do that...sorry about that did you put this in the top of .htaccess? it should be top... otherwise, I'm not sure how to proceed. Yes, I did.. It is supposed to create a www.whatever.com from a whatever.com... correct? The issue I have is the multistore works fine without www... but with it simply redirect to the main store... Maybe the other way around is what I need? from www to non-www....? Link to comment Share on other sites More sharing options...
El Patron Posted July 31, 2014 Share Posted July 31, 2014 On 7/31/2014 at 6:01 PM, zionlion said: Yes, I did.. It is supposed to create a www.whatever.com from a whatever.com... correct? The issue I have is the multistore works fine without www... but with it simply redirect to the main store... Maybe the other way around is what I need? from www to non-www....? you could simply change url's under seo * urls to www but here is the code for www to non-www surprised you still trust me..jajaja #Force non-www: #RewriteCond %{HTTP_HOST} www.(.*)$ [NC] #RewriteRule ^(.*)$ http://%1/$1 [R=301,L] Link to comment Share on other sites More sharing options...
zionlion Posted July 31, 2014 Author Share Posted July 31, 2014 On 7/31/2014 at 6:05 PM, El Patron said: you could simply change url's under seo * urls to www but here is the code for www to non-www surprised you still trust me..jajaja #Force non-www: #RewriteCond %{HTTP_HOST} www.(.*)$ [NC] #RewriteRule ^(.*)$ http://%1/$1 [R=301,L] This worked, it does the redirect to no-www then prestashop loads the right store... How does this affect SEO and SSL, any concerns? or can this be a long term solution? Link to comment Share on other sites More sharing options...
El Patron Posted July 31, 2014 Share Posted July 31, 2014 test seo test checkout make sure cart holds prodcuts test ssl test test test I have code for non-www to www including ssl but I don't have reverse. Link to comment Share on other sites More sharing options...
El Patron Posted July 31, 2014 Share Posted July 31, 2014 p.s. there should be no seo impact that I can think of, nor have I ever seen mentioned. when I wrote my multishop module for 1.4, I ran into this issue here is my code for prosperity. #check for shop domain, without using WWW in comparison, i.e. only match on domain name. if ((str_replace('www.', null, Configuration::get('PS_SHOP_DOMAIN'.$append))) == (str_replace('www.', null, $host)) OR (Configuration::get('PS_SHOP_DOMAIN_SSL'.$append) == $_SERVER['HTTP_HOST'])) 1 Link to comment Share on other sites More sharing options...
zionlion Posted August 1, 2014 Author Share Posted August 1, 2014 On 7/31/2014 at 6:19 PM, El Patron said: p.s. there should be no seo impact that I can think of, nor have I ever seen mentioned. when I wrote my multishop module for 1.4, I ran into this issue here is my code for prosperity. #check for shop domain, without using WWW in comparison, i.e. only match on domain name. if ((str_replace('www.', null, Configuration::get('PS_SHOP_DOMAIN'.$append))) == (str_replace('www.', null, $host)) OR (Configuration::get('PS_SHOP_DOMAIN_SSL'.$append) == $_SERVER['HTTP_HOST'])) Thank you. This multistore is frustrating... it's intermittent and wont consistently forward to the right shop... Google wont advertise the site because of this... I wish it worked properly, but I am at the end of my rope now... I guess I will be shutting it down and starting up individual websites. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now