Easy Populate 1.2.5.4 support

Yes you can edit, but EP see's your revised model number as a new product and add's it to your catalog as such. You could add the new model number as a new line on your .TXT file and then change the product status on the old product from 1 to 9. This will remove the old product from your catalog. IIRC, it will also remove the associated image file too.

It took me a long time to grasp the concept. EP doesn't know that your intent is, so to speak. All it can do is make changes based on very specific inctructions.

Lets say you have a product model number of 1234 and you want to change it to 123Z. Simply changing the number on the .TXT file won't work. EP see's this as a new item to be added. It has no way of knowing what you* want *to do.

It must be told that you want to delete a product model number and simply changing it on your .TXT doesn't do that.
So you must ;
A.) Tell it to Delete a Product Model Number
B.) Tell it to Insert a new Product Model Number.

This doesn't apply to changes you make in any of the remaining fields for a specific product. EP will make those changes since they will be associated with a known model number based on what is in the V_Products_Model field.

Make sense?

Anytime I try to download any tab-delimited files or save them to the temp dir, I'm always sent back to the login screen. This was brought up several times before, but it was never answered. Any help?

But when I click Download Complete tab-delimited .txt file to edit link, it ask for admin login, I login, click the link, but it still ask for admin login, then when I click the link or other link it always ask for admin login

FYI, I'm using EP Version 1.2.5.4 on Zencart 1.3.9h

Thanks!

Cheepnis:

Anytime I try to download any tab-delimited files or save them to the temp dir, I'm always sent back to the login screen. This was brought up several times before, but it was never answered. Any help?

FYI, I'm using EP Version 1.2.5.4 on Zencart 1.3.9h

Thanks!

Figured it out. It turns out that this (like several other contributions :censored:) won't work if I'm using full-time SSL in the admin. Not sure if it's because I use a shared certificate or not, but the only way this is fixed is if the admin/configure.php file is set to NOT have all four URLs as SSL. sigh

Sorry for the delay in replying. Many thanks for taking the time to reply. Makes perfect sense. Cheers.

Hi!
I can't seem to easily find a definitive answer. I am helping someone with their Zen Cart setup and we found Easy Populate as a good option for uploading the multiple products she has. However, she has already input about 50-60 products manually.
If I use Easy Populate and upload a list of additional products, will it leave the manually input products where they are or do I need to import them into the txt file to turn around and upload the entire inventory using EP?
Thanks!
Vanessa

vanessac:

If I use Easy Populate and upload a list of additional products, will it leave the manually input products where they are or do I need to import them into the txt file to turn around and upload the entire inventory using EP?
Vanessa
As long as all the products have a unique model number it will leave the ones already entered alone. To be safe even the ones already entered should have a unique number. But back up beforehand just to be safe!
Dennis

using zen cart v1.3.9b
using easy populate 1.2.5.4

when i download froogle file, it is saying all items are instock, flag is equal to Y even when they are not. this downloaded file is very useful for me to create my googlebase file which i do as another step in excel. I have all the programming done, and have been using for awhile. only now i realize why the numbers of items keep getting larger, as out of stock items are in inventory. my datafeed at google is now not being uploaded as too many items are not appearing...

does someone know a mod to the code or can make one that corrects this problem so instock varible is either Y or N, according to actual setting? with over 10,000 items in this file, there is no practical way i can find the out of stock items manually.

thanks in advance for your help
Betsy

jonprecise:

Please help, im new user of EP attempting to import products to zen cart, getting error when uploading to database with EP =

No model field in record. This line was not imported
No model field in record. This line was not imported
No model field in record. This line was not imported
No model field in record. This line was not imported
No model field in record. This line was not imported

The only documentation I can find on this is that all v_products_model need to be unique , but this is already the case..

also getting error when attempting to import larger files = Fatal error: Allowed memory size of 33554432 bytes exhausted (tried to allocate 20379 bytes) in ...\admin\easypopulate.php on line 1314

change line 2351 in easypopulate.php in folder admin

if ($col == $filelayout['v_products_model'])

to

if ($col == $filelayout['v_products_image'])

change line 1875 in easypopulate.php in folder admin

if ($v_products_model != "")

to

if ($v_products_image != "")

changer line 1879 in easypopulate.php in folder admin

$result = ep_query("SELECT products_id FROM ".TABLE_PRODUCTS." WHERE (products_model = '" . zen_db_input($v_products_model) . "')");

to

$result = ep_query("SELECT products_id FROM ".TABLE_PRODUCTS." WHERE (products_image = '" . zen_db_input($v_products_image) . "')");

hope can help you :smile:

