Jump to content
VJ

Easy Populate & Products Attributes

Recommended Posts

Hi,

 

I have an EP problem.

 

My database is so large (about 1000 products plus variants) that when I EP it and attempt to open using Excel, it actually has more columns than Excel caters for?

 

any suggestions ?

 

nick

sydney

 

 

That is so funny! I swear I was just about to post the same issue! I will try and find that Quattro Pro that Mibble mentioned, but if anyone has anyother suggestions please let me know.

Share this post


Link to post
Share on other sites

Hi..

 

I'm still looking for an answer for my question above. Just to paraphrase.. When adding attributes and options, how do I get EP to see the same ones as a single option and not multiple. Example.. T-shirts come in S, M, L and in White, Blue, Black. I want it to show each option as a single instance instead of 3 small (one for each color) or 3 white (one for each size).

 

Do I need a different contrib for this?

 

Also, say I have T-shirts that come in colors but I also have candles. I would like the attribute of White to show only once and not twice (once for t-shirts and once for candles).

 

Is this possible?

 

Thanks

Lori

Share this post


Link to post
Share on other sites
Hi All...

 

I can Dowload to Local and to Temp Directory fine, but having problems uploading... I can only ever get the 1st record updated - the rest are ignored .... even when I upload a file I've just downloaded (without editing)... doen't matter whether it is a full or partial download/upload - same problem

 

Data file is :

 

v_products_model v_categories_name_1 v_categories_name_2 v_categories_name_3 EOREOR

CARWC001 Threads Caron Collection Watercolours EOREOR

CARWC002 Threads Caron Collection Watercolours EOREOR

CARWL Threads Caron Collection  EOREOR

CARWF Threads Caron Collection  EOREOR

CARIS Threads Caron Collection  EOREOR

CARRA Threads Caron Collection  EOREOR

CARWC000 Threads Caron Collection Watercolours EOREOR

DMC151 Threads DMC Stranded Cotton EOREOR

DMC150 Threads DMC Stranded Cotton EOREOR

DMCECRU Threads DMC Stranded Cotton EOREOR

DMCBLANC Threads DMC Stranded Cotton EOREOR

DMCB5200 Threads DMC Stranded Cotton EOREOR

Output looks like :

 

File uploaded.

Temporary filename: /tmp/phpjwqOig

User filename: EP2005Aug23-0012.txt

Size: 617

| CARWC001 | Threads | Caron Coll | Watercolou Updated

| CARWC002 | CARWL Thr | CARWF Thr | CARIS Thr | CARRA Thr | CARWC000 | DMC151 Th | DMC150 Th | DMCECRU T | DMCBLANC | DMCB5200 |

all records have EOREOR fields

 

If I delete the 1st record (not header)... the second record (now 1st) loads successfully but all remaining are again ignored.

 

After Upload file is still in temp directory...

 

I've scoured the Thread and have found a number of similar problems - all seem to be related to DOCUMENT_Root and tempdir settings and the differences between local and Server environments - but haven't come across any explanations or resolutions....  Have tried just about all combinations for these setting I can think of ..

 

using Easy Populate 2.76-MS2 & osCommerce 2.2-MS2

 

Any Suggestions ??

 

Andy  :'(

 

Did you solve the problem? I have the same. On my localhost (testing site) is everything OK, but when I upload the site easypopulate is not uploading correctly. Thanks

Share this post


Link to post
Share on other sites

When I downoad a complete tab-delimited .txt file the file contain the same products several times. On my last attempt each product was listed 13 times.

 

Can anyone give me a hint of how to solve this?

 

// Fredrik

Share this post


Link to post
Share on other sites

this problem is because of php5, the answer is a few pages back

 

Did you solve the problem? I have the same. On my localhost (testing site) is everything OK, but when I upload the site easypopulate is not uploading correctly. Thanks


John Oligario

 

Knowledge Base Contributions

Share this post


Link to post
Share on other sites

I have a weird problem when I try t upload some products. I made a 50 products test file to see if easypopulate works...

 

I upload the csv file without splitting cause it's only 50 products and when it ends it says everything went smooth but when I check to see if the products are there, there's only the last product! Here's an example of easypopulate's output:

 

