Printable View
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?
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?.Quote:
Originally Posted by denliv
All Document General items are entered into 1 single category named 'My Collection' w/no sub directories.
Would I use something like this...
Thanks everyoneCode:UPDATE products_type SET products_type ='3' WHERE category_id = 'My Collection Category number'
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....
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.Quote:
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)