Easy Populate 1.2.5.4 support

Hi Dennis,

Thanks for your reply. I didn't find it cryptic, I found it impossible! Once you get past the first set of columns of products, it seems to start a new set of columns (but with the model numbers missing). Whether I open it in OpenOffice or Excel, I see this same oddness.

I'm wondering if someone could help me with some SQL though and maybe we can all figure out if this is the best way to go about this. After running this SQL, I propose to edit the resulting spreadsheet, to remove the products_description column and then to upload the products_attributes table with this new data.

Here's the SQL statement I've come up with - however, it limits the products_id to one (and there are three attributes on each of my products). If I'm not being clear, let me know. I'm *really* rusty with my SQL. Can someone help me fix it so that it returns all rows in products_attributes with the products description matched up?

Select A1.products_name, A2.*
From products_description A1, products_attributes A2
Where A1.products_id=A2.products_id
Group by A2.products_id

Thanks!

Janelle

Woops - thought I had it - more work needed.

Hi

I have installed easy populate 1.2.5.4 and it seems to work ok but when I go and download the "Model/Category tab-delimited .txt file to edit" it only gives me the model and there are no categories

v_products_model EOREOR
EML4032 EOREOR

It does not give any error and I cant seem to get a sample file to download. The other files download all fine

Please help

Quote:

---

Originally Posted by fakeDecoy

Version 1.2.5.4 from 2005 is the last EP version, is that right? The Froogle feeder doesn't work - Google changed it to Google Products and changed almost all the required fields, and field names, a couple years ago. I modified some of the code last year, but it needs more work. Does anyone plan on working on it?

---

Anyone know about this? Is this the latest EP version, and will it be the last?

fakeDecoy : Google have changed the format of the feed since 1.2.5.4 was written and it will not work now. There is a new contr. for this which I believe works with XML, other wise you would need to edit the file to the new format, search in the download section.

navneet : Are you sure you have Cats. set up correctly ? Have you edited the EP file at all as it is only showing

Quote:

---

v_products_model EOREOR

---

as my unedited version gives me

Quote:

---

v_products_model v_categories_name_1 v_categories_name_2 v_categories_name_3 v_categories_name_4 v_categories_name_5 v_categories_name_6 v_categories_name_7 EOREOR

---

kburner : Enter one product in a cat. via ZC and then download that file via complete download, edit/add products to that file and reload. EP will only work if there are product already in the database. OO and Office will only work with I think 255 columns which you can use up very quickly with EP, so you may need to use a different text editor.

hbombza : Check your version of EP Version 1.2.5.4 is the best that works out of the box !

milobloom : This is a known bug in 1.2.5.4 search this thread for details.

erinl : What version are you using ?

xt0rt : read your error 'Empty delimiter ' & 'No model field in record' it looks as if your upload file format is incorrect, the best way to test is download a complete file to start with and look at that alter a few things and then upload the new file, and I am sure that will work for you.

janellez : The problem with doing it via sql, ZC needs to update several tables at once, attributes are held in a different table to product details and ZC uses table ids not model name/numbers as references in the these tables,so when EP updates the db it queries the model number/ref to get the table id number and then inserts the data or updates the data by the table id's. Other than coding it yourself or seeing if EP Advance works better for you, you will just have to live with the present version.

scrat

I have not edited easy populate at all. I have the following layout

I have one product in category B and this category is in category A.
I also tried to add another product directly in category C

still the same

navneet : By default EP gives you 7 categories which should be showing in the header live in the download file whether you have 7 or not set up in ZC.
Did you upload your products via EP firstly ? as ZC does not like excepting uploads from EP unless there is a product and category already set up originally via ZC not EP. What Version are you using ? (Langer 1.2.5.4 from Modhole not ZC Downloads is the one to use! as the others seem to be buggy.)
What does your complete file give you ? is there 7 cats. in that ?

scart:
it seems that i didnot go into configuration of easypopulate. once i did that it is working fine. Thanks for help

hello all,

i have been using google "site:www.zen-cart.com/forum stuff i want found"
and it had worked well until now..

i have installed easy populate and found it helpful - but now i would like to remove all products or rather rename models and products and generally clean up my products.

problem is when ever i change the model, the easy populate add a new product.

note: at first i thought it would use excels row numbering as a primary key to make sure no duplicate records exist, but i dont think that works.


so now i have lots of half arsed products in one of my categories. what would be manageable way of correcting my catalog of products ?


thank you.