File uploaded.
Temporary filename: /tmp/phpFm2dcf
User filename: spectra.csv
Size: 9090
| History | History-1 | test1 | test1 | | 7 | 0.00 | | 17/06/2005 | 20 | | Magazines | PCMag | | VAT 19% | Active !New Product!
| History | History-2 | test2 | test2 | | 7 | 0.00 | | 17/06/2005 | 20 | | Magazines | PCMag | | VAT 19% | Active Updated
| History | History-3 | test3 | test3 | | 7 | 0.00 | | 17/06/2005 | 20 | | Magazines | PCMag | | VAT 19% | Active Updated
| History | History-4 | test4 | test4 | | 7 | 0.00 | | 17/06/2005 | 20 | | Magazines | PCMag | | VAT 19% | Active Updated
| History | History-5 | test5 | test5 | | 7 | 0.00 | | 17/06/2005 | 20 | | Magazines | PCMag | | VAT 19% | Active Updated
| History | History-6 | test6 | test6 | | 7 | 0.00 | | 17/06/2005 | 20 | | Magazines | PCMag | | VAT 19% | Active Updated
| History | History-7 | test7 | test7 | | 7 | 0.00 | | 17/06/2005 | 20 | | Magazines | PCMag | | VAT 19% | Active Updated
| History | History-8 | test8 | test8 | | 7 | 0.00 | | 17/06/2005 | 20 | | Magazines | PCMag | | VAT 19% | Active Updated
| History | History-9 | test9 | test9 | | 7 | 0.00 | | 17/06/2005 | 20 | | Magazines | PCMag | | VAT 19% | Active Updated

.... until it reaches the end (50th product)

| | | | | | | | | | | | | | | |

No products_model field in record. This line was not imported


There's a diference between living & BEING ALIVE!

Share this post


Link to post
Share on other sites

WOW that's an awesome QUICK answer! Thanks man it solved the problem. I'm so dumb afterall... :D


There's a diference between living & BEING ALIVE!

Share this post


Link to post
Share on other sites
When I downoad a complete tab-delimited .txt file the file contain the same products several times. On my last attempt each product was listed 13 times.

 

Can anyone give me a hint of how to solve this?

 

// Fredrik

 

I went thru the file once again, and it turned out that I made some msistakes and left out some code when I added the code for the Extra Image contrib.

 

// Fredrik

Share this post


Link to post
Share on other sites

I have added some code to update the extra images for the extra image contribution.

 

Below are the two sections that update and insert the extra images

###
////////// Check to see if there this product has extra images - JFJ
###

	 if ( isset($v_products_extra_image) ){
	 
   $query = "  INSERT INTO ".TABLE_PRODUCTS_EXTRA_IMAGES."
         (products_id,
          products_extra_image,
          products_extra_popup_image)
        VALUES (
            '" . $v_products_id . "',
    	 '" . $v_products_extra_image . "',
    	 '" . $v_products_extra_popup_image . "'
            )";
       }      
	 
   $result = tep_db_query($query);        
### ///////////////

###
///////////////////  Do we have extra images? JFJ
###
 if ( isset($v_products_extra_image) ){
  	 
     // Check to see if this product already have an extra image
   $result = tep_db_query("SELECT products_id FROM ".TABLE_PRODUCTS_EXTRA_IMAGES." WHERE (products_id = '". $v_products_id . "')");
 
   if (tep_db_num_rows($result) == 0)  {

     // nope, there comes the new extra image
     $result = tep_db_query($sql);
     $sql =
    	 "INSERT INTO ".TABLE_PRODUCTS_EXTRA_IMAGES."
       (products_id,
          products_extra_image,
          products_extra_popup_image)
        VALUES (
            '" . $v_products_id . "',
    	 '" . $v_products_extra_image . "',
    	 '" . $v_products_extra_popup_image . "'
            )";
     
  	 } else {
     // already has an image, then we just uptate it
     $sql =
    	 "UPDATE ".TABLE_PRODUCTS_EXTRA_IMAGES." SET
       products_id='$v_products_id',
       products_extra_image='" . $v_products_extra_image . "',
       products_extra_popup_image='" . $v_products_extra_popup_image . "'
    	 WHERE
       products_id = '$v_products_id'";
     }
     $result = tep_db_query($sql);
  	 }

###////////////////////

This code insert or update the extra images. But heres the problem;

If the section for "Extra Image" is empty in the .txt-file it insert a blank section in the database.

How do I make EP skip the insert, if there no extra image to insert?

 

// Fredrik

Share this post


Link to post
Share on other sites

OK I have tried to make this work but everytime I upload a file it says that it's in tmp/xyz now when i go to move it there is no such file or dir as tmp/xyz.

 

I have made a temp dir in catalog and chmod it to 777. Can you please help OH and DOCUMENT_ROOT is the server path to the store.

Share this post


Link to post
Share on other sites
so your path is /catalog/temp for the temp file in the ep file?

 

Yep it is and the temp file is chmod 777. I can upload the file and it gives me no errors now but there is no data imported. Thank you for your reply.

