Easy Populate 1.2.5.4 support

[Scrat]

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.

[robinstl]

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

[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.

[tonysebay]

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?

[robinstl]

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

[Scrat]

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.

[Scrat]

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?

[PriestB]

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!

[wickerman]

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.

[Scrat]

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.