Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Easy Populate & Products Attributes


VJ

Recommended Posts

doesnt look like you finished off the lines all with eoreor

the last two do not have model #'s

 

The last two shouldn't have been there at all, they've been removed.

 

As for the eoreor, none of the sixty items have an entry. If that column was relevant, wouldn't the first fifteen items not been added to the db properly?

Link to comment
Share on other sites

This may have being answered before, although I am, to say the least, a little confused. I am using EP 2.76e and have finally got it all working to the best of my knowledge. I have an exported CSV fie of all my products although this includes all varying attributes for each product listed on a single line. This means Product 1 with Attrib 1 and 2nd Attrib 1 and Product 1 with Attrib 1 and 2nd Attrib 2 and so on. Each single available option has a single row as a product. This makes somewhere in the region of 10000 lines. There is only approx 2 to 300

actual products, although what makes it appear as so many is when you include all the attributes. Hopefully someone will understand what I mean.

 

My question: Is there a way of getting Easy Populate to recognise these attributes and not create an individual product for each attribute as they are listed in my CSV and only show the 2 to 300 products and to automatically work-out that there are copies of the same product just with multiple attributes. Or is there a work around. Or what options can I use with the least amount of hassle. Any help with this is much appreciated.

 

Sam

Link to comment
Share on other sites

The last two shouldn't have been there at all, they've been removed.

 

As for the eoreor, none of the sixty items have an entry. If that column was relevant, wouldn't the first fifteen items not been added to the db properly?

Rationalizing that is futile, must end all lines with EOREOR for it to work correctly.

If you won't use the attributes, the columns can be omitted.

Link to comment
Share on other sites

This may have being answered before, although I am, to say the least, a little confused. I am using EP 2.76e and have finally got it all working to the best of my knowledge. I have an exported CSV fie of all my products although this includes all varying attributes for each product listed on a single line. This means Product 1 with Attrib 1 and 2nd Attrib 1 and Product 1 with Attrib 1 and 2nd Attrib 2 and so on. Each single available option has a single row as a product. This makes somewhere in the region of 10000 lines. There is only approx 2 to 300

actual products, although what makes it appear as so many is when you include all the attributes. Hopefully someone will understand what I mean.

 

My question: Is there a way of getting Easy Populate to recognise these attributes and not create an individual product for each attribute as they are listed in my CSV and only show the 2 to 300 products and to automatically work-out that there are copies of the same product just with multiple attributes. Or is there a work around. Or what options can I use with the least amount of hassle. Any help with this is much appreciated.

 

Sam

EP doesn't make additional rows for the attributes. It will make multiple rows for products in multiple categories. EP will expand the attributes into additional columns on each row.

 

If you have created the shop using the "copy" method to put products in multiple categories, you have a mess, regardless of whether all the multiple product entries have the same model number. This could be corrected, theoretically, by **backing-up your full database first**, then export the entire database using EP, then clear your products tables & your category tables, then reimporting the database using EP (in parts because it will be a large file). EP uses the "link" method to recreate all the references to the multiple categories which allows you to manage it as described below...

 

If you have used the "link" method to put products into multiple categories, it could be managed using one line per product since there will only be 1 actual product entry for all the multiple categories. If you want to update anything (except the categories), one line in EP will get the product updated.

 

There isn't any way to export the ENTIRE database without all the multiple lines per product if you have products in multiple categories.

Link to comment
Share on other sites

I am having an issue that suddenly came up. It is with images after uploading a csv with EasyPopulate 2.76e. I have the image in teh file, and when it uploads I can see the product in Admin product manager, but it says "IMAGE DOES NOT EXIST". I click edit, and it has the correct image name I click Preview, adn the image is there. I click Update, and it still says teh image doesn't exist. It does not show up in the store.

 

The file exists in the image directory, I can see it using my FTP client. It has 777 rights. I can see the time and date it was created.

 

