Easy Populate 1.2.5.4 support

YairOz - > /home/playrus/public_html/MYADMINCATEGORY/includes/easypopulate/easypopulate_import.php on line 39
I think you need to check your easypop. install as you should not have a easypopulate folder the easypopulate.php file should be just in the ' includes/' folder.
One question? which version are you using as the more I think about this it doesn't seem version 1.2.5.4 with the name of the above file, 1.2.5.4 which is the proven version. I know there are some new versions in the download section but I think they a little buggy, search this thread for links to the down of version 1.2.5.4 if you are not using it.

Scrat:

YairOz -
I think you need to check your easypop. install as you should not have a easypopulate folder the easypopulate.php file should be just in the ' includes/' folder.
One question? which version are you using as the more I think about this it doesn't seem version 1.2.5.4 with the name of the above file, 1.2.5.4 which is the proven version. I know there are some new versions in the download section but I think they a little buggy, search this thread for links to the down of version 1.2.5.4 if you are not using it.

Im using easy populate advanced 3.0.3 which I've download from http://www.zencartbuilder.com

I checked the files structure on my server with the zip file I got... looks fine... every file is where it suppose to be...

YairOz - My advance would be contact the seller (There is a forum on this Version on the website ) and seek advice from them, as it may be a issue with that version. As this version is a rewrite of the Easypopulate and works different to the free version as the file structure is different.

Hi everyone,

I'm about to reach for a pistol because I cannot find an answer to something that has been troubling me for several days...

I simply want to be able to populate 'Document General' items under a 'Document General' category with EP.

By this I mean a products_type 3 that are NOT for sale. I have a 'Doc-Gen' category all set up as an image gallery and it works fine as long as I add items manually. When I add them via EP it forces the items as 'Product General' and therefore they all have the 'add to cart', 'sold out', etc verbiage as if they were for sale.

I do not see a field labelled 'v_products_type' in the standard EP spreadsheet. Is it possible to add it and if so does it have to be in any particular place?

I'm sure this has come up before but I am having no luck doing it. Is there a way to do this or can anyone help me think of a way to trick it into working?

Thanks for any input

Assuming you don't have to many records to modify & you're comfortable with phpMyAdmin (if you have it on your server) you could do something like the following:
In easy poplulate pick a field you don't need or can modify without consequence & put a unique piece of data there as a marker for each record you want to modify (like a quantity of 5555 or unique date in a date field, etc). Then go to phpMyAdmin & in the products table search for all records with the unique item you entered & change the document type for all those records.
Kind of a round-about way but it'll git'er done.

Here is another quick question about easy populate. On my website I have a problem I redid my whole storefront and forgot to move my download section
I still have the first site can I import the download files tree?

denliv:

Assuming you don't have to many records to modify & you're comfortable with phpMyAdmin (if you have it on your server) you could do something like the following:
In easy poplulate pick a field you don't need or can modify without consequence & put a unique piece of data there as a marker for each record you want to modify (like a quantity of 5555 or unique date in a date field, etc). Then go to phpMyAdmin & in the products table search for all records with the unique item you entered & change the document type for all those records.
Kind of a round-about way but it'll git'er done.

Hi there, thanks for responding. This would work however I need to add just under 500 items initially then add 10-12 here and there. The 10-12 added periodically could be entered manually which bypasses my problem but I wonder about adding the first 500 via EP then running a update query which searchs for all items in category 'My Collection' and changes the products_type from 1 to 3?.

All Document General items are entered into 1 single category named 'My Collection' w/no sub directories.

Would I use something like this...

UPDATE products_type SET products_type ='3' WHERE category_id = 'My Collection Category number'

Thanks everyone

robinstl - If you have a unique ref to these products yes a sql script would do the job, what you need to do is test it out on your test shop/store first. Then when you are happy with that,as always backup... backup... and then try it on your live store.

tonysebay - are you saying you have moved hosts? or just updated your store image, have your links changed? Not really understanding what you are asking for?

Hi all, thanks for putting out great information on this site for us noobies!

I am having a problem. I have downloaded and installed Easy Populate successfully. So here is the problem I am having.

I have some files from the distributors, that were not in Easy Populate format, so what I did is add some categories and then products, then did a complete export so I can see where I needed to cut and paste the things I had from the distributors. In doing so, I noticed my exports had no "Categories" and when I did cut and paste, and imported the products, it was successfull, but no products show up! Any help would be appreciated or if someone can point me to a file I can use as a "template" that would be great!

I again thank you, as I am pretty new at this. Merry Christmas!

Hi,
i have the free version of langer's easypopulate mod installed on my site. I managed to get the products up but for some reason i cant get the attributes file to import properly. When i upload the file, it says that the product is updated. For example,

