Easy Populate 1.2.5.4 support

heavenlynights:

Hi There
I have just downloaded the complete Full-tab delimited.txt file and it appears not to have extracted all the information from the database. The v_products_url_1 field is empty. Is this field meant to be empty or should it show the url for each of the products.

I do recall way back, when I first downloaded the mod that when I did an upload of only a few new products, the system didn't generate a product url. All other information was created as I could see the products in the admin but couldn't actually navigate to the products on the storefront, as there was no product url allocated for each of the new products.

Does anyone have any idea as to what may have went wrong or advise me as to how ep is suppose to work so that I have a better understanding.

TIA

Do you mean that you want an external link to the manufacturer of each of your products??

A URL is not required for you to find a product within your own store. On your EP Full file do you have unique model numbers for each product?

products_url is a field in ZC that allows you to have a link to another page, like the manufacturers web site. It is not your local url.
So unless you added that field, blank is correct.

I was wondering if anyone had a fix for the bug with the no Manufacture, i tried setting it to --none-- and also 'none' but it just made new manufactures by those names, what i need easy populate to do is realise that there is nothing in the field and reset the field to "empty".

elkbow:

Do you mean that you want an external link to the manufacturer of each of your products??

A URL is not required for you to find a product within your own store. On your EP Full file do you have unique model numbers for each product?

Thanks for responding elkbow

No not external url ie: manufacturer. So the txt file isn't meant to show product url?

All my products are general products and have their own unique model number.

I will try another upload of a couple of new products to see what happens

Thanks

keylesslocks:

Tim,

thanks for your quick reply!

the only thing we changed was the weights so they will work with shipworks.

also, we have 3000 products, so I don't want any issues... so do you think we are good to go?

I would back up your db before uploading the text file. If it does not look right, just restore that backup. If you use the status 9 to delete the products, you will also delete the images for those products.

heavenlynights:

Thanks for responding elkbow

No not external url ie: manufacturer. So the txt file isn't meant to show product url?

All my products are general products and have their own unique model number.

I will try another upload of a couple of new products to see what happens

Thanks

Well I did another upload and the outcome is as below.

1. I opened a recently downloaded complete tab delimited file into MO excel which automatically opened up the text import wizard. I changed the "file origin" to Unicode (UTF-8) (not sure what the file origin should be). Then I just clicked next, then next again then finish. I left the the "column data format" as general.
2. I then keyed in 1 new product being very careful as to category names and so on
3. I then deleted all other products from the file to leave only the new product that I was importing.
4. I then saved the file as a new txt file.
5. I went into easy populate and proceeded to upload the newly named file containing only one product.
6. Upload results are as shown in below screenshot

Product shows up in admin however, if I try to edit it by clicking on admin>categories> product edit symbol or clicking on the product name, it takes me to google.com.au (very weird) same thing applies, if I click on all other symbols except for attribute and image handler symbols.

In regard to the actual store front, I can see the product in the product listing http://www.heavenlynightslingerie.com.au/index.php?main_page=advanced_search_result&search_in_description=1&keyword=7786 but when you click on the product it takes you to the page not found where the sitemap is showing.

So! not sure what to make of all of this, especially the google thing :wacko:

One other thing, in the admin >tools>easy populate page there appears to be indicate that there are 5 partially deleted products somewhere in the database.. i click on the link to delete them, but it fails every single time.

Could this have anything to do with my problems.

Any help would be much appreciated

TIA

ok, so I chose my new file, inserted into DB and then it says:

Upload Results
File uploaded.
Temporary filename: /tmp/phpokpXbQ
User filename: spread sheet update.xls
Size: 2006528

Upload Complete

But when I check the products, none of the new wieghts that are in the new EP file are included for the products, is there another step I need to take?

I was reading the wiki and realized, it should be a .txt, so I uploaded a txt and updated all our products it was looking great the results, but all my weights remain the same, this is the only thing I need the new info to really update, but it isn't?

ok, some things are updated and some are not, I am really confused....

in the upload results it says:

UPDATED! - Model: Washer Timer Knob 3364290 | 3364290.jp | Whirlpool | Whirlpool | | | | | 14.95 | 0.25 | | 2/19/2008 | 999 | Whirlpool | Washing Ma | Whirlpool | Whirlpool | | | | | Taxable Go | 1 |

UPDATED! - Model: Washer Timer Knob 3364290 | 3364290.jp | Roper Wash | Roper Wash | | | | | 14.95 | 0.25 | | 2/19/2008 | 1000 | Roper | Washing Ma | Roper Wash | Roper Wash | | | | | Taxable Go | 1 |

UPDATED! - Model: Washer Timer Knob 3364290 | 3364290.jp | KitchenAid | KitchenAid | | | | | 14.95 | 0.25 | | 2/19/2008 | 1000 | KitchenAid | Washing Ma | Kitchen Ai | KitchenAid | | | | | Taxable Go | 1 |

UPDATED! - Model: Washer Timer Knob 3364290 | 3364290.jp | Kenmore Wa | Kenmore Wa | | | | | 14.95 | 0.25 | | 2/19/2008 | 999 | Kenmore | Washing Ma | Kenmore Wa | Kenmore Wa | | | | | Taxable Go | 1 |