Now the wierd part (as if it isn't already wierd). If I go back to Admin product manager, edit the product, change the image file to anything else, save it, then re-edit it putting it back to the original file name, everything works correctly.

 

Before someone says I must have teh image directory not set up corectly, if I now go back and look at the same image using my FTP client, in exactly the same spot, the create date and time have changed. So it is over-writing the file, but for some reason it can now see what it could not previously.

 

I have been checking the forums for hours, last night and today. Can't find any mention of something like this. I have tried changing all teh image and thumbnail settings, clearing my thumbnail directory, anything else I can think of.

 

I have almost 1000 products, adn the prospect of having to change the image twice for every one of them is not pleasant.

 

Here is a little more information. I am using RC2a, EP 2.76e, On the Fly Thumbnails, STS (I turn it off, no help), I think that is about all that would effect this. I have 125 attributes, so I can't edit the full spreadsheet because it goes past the 256 column limit on any editor I have. So I do a on the fly export with EP with the needed columns, edit them and re-import. The only issue I seem to have is this image problem.

 

Thanks for any help you can give.

Link to comment
Share on other sites

If it only shows up after editing a product in the admin, and the path to the image is EXACTLY the same as what is entered using EP, my guess is the On the Fly Thumbnails. On the Fly Thumbnails should generate the thumbs at viewing time, but its not happening for you. Look over that install again for something missing in the /includes/functions/html_output.php or general.php, maybe?

Link to comment
Share on other sites

post the top half of your configure.php file as well as more info on your ep upload (first 5 to 10 products should do)

 

catalog/includes/Configure.php

 

define('HTTP_SERVER', 'http://www.*****.com');

define('HTTPS_SERVER', 'http://www.*****.com');

define('ENABLE_SSL', false);

define('HTTP_COOKIE_DOMAIN', 'www.*****.com');

define('HTTPS_COOKIE_DOMAIN', 'www.*****.com');

define('HTTP_COOKIE_PATH', '/dev_store/');

define('HTTPS_COOKIE_PATH', '/dev_store/');

define('DIR_WS_HTTP_CATALOG', '/dev_store/');

define('DIR_WS_HTTPS_CATALOG', '/dev_store/');

define('DIR_WS_IMAGES', 'images/');

define('DIR_WS_ICONS', DIR_WS_IMAGES . 'icons/');

define('DIR_WS_INCLUDES', 'includes/');

define('DIR_WS_BOXES', DIR_WS_INCLUDES . 'boxes/');

define('DIR_WS_FUNCTIONS', DIR_WS_INCLUDES . 'functions/');

define('DIR_WS_CLASSES', DIR_WS_INCLUDES . 'classes/');

define('DIR_WS_MODULES', DIR_WS_INCLUDES . 'modules/');

define('DIR_WS_LANGUAGES', DIR_WS_INCLUDES . 'languages/');

 

The store is in teh root of my site. All my images reside in an images directory off that root. And not all the pictures get broken, just some. At this point I have 4 layers of sub-catagories, and it only seems to break images in sub-catagories under that top level catagory, none of the others.

 

I'm trying to be as complete in my description and information as possible.

 

Here is a link to a sample csv

 

http://www.lapdogindustries.com/Sample.csv

 

I tried comparing the html_output.php from the On The Fly contrib to mine, but the HTML href link wrapper function was modified by Ultimate SEO URL, and there is other stuff in the contrib file that references STS that mine doesn't have in it (although ST works great). If I just try putting the contrib html_output.php in the catalog, it breaks my store and I can't get to any locations but the index.php.

 

My general.php in teh catalog is bone stock.

 

I tried doing this again tonight, and when I uploaded one catagory using EP it trashed many catagory and product images that are not even associated with what I uploaded. So basically whenever I upload using EP I have to reload a hundred or so images using the 2 step process listed above. Not fun.

 

I appreciate any efforts on my behalf.

Edited by ldisales
Link to comment
Share on other sites

If it only shows up after editing a product in the admin, and the path to the image is EXACTLY the same as what is entered using EP, my guess is the On the Fly Thumbnails. On the Fly Thumbnails should generate the thumbs at viewing time, but its not happening for you. Look over that install again for something missing in the /includes/functions/html_output.php or general.php, maybe?

 

Actually it happens all by itself. No image in the store, no image in teh admin product manager. The file actually exists in teh images directory. If I go in to the editor, change the image and then change it back to the original, it uploads a new file over the old one (modify date changes) and magically everything works again for that image. Repeat about 100 times to do all the broken product and catagory images. But just a percentage of all teh images, not every one. No rhymne or reason to which as far as I can tell.

 

Then, if I download an EP file with even just a small subset of products, make the most minor chnages to anything, then upload using EP, it seems to break all the same files again. Even those that are not included in the EP changes.

 

Images durectory and all images have chmod 777. Thumbnails are located off teh images directory, and I have tried deleting all teh thumbnails to cause them to be created again. No help.

 

I have been struggling with this for a couple days, and I have probably had to reload these images 10 or 12 times so far. I currently have about 800-900 products, and have maybe that many more to add. So I really would like to make this work.

 

EP adds the products fine, and puts them in teh right catagories, correct prices and all other information. It even puts in the proper image name, but the only thing that seems to actually find the image is the product manager preview function. The image doesn't appear in the list of products, but if I hit Edit then Preview I can see it there. But if I upload from preview it still doesn't appear unless I actually go back in to Edit and change to another file and then change back.

 

You guys would be lifesavers if you can figure this out.

Link to comment
Share on other sites

Actually it happens all by itself. No image in the store, no image in teh admin product manager. The file actually exists in teh images directory. If I go in to the editor, change the image and then change it back to the original, it uploads a new file over the old one (modify date changes) and magically everything works again for that image. Repeat about 100 times to do all the broken product and catagory images. But just a percentage of all teh images, not every one. No rhymne or reason to which as far as I can tell.

 

Then, if I download an EP file with even just a small subset of products, make the most minor chnages to anything, then upload using EP, it seems to break all the same files again. Even those that are not included in the EP changes.

 

Images durectory and all images have chmod 777. Thumbnails are located off teh images directory, and I have tried deleting all teh thumbnails to cause them to be created again. No help.

 

I have been struggling with this for a couple days, and I have probably had to reload these images 10 or 12 times so far. I currently have about 800-900 products, and have maybe that many more to add. So I really would like to make this work.

 

EP adds the products fine, and puts them in teh right catagories, correct prices and all other information. It even puts in the proper image name, but the only thing that seems to actually find the image is the product manager preview function. The image doesn't appear in the list of products, but if I hit Edit then Preview I can see it there. But if I upload from preview it still doesn't appear unless I actually go back in to Edit and change to another file and then change back.

 

You guys would be lifesavers if you can figure this out.

If I'm reading what you are saying right, I still think it is your implementation of On the Fly Thumbs. Fix it or remove it if there are areas that you can't merge correctly. Images are created when the product is saved, and check/updated when the product is viewed. The latter is broken on your shop.

Link to comment
Share on other sites

So you have checked the image path after uploading using the admin, and compare that with image path in your CSV file. And you have determined that they match EXACTLY, as I refered to in the first reply? This is very important since it is the basis of any thought in your case. And your category images are showing correctly?

Link to comment
Share on other sites

Hi surfalot,

 

Thanks for your help with that although I'm a little confused. I am aware of osC and how it lists attributes as additional columns. This is currently how we've being testing it. My issue lies with my client providing me with a csv file of all of their products with a listing of every attribute having its own row in the csv file e.g.

 

Jumper 01 Red S

Jumper 01 Red M

Jumper 01 Red L

Jumper 01 Blue S

Jumper 01 Blue M

Jumper 01 Blue L

Jumper 02 Blue S

Jumper 02 Blue M

Jumper 02 ... etc

 

 

Is there a work-around to take the multiple attributes from this format or is it easier to bring the listing down to one line for each product and manually insert the attributes? I'm sure there has to be an easier way to doing this or another contribution that will it do it for you, perhaps?

Link to comment
Share on other sites

I am having an issue with easy populate. I am importing appx 8000 prodcts. The images are linked to another website. However, when they are imported I get the following http://mysite.com/images/httt://imagesite.com/.....

 

I'm trying to figure out where I need to go to tell OSC or Easy populate to not default my /images folder. Hopefully my question makes sense.

 

Thanks in advance!

Link to comment
Share on other sites

Hi surfalot,

 

Thanks for your help with that although I'm a little confused. I am aware of osC and how it lists attributes as additional columns. This is currently how we've being testing it. My issue lies with my client providing me with a csv file of all of their products with a listing of every attribute having its own row in the csv file e.g.

 

Jumper 01 Red S

Jumper 01 Red M

Jumper 01 Red L

Jumper 01 Blue S

Jumper 01 Blue M

Jumper 01 Blue L

Jumper 02 Blue S

Jumper 02 Blue M

Jumper 02 ... etc

 

 

Is there a work-around to take the multiple attributes from this format or is it easier to bring the listing down to one line for each product and manually insert the attributes? I'm sure there has to be an easier way to doing this or another contribution that will it do it for you, perhaps?

 

at present, there is no method of importing multi-row products with EP. Everything must be done with the single row definition described in the docs. I didn't write the attributes part of EP, and don't thing that person is monitoring any longer. Import a couple products by hand, export and examine the format you must use.

Link to comment
Share on other sites

I am having an issue with easy populate. I am importing appx 8000 prodcts. The images are linked to another website. However, when they are imported I get the following http://mysite.com/images/httt://imagesite.com/.....

 

I'm trying to figure out where I need to go to tell OSC or Easy populate to not default my /images folder. Hopefully my question makes sense.

 

Thanks in advance!

you will have change the tep_image() function, or change its usage thoughout the site where product images are displayed.

Link to comment
Share on other sites

When i export with easy populate from my database i get some characters in chinese (undreadable). In my database I m using UTF-8, but it doesn't export them properly. The language I m using is Greek.

 

And when i use the excel to correct things and writing greek characters it doesnt load them. It just loads nothing there.

 

thanks for the help

Link to comment
Share on other sites

When i export with easy populate from my database i get some characters in chinese (undreadable). In my database I m using UTF-8, but it doesn't export them properly. The language I m using is Greek.

 

And when i use the excel to correct things and writing greek characters it doesnt load them. It just loads nothing there.

 

thanks for the help

there is help for using UTF-8 chars in the v2.76g package. the heading is "SPECIAL INSTRUCTIONS FOR NON-ROMAN CHARACTER SETS" under the USAGE subject, should apply to your usage. I don't know anything more about that subject. Hopefully someone else may have further help for you.

Link to comment
Share on other sites

there is help for using UTF-8 chars in the v2.76g package. the heading is "SPECIAL INSTRUCTIONS FOR NON-ROMAN CHARACTER SETS" under the USAGE subject, should apply to your usage. I don't know anything more about that subject. Hopefully someone else may have further help for you.

 

http://addons.oscommerce.com/info/5578

Link to comment
Share on other sites

you will have change the tep_image() function, or change its usage thoughout the site where product images are displayed.

 

Here is what I found <?php echo tep_image(DIR_WS_IMAGES . $category['categories_image'], $category['categories_name'], HEADING_IMAGE_WIDTH, HEADING_IMAGE_HEIGHT); ?></td>

 

What do I have to change to make the images link from the other site?

Link to comment
Share on other sites

Here is what I found <?php echo tep_image(DIR_WS_IMAGES . $category['categories_image'], $category['categories_name'], HEADING_IMAGE_WIDTH, HEADING_IMAGE_HEIGHT); ?></td>

 

What do I have to change to make the images link from the other site?

convert it to a plain HTML image tag.

<img src="<?php echo $category['categories_image']; ?>" title="<?php echo $category['categories_name']; ?>" width="<?php echo HEADING_IMAGE_WIDTH; ?>" height="<?php echo HEADING_IMAGE_HEIGHT; ?>">

 

But that isn't the product image, that is the category image.

Edited by surfalot
Link to comment
Share on other sites

convert it to a plain HTML image tag.

<img src="<?php echo $category['categories_image']; ?>" title="<?php echo $category['categories_name']; ?>" width="<?php echo HEADING_IMAGE_WIDTH; ?>" height="<?php echo HEADING_IMAGE_HEIGHT; ?>">

 

But that isn't the product image, that is the category image.

 

 

Whoops I guess I only found the category info. Do I need to edit product_info.php? If so, what do I need to remove and what do I need to add? I'm going to play around a bit with your code (changing category to image). I'll let you know if I figure it out. But more and likely I'll be needing your expertise :)

 

Thanks!

Link to comment
Share on other sites

HI, after wading through this post and everything i read is now merging in to one.

 

I have recently completed a resh install and set the attributes as stated in the php doc.

 

I have the csv file uploaded to the 'temp' file and it is visible drop down box in the easypopulate tool.

 

when i click 'Import EP file from Temp Dir' i have the below error message at the top of the screen

 

Filename: EP2008Apr20-0808.csv

 

Warning: Invalid argument supplied for foreach() in /home/fr201jus/public_html/index.html/admin/easypopulate.php on line 1021

 

I am still quiet new to all this but have started to get an uderstanding to what i am doing now - however i can not figure this error out. the refernce line t referes to is :

 

1021 foreach( $theheaders_array as $header ){

1022 $cleanheader = str_replace( '"', '', $header);

 

 

please someone help as i think i am going mad

 

:'(

Link to comment
Share on other sites

HI, after wading through this post and everything i read is now merging in to one.

 

I have recently completed a resh install and set the attributes as stated in the php doc.

 

I have the csv file uploaded to the 'temp' file and it is visible drop down box in the easypopulate tool.

 

when i click 'Import EP file from Temp Dir' i have the below error message at the top of the screen

 

Filename: EP2008Apr20-0808.csv

 

Warning: Invalid argument supplied for foreach() in /home/fr201jus/public_html/index.html/admin/easypopulate.php on line 1021

 

I am still quiet new to all this but have started to get an uderstanding to what i am doing now - however i can not figure this error out. the refernce line t referes to is :

 

1021 foreach( $theheaders_array as $header ){

1022 $cleanheader = str_replace( '"', '', $header);

 

 

please someone help as i think i am going mad

 

:'(

I can only make vague assumptions without any details. first one is the version, assuming you are using the latest that uses CSV file, please see the support section of the docs and post the details asked for in the how to ask for help section, thanks.

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...