UPDATED! - Model: J795 | 1 | 1 | COLOR | 1 | | Light Pink | 2 | | Black Terr | 3 | | White Terr | 4 | | | 5 | | | 6 | | | 7 | | | 8 | | | 9 | | | 2 | SIZE | 1 | | S (White S | 2 | | M (White S | 3 | | L (White S | 4 | | LL (White | 5 | | 1X | 6 | | 2X (White | 7 | | | 8 | | | 9 | | | 10 | | | 3 | | 1 | | | 2 | | | 3 | | | 4 | | | 5 | | | 6 | | | 7 | | |

But the option values are all blank and only two of the 5 option names are created. I've attached the tab delimited attribute file, I would really appreciate if you took time out of your busy schedule and help a noob(me) get my site up and working. Thanks in advance.

wickerman - Your problem is that you cannot have different values in the options_names columns - v_attribute_options_name_1_1 they have to be all the same....

v_products_id v_products_model v_attribute_options_id_1 v_attribute_options_name_1_1 v_attribute_values_id_1_1 v_attribute_values_price_1_1 v_attribute_values_name_1_1_1
1 J795 1 COLOR 1 Light Pink Terry (J795)
2 K700 1 COLOR 1 Matte Black (K700)
3 J792 1 COLOR 1 Red Terry (J792)
4 M121 1 COLOR 1 Starburst Orange (M121)
5 B956 1 BOTTOM SIZE 1 XS (Orange,Yellow,Black ONLY)

See attached example file do not import this as it is not the full file just an example, the best way is download a attributes file and open that and you should see the same stucture. You have to insert a value of +0.000 or higher/lower in v_attribute_values_price columns to make the attribute status live.

First off, thanks for the quick reply. I tried fixing that and uploading the new file(the one i've attached), but the same thing happens. What could i be doing wrong? Excuse my ignorance.

the paod version of this offers no support whatsover, ive been trying t oget in tocu via contact form and supprot ticket, with no answers. Looks like im out my $65.

This guy cant handle all the support that goes with a paid mod and is in way over his head just collecting our money and not caring if we figure out how to use it or not.

wickerman - right we need to fault find...

Is this a downloaded file or one you have produced?

 If not { download the attributes file and post that.}

 else 
      { you have a issue with your attribute values, which will be half your problem.}

You cannot have different values in the same column:
 
 v_attribute_values_name_1_3_1
 M (Black ONLY)
 L Limited
 M
 L
 M
 L
 M 
 L

They have to be the same value

 v_attribute_values_name_1_3_1
 M (Black ONLY)
 M (Black ONLY)
 M (Black ONLY)
 M (Black ONLY)
 M (Black ONLY)
 M (Black ONLY)
 M (Black ONLY)

so for every v_attribute_values_name column the value is the same (unique value)

so v_attribute_values_name_1_4_1 is

 v_attribute_values_name_1_4_1
 L (Black,Yellow Only)
 L (Black,Yellow Only)
 L (Black,Yellow Only)
 L (Black,Yellow Only)
 L (Black,Yellow Only)
 L (Black,Yellow Only)

and you set them on or off by giving a value to the v_attribute_values_price column. If you set that column to +0.000 it shows the attribute with the product at the price setup in the product details, and if you set v_attribute_values_price to +1.500 it adds 1.50 to the basic price like wise you can set it to a minus figure as well. I think you haven't got to grips with the attribute concept, and you are using EP to change the settings before you understand how attributes work.

CnTGifts - Don't know anything about EPA Authors situation, usually he is helpful as you can see looking back at this thread, do remember Zencart is fully automatic and works with out human hands so of cause you can still pay for downloads and you get the files even if the author does look at his pc for weeks, whats your issue, we maybe able to help but cannot promise.

PriestB - I think you are talking about merging data supplied by your suppliers to EP format, you would need to write a script to merge it automatically other wise you need to do a little/alot of cutting and pasting in OO or excel.

when you buy the mod your buying 1 years support, hes aprantly to busy to supply 1 day of support

I take back everything i said. No need to worry about support issues he will get to you in a reasonable time.

Scrat, Thanks for helping me out. I've been using zencart for only a couple of weeks now, thats why i dont know the basic stuff. Hopefully i'll get the hang of it soon.
Ok, so i managed to correct the errors you told me about and i uploaded the file, the fields get but updated but not as expected. I am uploading both the file i uploaded(attrib.txt) and the EP generated file after the upload(Attributes-EP2007Dec24-1604.txt). Is this because all the values in v_attribute_values_name have to be the same? Thanks again for all the help.

Hi All I searched High and low for this but found nothing. So here is my problem I added all my items using EPA and as always it went in with no problem, but now I wanted to add a new product and it came back with this ID 2147483647 I know this is the magic number for the end or last product
so when I went to add one more product this popped up

1062 Duplicate entry '2147483647' for key 1
in:
[insert into products (products_quantity, products_type, products_model, products_price, products_date_available, products_weight, products_status, products_virtual, products_tax_class_id, manufacturers_id, products_quantity_order_min, products_quantity_order_units, products_priced_by_attribute, product_is_free, product_is_call, products_quantity_mixed, product_is_always_free_shipping, products_qty_box_status, products_quantity_order_max, products_sort_order, products_discount_type, products_discount_type_from, products_price_sorter, products_image, products_date_added, master_categories_id) values ('1', '1', '2321', '2', null, '0', '1', '0', '0', '0', '1', '1', '0', '0', '0', '1', '0', '1', '0', '0', '0', '0', '0', '', now(), '388')]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

I downloaded my store with EPA and the last Item # was 2147483647
the one before that ID number is 98378 any Ideas how to reset this?
when I go into Tools/EPA/ the Index Mode: products_id it says
Next products table id: 2147483647 how do I reset that back to 98379?

Thanks for your help.
And Happy Holidays to All!

CnTGifts:

the paod version of this offers no support whatsover, ive been trying t oget in tocu via contact form and supprot ticket, with no answers. Looks like im out my $65.

This guy cant handle all the support that goes with a paid mod and is in way over his head just collecting our money and not caring if we figure out how to use it or not.

He has always replied to me in the past I have asked him a few questions recently and they have gone unanswered it appears he has either a family problem or a health problem He does the best he can and I'm sure when everything clears up he will be back on again.

Happy Holidays To ALL!