Easy Populate & Products Attributes

[kunal247]

until you change your document root to what it is supposed to be, not much else is going to happen. please change it to $DOCUMENT_ROOT

excel, open office, quattro pro all have tutorials on how to edit spreadsheet files

are the products setup with categories?

John,

thanks for your response.

I am able to edit the file but want to know how to set up maping for other supplier feeds into my format for the feed?

 

Hope i am able explain the situation, also that i am not missing your point of view too.

 

Regards,

Kunal

[Guest]

until you change your document root to what it is supposed to be, not much else is going to happen. please change it to $DOCUMENT_ROOT

excel, open office, quattro pro all have tutorials on how to edit spreadsheet files

are the products setup with categories?

 

 

Yes indeed, some even have two subcategories.

[mcoski]

If my stores url only allows it to be:

www.yourstore.com/online/catalog

 

then under $tempdir would I use:

 

"/catalog/temp/"

"/online/catalog/temp"

 

I am confused about this part, thanks.

[miked]

Mike when I was looking closely at my error I found that putting a / before catalog was unnecessary, however i changed it so that it was in the root folder so i just made a temp / folder inside of the root folder.

 

Make sure it's not giving you a // error because then it's a simple fix simply try "your location/"

 

Ex. "temp/" instead of "/temp/"

 

It turns out the Field Separator section was not set correctly in the easypopulate.php file I downloaded. Tab Delimited was not the pre-set, it was a comma.

It seems to work fine right now.

Thanks to all.

Mike D

[Guest]

"/online/catalog/temp/"

for both

 

