Announcement

Collapse
No announcement yet.

Google Base/Froogle

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

  • Google Base/Froogle

    Everytime i try and upload a feed it gives errors. Any idea how i would fix this?

    Too many column delimiters (11 errors)

    Your items contain more attributes than those specified in the header row. Learn more.
    Examples:
    Line Nr.
    2
    3
    4
    5
    6
    Invalid date time format in attribute: expiration date (1 error)

    Please enter a date and time in the correct format: YYYY-MM-DDThh:mm:ss.
    Examples:
    Line Nr. Value
    8 "2013-11-19" Show Item Load Item into Debugger

  • #2
    anyone?????????

    Comment


    • #3
      Chris04626,
      Remove the expiration date from the feed. The feed expiry will happen automatically in 30 days from the date of upload. If you need it to expire in less than 30 days, you will need to format it as suggested by google, notice the "T", it must be there: YYYY-MM-DDThh:mm:ss

      This should take care of your missing attributes.
      Elegant Weddings +
      www.elegantweddingsplus.ca
      www.elegantweddingsplus.com

      Comment


      • #4
        How do i remove it?

        Comment


        • #5
          If you are using 3DCart Shopping Engine Feature do the following:
          • Go to your Online Store Manager
          • Marketing>Shopping Engines
          • Click on Google Base (Learn More)>Customize
          • Add/Delete the fields


          Hope this helps.
          We do not use this feature or GoDataFeed, we use our own proprietary methods.
          If you are using a third party feed perhaps they someone else can help
          Elegant Weddings +
          www.elegantweddingsplus.ca
          www.elegantweddingsplus.com

          Comment


          • #6
            Originally posted by ElegantWeddings View Post
            If you are using 3DCart Shopping Engine Feature do the following:
            • Go to your Online Store Manager
            • Marketing>Shopping Engines
            • Click on Google Base (Learn More)>Customize
            • Add/Delete the fields


            Hope this helps.
            We do not use this feature or GoDataFeed, we use our own proprietary methods.
            If you are using a third party feed perhaps they someone else can help
            There is no expiration field in there

            url_link
            name
            extended_description
            image_link
            top_category
            id
            price
            constant

            IS what i have

            Comment


            • #7
              I would just use godatafeed until 3dCart fully supports all the Google Fields needed.

              Comment


              • #8
                Google Feed Setup

                Hi Chris,

                3Dcart does not want to be fully set up for Google Feed or they would be. Instead would rather you use a paid service like Godatafeed.

                3Dcart should have dedicated fields setup like shown below but they force us to use a work around with their available extra fields. Below is a copy of my Google Feed fields that I had to discover and wish I had someone give me a hand with. Since you had to use the extra_fields_ x you will have to <!-- comment around them in the code --> to stop them from appearing on your "Product Pages". There other things to setup but this will get you started.

                Customize Google / Build Export Sets

                Set Name: Google
                Category Separator: -
                Delimiter: Tab Delimiter

                Field---------------------------Alias----------------------- Prefix
                Catalogid -------------------- id
                Name ------------------------ title
                extended_description ----- description
                extra_field_2 ------------- google_product_category
                top_category --------------- product_type
                url_link ---------------------- link
                image_link ----------------- image_link
                constant ------------------- condition ------------------- new
                stock ----------------------- availability ------------------ in stock
                weight ---------------------- shipping_weight
                price -----------------------
                expiration-date ----------- expiration_date
                manufacturer-------------- brand
                mfgid ----------------------- MPN
                extra_field_1 -------------- UPC
                extra_field_3--------------- ISBN
                extra_field_4--------------- gender
                extra_field_5--------------- age group
                extra_field_6--------------- color
                extra_field_7--------------- size

                Hope this is of some benefit. If anyone knows of a better way let us know.
                Last edited by Patriot Al; 11-01-2013, 04:38 PM.
                Patriot Al
                www.BackyardWildBirds.com

                Comment


                • #9
                  I just personally fought and fought with this last month because suddenly ALL my products were disallowed because of feed issues. Not sure why, I didn't change anything at all. Asked for help on a couple of occasions from support and got none, did ALOT of research and alot of reading and finally got my export set built and all my products were accepted. FINALLY, I'm telling you I only had a couple hairs left at that point.

                  I'm not sure how many attributes that are associated with your product line are needed, but in my case I whittled down alot that were not required and this is my current export set for Google
                  Attached Files

                  Comment

                  Working...
                  X