Easy Populate 1.2.5.4 support

stlnyc:

I've used EP to get items onto my site. Everything works great.

My issue is that I use the barcode numbers as the item number and when I download our current inventory to make price changes via EP, both excel and open office removes the zero off of the front of barcodes that then mess up my inventory on the reupload by adding duplicated products. How can I fix this?

in excel: highlight the column(s), then "format cell" -> "number" tab -> custom -> now select the kind of number you'd like to show (i.e., use zeroes for the number of numbers in the UPC - mine all use 12, dvds).

I'm sure you can fiddle with excel and open office settings to default to this too, but I'm not sure how. using "text" should do it, but it didn't seem to work when I tested it.

I'm using office 2007, but it works similarly in earlier versions.

I've certainly messed with the format cells option in excel. But that is usually for new spreadsheets. When I open an EP file, it opens to excels default settings with the cells not formatted the way I want, and the beginning zero removed from the barcode.

stlnyc:

I've certainly messed with the format cells option in excel. But that is usually for new spreadsheets. When I open an EP file, it opens to excels default settings with the cells not formatted the way I want, and the beginning zero removed from the barcode.Yes, you are correct. The only way to get this done is to do a Data/Import into a new spreadsheet.

I am getting followin error, when I go in to edit byte size I do not find anything on that line that would enable me to do that:

Creat Froogle:
Fatal error: Allowed memory size of 33554432 bytes exhausted (tried to allocate 71 bytes) in /home6/hillsie0/public_html/includes/classes/db/mysql/query_factory.php on line 189

Creat cvs file:
Fatal error: Allowed memory size of 33554432 bytes exhausted (tried to allocate 24 bytes) in /home6/hillsie0/public_html/includes/classes/db/mysql/query_factory.php on line 393

Any ideas on how to fix this problem?

Easy Populate 1.2.5.5.csv
Zen-Cart 1.3.8a Fresh Install
PHP 5.2
MySQL 5

WilpackPackaging:

I just tried that and still nothing. No additional products were added.

I tried doing the reset then re-uploading the file and then doing the reset again. Still not working.

Okay... what is your default language? If it is not "1" for english, this also seems to cause problems. Are you running a multi-lingual store? If so, I think english still needs to be the default for ep to work correctly. I have not tested this, but this does come up from time to time.

Also. Jump into phpMyAdmin and check the databases manually to see if in fact NO data was imported.

stlnyc If you use OO and start with a fresh sheet (No data) and

Insert
>Insert from Sheet

Choose the .txt file, then a new window opens with Fields,
Column Types - you can select the model column to open as a Column Type => Text
This should not change the format of your barcode number whether EAN, 2of5, or any other barcode format.

WilpackPackaging
Whats the :censored: about,
I am trying to be helpful it may save some one a lot of time, it was the original author (porter) of EP 1.2.5.4 who started this thread. The thing is that these new EP version work slightly different,
Version 1.2.5.4 is tried and tested (with a few know bugs) but it just works, these others seem to have bugs...
Sorry if I seem to have offended you ?

Ok, I still cannot get a EP file to open. In Excel, during the import all of the cells are jumbled but the barcode shows with the leading zero (as I want it to), and in OO the preview looks great but in the actual view the leading zero is gone but the other cells are all lined up.

stlnyc Any chance of a test file example ?

A test file can be found below. Each of the Item numbers listed are the items barcode and each one should start with a "0"

Without the zero, EP uploads the items as a new product, therefor duplicating the items currently in the database.

http://www.hillsideliquors.com/Full-EP2009.csv

Hi, is it possible to use absolute urls to images with easy populate? Thanks.

stlnyc By the looks of your test file its not OO or Excel which is your problem it is EP 1.2.5.5 csv as it looks as if it is stripping the '0' from the model field when it downloads the file from Zencart, if you open the file in just a text editor there are no leading '0', so it is not in the file to start with?

(Just a thought is the test file edited in OO or excel before saving or in a text editor, as if in OO or excel you will loose the '0' unless you open in the way i suggested earlier, if in a text editor (wordpad, gedit) it should remain original ?)

That test file was download through EP admin in ZC admin. I did edit the file a little, which maybe why it lost the zero. Here is my full file direct from my EP Temp Directory. And opening it in notepad shows the leading zeros.

http://www.hillsideliquors.com/tempEP/Full-EP2009Jun13-1705.csv

stlnyc
As opened in OO as suggested, no problems with fields merging or loosing '0's.

v_products_model v_products_image
0783 DSC02309.JPG
9428 DSC01401.JPG
01007 DSC02337.JPG
235689 beauvigne_cab.JPG
08981972337 DSC02347.JPG
08682830001 DSC01458.JPG
01248599002 DSC02412.JPG
08088749396 DSC02479.JPG
08069692122 DSC02349.JPG
08069612122 corks.gif
08069691534 DSC02349.JPG
08069609642 bvnapa_cab.JPG

Which fields are getting > during the import all of the cells are jumbled ?

Ok, sweet, finally got it working, although the pricing isn't in the file.

I'm running Easy Populate 1.2.5.5.csv 2

Every time I go and upload my new .csv file, none of the new products are added, but it says the old ones are updated. I am doing nothing different and everything is in the correct columns. My statuses are --none-- 1 0 0 0 0 0

, the same as they always were, but nothing new is being added. I've double checked my .csv and everything is correct, category names, etc.

Please help me figure out why it's doing this. If you need any other info just let me know, I don't really know what else to say.

Thank you.

Never mind that post, I'm re-doing everything and it's working now. I guess in the future I'll just upload it after every few products instead of adding a huge batch, for some reason that's not working..

Kenichi:

Never mind that post, I'm re-doing everything and it's working now. I guess in the future I'll just upload it after every few products instead of adding a huge batch, for some reason that's not working..

I was having the same problems and after fully reading the wiki for EP, you can remove columns from the complete EP file. As long as the item number is the same, only include the item number column and any of the other columns you are updating. Remove all the other columns that stay the same and you will have no problem no matter how many lines are in your spreadsheet.

I've only one problem with latest version of easy populate, after importing the csv file, i've the categories names in only one language, instead production description and title are rights in both languages i'm using. :huh:

example:

language 1 CATEGORY
language 2 CATEGORIA

after importing file

language 1 CATEGORY
language 2 (empty)

but product are rights in boths languages.
How i fix this? :shocking:
Thanks!

stlnyc:

I was having the same problems and after fully reading the wiki for EP, you can remove columns from the complete EP file. As long as the item number is the same, only include the item number column and any of the other columns you are updating. Remove all the other columns that stay the same and you will have no problem no matter how many lines are in your spreadsheet.

Thanks! That works like a charm =)

I am currently running the cart in "display mode" for 2,000 products, however, I need to make the cart active for 250 products within a specific category.
Is it possible to control the cart's "display" mode via EP? Perhaps by adding an attribute?
Please advise - thank you!