[quote name='mcoski' date='Sep 26 2005, 01:12 PM' post='709573'

If my stores url only allows it to be:

www.yourstore.com/online/catalog

 

then under $tempdir would I use:

 

"/catalog/temp/"

"/online/catalog/temp"

 

I am confused about this part, thanks.

[thessrtech]

Anyone know how to do what I'm talking about?

 

I'm adding in the products with easypopulate however I want to add in some universal sub items to specific products. Instead of having to maek a subcategory I want there to be a selection inside of a product page.

 

Any ideas?

[Guest]

I've been reading throughout the posts of this contribution and I think Easypopulate does not support different languages for categories.

Can someone confirm this please?

[simplyclesha]

Hello.

 

I'm trying to get EP to up/download the special prices per customer fields with no luck. I have uncommented the fields in ep.php and when I manually add the the 4 fields to the sheet(v_customer_price_2' v_customer_group_id_2' v_customer_price_3' v_customer_group_id_3'), nothing from those fields upload and when I then download, the fields are gone. The groups in admin are listed as Retail, Reps & Wholesale, which I have made groups 1, 2, & 3 repectively, with 1 as the original field.

 

How do I get this function to work? Should this field be placed right after the v_products_price field? I have it after the v_products_quantity field only because of the order in the manul.

 

Anyone?

[trademaster_adam]

I changed my configure.php to:

 

// define('DIR_FS_DOCUMENT_ROOT', '/mnt/webhosting/sites/b/mysite.com/mystore/shopping/');

define('DIR_FS_DOCUMENT_ROOT', $DOCUMENT_ROOT);

 

I create a file in the temp directory, it says:

You can get your file in the Tools/Files under /mystore/temp/EPEP2005Sep26-1806.txt

 

And nothing is there. I've got that folder CHMOD'd to 777.

 

Thanks!

 

TrademasterAdam

 

 

until you change your document root to what it is supposed to be, not much else is going to happen. please change it to $DOCUMENT_ROOT

 

QUOTE(trademaster_adam @ Sep 25 2005, 01:47 PM) *

 

Thanks! but, it's still not quite working, almost there. For some reason it's trying to point to a different temp directory or something. All of these directories are chmod 777:

 

mystore/tmp

mystore/temp

mystore/admin/tmp

mystore/admin/temp

 

And still when I hit create EP files, it says a file was created, but nothing is in any of the directories. Something is hosed up somewhere and I don't know quite where, here's all that I've changed, what am I missing? I can download a file straight to my PC but it's not finding the temp directory.

After I upload something:

Easy Populate 2.76-MS2 - Default Language : English(1)

File uploaded.

Temporary filename: /tmp/phpWKvf7j

User filename: Upload_List.txt

Size:

 

At the bottom of easypopulate.php it says:

Create EP and Froogle Files in Temp Dir (/mystore/temp/)

 

Configure.php

define('DIR_FS_DOCUMENT_ROOT', '/mnt/webhosting/sites/b/mysite.com/shopping/mystore/'); // where the pages are located on the server

// define('DIR_FS_DOCUMENT_ROOT', $DOCUMENT_ROOT);

define('DIR_WS_ADMIN', '/shopping/mystore/admin/'); // absolute path required

define('DIR_FS_ADMIN', '/mnt/webhosting/sites/b/mysite.com/shopping/mystore/admin/'); // absolute pate required

 

easypopulate.php

$tempdir = "/mystore/temp/";

$tempdir2 = "/mystore/temp/";

 

// fix by jb 20040815 set the strings to http post/request, since they don't seem to work on the new server, with register globals=off...

$dltype=$_REQUEST['dltype'];

$download=$_REQUEST['download'];

 

global $HTTP_POST_FILES;

 

foreach( $HTTP_POST_FILES as $varname => $fileinfo ){

$GLOBALS[$varname] = $fileinfo["tmp_name"];

$GLOBALS[$varname.'_name'] = $fileinfo["name"];

}

// end fix jb

THANKS!!

 

 

until you change your document root to what it is supposed to be, not much else is going to happen. please change it to $DOCUMENT_ROOT

excel, open office, quattro pro all have tutorials on how to edit spreadsheet files

are the products setup with categories?

[jackrabbit]

Hello.

 

I'm trying to get EP to up/download the special prices per customer fields with no luck. I have uncommented the fields in ep.php and when I manually add the the 4 fields to the sheet(v_customer_price_2' v_customer_group_id_2' v_customer_price_3' v_customer_group_id_3'), nothing from those fields upload and when I then download, the fields are gone. The groups in admin are listed as Retail, Reps & Wholesale, which I have made groups 1, 2, & 3 repectively, with 1 as the original field.

 

How do I get this function to work? Should this field be placed right after the v_products_price field? I have it after the v_products_quantity field only because of the order in the manul.

Anyone?

 

I'm sorry that you didn't get an answer sooner, I know how frustrating that can be...

 

For whatever reason if you download the complete EP file the alternative pricing does NOT show up. You have to click on the "Download Model/Price/Qty tab-delimited .txt file to edit" link. That should let you edit your different price catagories.

[sukotto]

For everyone that had the following error when using easy populate with quantity discount mod, or maybe just had the following error anyway:

 

1136 - Column count doesn't match value count at row 1

 

insert into products_attributes values.....

 

 

[TEP STOP]

 

here's a tidbit that may help you. After searching forever, and not finding a solution in the forums, I trusted the posts by Mibble that there was nothing wrong with the code. There were posts cautioning the fact that there are many poeple who upload a easypopulate contrib, but had adjusted the variables to their own liking, and sometimes things don't work for another person. I decided to start with a brand new clean copy of easypopulate (ver 2.76.). I used a file comparer tool to compare the code. What I realized was that soem of the column listings in easypopulate_pricebreak were placed in the wrong order, or that they were placed twice in the same query. After using the file comparison tool, I copied and made sure that things were in teh right order.

 

After doing this, I was still having errors. but this time it was because there was an unexpected $ somewhere in teh code. After searching for another few hours, I discovered that the way I had copied things over from using the file comparison tool.

 

In the code around line 1235, after the code of $key5, I forgot to close the for argument with a }. My comparison software didn't flag it as a missing line, and it was probably just as easily have been me copying things over incorrectly the first time.

 

This made my easypopulate working. I can now add new products to the database.

 

I am by no means a programmer, so for me, this was a huge undertaking to fix this problem. I still dont' know the actual code that caused problems, but by starting over and taking the steps above, I solved my problem. I hope that my experience can help someone else out there trouble shoot.

 

All I can say is, use a clean version of easypopulate, copy only the things you need, and make sure everything is in the right order.

[simplyclesha]

Anyone?

I'm sorry that you didn't get an answer sooner, I know how frustrating that can be...

 

