Jump to content

Multistore Product URLs, pricing and images


Recommended Posts

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

  • 2 weeks later...
  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

  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,

  • Like 1
Link to comment
Share on other sites

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

  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

  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

  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

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'])) 
  • Like 1
Link to comment
Share on other sites

  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

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...