Easy Populate 1.2.5.4 support

Scrat:

Eddie Irvine - Post what your problems are if its to do with EP and let everyone try to help.

Thanks,

I posted up before regardig the matter. I am using easy populate to upload to the catalogue but once the items are uploaded I cannot view them in order to adjust, delete or amend.

I am also unsure as how to link image to the catagories in the store. For example on this page

http://www.jiperformance.com/store/index.php?main_page=index&cPath=21&zenid=288c7866fce50c79917a3ad95e586f0c

you can see that some of the product catagories have images whilst some do not. It wasnt myself who did the images which you can see so im unsure how this is done.

Also unrelated but I'm not sure how you put key words and meta data into the site.

Sorry fdor all the questions but as you can guess im very new to this

Eddie Irvine - OK the images for your categories are in

Categories / Products - Top > edit your categories

These are not imported via EP, so all the sub cats. will also have to be edited manually as well.

As for products not showing up to edit, thats got me :blink:
OK Fault finding again
When you import them do you get a error or does EP state the product is up dated, new...
We need to know what it is giving as a result of the import, are you giving each product a unique model ref/number as they have to unique
Going on from that if EP says inserted/updated and they still donot appear use myphpadmin to see if they appear in the dbase and report back.
Further usually by default Zencart disables out of stock products so if your stock is set to zero the product will not appear, you can change this in

Conf.>Stock
Lets us know how you get on...

Personnel note:-
One last thing I would do is turn off your product dated added as you are now showing goods that are a year old, I know they may not change but its not really relievent if they are this old
For example:

This product was added to our catalog on Sunday 26 November, 2006.

Wow - I just downloaded the "lite/free" version. WOW - exactly what I was thinking... and to think I was prepared to code it all myself!!!! Awesome.

Thanks guys.

It even create Subcatagories that did not exist before!!! Talk about sweet.

now all I have to do is automate the whole process!!! Take my new images, run "convert" against them, put them in the images directory, create the tab file for easy populate... and throw it all into a cron!!! hahaha

alright - call me lazy

:clap:

OK I know I should do a search but I don't feel like poking through this 121 page thread. Was wondering what Easy Populate does when it finds a duplicate record - overwrite, skip, delete, add new? If it does check for duplicates, it does so on the basis of what? Description? Model number?
Thanks!

Hey - you know what would be cool??

Make this into an HTML page (or PHP most likely) that displays everything in a table like fashion... to allow you to make updates right on the page!!

and complete with little thumbs of the products, too...

so you navigate around through your stuff in like a mini webpage or something - but one YOU can make changes to...

Does that make sense?

kbalona:

OK I know I should do a search but I don't feel like poking through this 121 page thread. Was wondering what Easy Populate does when it finds a duplicate record - overwrite, skip, delete, add new? If it does check for duplicates, it does so on the basis of what? Description? Model number?
Thanks!

Hmmm - good point...

I'm playing with it right now - I'll let you know...

(SO far, it UPDATES descriptions)

Oh - and not on v_products_name_1

Because I used the same name for all of them!

i bet it's Model: v_products_model

Alright - TEST DONE

I put a duplicate in my TXT file... but change Description, Price, Qnty...

IT OVERWROTE the previous one...

So my assumption is that its based on the model number you assign (which makes perfect sense) and it takes the LAST occurance of your model as the record...

HOWEVER - what if you change the category or subcategory??

Well - this is good if you want cross posting of your product in several categories because it will create copies... but this might be bad because ZenCart already has this sort of feature, which allows you to have one product shown in multiple places... but that when you edit it, it will change EVERYWHERE it is shown.....

With this one, it seems it might make copies everywhere... be sure to SORT in Excel to detect duplications...

Well - I'm not entirely sure about that last part and the duplications...

I tried deleting my "new" product (the dup) and it used the "real" line...

However, it did NOT remove the multiple entries in othe categories...

BUT - big but - it DID change the other information like desc, price, qty EVERYWERE it occurred...

SO... carefully edit your TAB delimited file, eh!!! :)

kbalona:

OK I know I should do a search but I don't feel like poking through this 121 page thread. Was wondering what Easy Populate does when it finds a duplicate record - overwrite, skip, delete, add new? If it does check for duplicates, it does so on the basis of what? Description? Model number?
Thanks!

Hey - nice site dude!

I need me a Shindaiwa or Stihl ~6hp chainsaw... I have a Stihl Farmboss - but its too slow for ripping lumber on my chainsaw mill (Logosol)

