Easy Populate 1.2.5.4 support

I have an issue.

When I do a change to experiment with.

I have an item is "#13129"

It was on lets say Category 1 and I move it Category 2.

its shows this:

#13129 Category 1 so I deleted Category 1 to Category 2

Then when I upload it to the db I get duplicates (Links) Catorgies so Its not moving that product to another categories. What am I doing wrong?

schoolboy:

It can be frustrating, but you have to "think like a computer" when you work with easy populate.

Computers are incredibly stupid, but absolutely obedient. They will do EXACTLY what you tell them to do!

In your case, if you do not REMOVE the product from the ORIGINAL category before changing it to the NEW category, both easy populate and zencart will assume that you want to LINK the products.

So, after you get your first easy populate file dump you must work out what the V_STATUS needs to be... If you want to MOVE products, you will first have to DELETE them.

So your first RUN of easy populate back into the store will be a v_status = 9 for all products you want to move.

I usually create a seaprate spreadsheet for these products, because once I have done the v_status = 9 upload, I then take the SAME spreadsheet, change the categories, then make v_status = 1.

Then I run that file through EP again.

The second time, (As there are NO products of that model number in the database) easy populate adds them as NEW products into the different categories.

PS... when using v_status=9, be sure to BACKUP all data... AND backup your images folder... v_status=9 will delete the product and its image...

Sorry I still don't like this mod. its wastes my time typing everything in and will take forever.

All I want is where you can select pruducts from one category to another. Like for an example.

lets say Category 1 has 20 items.

I want to move about 8 items from Category 1 to Category 2 at the same time. Then move 5 products from Category 1 to Category 3 at the same time and so forth.

I am starting to get the hang of this, but I have a problem. When I download the full EP to edit after I did some few changes. Then why my Products prices are different then orignally. Like for an example:

I have a candle that I am selling for $7.95 and it changes to $28.90 it change all my products prices how can fix this so I won't to go through indvidually?

I need this solve ASAP

I hate this mod. it is screwing everything up.

bkeaton:

I hate this mod. it is screwing everything up.

Is there someone standing behind you with a gun saying "Use Easy Populate or I will shoot you." ?

You don't have to use Easy Populate if you don't want to. I have been using it for 5 years (across various versions) and have successfully populated over 100 webshops - many of them several times over.

If I were to add up the number of products uploaded and downloaded over the years, it would probably be close to half a million data items...

I have never had a problem with EP, and as I say in my WIKI tutorial, problems can usually be traced back to the operator, rather than the software! :D

Well when I do a full download and change my prices like it should be then when I upload the full it chages the prices on me. Why?

Is there a way to change the Always Free Shipping option?

I don't see that item in any of the EP downloaded files unless the column titled "shipping" in the Froogle download is it. ( I didn't think it was since it was blank for all of my products and I have them set both ways.)

Can a column for that option be added to any of the EP CSV downloads? If so what would be the name for that column?

(I searched the forum and found this question ASKED many times but never could find an answer.)

You're in luck...

The following field:

product_is_always_free_shipping

is part of the PRODUCTS table, so you can add this field to Easy Populate.

I have done this with other fields in the products table, by following this thread:

http://www.zen-cart.com/forum/showthread.php?t=116061

bkeaton:

Well when I do a full download and change my prices like it should be then when I upload the full it chages the prices on me. Why?

bkeaton,

very sorry to hear you are having so many problems with EP. However, it is very hard for us to help you unless we know just what you are doing, meaning:

1. exactly which version you are using -> use 1.2.5.4 for the fewest problems! (but not issue free!)
2. what program you are editing your spread sheet in
3. if you've modified the data type in the cost field -> specifically, if you make it "currency" so it displays a $ dollar sign, on export this will not import correctly. Leave it as type 'general'
4. what operating system you are on: mac or pc
5. post some of your sample data for us to check -> yes, a portion of your excel spreadsheet!

Also note that this is a free mod with free support. And those of us that do try to help do so on our own time and dime without any compensation and as time permits.

schoolboy:

You're in luck...

The following field:

product_is_always_free_shipping

is part of the PRODUCTS table, so you can add this field to Easy Populate.

I have done this with other fields in the products table, by following this thread:

http://www.zen-cart.com/forum/showthread.php?t=116061

That worked. :clap:Thanks!

LRS:

That worked. :clap:Thanks!
After I added it that way I saw an option in the admin section for EasyPopulate that is called "Custom Products Fields" --- the description from that menu reads:

Custom Products Fields
Enter a comma seperated list of fields to be automatically added to import/export file(ie: products_length, products_width). Please make sure field exists in PRODUCTS table.

Would that menu do the same thing?

Apologies if this has already been asked, but it's late and the thread is 270 pages long!

Is there someway of automating the import? I have scripted the update of products etc on my machine on a daily basis, this then uploads the csv to the server, i then want to kick of an EP import script or webpage - without having to manually visit the admin section and click on import.

Thanks
Greg

LRS:

After I added it that way I saw an option in the admin section for EasyPopulate that is called "Custom Products Fields" --- the description from that menu reads:

