ianditch

Hi There, I have a live shop on my hosted server. I want to install Prestashop on my local server and connect to the live shop's database. I need to know that if I do this and do add my live DB credentials when installing onto my local server that the installation process will not drop or edit the existing DB tables in any way.... It it safe to do this? Ian

I dont really mean content wise, more as a per item index with google. If i was to have several light bulbs, all at different wattage listed on a combination page, would google index each light bulb? .html#/lightbulb/20watt .html#/lightbulb/40watt .html#/lightbulb/100watt Ian

Hi There, I just wanted to ask about combination pages. I get that a different coloured blouse would be best to have as a combination but what if the item i'm selling are resistors or light bulbs etc. These items are the same but have differnent values. eg, resistors are listed in different ohms values and bulbs in wattage etc. If i was to sell light bulbs for example, would it be best to have a single product page and have one combination selling 20watt, another selling 40watt , another selling 100watt etc or would it be best to have a separate product page for each bulb? I want google to index each light bulb, or resistor or what ever so i guess my question is what is the best method and most google friendly way to do this? Ian

Hi All, Ever since starting my site, I have all ways had the Google Search Console list errors with my products in the Rich Results test tool. Google always listed the error; 'Either "offers", "review", or "aggregateRating" should be specified. I've had a few hours spare today so i thought i would look into fixing this with partial success. To fix the above issue with version 1.7 i have created and added the below code which seems to have fixed the issue with the product being shown but my next issue is that i now get the same Rich Results error for each of the products in the 'Related Products' at the bottom of the product page. To fix this issue with the main product i have added the below code to my templates/catalog/product.TPL file. My question is, can i add the same code for each of the 'Related Products' shown on the Product page?.... Can i have more than 1 schema product on the same page? Any advise would be helpful. Ian <div itemtype="https://schema.org/Product" itemscope> <meta itemprop="mpn" content="{$product->mpn|htmlentitiesUTF8}" /> <meta itemprop="name" content="{$product.name}" /> <link itemprop="image" href="{$product.cover.large.url}" /> <meta itemprop="description" content="{$page.meta.description}" /> <div itemprop="offers" itemtype="https://schema.org/Offer" itemscope> <link itemprop="url" href="{$product.url}" /> <meta itemprop="availability" content="https://schema.org/InStock" /> <meta itemprop="priceCurrency" content="{$currency.iso_code}" /> <meta itemprop="itemCondition" content="https://schema.org/NewCondition" /> <meta itemprop="price" content="{$product.price_amount}" /> <meta itemprop="priceValidUntil" content="2030-11-20" /> </div> <div itemprop="aggregateRating" itemtype="https://schema.org/AggregateRating" itemscope> <meta itemprop="reviewCount" content="90" /> <meta itemprop="ratingValue" content="4.6" /> </div> <div itemprop="review" itemtype="https://schema.org/Review" itemscope> <div itemprop="author" itemtype="https://schema.org/Person" itemscope> <meta itemprop="name" content="Lynda Ditchfield" /> </div> <div itemprop="reviewRating" itemtype="https://schema.org/Rating" itemscope> <meta itemprop="ratingValue" content="5" /> <meta itemprop="bestRating" content="5" /> </div> </div> <meta itemprop="sku" content="{$product->reference|htmlentitiesUTF8}" /> <div itemprop="brand" itemtype="https://schema.org/Brand" itemscope> <meta itemprop="name" content="Fase Controls" /> </div> </div>

Thanks lordignus, I've tried clearing everything but it still shows this error. This has been on-going and I've clear the cache many times over many months but this error still remains. Ian

Hi All, I dont use the owlCarousel plugin and have un-installed this from the Module Manager but i still have the below error show on each page load. Though i've un-installed this, do I need to remove reference to this on another page?.. If not, how do I stop the below error from showing? Any help would be appriciated. Ian jQuery.Deferred exception: $(...).owlCarousel is not a function @https://fasecontrols.co.uk/themes/apparel/assets/cache/bottom-117987192.js:412:55 c@https://fasecontrols.co.uk/themes/apparel/assets/cache/bottom-117987192.js:39:25650 Deferred/then/s/</d<@https://fasecontrols.co.uk/themes/apparel/assets/cache/bottom-117987192.js:39:25949 undefined

