Announcement

Collapse
No announcement yet.

Finally figured out Google Merchant

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • giftlady
    replied
    Okay, never mind I figured it out.

    http://forums.3dcart.com/optimizing-...ew-3dcart.html

    Leave a comment:


  • giftlady
    replied
    Originally posted by vkmcewen View Post
    Bryon-
    *First I want to make sure that you're on a PC, not a Mac. I really only know the PC side of this. If you're a Mac user, please ignore the small novel that follows....

    I was able to get to your info. From there, these are the steps I follow:
    -Save page as: Text File
    -open Excel
    -open your file (I usually have to change the parameters so that I'm searching for 'all files' and not just excel files to find it).
    *I think you're OK up to this point. I want to make sure that we're on the same page for everything after this*

    -on the 'Import file' popup, I choose 'Delimited', then 'Next'
    -choose 'Tab' under the delimiter choices, then 'Next'
    -choose 'General' under column data formula, then 'Finish'

    Now your info should be in a spreadsheet. I usually tweak a couple things. First, I've recently encountered errors with my expiration date. It's somehow just a day or two longer than what's allowed by Google. So I just alter it by a few days.

    By default, my GTIN comes up in scientific notation (weird), so I format the whole column as a number with no decimals.

    Now you're ready to save it again. However, you have to be sure that it's saved as a txt file again.

    -Choose 'Save as'
    -Choose either 'Other format' and save as type Text-tab delimited
    -----or 'Save as' and choose 'text-tab delimited'
    -----these both get you to the same point. :)

    I then get some errors when excel is also trying to save my file as a regular spreadsheet, and I just cancel out & ignore those.

    From your file sheet, the only issue I actually see is possibly within your description. If you've typed those in a way that there's actually a tab embedded in them, that *might* be causing your problem. Try the above walk-through & let me know what errors you get.
    I went through and tried to do this. I couldn't change the date at all. When I clicked on the date it made a white box kind of over the date. I tried to save it anyways as a tab delimited file (bypassing any warnings that came up while trying to save it this way), and then tried to upload it and I still get the "Too many column delimiters" plus a bunch of other errors. I don't understand why this is so complicated. I tried CoreCommerce before coming to 3dcart and this was all automated.

    I am so confused as to how to make this work?

    Leave a comment:


  • piaf
    replied
    Page 4 from this thread specifically addresses the Google categories:

    http://forums.3dcart.com/optimizing-...22-2011-a.html

    Leave a comment:


  • sisbrown34
    replied
    Missing recommended attribute: google product category

    Ok Im missing product category. Does anyone know how to add this to my feed?
    Thanks

    Leave a comment:


  • elightbox
    replied
    Excel will change long series of numbers into exponential values. You can deal with this in two ways:
    1. when importing a text file into Excel, you will get a dialog box with different steps. in one of the steps, you can select the mfgid column and mark it as Text column (there radio buttons on the dialog box to mark what type of content the column has)
    2. when entering data directly into excel put a ' (apostrophe) before the numbers especially and Excel will treat it as a text field instead of a number field.
    Hope this helps.

    Leave a comment:


  • Elipey
    replied
    Extended Detail to new Google Feeds

    I have read with interest all of your comments. Thanks for sharing the .jpegs and .txt files as they are most helpful. My problem lies in the MFG ID field. When imported, it changes the numbers to letters and vice versa. I also noticed in the .txt feed you showed, it did the same thing in the gtin field. Does Google read this the right way. I had all but given up with this project until I saw your blog.

    Any insight would be GREATLY appreciated.:)

    Leave a comment:


  • Kanoa9321
    replied
    what do you guys do about the product categories link for google? You leave them blank or manually go add each one in.

    Leave a comment:


  • Kanoa9321
    replied
    anything happen with the URL links?

    just loaded everything to google and Im going to have to go change anything.

    if that can't be fixed, can we at least have the custom file name be an option, so we can just choose that.

    Leave a comment:


  • elightbox
    replied
    I don't understand it. 3dcart added the Canonical tag to avoid this same issue, then we send a duplicate URL to Google!!?

    This is what support said.
    As Technical Support, I can only provide the information about how it is done, not why. If you would prefer more information about "why" it was done this way by our Programming Dept, we can forward this ticket to see if more info is available.
    I requested more detail from the "Programming Dept", I will post what they say if or when I get a response.

    Leave a comment:


  • elightbox
    replied
    Product.asp

    I just noticed that the url_link in google feed generates pages with this type of link
    http://www.yoursite.com/product.asp?itemid=79

    The site map and the product index both have the regular
    http://www.yoursite.com/productxxxxxx_p_70.html

    I noticed that google had one of our products listed with both URLs. This does not seem right to me. It seems like the Froogle Feed URL should match that of the site map, and product index.
    I would appreciate anyone's comment?

    Leave a comment:


  • TMS Clint
    replied
    RE: Brand

    Mapping the "Manufacturer" field with the "Brand" Alias should have worked assuming you include a manufacturer for all off your items. I would try it again – be sure to clear your cache beforehand so you are sure to generate a completely new file. The feed generator can get sluggish/stuck and generate the same exact feed even after you've made changes, and clearing your cache fixes that.

    Leave a comment:


  • sportscenterisnext
    replied
    Finally I figured out how to get our store up and running. As someone else suggested by going to Marketing > Shopping Engines > Google Base / Froggle, it worked like a champ, Google accepted all 248 of my items.

    Google also informs me I have 1 issue, I've tried several work arounds without success. Google claims I'm missing one attribute (brand). Within my customized fields I've tried:

    Field -- Alias
    Manufacturer -- Manufacturer
    Constant -- Brand
    Manufacturer -- Brand

    The Google Gods are not happy any suggestions?

    Leave a comment:


  • Pecos
    replied
    Originally posted by vkmcewen View Post
    Here's a screenshot of my settings also. Hope this helps! :)
    Thanks! These settings worked along with using the extra field feature for product_type that GMC like's so much.

    -Pecos
    Terra Savia Winery

    :D

    Leave a comment:


  • TMS Clint
    replied
    Re: MPN/UPCs on multiple similar items

    I know that for MPN, you can put in multiple results — separated by commas. I just assumed you could do the same with UPC.

    Leave a comment:


  • QuirkyBaby
    replied
    Has anyone figured out a workaround for MPN/UPCs on items that have different size or pattern options?

    For example, I sell these hats:

    SunDay Afternoons Kids Play Hat Cream Sand

    They come in four sizes, so the size is an option template. But each size and color combo has its own UPC. As per the 3dcart setup, I can't list those, since there's only one field in the product listing that's mappable to UPC! And it would make no sense at all to list each size/color combo on its own product page as there are 8 colors and to have 32 listings would be beyond annoying.

    Same holds true for other products where the variable is the color or pattern -- I can't figure out a way to add the UPCs for each color, etc.

    Leave a comment:

Working...
X