Announcement

Collapse
No announcement yet.

Help Setting Up Google Feed

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

  • Help Setting Up Google Feed

    I am kinda new to 3dcart, and could use a little help understanding and fixing the errors I am getting via our google base feed. Below are the errors I thank you in advance for any help you may give.

    Item Errors - 2478 items with errors 2478 items affected
    1240
    Extra tabs (1240 errors)
    Your items contain more attributes than those specified in the header row.
    Learn more.
    Examples: Examples:

    Item Nr. Line Nr.
    2 3
    3 4
    4 5
    5 6
    6 7

    619
    Invalid date time format in attribute: expiration date (619 errors)
    Please enter a date and time in the correct format: YYYY-MM-DDThh:mm:ss.
    Examples: Examples:

    Item Nr. Line Nr. Value
    1 2 "2011-1-30"
    18 19 "2011-1-30"
    19 20 "2011-1-30"
    20 21 "2011-1-30"
    21 22 "2011-1-30"

    619
    Invalid price (619 errors)
    We don't accept non-numeric values, zero (0), or negative prices. If you are including the currency code or symbol, please make sure it matches the currency of the target country.
    Examples: Examples:

    Item Nr. Line Nr. Value
    1 2 "15"
    18 19 "33"
    19 20 "33"
    20 21 "33"
    21 22 "33"
    Jimmy

  • #2
    I am having the exact same problem. I can't seem to find instructions on how to customize the feed.
    VMcEwen
    Zephyr Kites

    Comment


    • #3
      Been getting the same exact errors and have been resubmitting a four month old feed with new dates.

      Finally got it to work last week.

      Save it as a tab delimited text file. NOT COMMA which is what I've been doing.

      I think I saved it first a csv but not sure but when I took the same exact file and save as tab it worked.

      The date will be formatted as x/xx/2011 instead of 2011/xx/x. ignore it and submit it as is

      Comment


      • #4
        It will be nice when this is automated...

        >Great News! The scheduled shopping feeds request has been accepted and >it's already being included in our development schedule.
        >Gonzalo Gil
        Last edited by ritchey; 01-17-2011, 06:30 PM.

        Comment


        • #5
          Originally posted by ritchey View Post
          It will be nice when this is automated...
          Yes, it should be tab deliminated. If you're using a Mac, save it with the MS format, not the default.
          kem
          AddressNumbers.com
          Address Plaques, Memorials, Home & Garden Decor, Gifts and more.

          Comment


          • #6
            Here's what I do:
            1. Import into excel
            2. name the columns as:
            link, title, description, image_link, product_type, id, price, brand, condition
            3. I leave the year off. Google adds it on mine.
            4. save file as google_base.txt (Mac uses should save as Windows formatted text. Format: tab deliminated Text (.txt)
            5. Manually import to Google base.

            May not work for you, but that's what I do.
            kem
            AddressNumbers.com
            Address Plaques, Memorials, Home & Garden Decor, Gifts and more.

            Comment


            • #7
              kem!! This actually worked for me! Thank you soooo much!! :D :D
              VMcEwen
              Zephyr Kites

              Comment


              • #8
                Originally posted by kem View Post
                Here's what I do:
                1. Import into excel
                2. name the columns as:
                link, title, description, image_link, product_type, id, price, brand, condition
                3. I leave the year off. Google adds it on mine.
                4. save file as google_base.txt (Mac uses should save as Windows formatted text. Format: tab deliminated Text (.txt)
                5. Manually import to Google base.

                May not work for you, but that's what I do.
                Hi Kem,

                How do you import this file into Excel? Each time I click "generate feed", "click here to download the export file", a new tab opens up in Firefox with the url "https://www.macdimms.com/assets/exports/file.txt". Do I need to download this file via FTP?

                Here are the headers and the first line for a single product I have submitted:
                link,title,description,image_link,product_type,id, price,brand,condition,expiration_date
                "http://www.macdimms.com/product.asp?itemid=66","Crucial Mac Pro DDR2 667MHz FB-DIMM ECC 2GB (1GB x 2) Kit"," Kit: 2GB (1GB x 2)Brand: CrucialPins: 240 pinType: DDR2 FB-DIMM Speed: PC5300 667MHzCapacity: 1GB per module, 2 modulesECC: YesWarranty: Lifetime ","http://www.macdimms.com/assets/images/crfbdimm150.png","Mac Pro RAM - Mac Pro DDR2 667MHz ECC FB-DIMM Memory ","CRFB6672GBK","110.99","","new","2011-05-06"

                I know that looks confusing but the point I'm trying to make is that even though I choose "tab delimiter" everything is separated by commas. What I have been doing is copying and pasting the text from the new tab that opens up and pasting into notepad, saving the file and then uploading. Errors, errors, errors. :( This is confusing. Can you or anyone help?

                Bryon
                www.macdimms.com
                The Mac Memory Specialists.

                Any fellow 3dcart Mac users can use the promo code - 3dcart - to receive a discount on RAM for your Mac. This is a special thank you for all the previous and future help!

                Comment


                • #9
                  Hi Byron. Sorry for the delayed response. It appears from another thread that you got your answer. If not, let me know. If you have a Mac, you may have a couple extra steps.
                  kem
                  AddressNumbers.com
                  Address Plaques, Memorials, Home & Garden Decor, Gifts and more.

                  Comment

                  Working...
                  X