Thanks Ress, I've looked for that for hours and its right there in front of me! Thanks for your help. Top Man 😉

Hi All, We've had a problem recently where a part order was missed... This has happened a couple of times now. I might write myself a simple CMS system myself which would be totally independent form Prestashop to allow me to monitor orders which have been shipped and which orders still have items which are yet to be shipped. To do this, i've been looking into the crazy Prestahop database structure and its not simple to understand. I plan to connect to the Prestashop database from a remote website and query this as needed. I'll then pull order details into a totally separate database and use this in my own CMS. I can see order details in PREFIX_orders and the associated products in PREFIX_order_detail which is fine and i can work with this. The issue i have is that i can't see how to get the delivery and invoice address which is associated with an order. Customer address details are stored into the PREFIX_address table but i can't see how to correctly grab the correct delivery & invoice address for the order. I hope that makes sense? proposed steps; 1) Goto PREFIX_orders and grab the id_order and id_customer. 2) Get the details from PREFIX_order_detail for which products are included in this sale. These 2 steps are simple enough. 3) Get the delivery and invoice addresses for this sale. <-its this bit i'm struggling with! I know this is all a bit long winded and i'm only looking at options at the moment but i should be able to write something which will really help us out. Any help or guidence with this would be appricated. Ian

Thanks MILBUC, Your English is perfect! I think i've worked out a better way of doing this.... Definitely works for the Apparel theme using 1.7. Navigate to and open "themes\*your theme*\modules\ps_featuredproducts\views\templates\hook\ps_featuredproducts.tpl". On this page you will see the <H2></H2> tags. Change these to the <H1></H1>. So, find <h2> <span>{l s='Special Products' d='Shop.Theme.Catalog'}</span> </h2> And change this to the below... <h1> <span>{l s='Your H1 Text Here' d='Shop.Theme.Catalog'}</span> </h1> Clear the cache and then view your home page. This should now be showing as the H1 heading. To add style to this, give this a unquie class and then add your required style in the Css file. <h1 class="home_h1"> <span>{l s='Your H1 Text Here' d='Shop.Theme.Catalog'}</span> </h1> I hope this helps others out. Ian

Thanks All. I'm not sure that using a module to achieve this is the best approach but i'll give the ps_customtext module a blast and see how I get on. Ian

Thanks SmartDataSoft, I'm using 1.7 with the Apparel theme. As well as trying to change this, i'm trying to keep everything SEO freiendly. If I was to move the current H2 wording, that would leave an empty H2 tag I assume? I want to change this from the current H2 to the H1 instead of doing this through a module. I understand that i would then need to add a css class to resize this H1 tag. This shouldnt be that hard to do but i just cant see which file i need to alter? Any pointers would be very helpful. Ian

Hi There, Is there a reason why there is no 'H1' tag on the home/index page? I would have thought this would have been added for SEO purposes but seeing how this has not been, i'm wondering if the H1 tag has been missed on purpose? I've removed the top carousel/banners from my home page and changed the translation of "ShopThemeCatalog - 1 expression" or "Special Products" as my theme calls it (see attached image) to a main heading and I would like this to be the 'H1' tag. 1st of all. Is this wise to do? If prestashop have not done this as default, am i causing SEO issues by doing this? 2nd, How to I do this? I cant see which template I need to edit to achiveve this. 3rd, is this simply a matter of finding this <h2></h2> header and changing it to <h1></h1> in the template file? Any advise would be appreciated.

Thanks Leo but when i do that the <div class="header-top"> height reduces to 0px and my logo is left floating over the horizontal menu. Is there any way of forcing a fixed height to this or maybe padding the div? I've tried adding height :300px; to the .header-top class in custom.css but this has no effect.

I need a little more help whilst i'm setting up my shop please. I have moved the search bar to the very top of the page but the original search bar remains in the header and is blocking my logo. How do remove the search bar in the header? see the attached image. Ian

Thanks for your help musicmaster. I did finally suss this in the end.... You HAVE to add all combinations in 'one shot'. I was adding my enclosure type and then adding my power supply type and generating each time. This does not work and gives the effect as i have detailed above on the front store. If you select all required options and then hit generate it works.