Custom Products Fields
Enter a comma seperated list of fields to be automatically added to import/export file(ie: products_length, products_width). Please make sure field exists in PRODUCTS table.

Would that menu do the same thing?

1. You cannot ADD data to a dbase table unless there is a field available to STORE that data. That is why the above comment says: "Please make sure field exists in PRODUCTS table."

2. You can add whatever FIELDS you like to the products table, and then put data into those fields - but the data that sits in these new fields is of no use to you, unless and until you incorporate it into your webshop. In other words, you will use php commands and scripts to bring that data into some useful function or operation within your store.

This will involve either editing existing PHP files so that the data can be made "useful" (perform some function), or writing new php files to do the same.

Personally I think EZ is a great mod. Once you have your basic product tab delimited file created you can add, delete, etc. just by editing that one file and saving it under a different file name. Yes, it DOES take a lot of work to get the first file created (it won't do it by itself...) but once that's done you're really on easy street.

I am having a minor problem I can't figure out. When I UL my entire product listing to Zen it's cutting off part of the product name and the descriptions as well. It doesn't do it with every product, just at random. Example: if I have a candle called "Spice Candle" I may get just "Spice Can" as the product name. In the product description it will cut off part of a word mid-sentence in the descript and the remainder of the descript isn't there at all.

Prices, quantities, model number and everything else comes through fine and nothing is changed during the upload (i.e., prices?) in those areas. I DO save all cells/columns in my spreadsheet as 'general', nothing else, regardless of what they contain.

Any idea(s) what might be causing this? I've checked my titles and descripts in my tab delimited file and everything is there and complete. I've even widened the column holding the descriptions then saved the file (thinking that may help) but it still doesn't give all descripts in my store.

Thanks!

Rod

Schoolboy...

Any advice on how to have EZ port my product names and descriptions properly (completely)? I have done it several times and many names and/or descriptions are partial or don't exist at all. Of course I can manually edit each of over 2000 products but that kind of defeats the purpose of EZ.

When I'm editing my products in my spreadsheet is there any special cell formatting for the text in those cells? Length of product name and/or descripitions? Font type? Characters I should avoid using, etc? Also when I do edit names/descriptions in my sheet should I port again using all existing fields and not just those fields that are missing data to do an update?

I usually select the entire spreadsheet and format the cells as 'general' (in Excel 2007). If I use OpenOffice I format the cells as text. Is there a preference as to which spreadsheet does the better job (Excel or Openoffice) in your opinion?

Thank you. I have all my products in place. It's just the names and descripts that are giving me fits now. Prices, quantities, etc., port fine and are correct.

BTW, I am using EZ 1.2.5.4.

Rod

Easy Populate like things kept SIMPLE... as does php and MySQL. The minute you start using "special characters" in the content (data), you risk corrupting it, because some characters are used in the programming for various purposes.

Back and forward slashes, single quotes (even as apostrophes), % signs, @ signs, and many others, can wreak havoc in the data.

I have seen many people give their images very elaborate names - some using square brackets, periods, slashes, aplostrophes, etc - or a convoluted combination of all of these. And the result is usually a confused mess in Easy Populate.

Even in the product description text, some characters give real problems - such as single quote marks and apostrophes. I try to use HTML character codes for these, so instead of saying "it's the best product on earth", I would use the HTML character code for the apostrophe (it& # 3 9 ;s) - no spaces of course... I put spaces here to prevent your browser rendering it as an apostrophe!

I deal with a lot of this in my WIKI
http://www.zen-cart.com/wiki/index.php/Easy_Populate

Additionally, if your product descriptions are long - or contain formatted line breaks - a program like Excel can TRUNCATE the text. Many people write up their product data in programs like MSWord and then use COPY and PASTE to get the text into the spreadhseet. This will copy MS formatting too - which is an absolute NO-NO.

So when I populate the v_products_description datasets I MAKE SURE not to have formatted line breaks and replace all these with <br /> tags. I remove ALL other formatting - or at least replace it with good, clean html tags.

Read my WIKI for additional advice.

Thanks, Schoolboy. I now have a direct link to your wiki and will be scouring it.

My product supplier supplies the images and they correspond to the model number (i.e., 12000 is the model number and the image is 12000.jpg). So that makes it simple for me. Nothing fancy with image names and I won't be reinventing the wheel there.

I'll check those descriptions that have ported correctly to see what they contain (or don't) then compare them against those that didn't and see what those that are partial contain that is messing up. Understanding how EZ looks at and ports text/characters will help me a lot.

Sounds like editing my products in Word first may be a better approach or maybe better yet, Notepad, where there is no formatting at all. I know when I receive my product descriptions and sizes are described my supplier many times uses, for example, 3/4 as all one character (as would be see in a MS Word document) and not three independent characters, 3 then / then 4. This may also be an issue in the porting.

Thanks again!

Earnest,

Give OpenOffice a try! OO will properly encapsulate exported fields in "" (quotes) where excel will often not. OO will also allow you to have more than 256 characters in a field.

-cj

Oh, and OO is free!

I don't know if this helps, but I went into the phpadmin and changed the varchar up to around 125 and it allowed my entire product name to appear. Seemed that the description length was too short.