For whatever reason if you download the complete EP file the alternative pricing does NOT show up. You have to click on the "Download Model/Price/Qty tab-delimited .txt file to edit" link. That should let you edit your different price catagories.

 

 

jackrabbit -

 

thank so much for the reply! i should be able to get everything completed now.

[Guest]

i have just instaled auto populate with my oscommerce. i have installed STS and i am using them template that comes with that. I was able to successfully upload my spreadsheet, but i see no product listings.

am i doing something wrong, or are there changes that i have to make since i am using STS.?

 

Thanks in advance for the help.

Clint

[thessrtech]

I'm having problems with my store, it's getting out of control because I have alot of the same products but with different attributes. So basically what I need is to have a way to easypopulate 1 product and have a pull down tab with different prices for the variables? is this possible?

[astraler]

Hi,

 

I have problem about upload product file.My product file is tab delimited txt file.After upload file for spliting, appear easypopulate frontpage, there is no error, and no upload file.What is problem?

 

Thanks for your help.

Regards,

[Guest]

:( I have a serious problem with EP...

 

I have two languages in my catalogue... when I upload my products they all upload fine and all the product names are in both languages, also the categories should be in both languages and they are NOT.

 

Then if I try to go to the admin section and manually add the other languages to the different categories it will not upload the changes.

 

Before I installed EP I could edit and change the categories language but since I installed EP something has been messed up.

 

Is there someone else had this before?

Can someone tell me how to fix that???

[Guest]

:( I have a serious problem with EP...

 

I have two languages in my catalogue... when I upload my products they all upload fine and all the product names are in both languages, also the categories should be in both languages and they are NOT.

 

Then if I try to go to the admin section and manually add the other languages to the different categories it will not upload the changes.

 

Before I installed EP I could edit and change the categories language but since I installed EP something has been messed up.

 

Is there someone else had this before?

Can someone tell me how to fix that???

 

I've been doing some tests and I can edit and change the information of any of the categories from the default catalogue (the ones that weren't uploaded by means of EP).

It looks like the action=update_category doesn't work for the categories I uploaded with EP...

:o

I've no clue of what should I do...

[-RJM-]

I am using Easy Populate and Attribute Sort V1.0 which adds a value to the database for sort order of the attributes. Easy Populate does not import this value, nor does it export it.

 

Any ideas on how to work with this, as attribute sorting is very important to me.

[mcoski]

Is there a way after I load up a new site with products to change all of their status to active, without having to give them inventory numbers. All product stock just says 0 (for now), but I don't want to have to click active for their status on each and every product.

[Guest]

do u have access to phpmyadmin?

[Guest]

:( I have a serious problem with EP...

 

I have two languages in my catalogue... when I upload my products they all upload fine and all the product names are in both languages, also the categories should be in both languages and they are NOT.

 

Then if I try to go to the admin section and manually add the other languages to the different categories it will not upload the changes.

 

Before I installed EP I could edit and change the categories language but since I installed EP something has been messed up.

 

Is there someone else had this before?

Can someone tell me how to fix that???

 

 

Try this http://www.oscommerce.com/community/contri...h,easy+populate

[svenman]

I'm going insane here! Similar problem to the one above. Something about having two languages messes up EP. It doubles the categories and the products. On the English site you see only one of the categories, on the Dutch site you them double, including a categorie I already deleted. In the admin you only see the English ones and you have no control over the Dutch ones. Help me! (my website: www.manamaze.com)

 

 

Sven

[yatahaze]

Currently, is there any way to import specials? Even with a different mod or something?

[1cns]

I just installed EP 2.76b and am experiencing issues similar to "trademaster adam" and "miked". That is, no error messages, but no files showing up in the temp directory. Uploads also produce no error messages, but don't actually update anything.

 

I notice some references in this thread to modifying configure.php "per doc". My Easy Populate doc makes no reference to changing this file. What needs to change there to make this work? Is there some more complete EP documentation somewhere? The configure.php additions noted in trademaster adam's post didn't do it for me.

[Guest]

Try this http://www.oscommerce.com/community/contri...h,easy+populate

 

Thank you so much for your answer yoyo!

It looks like that is the solution to my problem... I will try that.

:thumbsup: