Easy Populate 1.2.5.4 support

http://i285.photobucket.com/albums/l...ee/zencart.jpg

This is what it looks like by the way, in zen admin

I just don't know what to do now.

Hi somewhere in this huge thread, someone mentioned a problem with uploaded products not producing a product page. I can't find that particular post but is here.

What happens when I use easy populate to upload new products, the upload works to a point where you can view the new products in the product listing, but when you click the product to open the product page, I get "page not found".

Does anyone have any idea what will cause this??

Help would be appreciated..

I also still have this problem regarding the attributes .txt file as mentioned in post above & below!

Quote:

---

I am also having an issue importing the attributes.txt file into excel. too many columns. does anyone have a resolution for this problem.

---

P.S using zen version 1.3.8a

TIA

I have the purchased version of Easy Populate. I want to know is it possible to define the category meta tages with EP. These are the fields i used for products:

v_metatags_title_en, v_metatags_keywords_en, v_metatags_description_en

Will it work for categories?

Quote:

---

Originally Posted by heavenlynights

I am also having an issue importing the attributes.txt file into excel. too many columns. does anyone have a resolution for this problem.
TIA

---

It seems there is no real answer, at least not one I could find here.

Another way to add attributes is to add them direct to your database via phpmyadmin. I have tried this and it works fine.

My store is live but not 'released' as such, ie, it's brand new I haven't advertised it and it has no traffic so it's ok to mess around with things. What I did is this.

Go to your database via phpmyadmin and click on the products_attribute table then the export tab. Select csv for MS Excel and select put field names in first row, select zipped then click go. Save to your computer when asked.

I only had a few products added to my DB so it was easy to see what was required when editing the spreadsheet, when you have finished editing delete the row with field names and save as a .csv

Putting it back is basically the export procedure in reverse. Go to the products_attributes table and click the import tab then browse to your saved .csv file, then click the csv option in the format of imported file box and be sure to change the field terminated by ; to , (semi colon to comma) there are other options for 'replace table data with file' this will replace all the data within the table, and ignore duplicate rows. I usually select replace table data.

This has worked fine for me, it worked fine with oscommerce too. Two rules.

1) BACK UP FIRST
2) Never forget rule 1.

Quote:

---

Originally Posted by Impact-Flies

It seems there is no real answer, at least not one I could find here.

Another way to add attributes is to add them direct to your database via phpmyadmin. I have tried this and it works fine.

My store is live but not 'released' as such, ie, it's brand new I haven't advertised it and it has no traffic so it's ok to mess around with things. What I did is this.

Go to your database via phpmyadmin and click on the products_attribute table then the export tab. Select csv for MS Excel and select put field names in first row, select zipped then click go. Save to your computer when asked.

I only had a few products added to my DB so it was easy to see what was required when editing the spreadsheet, when you have finished editing delete the row with field names and save as a .csv

Putting it back is basically the export procedure in reverse. Go to the products_attributes table and click the import tab then browse to your saved .csv file, then click the csv option in the format of imported file box and be sure to change the field terminated by ; to , (semi colon to comma) there are other options for 'replace table data with file' this will replace all the data within the table, and ignore duplicate rows. I usually select replace table data.

This has worked fine for me, it worked fine with oscommerce too. Two rules.

1) BACK UP FIRST
2) Never forget rule 1.

---

Thanks Impact. Much appreciate your assistance. This will save me a lot of time..

Do you use easy populate for adding products? if so do you have the same problem regarding no product page created?

TIA

Quote:

---

Originally Posted by heavenlynights

Thanks Impact. Much appreciate your assistance. This will save me a lot of time..

Do you use easy populate for adding products? if so do you have the same problem regarding no product page created?

TIA

---

I added just 6 products with EP to start with to a sub category and they all uploaded fine to the correct place and all display ok, providing everything is added to the correct columns I wouldn't expect to have a problem (?) adding a lot at one time.

One thing I should of mentioned in my previous post about attributes.

When you download the DB table and open it with Excel or Calc the format is a little different to what you get from the EP attribute download.

In column A is attributes ID, this (it seems) has to be a different number for every line and the number has no bearing on the product ID in column B. In column B you have your product ID number and that column can have repeats of the ID number due to the same product have several attributes, so the same product with several attributes would look a little like this in column A & B

A##############################____B
products_attributes_id products_id
1##############################____1
2##############################____1
3##############################____1
4##############################____1

So product #1 has four separate attributes.

If your store is live it would be prudent to set up a test category with a handful of products and add attributes to these before trying it on live products. BACK UP the table first so if anything goes wrong you can restore the back up and put everything back to how it was.

Quote:

---

I am also having an issue importing the attributes.txt file into excel. too many columns. does anyone have a resolution for this problem.

---

Use Open Office, instead of excel.. works fine.
http://www.openoffice.org/

I do use Calc from Open Office. The file seemed to edit ok but the attributes never got added when I restored the file. Perhaps I did something wrong but it seems a lot of people have trouble getting the attributes side of EP to actually work.

Quote:

---

Originally Posted by Impact-Flies

I added just 6 products with EP to start with to a sub category and they all uploaded fine to the correct place and all display ok, providing everything is added to the correct columns I wouldn't expect to have a problem (?) adding a lot at one time.

One thing I should of mentioned in my previous post about attributes.

When you download the DB table and open it with Excel or Calc the format is a little different to what you get from the EP attribute download.

In column A is attributes ID, this (it seems) has to be a different number for every line and the number has no bearing on the product ID in column B. In column B you have your product ID number and that column can have repeats of the ID number due to the same product have several attributes, so the same product with several attributes would look a little like this in column A & B

A##############################____B
products_attributes_id products_id
1##############################____1
2##############################____1
3##############################____1
4##############################____1

So product #1 has four separate attributes.

If your store is live it would be prudent to set up a test category with a handful of products and add attributes to these before trying it on live products. BACK UP the table first so if anything goes wrong you can restore the back up and put everything back to how it was.

---

Thanks impact for that, I only uploaded 3 new products to test and this is where i came across the glitch. Haven't tried since, no point till I get a fix for it.

Quote:

---

misty - Use Open Office, instead of excel.. works fine.
http://www.openoffice.org/

---

Thanks misty - visited site, says that it doesn't support all platforms as yet. do you know if windows Vista is one of those non supported platforms? Doesn't mention the platforms not supported.

TIA

Quote:

---

Originally Posted by marksu

Anyone solved the isue with attributes.txt file having too many columns to import to excel?

marksu

---

view thread:
http://www.zen-cart.com/forum/showpo...postcount=1509