Jump to content

Wrong item added to basket


towersecurity

Recommended Posts

I was contacted by a customer who noticed that when he tried to add a product to the basket, a different one was added.

We looked into this and found just the one item that does this:
http://towersecurity.co.uk/locks/specialist-locks/metal-shop-door-locks/tower-security-21068-apg-lock-set-of-4.html

adds

http://towersecurity.co.uk/locks/specialist-locks/metal-shop-door-locks/union-21068-kxt-armour-plate-glass-apg-lock-pair.html

to the basket.

I looked at the database but couldnt see any duplicated fields,
The items were created many years ago and each have  different product_id, product_code, description and name.
I'm not sure what the unique key is for the file, so I cant see why?

the product_id (generated by CC) are 819, and 647 - I assume they were created at different times even though they are essentially the same product but a different configuration.
 

I tried creating an error log, but nothing showed up.

this occurred in version 6.1.1, and still happens now i've updated to 6.1.3.

we've only found this one item doing this, but still looking to see if it happens elsewhere.

It only occurs when adding to the basket from the main product view.. not if you add from the search results or catagory listing.

Any Ideas?

Link to comment
Share on other sites

It's a specialised item and hasn't been sold on this listing before.
The store has been updated several times over the years.
Today upgraded to 6.1.3, noticed the problem on 6.1.1 but who knows when it first occurred.

Before V5, we had some third party addins, including SEO, but now run a standard product except for some personal amendments to skins.

the seo urls are generated by cc we don't change the url but do add meta description & keywords.
I attach a csv file with the two records.

 

 

Book1.csv

Link to comment
Share on other sites

Take a closer look at the meta description of the 4 lock set and maybe the description, too. There's something unexpected in the source code. Copy it to Notepad+ or some other developer note app and then copy/paste in again.

 

There's also a reference to an Estelle mod in the Source code on the 4 pack, too!!

Link to comment
Share on other sites

not sure what i'm looking for.

attached is the original SQL export in notepad++, i copied it to excel before so i could read and compare easier

I would have thought the "add to basket" button works on the Product_id, not the seo. How does this affect things?

CubeCart_inventory.sql

ayz.. i agree, deleting and relisting might solve THIS instance.. I just like to see if there's a reason first.

If i could see corrupted data, i'd be happy to accept that. But everything i looked at seems OK.

Link to comment
Share on other sites

<html xmlns="http://www.w3.org/1999/xhtml" dir="ltr" lang="en-GB">
  <head>
	<title>Tower Security 21068 (APG) Lock (Set of 4) - Tower Security, Quality Locksmiths</title>
	<link rel="canonical" href="http://towersecurity.co.uk/locks/specialist-locks/metal-shop-door-locks/tower-security-21068-apg-lock-set-of-4.html" />
	<link rel="shortcut icon" href="http://towersecurity.co.uk/favicon.ico" type="image/x-icon" />
	<link rel="stylesheet" type="text/css" href="http://towersecurity.co.uk/skins/kurouto/styles/common.css" media="screen" />
	<link rel="stylesheet" type="text/css" href="http://towersecurity.co.uk/skins/kurouto/styles/blue/layout.css" media="screen" />
	<link rel="stylesheet" type="text/css" href="http://towersecurity.co.uk/js/styles/styles.php" media="screen" />
		<!--[if IE 7]><link rel="stylesheet" type="text/css" href="http://towersecurity.co.uk/skins/kurouto/styles/ie7.css" media="screen" /><![endif]-->
	<meta http-equiv="Content-Type" content="text/html;charset=utf-8" />
	<meta name="description" content="Set of 4 locks to replace Union 21068 "KXT" as fitted in the top/bottom rail of some armour plate glass shop doors. All four locks are keyed alike to operate with the same keys

 Locksmith, Tower Security is a family run business, providing security products and services for more than 60 years." />
	<meta name="keywords" content="union 21068,21068,union kxt,kxt lock,apg lock,armour plate glass door lock,shop door lock,lock, locks, locksmith, Lock, Locks, tower, Tower Security, Security, Tower, london, keys, key, Key, Keys, security,Chubb, chubb, chub, yale, Yale, abloy,...more deleted 

The description part shown in Source Code with FF has the content in bold red - which is usually an indication of some sort of syntax issue, plus the odd spacing.

Link to comment
Share on other sites

ok, i see the estelle reference, we did have that mod back in V.3 or 4..

looking at the description on the product setup i see a odd item on the bottom of the page.. screenshot attached.
this references 647.. so this must have be redirecting the item to the basket as I've deleted it and it's working OK now.

But the estelle reference still shows on the database record. so doesn't seem to be related to this.

I have 15 other products with an estelle reference, so i'll look through and see if any of those are affected.

not sure about the red ie7 line, it's not one I'd have modified. I'll have a look for that too.

 

screenshot.gif

Link to comment
Share on other sites

Finally, deleted all the references to estelle mod

the hidden cell shows on the one product description  .. <input name="add" type="hidden" value="647" ..
Don't have the faintest idea how this would redirect what's being sent to the basket.. but apparently it did.

Thanks for all your help on this.. :)

Link to comment
Share on other sites

just had another look at that ie7 red line Butter highlighted above..

isn't  "<!-- " a comment tag..? 
i still dont think it's something i would have edited unless it was instructions in one of the mods we used to have ..

as IE7 is 10 years old, i don't think I'll worry about it too much.

But Thanks again for everyone's help.
 

Link to comment
Share on other sites

This is something strange: CC5 allows this to happen, but CC6 forces the issue---

If I visit the page:
towersecurity.co.uk/?_a=product&product_id=819
the URL stays in that syntax.

CC6 will always send a 302 bounce to the browser and have it re-request the page using the seo-friendly syntax of the URL:
towersecurity.co.uk/locks/specialist-locks/metal-shop-door-locks/tower-security-21068-apg-lock-set-of-4.html
unless this is something about CC613 I do not yet know about.

 

Link to comment
Share on other sites

And the hidden cell was in the ordinary description, not the seo description.or the item name, which the seourl is based on.

OK, i'll pass the quotes info onto the people who enter the new products,

Is it just the description, or other field as well?

Is it possible to write a sql to replace any quotes already there?

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...