BigDon Posted April 20, 2015 Share Posted April 20, 2015 Upgraded to 6.0.2 on Friday afternoon from v5. All was working well with v5, and appeared to be working fine with v6. However I do an item push to Amazon on Monday mornings and this push was totally hosed! 448 errors in a push that in the past had none or an occasional 1.I have attached the actual push file and the error file that was generated by CC-v6 directly from Amazon this morning (one is a csv file and the other is a text/csv file). I HAVE to have this fixed! I run a small store and cannot afford to have ALL of my items disallowed because of errors. Amazon gets pretty PO'd about things like this and WILL shut your store's feed down - no questions asked.HELP!!!!Thanks,-DON- LindoCraftProducts.f101182310.u1429509600000000.feeduploadreport.csvuploadts-1429509600-sec_Lindo Quote Link to comment Share on other sites More sharing options...
bsmither Posted April 20, 2015 Share Posted April 20, 2015 As a comparison, can we have a copy of a file that was accepted with no errors? Quote Link to comment Share on other sites More sharing options...
BigDon Posted April 20, 2015 Author Share Posted April 20, 2015 Not now... this file was taken directly from Amazon's site. I have already upgraded my site, so there is no way to get an old file. The second file, the one with no extension, has the line numbers and the supposed "error" that they see in the file. To me, it appears there is a comma missing somewhere in the initial record that throws all of the data into a frenzy!I say that because later in the file, on line 72 I believe, they are reporting a "non-numeric" amount in the cost field - and in fact the field is showing an item title instead of the cost of the item.....-DON- Quote Link to comment Share on other sites More sharing options...
bsmither Posted April 20, 2015 Share Posted April 20, 2015 I loaded the exported data into my Microsoft Excel and immediately noted an anomaly that I do not know if it is actually an aspect of Excel.The product descriptions have 'new-lines' (CR/LF) in them.This is, of course, very expected. Although the description is actually HTML, and new lines and paragraphs are rendered with <br> and <p> tags, the actual HTML source code has proper line endings.Excel considers line endings to be the end of the record -- regardless if those line endings are 'quoted'. Thus, after a line ending, wherever it is, Excel starts a new row.Maybe this is the case with Amazon -- which means, there is a difference between CC5's output for Amazon and CC6's output. That is, CC5 may have stripped out all the line endings of the product description and CC6 does not.I'm looking through the code and will find where the Amazon output gets generated.Is it a module? Quote Link to comment Share on other sites More sharing options...
bsmither Posted April 20, 2015 Share Posted April 20, 2015 (edited) No, not a module. It's (probably) admin, Export Calatalogue.Do you recall which exporter you were using?GoogleBase, Storeya, Shopzilla, Shopping.com, or CubeCart? Or did you have other choices? Edited April 20, 2015 by bsmither Quote Link to comment Share on other sites More sharing options...
bsmither Posted April 20, 2015 Share Posted April 20, 2015 If you can recall, go to: https://www.cubecart.com/extensions/product-feeds and download the appropriate Product Feed module.If not, have you given Amazon a URL to use to fetch the feed automatically - like, on a time schedule? If so, maybe the URL stored in your Amazon Merchant control panel may help. Don't reproduce it here as it contains your secret access key. There should be a 'format' value in the URL. Quote Link to comment Share on other sites More sharing options...
BigDon Posted April 20, 2015 Author Share Posted April 20, 2015 (edited) BSmither,Don't know what you are referring to. There is a password you give to Amazon that allows them to do a product feed. I remember you gave the URL to someone in the past and included the password and it generated an screen listing of the products, that's what Amazon does. I do not do any manual exports, so I don't use any modules..... Am I confusing you yet??!!-DON-p.s. Here is the URL for autogenerating the feed:http://www.lindocrafts.com/admin.php?_g=products&node=export&page=1&per_page=5000&format=googlebase&node=export&access=XXX Edited April 20, 2015 by BigDon Quote Link to comment Share on other sites More sharing options...
bsmither Posted April 20, 2015 Share Posted April 20, 2015 So we will work on the assumption that Amazon has been given the information to use to "pull" a product feed/report from your store.Please log in to your Amazon Merchant account control panel and find the information Amazon has that is used to pull that feed/report. Quote Link to comment Share on other sites More sharing options...
BigDon Posted April 20, 2015 Author Share Posted April 20, 2015 All they need is the password. Has been working fine for about the past year - until the upgrade.See the URL I copied in message above. That is what I gave Amazon is using to generate their product listing download. They don't need anything else. I just ran the URL code and it works correctly, but as you indicated earlier, there is an EXTRA line feed/return after each record. I do not remember there being one in the past.-DON-BSmither: If there is some way to get you the password for the data-pull, let me know and I will give it to you. Quote Link to comment Share on other sites More sharing options...
bsmither Posted April 20, 2015 Share Posted April 20, 2015 format=googlebaseThat's what I needed to know.Go to: https://www.cubecart.com/extensions/product-feeds and download the GoogleBase Product Feed module. Quote Link to comment Share on other sites More sharing options...
BigDon Posted April 20, 2015 Author Share Posted April 20, 2015 Let me preface this with one comment - I stand corrected - it was GOOGLE who was doing the complaining and NOT Amazon - I have been working with both this morning with issues!!BSmiter,I have downloaded the module (got the "code" and entered it in the manage plugins, just like the instructions said) and installed it, clicked on the check box to activate it and ran another download/upload product listing to Google - same errors...I ran the URL and the feed looks the same to me. I did notice on the "header" line, immediately following the last column descriptor (if that's the correct name for the column header in the file) is the first item name in quotes, some data, and then a line return/feed a title, another line return/feed and more data... It seems that the data should ALL be on the same line until the end of the product listing and a new listing begins - correct?? Quote Link to comment Share on other sites More sharing options...
BigDon Posted April 20, 2015 Author Share Posted April 20, 2015 Here are the screen captures from Google showing the types of errors/warnings they are seeing....the page was too long to capture in one image! Quote Link to comment Share on other sites More sharing options...
Dirty Butter Posted April 20, 2015 Share Posted April 20, 2015 I'm not having any issues with my v6.0.2 Google feed, and all I did was install the GoogleBase Product Feed module. How can I help? Quote Link to comment Share on other sites More sharing options...
bsmither Posted April 20, 2015 Share Posted April 20, 2015 The GoogleBase plugin specifies that the file type to be exported is TXT (as opposed to CSV). As such, new line characters (as well as a few other characters) are stripped out, and the field delimiter is a tab character.According to the image above, the "Detected delimiter" is a comma. Did Google make available a copy of what they fetched?In CubeCart's admin, Export Catalogue, if GoogleBase is an option, click the "1" in the Download Parts column. Examine the file that was just downloaded. Quote Link to comment Share on other sites More sharing options...
BigDon Posted April 20, 2015 Author Share Posted April 20, 2015 What I attached to the original message is DIRECTLY from what Google fetched! Quote Link to comment Share on other sites More sharing options...
BigDon Posted April 20, 2015 Author Share Posted April 20, 2015 OK - the Google plugin has be not only checked on the "Plugins Listing", but ALSO INSIDE the plugin for it to work. When I first installed the plugin, I did open it and there was NO check-box. So, I checked the box in the main listing of plugins, cleared the cache and still got the same results.NOW, I open the plugin and lo-and-behold --- there is a check-box! And it is UNCHECKED although the box in the plugins listing IS checked. So, I checked the box, flushed the cache and ran the URL again. Now the listing LOOKS like it should. I will resubmit to Google and see if there are errors this time.-DON- Quote Link to comment Share on other sites More sharing options...
BigDon Posted April 20, 2015 Author Share Posted April 20, 2015 It looks like problem is now resolved. Resubmitted and got 34-items read with no errors this time.Thanks for all of your help.-DON- Quote Link to comment Share on other sites More sharing options...
bsmither Posted April 20, 2015 Share Posted April 20, 2015 "OK - the Google plugin has be not only..."Now, that is extraordinarily weird. I will say that in Manage Plugins, the Available Plugins list, the checkboxes to the left of each item does not instantaneously enable the module. There is a Save button at the bottom of the list that will then instruct CubeCart to enable/disable modules as appropriate."When I first installed the plugin, I did open it and there was NO check-box."Please tell us how you installed it. Did you use the Auto Install Token approach, or manually (FTP) the Google_Base folder to the /plugins/ folder.When you first observed the Google Base settings screen, and you say there was no checkbox, did you also note if there was or was not the Google Base logo, Configuration Settings table header, and the word Status in the table.We would like to know so that, if a glitch can be uncovered in whatever process you used, we can find and fix it. Quote Link to comment Share on other sites More sharing options...
BigDon Posted April 20, 2015 Author Share Posted April 20, 2015 I am pretty sure the Logo was there, but no checkbox, although if I remember correctly, there was some greyish artifact there, but no box. I don't remember if the word status was there or not.I indicated in an earlier post that I had used the "authorization code" method to install the plugin.I am almost 90% certain when I clicked on the modules listing box, I also scrolled to the bottom and clicked on the save button. I know I have forgotten to do that in the past - and may have this time as well (I am over 60 now, so my memory, along with a couple other things, is getting shorter!)In any event, by updating the Google App plugin, clearing the cache, making sure the plugin was enabled, seemed to do the trick. It is working now.I see the headers tabs, allow zones, disallowed zones, but there is nothing on those tabs! Of THIS I am certain - 'cause I just looked at it this very minute! Quote Link to comment Share on other sites More sharing options...
bsmither Posted April 20, 2015 Share Posted April 20, 2015 Good to know this.Thank you for the summarization of your experiences. 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.