If this is your first visit, check our documentation. To post, register or login.
Forums / Addon Admin Tools / Easy Populate 1.2.5.4 support

Easy Populate 1.2.5.4 support

Started by langer on 9 May 2006, 9:44 PM · Views: 1,303,113

Results 721 to 740 of 3,834
19 May 2007, 5:33 AM
#721
rikko101 avatar

rikko101

New Zenner

Join Date:
Mar 2007
Location:
Hope Mills, North Carolina, United States
Posts:
14
Plugin Contributions:
0

Easy Populate 1.2.5.4 support

Thanks Kobra

I've been using EP for quite a while. This situation just arose.
I'm pretty sure it some error I've made adjusting the excel file.
I've tried 50 products and it goes like this:

The first 10 products are fine. The the next one is missing product name and description but the rest of the info is fine.
Then maybe 5 more products are OK and then a couple more are missing the same info. And so on. It is the same products all the time that have the missing info. So it's got to the same error common to each product maybe!

21 May 2007, 3:45 PM
#722
chadderuski avatar

chadderuski

Totally Zenned

Join Date:
Apr 2006
Location:
Dark Side of the Moon
Posts:
986
Plugin Contributions:
0

Re: Easy Populate 1.2.5.4 support

Rikko,

Have you changed any of your categories? If a cataory doesn't exit, or you changed it somehow, then I don't think it will import those records.

21 May 2007, 4:45 PM
#723
scrat avatar

scrat

Zen Follower

Join Date:
Dec 2005
Posts:
451
Plugin Contributions:
0

Re: Easy Populate 1.2.5.4 support

rikko101 - Find the product that has not imported OK and delete all the other products and just upload that one product(with header row), and see what that brings.

If you change/or a have a new catergory it should update that in the store to that new/changed cat.

What error message does EP give you UPDATED ? SKIPPED ?

21 May 2007, 5:32 PM
#724
fakedecoy avatar

fakedecoy

Zen Follower

Join Date:
Jul 2006
Posts:
309
Plugin Contributions:
0

Re: Easy Populate 1.2.5.4 support

EP isn't creating the Google Products file correctly. The required format actually changed a few months ago, so I'm surprised they haven't rejected it until now. This is part of a message from Google I got that my upload was disapproved:

Thank you for submitting a bulk upload to Google Base. We've reviewed your bulk upload and need you to make changes. Your bulk upload has been disapproved due to the reason(s) listed below.

Issues:

  1. Using outdated attributes (fields)
  2. Irrelevant product type

  1. Using outdated attributes (fields): We noticed that your bulk upload is using attribute names from an old version of our product feed format. For example, you've included "product_url" as an attribute name, although this attribute is named "link" in the Google Base format. Please convert your product feed to the new Google Base format by changing the attributes names in your header line:

http://base.google.com/support/bin/answer.py?answer=40443

Using Google Base attributes will allow you to provide more structured information about your items, which will help us to match search queries to your items.

  1. Irrelevant product type: We noticed that some of the product_type values you included aren't relevant to your items. For example, your item titled "PowerLine Home Gym" should include a more relevant product_type value, such as "Exercise equipment."

Including irrelevant information may cause your products to be miscategorized and adversely affect your items' placement. For a list of example product_type values, please visit:

http://base.google.com/base/product_types.html

Adamant Barbell - Home & commercial gym equipment - Since 2007
www.adamantbarbell.com

21 May 2007, 6:03 PM
#725
fakedecoy avatar

fakedecoy

Zen Follower

Join Date:
Jul 2006
Posts:
309
Plugin Contributions:
0

Re: Easy Populate 1.2.5.4 support

As a followup to my last post, these are now the required attributes for Google Products:

* brand
* condition
* description
* expiration_date
* id
* image_link
* isbn
* link
* mpn
* price
* product_type
* title
* upc

Only a few of these are in the current Froogle file EP generates.

See http://base.google.com/base/products.html

It's also not Froogle anymore, it's Google Products, but I don't care about that as long as it works! :)

Adamant Barbell - Home & commercial gym equipment - Since 2007
www.adamantbarbell.com

21 May 2007, 6:07 PM
#726
fakedecoy avatar

fakedecoy

Zen Follower

Join Date:
Jul 2006
Posts:
309
Plugin Contributions:
0

Re: Easy Populate 1.2.5.4 support

