Easy Populate 1.2.5.4 support

Hi - thanks all for your posts. Will try a few suggestions off-line first. Any ideas how to uninstall EP so the downgrade will be as clean as possible? FYI had a brief flirtation with CRE Loaded (slicker than ZC, but very poor features compared to Zen) and EP worked fine with that - even with a Mac and MS Excel!

fakeDecoy

fakeDecoy:

I downgraded from EP 1.2.5.5 to EP 1.2.5.4 as you recommended in order to try to get this to work.

So it turns out I don't need to add a new field. There's already one there.

v_products_url_1

This column is in the Complete file download, but it's empty for every row. Why is that? For any feed out there, I need to be able to give the product url.

v_products_url_1 = the url of the supplier NOT THE PRODUCT

You will need to add the 'product_id' field to the EP Complete.txt download.

Or use Google Feeder and convert XML to CSV gooogled :- command line program XML2CSV open source...

Ok, I finally figured it out. The below from post #949 has a bug, I think - in one piece of code you insert the new field between the name and description, and in another you insert it after them. I haven't tried messing with it to see if I can corrupt my database, but it might be important to be consistent when changing it like I did.

To add the products_id field, all I did was the below two edits out of the 10 or so.

Line 360

Original:
$filelayout = array_merge($filelayout , array(
'v_products_name_' . $l_id => $iii++,
'v_products_description_' . $l_id => $iii++,
));

Changed to:
$filelayout = array_merge($filelayout , array(
'v_products_name_' . $l_id => $iii++,
'v_new_field_' . $l_id => $iii++,
'v_products_description_' . $l_id => $iii++,
));


Line 791

Original:
$row['v_products_name_' . $lid] = $row2['products_name'];
$row['v_products_description_' . $lid] = $row2['products_description'];
if ($ep_supported_mods['psd'] == true) {
$row['v_products_short_desc_' . $lid] = $row2['products_short_desc'];
}

Changed to:
$row['v_products_name_' . $lid] = $row2['products_name'];
$row['v_products_description_' . $lid] = $row2['products_description'];
$row['v_new_field_' . $lid] = $row2['new_field'];
if ($ep_supported_mods['psd'] == true) {
$row['v_products_short_desc_' . $lid] = $row2['products_short_desc'];
}

Im having slight issues with double spacing between the lines of text.
I use dreamweaver to come up with the HTML description, then i paste it back into excel. Once my products are done i copy the information into a notepad then upload to the server using "easy populate" upload from the admin.

the problem is that i get double spaces! even though in HTML code the spacing is <br> i still get double spaces!
now.. when i take the same code and input it manually into the product description (without using easy populate) everything shows up fine!

is anyone else having this issue? its driving me crazy! please assist!

p.s. I also keep getting double quotation marks when copying data from excel to notepad. thats a seperate issue but any idea why this is happening?

fakeDecoy:

Yikes... 245 pages in this thread. Any idea how long ago that was discussed?

Look at the first post in the thread -
Here's a quick tutorial on how to add fields to easypopulate v1.2.5.4 or 1.2.5.5
http://www.zen-cart.com/forum/showthread.php?t=116061

The instructions are very easy to follow and I was able to do it.

Good luck
Mona

Easy Populate v1.2.5.5;
has huge bug when I try to import products with same model number
I was really relying on this so I thought I should post here and see if anyone knows what I can do.

It inserts the first product; then instead of inserting the second product; it updates the first one because the product model is the same
; and creates some sort of product link bug

For example if I try to import

• model - product name -
• FP 600x450 - name 1 -
• FP 600x450 - name 2 -

BIG BUG when you try to do this!
Seems this module can really stuff up your catalog in you have the same model name for many of your items.

Example attached.

vandiermen:

Easy Populate v1.2.5.5;
has huge bug when I try to import products with same model number
I was really relying on this so I thought I should post here and see if anyone knows what I can do.

It inserts the first product; then instead of inserting the second product; it updates the first one because the product model is the same
; and creates some sort of product link bug

For example if I try to import

• model - product name -
• FP 600x450 - name 1 -
• FP 600x450 - name 2 -