Share this post


Link to post
Share on other sites

I am having trouble importing data into Easy Populate. I can download and edit files in tab deliniated format but not import them. I don't get error messages, just no data. I am running oscommerce in localhost mode on a Windows XP machine.

 

My catalog is located at D:\Program Files\Apache Group\Apache2\htdocs\catalog, and I have created a temp directory as required under catalog. I think from what I have read in the posts that my problems are likely to be associated with tempdir and document root settings in configure.php., but I just can't get it right.

 

If anyone is able to assist with specific configure.php line entries I would be very grateful.

 

Many thanks, Michael

Share this post


Link to post
Share on other sites

Well I am soooooooooooo pleased to say that I think I just figured it all out. The problem was that I was saving the database as a tab delimited file as I thought I was supposed to BUT if you look at the examples clearly the data is semicolon demilited SO i opened my text file and copied a tabed space and pasted into find and then in replace put a semicolon and bingo it actaully imported and gave me the same looking info everyone else sees.

Share this post


Link to post
Share on other sites

Ok I have a problem my site contains about 1200 different products with about 100 different categories. The problem I have is the category images. I need the abilty to add the path to the subcategory and category images to my spreadsheet, otherwise i will have to manually edit the categories to set the images. Since I will be uploading my list 2 or 3 times a week that creates alot of mindless boring work. Is there anyway to do this or has anyone done this?

Share this post


Link to post
Share on other sites

that means you have an older version, you should change it back to tab deelimited, someone had changed it and it has been messing people up all over the place. read thru the ep file as the docs state, you will find the spot to change it.

 

Well I am soooooooooooo pleased to say that I think I just figured it all out.  The problem was that I was saving the database as a tab delimited file as I thought I was supposed to BUT if you look at the examples clearly the data is semicolon demilited SO i opened my text file and copied a tabed space and pasted into find and then in replace put a semicolon and bingo it actaully imported and gave me the same looking info everyone else sees.


John Oligario

 

Knowledge Base Contributions

Share this post


Link to post
Share on other sites

DOCUMENT_ROOT needs to be $DOCUMENT_ROOT

 

check for tab delimited versus semicolon, make sure set to tab delimited in the ep file.

 

I am having trouble importing data into Easy Populate. I can download and edit files in tab deliniated format but not import them. I don't get error messages, just no data. I am running oscommerce in localhost mode on a Windows XP machine.

 

My catalog is located at D:\Program Files\Apache Group\Apache2\htdocs\catalog, and I have created a temp directory as required under catalog. I think from what I have read in the posts that my problems are likely to be associated with tempdir and document root settings in configure.php., but I just can't get it right.

 

If anyone is able to assist with specific configure.php line entries I would be very grateful.

 

Many thanks, Michael


John Oligario

 

Knowledge Base Contributions

Share this post


Link to post
Share on other sites
the same as adding extra fields, header tags is commented out

 

 

Hi John.

 

I've been trying to figure out how to uncomment the header tags and I'm at a loss (i'm still learning php). I need to be able to add SPPC & Header tags to my spreadsheet so I can upload. When I downloaded the database, there were no fields for either although they're installed on the server.

 

From the manual I know I need to add this to my spreadsheet:

 

'v_products_head_title_tag_N'
'v_products_head_desc_tag_N'
v_products_head_keywords_N'

 

and

 

'v_customer_price_N'
'v_customer_group_id_N'

 

What I can't figure out is how to make the header tags & SPPC uncommented without screwing up my database. I found this in easypopulate.php and when I removed the // I got a parse error.

 

// support for Linda's Header Controller 2.0 here
	 if(isset($filelayout['v_products_head_title_tag_' . $lid])){
   $row['v_products_head_title_tag_' . $lid]  = $row2['products_head_title_tag'];
   $row['v_products_head_desc_tag_' . $lid]  = $row2['products_head_desc_tag'];
   $row['v_products_head_keywords_tag_' . $lid]  = $row2['products_head_keywords_tag'];
	 }
	 // end support for Header Controller 2.0

 

Am I even close to being on the right track?

Edited by simplyclesha

Thanks!

Clesha

Share this post


Link to post
Share on other sites

John,

 

Thanks -- but I'm not sure what you mean. The fields are obviously in the database, but they don't appear in the EP-generated delimited file. I see in easypopulate.php where the field names are set up (lines 214-227). Is it a simple matter of adding the new fields to this list, or is there something more to it when you say "programmed in." Thanks.

 

easypopulate will recognize these fields if they are programmed in.  i use the attribute options contribution

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×