Duplicate product problems after V8.5.1 upgrade

[Mintec]

My first site is mostly ‘out of the box’ but with some small changes to the layouts and is still very basic at the moment. I upgraded my site from v8.5.0 to v8.5.1 by downloading the full file and selecting ‘Add revised design elements to library without affecting site design.’ All seemed well until I discovered later that any product that was a duplicate could not be added to the cart. The error message was ‘The quantity must be a whole number between 1 & 32767’ even though a quantity of 1 (or any number) was selected. The original products were able to add to cart without error. I solved this by changing the product layout to the newer version (which had been saved in the library with v8_5_1_0) and then changed the layout positioning back to how I want it again.

I have solved this, but I wanted to let anyone else know that it is worth checking that even if the original products still work the duplicates might not do so.

Colin
www.just4legs.co.uk

[Kiran]

Hi Colin

Thanks were much for the information. I'm sure it will help other's who encounter the same problem.

Kind Regards

[kevster]

We are having the same problem with an upgraded shop - shop.whitehatmedia.com (dev site) - if you order certain dup items then you get an error message:

The following product(s) can not be added to the cart.
You can find the error description(s) by following the link(s).
Jellycat Rollo Rabbit

the link does not do anything.

Also I noticed that certain dup items when you click to add them to cart this works but the breadcrumb changes from the dup item path to the original path. If this jump doesnt take place it seems that the dup item will not add to cart - looks like something is corrupt with the non page genreated files referencing original and dup items?

[cdicken]

Could I ask both of you to contact Actinic support with these problems? If you don't have cover, you can contact them via http://www.actinic.co.uk/support/register.htm.

I really want to get to the bottom of every problem people experience with v8, and although quite often there are workarounds, ideally the problem wouldn't happen in the first place.

Thanks.

[kevster]

Hi Chris,

Yes we've raised this as a ticket, support have a snapshot. After reading other posts I think it could be that we used the 8.5.1 patch rather than download the full version & uninstall etc.

I think we will have to uninstall here and do a fresh setup. we had two problems - paths from dup sections/products linking to the original at some point when drilling down and also some products getting an error when addin g to cart but they used the same template throughout shop.

[cdicken]

I think we will have to uninstall here and do a fresh setup.

That's not a bad idea. Upgrading from 8.0.x to 8.5.x via a patch can be tricky as there are database changes that need to be made - but usually this just afftesct shipping rather than duplicates.

There is something definitely a bit iffy with your database anyway. The support team should be able to put their finger on it.

[tonyd]

Hi
Same problem here. Original products add to cart OK, duplicates bring up the same message:The quantity must be a whole number between 1 and 32767. I also get the same message when trying to add to the cart from the extended info page.
Anybody come up with any solutions?

[cdicken]

The problem is with this bit of code in the product layout:

<input type="text" name="Q_ProductReference" size="4" value="DefaultQuantity" class="form_input_general" />

and also

<input type="hidden" name="Q_ProductReference" value="DefaultQuantity" />

To fix the problem, the variable 'ProductReference' needs to replaced with a new variable called 'ProductID'.

The variable needs to be replaced in all the product layouts (other than where it is prefixed with 'Ref: ') and elsewhere in the library as well. You can find all instances of 'ProductReference' by right-clicking within the library and selecting 'Find'.

You'll find further instances of this within the following library groups:

Add to Cart Button - all layouts
Components - all layouts
Best Sellers Lists Entries - all layouts
Related Products Lists Entries - all layouts
New Products Lists Entries - all layouts
Also Bought Lists Entries - all layouts
Extended Info Button - all layouts
Attributes - Push Button Grid
Extended Info Layout - Includes Add To Cart Button
Day List - all layouts
Month List - all layouts
Year List - all layouts

For the last three you will need to click the orange 'click here to edit list layout settings' text and edit the 'Start of List' field.

Hope that helps.

[pinbrook]

Chris, can you expand on this please.

I have an instance of a duplicate also disappearing from the basket. I have run tests and can pin point the duplicate.

On inspecting the product layout used by the duplicate the layout is as follows

<!-- ProductLine HTML begin -->
<!-- Insert HTML for the top of the individual product -->
<actinic:block if="%3cactinic%3avariable%20name%3d%22ListIndex%22%20%2f%3e%20%20%3e%201"><!-- ProductSeparator HTML begin -->
<!-- This template specifies the product separators -->

