towersecurity Posted January 7, 2017 Share Posted January 7, 2017 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? Quote Link to comment Share on other sites More sharing options...
Dirty Butter Posted January 7, 2017 Share Posted January 7, 2017 Have you sold this item before with the same listing? If so, what changes to the store have been made since then? What CC version are you on? Do you use custom seo urls? Please list the seo urls for the two products. Quote Link to comment Share on other sites More sharing options...
towersecurity Posted January 7, 2017 Author Share Posted January 7, 2017 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 Quote Link to comment Share on other sites More sharing options...
Dirty Butter Posted January 7, 2017 Share Posted January 7, 2017 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!! Quote Link to comment Share on other sites More sharing options...
ayz1 Posted January 7, 2017 Share Posted January 7, 2017 Easiest solution may be to delete and relist. Quote Link to comment Share on other sites More sharing options...
towersecurity Posted January 7, 2017 Author Share Posted January 7, 2017 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. Quote Link to comment Share on other sites More sharing options...
Dirty Butter Posted January 7, 2017 Share Posted January 7, 2017 <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. Quote Link to comment Share on other sites More sharing options...
towersecurity Posted January 7, 2017 Author Share Posted January 7, 2017 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. Quote Link to comment Share on other sites More sharing options...
towersecurity Posted January 7, 2017 Author Share Posted January 7, 2017 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.. Quote Link to comment Share on other sites More sharing options...
towersecurity Posted January 7, 2017 Author Share Posted January 7, 2017 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. Quote Link to comment Share on other sites More sharing options...
bsmither Posted January 7, 2017 Share Posted January 7, 2017 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. Quote Link to comment Share on other sites More sharing options...
towersecurity Posted January 7, 2017 Author Share Posted January 7, 2017 first noticed in 6.1.1. but the item has probably been listed since v3 or 4, but no one wanted it before now. Quote Link to comment Share on other sites More sharing options...
bsmither Posted January 7, 2017 Share Posted January 7, 2017 The quote characters in the meta description is throwing off most attempts at code viewers' syntax coloring/highlighting algorithms. Quotes are illegal here. Perhaps try to use apostrophes. Quote Link to comment Share on other sites More sharing options...
towersecurity Posted January 7, 2017 Author Share Posted January 7, 2017 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? Quote Link to comment Share on other sites More sharing options...
Dirty Butter Posted January 7, 2017 Share Posted January 7, 2017 I use this one when I want to edit meta_keywords for existing listings: UPDATE tablename SET tablefield = replace(tablefield,"findstring","replacestring"); Quote Link to comment Share on other sites More sharing options...
jasehead Posted January 8, 2017 Share Posted January 8, 2017 (deleted) Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.