but when I check the 3364290 on the site, only 1, the kenmore, is coming up with the weight .25 the other 2 are coming up 1 pound... but the updated results says they all should be .25

something wierd is goin on.... if products have linked items, they right and but the others are not, see pic

here is another example... also, another VERY funny thing is I NEVER link products, so why does it show all of these products with links, something is definitely not right,....

ok, EP definitely made a linked product for each product, this item is only just 1, now it has 1 and a linked product:

diving deeper I thought it was duplicating everything, but now I see only some and don't know why, see this

keylesslocks:

ok, some things are updated and some are not, I am really confused....

in the upload results it says:

UPDATED! - Model: Washer Timer Knob 3364290 | 3364290.jp | Whirlpool | Whirlpool | | | | | 14.95 | 0.25 | | 2/19/2008 | 999 | Whirlpool | Washing Ma | Whirlpool | Whirlpool | | | | | Taxable Go | 1 |

UPDATED! - Model: Washer Timer Knob 3364290 | 3364290.jp | Roper Wash | Roper Wash | | | | | 14.95 | 0.25 | | 2/19/2008 | 1000 | Roper | Washing Ma | Roper Wash | Roper Wash | | | | | Taxable Go | 1 |

UPDATED! - Model: Washer Timer Knob 3364290 | 3364290.jp | KitchenAid | KitchenAid | | | | | 14.95 | 0.25 | | 2/19/2008 | 1000 | KitchenAid | Washing Ma | Kitchen Ai | KitchenAid | | | | | Taxable Go | 1 |

UPDATED! - Model: Washer Timer Knob 3364290 | 3364290.jp | Kenmore Wa | Kenmore Wa | | | | | 14.95 | 0.25 | | 2/19/2008 | 999 | Kenmore | Washing Ma | Kenmore Wa | Kenmore Wa | | | | | Taxable Go | 1 |

but when I check the 3364290 on the site, only 1, the kenmore, is coming up with the weight .25 the other 2 are coming up 1 pound... but the updated results says they all should be .25

The first thing I see is the Unique Model Number is the same for all of the items shown above. try changing the 3364290 to
3364290A, 3364290B, 3364290C. Since you have different named sub categories and the same model number is the linked problem.

I was reading these posts because I am trying to figure out Easy Populate as well, but when I went to your site http://lockdownsurveillance.com/ I saw something else I would like to know how to do. When you rollover your mouse on an image it brings up a larger image. How is it done?

Newbie here.

When you rollover your mouse on an image it brings up a larger image. How is it done?
Image Handler 2 available in Free Software Addons.

elkbow:

The first thing I see is the Unique Model Number is the same for all of the items shown above. try changing the 3364290 to
3364290A, 3364290B, 3364290C. Since you have different named sub categories and the same model number is the linked problem.

hmmm....

2 questions:

1. a lot of my UMN are maxed out the characters from ZC admin when I added them, if I go over the amount limited will it be ok?

2. I have 3000 items... how can I find all the ones that are duplicated? shouldn't it be replacing by some kind of unique number other than the model number?

Sorry for bumping, but I really need some help with this problem!!

heavenlynights:

Well I did another upload and the outcome is as below.

2. I opened a recently downloaded complete tab delimited file into MO excel which automatically opened up the text import wizard. I changed the "file origin" to Unicode (UTF-8) (not sure what the file origin should be). Then I just clicked next, then next again then finish. I left the the "column data format" as general.

3. I then keyed in 1 new product being very careful as to category names and so on

4. I then deleted all other products from the file to leave only the new product that I was importing.

5. I then saved the file as a new txt file.

6. I went into easy populate and proceeded to upload the newly named file containing only one product.

7. Upload results are as shown in below screenshot

Product shows up in admin however, if I try to edit it by clicking on admin>categories> product edit symbol or clicking on the product name, it takes me to google.com.au (very weird) same thing applies, if I click on all other symbols except for attribute and image handler symbols.

In regard to the actual store front, I can see the product in the product listing http://www.heavenlynightslingerie.com.au/index.php?main_page=advanced_search_result&search_in_description=1&keyword=7786 but when you click on the product it takes you to the page not found where the sitemap is showing.

So! not sure what to make of all of this, especially the google thing :wacko:

One other thing, in the admin >tools>easy populate page there appears to be indicate that there are 5 partially deleted products somewhere in the database.. i click on the link to delete them, but it fails every single time.

Could this have anything to do with my problems.

Any help would be much appreciated

TIA

Thanks

can I just increase the max characters for this field:

Products Model

so then when I import the EP file again,. I don't have to worry about the field being too big

Hi

well I have a problem OO Calc won't let me import the file I have completely, it will cut off some columns. Even tried uniCSVed and CSVed, no luck either.

I got to add 100 products but all have different attributes, e.g. a bra that has different sizes.

My client does not want to go through editing tons of lines over and over again. What would be the fastest way to add attributes to a product relatively quickly?

Does EP advanced have a GUI? That would be a feature.. you just select the attributes that are already stored into zencart and you can mass-add it to any product. That system would be fool-proof ;)

Thanks for your help and suggestions :)