HI
Could someone point me to a starting point for Easy populate i have a csv from a supplier i want to import , in the past i have given up due to partial / incomplete uploads
I may be a computer engineer but databases make me feel very sick

Thanks in anticipation :D

CastleComputers:

HI
Could someone point me to a starting point for Easy populate i have a csv from a supplier i want to import , in the past i have given up due to partial / incomplete uploads
I may be a computer engineer but databases make me feel very sick

Thanks in anticipation
Try
http://www.zen-cart.com/wiki/index.php/Easy_Populate

Of course lol ty
still feel sick mind :lookaroun

In the EP TEMP folder is a "sample" file...

Be VERY CAREFUL to open it in a plain text editor, and then look at the date formatting.

The trouble with spreadsheets (eg; excel) is that they automatically parse a date (or anything that looks like a date) into a date format (usually a default).

So when you come to do your data load, your date formatting may be different from that needed by EP.

Remember also, that EP (under the CONFIGURATION area of your admin) requires that you set the desired date format.

What I have done in the past is load up a dummy product using the standard add-product screen, giving it a date added as well.

Then, do an EP export from the store, and see how it's formatted the date for my test product.

That's how it must be formatted when you do your EP upload...

Thanks

Ill look at that t`moro i am all based out lol i am getting a few things uploaded troble is as i see it the data supplied by my supplier ie the catergories are all in one so to speak i am havin to separate them out and they are alphabetical i am doing this on a sub domain at mo

cheers :blink:

hi for all,
I have installed Easy Populate and work correctly expect UTF-8 char.
My language is arabic, but when I use Easy Populate all arabic word appeared as unknown char
but in english work very nice.
how can I use Easy Populate in arabic language?
I try to save my file as utf-8 encoding but when importing it the system show this message ( there is no model column

thanks for all

I am using this mod, I am familiar with Easy populate CSV, but on this one I can’t figure out how to add stock by attributes. Is there a column I need to add to make all the sizes I have appear as having “1” in stock? Do I have to add a column in the main CSV file or in the attributes file?

Thanks for any help

bahaa87:

hi for all,
I have installed Easy Populate and work correctly expect UTF-8 char.
My language is arabic, but when I use Easy Populate all arabic word appeared as unknown char
but in english work very nice.
how can I use Easy Populate in arabic language?
I try to save my file as utf-8 encoding but when importing it the system show this message ( there is no model column

thanks for all

Bahaa87,

You have to first check to see if you installed Zencart as UTF. In most cases this is not the default. You can check this through phpMyAdmin. Also look for Dr. Byte's tool for converting to UTF-8.

http://www.zen-cart.com/index.php?main_page=product_contrib_info&products_id=1937

Be sure to properly backup your files before doing any conversion if necessary.

You will next have to use OpenOffice to export your data. OpenOffice will let you export in various encoding where excell seems to do what ever it wants. When using OO be sure to select "edit filter settings" when doing your export (or save as) and ensure you have the encoding you want.

-cj

chadderuski:

You will next have to use OpenOffice to export your data. OpenOffice will let you export in various encoding where excell seems to do what ever it wants. When using OO be sure to select "edit filter settings" when doing your export (or save as) and ensure you have the encoding you want.

-cj

I have found a nifty "bypass" that seems to work well.

Instead of SAVING the spreadsheet as a TXT file (with appropriate character set), I use "copy and paste"...

I create the spreadsheet, making sure that the data is "clean for easy populate", and then I highlight the full range of cells and <CTRL+C>.

Then I <CTRL+V> into Emerald Editor (or equivalent text editor - use a good one) and I save THAT file as a TXT file with appropriate charecter set choice.

Hi,

I installed easy populate 1.2.5.4 , everything works correctly but one thing , my site encoded to utf-8 with hebrew.

export is working great i see everything in he but when i try to import the ep returns this failure :

No model field in record. This line was not imported10113134CF | פרו פ� | | | פרו פ� | חתולי | | | | | 0 | 3.2 | | 2011-07-08 | 50 | פרופל | הכל ל� | אוכל � | יבש | | | | | --none-- | 1 |
SKIPPED! - Model: - No category provided for this product | | | | | | | | | | | | | | | | | | | | | | | | |

anyway to fix this problem?

Thanks!!

Hi Zenners,

I have two languages on my website - Hebrew and English...
I am able to upload the products - EP uploads a category name in Hebrew - that is fine - however, Zen Cart does not allow me to add the category name in English... I edit the category and press update, however, the category name in English does not appear...

Any possible suggestions?

Eran

Hi Eran,

How do you upload in Hebrew , the script returns me problems with categories , any idea why ?
my site encoded to UTF8

Thanks
Shay