<TR><TD COLSPAN="3"><HR SIZE="1" ALIGN="CENTER" WIDTH="100%"></TD></TR>

<!-- This template specifies the product separators -->
<!-- ProductSeparator HTML end --></actinic:block>


<actinic:block if="%3cactinic%3avariable%20name%3d%22IsProductFormUsed%22%20%2f%3e">
      <form method="post" action="<actinic:variable name="OnlineScriptURL" value="Shopping Cart Script URL" />"> 
         <input type="hidden" name="SID" value="<Actinic:Variable Name="SectionID"/>" />
         <input type="hidden" name="PAGE" value="PRODUCT" />           
         <input type="hidden" name="PAGEFILENAME" value="<Actinic:Variable Name="SectionPageName"/>" />
         <Actinic:SECTION BLOB='<Actinic:Variable Name="SectionCatFile"/>'/>
</actinic:block>
  <tr>
    <td rowspan="2" valign="TOP" align="CENTER">  <actinic:variable name="ProductImageLayout"/> </td>
    <td valign="TOP" align="LEFT" colspan="2">  
      <a name="<actinic:variable name="EncodedProductAnchor"/>"><span class="actregular"><b><actinic:variable name="ProductName"/></b></span></a>
      <span class="actxsmall"><actinic:block if="%3cactinic%3avariable%20name%3d%22IsProductReferenceVisible%22%20%2f%3e">
         Ref: <actinic:variable name="ProductReference" />
</actinic:block> <br>
      <actinic:variable name="ProductDescription"/>&nbsp;<actinic:variable name="ExtendedInformationLinks"/></span>
      <br>
      <span class="actxsmall"><actinic:block if="%3cactinic%3avariable%20name%3d%22FileURLNotEmpty%22%20%2f%3e">
	<br><a href="<Actinic:Variable Name="ProductLinkInfo"/>">
	</actinic:block><actinic:variable name="ProductLinkText"/><actinic:block if="%3cactinic%3avariable%20name%3d%22FileURLNotEmpty%22%20%2f%3e">
	</a>
</actinic:block>
      <actinic:block if="%3cactinic%3avariable%20name%3d%22IsRetailCustomerMessageUsed%22%20%2f%3e">
<br>
<Actinic:PRICE_EXPLANATION PROD_REF="<actinic:variable name="ProductID" />" COMPONENTID=-1><Actinic:Variable Name="RetailCustomerMessage"/></Actinic:PRICE_EXPLANATION>
</actinic:block> </span><br>
      <b><actinic:block if="%3cactinic%3avariable%20name%3d%22PriceIsEnabled%22%20%2f%3e">
<b>
<Actinic:PRICES PROD_REF="<actinic:variable name="ProductID" />" RETAIL_PRICE_PROMPT="<Actinic:Variable Name="ProductPriceDescription"/>">
<actinic:variable name="PriceListRetail" />
</Actinic:PRICES>
</b>
</actinic:block>
<actinic:block if="%3cactinic%3avariable%20name%3d%22ProductPriceIsEnabled%22%20%2f%3e%20%3d%3d%20False">
<Actinic:NOTINB2B><br><strong><actinic:variable name="ProductPriceNotEnabledMessage" /></strong></Actinic:NOTINB2B>
</actinic:block></b><br>
      <span class="actxsmall">   <actinic:block if="%3cactinic%3avariable%20name%3d%22DiscountDescriptionIsShownForProducts%22%20%2f%3e">
      <actinic:variable name="DiscountList" value="Standard Section Discount List" />
   </actinic:block> </span>
      <span class="actxsmall"><actinic:block if="%3cactinic%3avariable%20name%3d%22IsOtherInfoPromptShown%22%20%2f%3e">
         <br />
         <span class="actrequired"><Actinic:Variable Name="OtherInfoPrompt"/></span><br />
         <input type="text" name="O_<Actinic:Variable Name="ProductID"/>" size="60" maxlength="1000" value="" />
</actinic:block> </span>
      <span class="actxsmall"><actinic:block if="%3cactinic%3avariable%20name%3d%22IsDatePromptShown%22%20%2f%3e">
         <br />
         <span class="actrequired"><actinic:variable name="DatePrompt"/></span><br />
         <actinic:variable name="DayList" /><actinic:variable name="MonthList" /><actinic:variable name="YearList" />