Scrat:

Eddie Irvine - OK the images for your categories are in

Categories / Products - Top > edit your categories

These are not imported via EP, so all the sub cats. will also have to be edited manually as well.

As for products not showing up to edit, thats got me :blink:
OK Fault finding again
When you import them do you get a error or does EP state the product is up dated, new...
We need to know what it is giving as a result of the import, are you giving each product a unique model ref/number as they have to unique
Going on from that if EP says inserted/updated and they still donot appear use myphpadmin to see if they appear in the dbase and report back.
Further usually by default Zencart disables out of stock products so if your stock is set to zero the product will not appear, you can change this in

Conf.>Stock
Lets us know how you get on...

Personnel note:-
One last thing I would do is turn off your product dated added as you are now showing goods that are a year old, I know they may not change but its not really relievent if they are this old
For example:

Thanks very much,

I'll try these out tomorrow. All products definatly have a unique item number on them.

I cant remeber what comes up when the new products are loaded. it certainly wasnt any kind of error message. Problem I have is if i upload new products to try this I cannot then delete them

Eddie Irvine:

Thanks very much,

I'll try these out tomorrow. All products definatly have a unique item number on them.

I cant remeber what comes up when the new products are loaded. it certainly wasnt any kind of error message. Problem I have is if i upload new products to try this I cannot then delete them

I'm thinking the delete will have to be done the "old fashion" way!

When i did this - I went to clean up the mess I had made. I used the Catalog and Categories/Products page under ADMIN... when I chose the X, I was presented with check boxes where it existed - shown as:

Product Master Category:

With check boxes next to each...

So it does seem to know that they are cross Linked...

COOL!

And from the LESSON, i will always sort my file on the "v_products_model" column

I am wondering how I can delete discontinued products. I get a csv file from my distributor that has nearly 8000 products. I try to upload this once a week. During that time, there are several products that have been discontinued. The products that are discontinued obviously are not on the csv file, but are still in my database.

Is there a way to have EP automatically delete them from my database (other than manually - as this would take hours to find/cross reference/delete)? Or can I wipe my products out, and redo a fresh product install every time?

Any help is appreciated.

tgotch:

I am wondering how I can delete discontinued products. I get a csv file from my distributor that has nearly 8000 products. I try to upload this once a week. During that time, there are several products that have been discontinued. The products that are discontinued obviously are not on the csv file, but are still in my database.

Is there a way to have EP automatically delete them from my database (other than manually - as this would take hours to find/cross reference/delete)? Or can I wipe my products out, and redo a fresh product install every time?

Any help is appreciated.

There are programs that will let you compare text files (the old cvs to the new one) but if I were doing it, I would keep a copy of the old upload, change the status column from a 1 (Active) to a 9 (which will delete the product) and then upload it. Then do the new list. Be sure to backup your database first in case it does no go according to plan.

Dennis, Thanks for your reply.

Do you know what programs may compare csv files?

I am not sure what you are advising will work for me. As I mentioned, I have over 8000 products. In one weeks time, there may be 10-20 NEW products, and 5-10 discontinued between uploads to my db. So unless I am misunderstanding you, I would have to manually check everyone of the 8000 line items to see if a product has been dropped or added.

Phil020782:

Does that mean if I edit that file and change /t to | that will be the delimiter?

Well I finally got round to trying it, I changed the seperator from /t to | and it seems to work perfectly. Hopefully it won't cause problems further down the road but just wanted to let everyone know it does work.

tgotch:

Dennis, Thanks for your reply.

Do you know what programs may compare csv files?

I am not sure what you are advising will work for me. As I mentioned, I have over 8000 products. In one weeks time, there may be 10-20 NEW products, and 5-10 discontinued between uploads to my db. So unless I am misunderstanding you, I would have to manually check everyone of the 8000 line items to see if a product has been dropped or added.

I am not sure on this. But you might try using winmerge. Don't know how if it would examine the contents of the CVS file.

The other option is to turn the product off by changing the status setting from "1" to "0" instead of "9" and deleting it. Then upload the new files with the status column of the new file set to "1". Similar to awhfy99's process, but without deleting the items from the database. over time this may make you database rather large and you will to maintain that aspect.

I can't see a answer to this question but there are over 120 pages..

Is there a version of Easy Populate that will work with;

Zen Cart v1.3.8
New Release with PayPal Website Payments Pro support

Darkwander - Yes - Version 1.2.5.4 and all the other versions at present but this is the best stable version so far that is free!

See the original posters signature for the download link