And lastly (or maybe not lastly), the "manufacturer_id" column, now the "brand" column, has never shown the items' manufacturers from the zencart database - it's blank.

Adamant Barbell - Home & commercial gym equipment - Since 2007
www.adamantbarbell.com

21 May 2007, 8:30 PM
#727
kobra avatar

kobra

Black Belt

Join Date:
Aug 2005
Location:
Arizona
Posts:
31,500
Plugin Contributions:
4

Re: Easy Populate 1.2.5.4 support

And lastly (or maybe not lastly), the "manufacturer_id" column, now the "brand" column, has never shown the items' manufacturers from the zencart database - it's blank.
Slightly wrong thread for this....

Try entering a manufacturer from the admin as these list correctly then look at the EP download for the correct entry

Zen-Venom Get Bitten

21 May 2007, 8:43 PM
#728
fakedecoy avatar

fakedecoy

Zen Follower

Join Date:
Jul 2006
Posts:
309
Plugin Contributions:
0

Re: Easy Populate 1.2.5.4 support

kobra:

Slightly wrong thread for this....

Try entering a manufacturer from the admin as these list correctly then look at the EP download for the correct entry

Actually I spoke too soon in regards to the manufacturer. The "brand" column is already there, and it's mapped to the zencart item's manufacturer correctly. The manufacturer field doesn't do anything and isn't required either, so no issue there really.

Adamant Barbell - Home & commercial gym equipment - Since 2007
www.adamantbarbell.com

22 May 2007, 4:29 PM
#729
mafiasam avatar

mafiasam

Zen Follower

Join Date:
Jan 2006
Location:
Portland, Oregon
Posts:
256
Plugin Contributions:
0

Re: Easy Populate 1.2.5.4 support

I have been trying to find a quick way to update inventory quantities for a while.

I get an updated xml feed from the supplier whose inventory is most crucial. I know how to convert the xml feed to an sql or excel file or at least I hope it is right.

what do I need to do in easy populate to update the inventory quantities?
I want this to be relatively simple and quick so I can do an inventory update and backup daily. will the standard easy populate work for this or do I need easy populate advanced?

OldWestPokerSupplies.com – Custom Poker Chips and Other Professional Poker Supplies
Zen Cart 1.3.9.h with Google Base Feeder, Share Bookmarking Widget, Ultimate SEO URL, A Black Pure Template, Quick Updates, Sitemap XML and reCAPTCHA.

23 May 2007, 4:16 AM
#730
rikko101 avatar

rikko101

New Zenner

Join Date:
Mar 2007
Location:
Hope Mills, North Carolina, United States
Posts:
14
Plugin Contributions:
0

Re: Easy Populate 1.2.5.4 support

Scrat:

rikko101 - Find the product that has not imported OK and delete all the other products and just upload that one product(with header row), and see what that brings.

If you change/or a have a new catergory it should update that in the store to that new/changed cat.

What error message does EP give you UPDATED ? SKIPPED ?

Thanks Scrat

I found it.
I had some tabs to the RIGHT of EOREOR. Cleaned up that area and all is well!

25 May 2007, 4:25 AM
#731
click avatar

click

New Zenner

Join Date:
May 2007
Posts:
4
Plugin Contributions:
0

Re: Easy Populate 1.2.5.4 support

Can Easy Populate 1.2.5.4 upload items with attributes? We need to upload a few thousand items. Each item has several sizes & colors. The size/color combo is tied to a sku# that is used in an XML feed. Is there a template that will work for this type of upload?
Thanks,
Click

25 May 2007, 5:49 AM
#732
kobra avatar

kobra

Black Belt

Join Date:
Aug 2005
Location:
Arizona
Posts:
31,500
Plugin Contributions:
4

Re: Easy Populate 1.2.5.4 support

Can Easy Populate 1.2.5.4 upload items with attributes?
With a few thousand items I would use something with more power....

Pop for the advanced version or use a general full featured tool for databases

Zen-Venom Get Bitten

25 May 2007, 12:45 PM
#733
peekay avatar

peekay

Zen Follower

Join Date:
Jun 2006
Location:
U.K.
Posts:
103
Plugin Contributions:
0

Re: Easy Populate 1.2.5.4 support

I have set up an MS Access database for my client to batch-add products under controlled conditions. I then export the table as a delimited file and use Easy Populate to add the products.

It all works very well, but I do wish that 'display Qty box' was available as an option. I need a big list of several hundred products with 'Buy Now' buttons, not Qty boxes.

