Easy Populate 1.2.5.4 support

[Scrat]

mediathing -

Can I use a url under v_products_image?

No you cannot

...Also, when adding new products, do I have to add them onto the end of the complete file or can I just use a blank template with the header I need and upload, say 30 products?...If so, what should I call the file?

As long as you have the headers on the first row you can add new products as many as you want, but up 300 is the most with out problems. Make sure you have unique model id's

[mediathing]

Thanks for the answers, helps a alot. A couple more questions:

Does it make a difference what the file is called, I am using open office and when I save it gives me an option regarding what type to save as?

Does the file have to have all the headers or just the ones that I want (name, image, qty, desc, cat).

When I upload a file, this will only make additions to the product DB and will not remove anything. For example my store currently has around 400 products. If I create a file with 50 products adn upload it, it will just add these and not assume that this is now the "full list".

Thanks for your help.

[CJ Internet Sales]

I am getting a Line Delimiter not found! error when I try to import a small file containing new items.

I can go into easypopulate_overides.php and change $ep_overrides['linebreak']" to true and the first line will import correctly but the rest of the file will not.

I am on a Linux server and using Excel to create the spreadsheet, which I save as a txt file.

Please help.

[jaskarn]

Hi,
I have a couple of questions on this mod.

1. Is it possible for Zencart for automatically import a file into its database at a fixed time, instead of me manually loging in and uploading it. My supplier can automatically connect to my store via FTP and drop a tab-delimited file in a folder every night, so Zencart only has to detect the file and put it into its database.

2. Is it possible to have more than one upload file? I have about 5 suppliers who can supply me with a tab-delimited file every night or so, and I want those files to be imported at different times at night, but I want the database to be updated with the products. I’m not sure and may be wrong but is it true that if i upload with a file full of products and then upload with a different file with different products- Will my whole catalog be overwritten or will the new records from the other file update my database.

Thank you in advance, sorry for the length of the questions.

[buyersparadise]

Thanks for the advice. Problem is I tried that and it wont work how come? Once it finds the .000 then it ask what i want to replace it with and I type .jpg and it keeps telling me excel cannot find a match. next to the replace it has a preview and format area. DO I change any thing on there? what should the within, search, and look in be on and should the match case and match entire cell content be checked? Thanks.

[buyersparadise]

Well now I cant get the concatenation to work but when I did try that once before it didnt work could you email me how to do this? customerservice AT buyersparadiseonline DOT com just send me an example of the formula and how you did it thanks!

[Scrat]

mediathing - 1.Has to be a .txt file in a TAB delimited format but can be named what ever you like (xxxx.txt, newfile.txt, lastupload-08-03-2008.txt )etc
2. It must have the model heading but as from the readme file you can exclude unwanted columns but not tried it personnally.
3. It will upload new products, and update others if in the file if the status column is marked 1 if that column is marked 9 it will delete that product. Other than that just upload new products and it will not effect the rest of the DB.

CJ Internet Sales - Try a test, download a complete file from the DB, remove all the rows except the first row (Headers) and two products with out changing anything else and then up load that file back into Zen, this should give you a result of Two products updated. If this works it means your current upload file is incorrect in foramt some way so you must check that. Check you have 'EOREOR' on the end of each row.

jaskarn - Yes this would be possible, if you know php, if you don't have a look at cron jobs this may be able to do it for you. I don't use cron myself someone else maybe able to advise you better.

buyersparadise -
This will join column A1(sheet1) +'.jpg' and put it on sheet2

=CONCATENATE(Sheet1!A1,".jpg")

[hankthtank]

I am still having one problem with my inventory that has been uploaded using EP. All the items upload fine now, however, my categories are messed up on the store. For example, when I uploaded Wyse Terminals, a new Terminals category, with a lone subcategory, Wyse Terminals was created. I have checked my upload files, and they seem to be setup correctly. Another weird thing, is the double categories do not show up in admin, so I have no idea how to even manually correct this.

If you want to see what I'm talking about, my website is www.centrixcs.com.

Any ideas? Thanks.

[hankthtank]

Sorry to be a pain, but I'm running into one other problem.

The width of the header_bg.jpg image has somehow gotten changed, and sticks out about 1/8th of inch past the right board. First, how the heck did I manage to change this? I have edited the width in both header.php and stylesheet.css, with no avail.

What I really want to do is just remove this image completely, and simply use my logo in header.php. Any advice would be greatly appreciated! - Hank

[misty]

Sorry to be a pain, but I'm running into one other problem.

The width of the header_bg.jpg image has somehow gotten changed, and sticks out about 1/8th of inch past the right board. First, how the heck did I manage to change this? I have edited the width in both header.php and stylesheet.css, with no avail.

What I really want to do is just remove this image completely, and simply use my logo in header.php. Any advice would be greatly appreciated! - Hank

This post does not relate to this thread which is for Easy Populate..
Suggest posting in css/stylesheet forum