</actinic:block> </span>
    </td>
  </tr>
  <tr>
    <td align="LEFT" colspan="2"><span class="actxsmall">
			<actinic:variable name="CartErrorListXML"/><actinic:block if="%3cactinic%3avariable%20name%3d%22IsQuantityPromptShown%22%20%2f%3e">
      <br />
      <span class="actrequired"><Actinic:Variable Name="QuantityPrompt"/></span>
      &nbsp;
      <input type="text" name="Q_<Actinic:Variable Name="ProductID"/>" size="4" value="<Actinic:Variable Name="DefaultQuantity"/>" />
</actinic:block>
<actinic:block if="%3cactinic%3avariable%20name%3d%22IsQuantityPromptHidden%22%20%2f%3e">
	<input type="hidden" name="Q_<actinic:variable name="ProductID"/>"  value="<actinic:variable name="DefaultQuantity"/>" />
</actinic:block><br>
			<actinic:variable name="AttributeList"/>
<actinic:variable name="ComponentList"/>
<actinic:block if="%3cactinic%3avariable%20name%3d%22IsAddToCartButtonShown%22%20%2f%3e%20%3d%3d%20False">
	<br>
</actinic:block>
<actinic:block if="%3cactinic%3avariable%20name%3d%22IsAddToCartButtonShown%22%20%2f%3e%20AND%20%0d%28%3cactinic%3avariable%20name%3d%22NumberAttributesInPushButtonGrid%22%20%2f%3e%20%3d%3d%200%29" >
   <p>
   <actinic:variable name="AddToCartButton" />
</actinic:block>
      <actinic:block if="%3cactinic%3avariable%20name%3d%22IsOutOfStockShown%22%20%2f%3e"><!-- OutOfStock HTML begin -->
<!-- This template is used for the out of stock message. -->

<B><P class="actwarningcolor"><actinic:variable name="OutOfStock"/></P></B>

<!-- This template is used for the out of stock message. -->
<!-- OutOfStock HTML end --></actinic:block><actinic:block if="%3cactinic%3avariable%20name%3d%22IsCatalogSuspendedShown%22%20%2f%3e"><!-- Suspended HTML begin -->
<!-- This template is used for the catalog suspended message. -->

<B><P class="actwarningcolor"><actinic:variable name="CatalogSuspended"/></P></B>

<!-- This template is used for the catalog suspended message. -->
<!-- Suspended HTML end --></actinic:block>

		    </span>
	
       </td>
  </tr>
<actinic:block if="%3cactinic%3avariable%20name%3d%22IsProductFormUsed%22%20%2f%3e">
      </form>
</actinic:block>
<actinic:block if="%3cactinic%3avariable%20name%3d%22IsPopUpPageGenerated%22%20%2f%3e">
	<actinic:variable name="ExtendedInfoPageDesign"/>
</actinic:block>

I can find one instance of ProductReference - prefixed with Ref: so that can be ignored. All other references are already ProductID, so I can't find anything to correct.

[EDIT] on rereading the thread my problem is slightly different in as far as you choose to buy a duplicate it goes into the basket, you then add other items to the basket and the first item is dropped from the basket. It doesn't matter in which order you add the items, but this one dup is always dropped after adding another item. Using 8.5.1 downloaded and upgraded using the full version.

[Miranda Stamp]

Just subscribing to the thread (it's mine that Jo is posting about)

[TraceyHand]

Just subscribing to the thread (it's mine that Jo is posting about)

I figured as much after I read the "other" forum lol

You can subscribe to a thread without posting in it, you know..
It's in the "Thread Tools" drop down menu top right

Just so ya know

[Miranda Stamp]

Oh yes hadn't spotted that, not being a regular daily poster here

[JulesRS]

Hi,

I am also having problems with duplicate products. I have discovered that when I view any duplicate products the extended information window displays as it should. However, when I click on the 2nd pop-up window which is used to show the dimensions of the product, I get the following error in the window with no product information:

'404 Not Found

The page you requested was not found.'

This only happens on the duplicate products and within the 2nd pop-up window. Any ideas as to how can I resolve this?

[brian.mc]

I upgraded from 8.0.4 to 8.5.1 last night, and I've so far had no problems. I've tried to replicate the problems with duplicate products, but they seem to add to cart without any issues.

[cdicken]

Jo

You are experiencing a different problem here - and having looked at your code, I'm pleased to report that it is perfect. I think it's worth raising a separate community thread or support ticket about this.