I'm running a SQL patch for now after the upload, but having that extra switch would be a welcome addition in future versions (IMHO). :D

25 May 2007, 5:58 PM
#734
mboley370 avatar

mboley370

New Zenner

Join Date:
May 2007
Posts:
91
Plugin Contributions:
0

Re: Easy Populate 1.2.5.4 support

Hi, I was wondering if the easy populate standard will work with the new 1.3.7 version of zen cart? What is the diffrence in the standard and the advanced? I looked at the site and many forums and can't find what the standard actually does so I can't compare it to the advanced.

25 May 2007, 6:31 PM
#735
click avatar

click

New Zenner

Join Date:
May 2007
Posts:
4
Plugin Contributions:
0

Re: Easy Populate 1.2.5.4 support

We need to upload a few thousand items over time. We can upload them in small increments. Is there a template available that has all of the attribute fields?

25 May 2007, 6:35 PM
#736
kobra avatar

kobra

Black Belt

Join Date:
Aug 2005
Location:
Arizona
Posts:
31,500
Plugin Contributions:
4

Re: Easy Populate 1.2.5.4 support

I have set up an MS Access database for my client to batch-add products under controlled conditions. I then export the table as a delimited file and use Easy Populate to add the products.
From this comment I am assuming that you are somewhat DB savvy....

I use navicat, that is a general DB tool and can be scripted and these can be saved for repeat function....can connect to several DB types etc.. Powerful if you can ferret out the DB yourself.....EP is all Zen Cart and limited to only certian tables but they do provide Zen Cart support where NaviCat does not and you are on your own

http://www.navicat.com/ and they offer a 30 day trial so you can determine if this works for you before making the plunge

Zen-Venom Get Bitten

25 May 2007, 8:23 PM
#737
peekay avatar

peekay

Zen Follower

Join Date:
Jun 2006
Location:
U.K.
Posts:
103
Plugin Contributions:
0

Re: Easy Populate 1.2.5.4 support

Thx for the Navicat link Cobra. I'll take a look at that.

I'm not a DB expert, but I figure it's worth climbing a learning curve to avoid my client mis-spelling a category name and spoiling my whole day!

I am currently setting up 'dependent' combo boxes so if a client selects 'Homewares' for category 1, they have the choice of 'Kitchen' or 'Bathroom' for category 2. If they then select 'Bathroom' they get 'Towels' or 'Mirrors' for category 3.

I knew that 'Learn Access' book would come in handy one day! :book:

@mboley370
Works for me in 1.3.7. Not certain of the specific advantages of the pro version.

26 May 2007, 9:39 PM
#738
peekay avatar

peekay

Zen Follower

Join Date:
Jun 2006
Location:
U.K.
Posts:
103
Plugin Contributions:
0

Re: Easy Populate 1.2.5.4 support

I have hit a small problem. :mellow:

If I set up 10 products for import via Easy Populate and enter a manufacturer's name for product 5, all the records following that record (6,7,8,9 and 10) all adopt the same manufacturer even if the delimited container in the text file is empty. The column headers in the file and the delimiter marks in the EP screen all seem to add up.

Is this a known/reproducable problem, or is it just me?

27 May 2007, 8:05 AM
#739
kobra avatar

kobra

Black Belt

Join Date:
Aug 2005
Location:
Arizona
Posts:
31,500
Plugin Contributions:
4

Re: Easy Populate 1.2.5.4 support

Double check that each line has the end of record as the last entry - this is all that I can think of with EP

Zen-Venom Get Bitten

27 May 2007, 9:43 AM
#740
peekay avatar

peekay

Zen Follower

Join Date:
Jun 2006
Location:
U.K.
Posts:
103
Plugin Contributions:
0

Re: Easy Populate 1.2.5.4 support

Hi Kobra.

The text file seems in order. I opened it in 'Context' text editor to check the tabs. I have since discovered that if there is a value in every row for manufacturer (even a '-') then it works fine. Just doesn't handle a mix of values and blank entries. I can work around it by setting a default value.

Bigger issue I have is with the exported date format. Access won't (by default) import it as text and I get a type conversion error. Excel converts it to it's own long date format based on locale, so:

2007-03-21 17:01:17 becomes 21/03/2007 17:01

In advance of me trying it, do you know if EP will re-import successfully in that date format, or do you have to retain the format somehow?