BIG BUG when you try to do this!
Seems this module can really stuff up your catalog in you have the same model name for many of your items.

Example attached.

I just finished uploading 900 products and under the v_products_model column I had to start with the next available Zen Cart product ID number and continue sequentially. That worked fine for me.

Hello All,

I'm uploading attributes with some success. The uploads seems to be getting stuck on my attribute for 'Uploading a file'.

Does anyone know what the **v_attribute_values_id_
** should be for the **v_attribute_values_name_
** (FILE)?

I think this is what is causing it.

Any help would be appreciated.

Thanks!!

kcb410:

I just finished uploading 900 products and under the v_products_model column I had to start with the next available Zen Cart product ID number and continue sequentially. That worked fine for me.

I have about 4000+ products I will have to update with a ID number on the end of the v_products_model :dontgetit

SAV - 200x150 - ID01
SAV - 300x200 - ID02
PVC - 200x150
...
SAV - 200x150 - ID04
SAV - 300x200 - ID05
PVC - 200x150

http://www.safetysigns4u.com.au/index.php?main_page=index&cPath=99_100

vandiermen:

I have about 4000+ products I will have to update with a ID number on the end of the v_products_model :dontgetit

SAV - 200x150 - ID01
SAV - 300x200 - ID02
PVC - 200x150
...
SAV - 200x150 - ID04
SAV - 300x200 - ID05
PVC - 200x150

http://www.safetysigns4u.com.au/index.php?main_page=index&cPath=99_100

I would try a small test file on that first. I'm not sure how EP will handle letters, number & characters. I'm finding it to be a challenge as to what EP will accept and handle well.

kcb410:

I would try a small test file on that first. I'm not sure how EP will handle letters, number & characters. I'm finding it to be a challenge as to what EP will accept and handle well.

The model number can handle just about anything as long as it it does not exceed the allotted number of characters that you have assigned to it. I have used many special characters (#, &,$, -, digits, spaces, etc.) without any problems.

awhfy99:

The model number can handle just about anything as long as it it does not exceed the allotted number of characters that you have assigned to it. I have used many special characters (#, &,$, -, digits, spaces, etc.) without any problems.

Thank you for that information. I am new to Easy Populate but I am knee deep in learning by trial and error!! Great mod but I'm struggling with attributes a lot.

hello all!

i have to make a website for someone. He request an auto update of stock. I had made a script to transform his list automaticaly into the tipe of tab delimited list that easy populate need.

Can anyone help me making easy populate to automaticaly update from a file on localhost?

Hello all!

I have recently uploaded 900 new products to my web site.
They are all priced by attributes. Does anyone know how to change "Product is Priced by Attributes" to yes using EP?

I would like to avoid having to do it one product at a time.

Any help is appreciated.

Thank you!

where can I get easy populate now?

clnwink:

where can I get easy populate now?

In my opinion this is the best version to get

Easy Populate and attributes:

I have a great deal of products that require unique attributes (mostly shoe sizes)

Unless I pre-create a "Attribute ID" for each of these unique attributes, than download the attribute file and update it than re-insert it WILL NOT allow me create new attributeID's with unique names and update them automatically correct?

Any shortcuts for creating attributeID's and names based on unique product model out there?

I did some digging and got the "updated attribute controller" and it helps if I need to manually insert them into each product...but not by much!

Thanks!

vandiermen:

In my opinion this is the best version to get
I want to install that one.
How can I uninstall 1.2.5.5?
Thanks.

I've installed EZ Pop CSV but my store is too large to download the data so I don't have the new format.

Can someone post the headings this version needs for the full product import? Also the specials headings. We don't use attributes so the basic would work fine.

I tried my old ez pop file and it couldn't find the model number so I assume the format is new.

Thanks!

Tapper:

I've installed EZ Pop CSV but my store is too large to download the data so I don't have the new format.

Can someone post the headings this version needs for the full product import? Also the specials headings. We don't use attributes so the basic would work fine.

I tried my old ez pop file and it couldn't find the model number so I assume the format is new.

Thanks!

This is the complete.csv file.
I think this is the one you're looking for.