Multiple, critical problems - EZ POP

[double-happiness]

I have Zen Cart 1.3.9h installed with Easy Populate 1.2.5.4

I am just having nothing but problems with it.

When I did finally manage to get an upload of my inventory (3700 products) it came out quite badly wrong with almost every product linked to two categories, the correct one and another incorrect one. The way the upload has come out it seems to have incorrectly assigned the first few products to category A, the next few to category B, the next to category C, and so on. I am pretty sure of this as I always keep my uploads in alphabetical order and that is the way they have come out, alongside the correct category assignment. I am pretty experienced with spreadsheets and csv uploads so I don't think that is the problem, the file was in tab-delimited text, formatted correctly I think, with EOREOR at the end of each row.

The 'server response' (if I can call it that) to the upload was pretty horrible, with a dialogue box along the lines of 'You have decided to open blahblahblah.php what do you want to do with this file - open - save - cancel' this would then open a blank page in a new tab every time I clicked 'open', this would only stop when I clicked 'cancel'. I never got any kind of confirmation of an upload success.

So anyway I decided the best thing to do was to manually edit all the products to their right categories. This isn't such a problem in itself as I have worked out how to use the Multiple Categories Link Manager to do this in bulk. Problem is, Zen cart is just throwing up every kind of error, timing out, failing to connect to the server, it is just completely unusable. I sometimes get php error messages though not so often, it is usually just impossible to access admin at all. I do have some logs (I've altered the admin area name):

[18-May-2011 13:30:07] PHP Warning: explode() [<a href='function.explode'>function.explode</a>]: Empty delimiter in /home/a2679801/public_html/catalog/mysecretadminarea/includes/functions/extra_functions/easypopulate_functions.php on line 241
[18-May-2011 13:30:07] PHP Warning: explode() [<a href='function.explode'>function.explode</a>]: Empty delimiter in /home/a2679801/public_html/catalog/mysecretadminarea/includes/functions/extra_functions/easypopulate_functions.php on line 241
[18-May-2011 13:30:07] PHP Warning: explode() [<a href='function.explode'>function.explode</a>]: Empty delimiter in /home/a2679801/public_html/catalog/mysecretadminarea/includes/functions/extra_functions/easypopulate_functions.php on line 241
[18-May-2011 13:30:07] PHP Warning: explode() [<a href='function.explode'>function.explode</a>]: Empty delimiter in /home/a2679801/public_html/catalog/mysecretadminarea/includes/functions/extra_functions/easypopulate_functions.php on line 241
[18-May-2011 13:30:11] PHP Warning: explode() [<a href='function.explode'>function.explode</a>]: Empty delimiter in /home/a2679801/public_html/catalog/mysecretadminarea/includes/functions/extra_functions/easypopulate_functions.php on line 241
[18-May-2011 13:30:11] PHP Warning: explode() [<a href='function.explode'>function.explode</a>]: Empty delimiter in /home/a2679801/public_html/catalog/mysecretadminarea/includes/functions/extra_functions/easypopulate_functions.php on line 241
[18-May-2011 13:30:13] PHP Warning: explode() [<a href='function.explode'>function.explode</a>]: Empty delimiter in /home/a2679801/public_html/catalog/mysecretadminarea/includes/functions/extra_functions/easypopulate_functions.php on line 241
[18-May-2011 13:30:13] PHP Warning: explode() [<a href='function.explode'>function.explode</a>]: Empty delimiter in /home/a2679801/public_html/catalog/mysecretadminarea/includes/functions/extra_functions/easypopulate_functions.php on line 241
[18-May-2011 13:30:14] PHP Warning: explode() [<a href='function.explode'>function.explode</a>]: Empty delimiter in /home/a2679801/public_html/catalog/mysecretadminarea/includes/functions/extra_functions/easypopulate_functions.php on line 241
[18-May-2011 13:30:14] PHP Warning: explode() [<a href='function.explode'>function.explode</a>]: Empty delimiter in /home/a2679801/public_html/catalog/mysecretadminarea/includes/functions/extra_functions/easypopulate_functions.php on line 241
[18-May-2011 13:30:32] PHP Warning: explode() [<a href='function.explode'>function.explode</a>]: Empty delimiter in /home/a2679801/public_html/catalog/mysecretadminarea/includes/functions/extra_functions/easypopulate_functions.php on line 241
[18-May-2011 13:30:32] PHP Warning: explode() [<a href='function.explode'>function.explode</a>]: Empty delimiter in /home/a2679801/public_html/catalog/mysecretadminarea/includes/functions/extra_functions/easypopulate_functions.php on line 241
[18-May-2011 13:30:44] PHP Warning: explode() [<a href='function.explode'>function.explode</a>]: Empty delimiter in /home/a2679801/public_html/catalog/mysecretadminarea/includes/functions/extra_functions/easypopulate_functions.php on line 241
[18-May-2011 13:30:44] PHP Warning: explode() [<a href='function.explode'>function.explode</a>]: Empty delimiter in /home/a2679801/public_html/catalog/mysecretadminarea/includes/functions/extra_functions/easypopulate_functions.php on line 241
[18-May-2011 13:30:53] PHP Warning: explode() [<a href='function.explode'>function.explode</a>]: Empty delimiter in /home/a2679801/public_html/catalog/mysecretadminarea/includes/functions/extra_functions/easypopulate_functions.php on line 241
[18-May-2011 13:30:53] PHP Warning: explode() [<a href='function.explode'>function.explode</a>]: Empty delimiter in /home/a2679801/public_html/catalog/mysecretadminarea/includes/functions/extra_functions/easypopulate_functions.php on line 241
[18-May-2011 13:30:58] PHP Warning: explode() [<a href='function.explode'>function.explode</a>]: Empty delimiter in /home/a2679801/public_html/catalog/mysecretadminarea/includes/functions/extra_functions/easypopulate_functions.php on line 241
[18-May-2011 13:30:58] PHP Warning: explode() [<a href='function.explode'>function.explode</a>]: Empty delimiter in /home/a2679801/public_html/catalog/mysecretadminarea/includes/functions/extra_functions/easypopulate_functions.php on line 241
[18-May-2011 13:31:04] PHP Warning: explode() [<a href='function.explode'>function.explode</a>]: Empty delimiter in /home/a2679801/public_html/catalog/mysecretadminarea/includes/functions/extra_functions/easypopulate_functions.php on line 241
[18-May-2011 13:31:04] PHP Warning: explode() [<a href='function.explode'>function.explode</a>]: Empty delimiter in /home/a2679801/public_html/catalog/mysecretadminarea/includes/functions/extra_functions/easypopulate_functions.php on line 241
[18-May-2011 13:31:04] PHP Warning: explode() [<a href='function.explode'>function.explode</a>]: Empty delimiter in /home/a2679801/public_html/catalog/mysecretadminarea/includes/functions/extra_functions/easypopulate_functions.php on line 241
[18-May-2011 13:31:04] PHP Warning: explode() [<a href='function.explode'>function.explode</a>]: Empty delimiter in /home/a2679801/public_html/catalog/mysecretadminarea/includes/functions/extra_functions/easypopulate_functions.php on line 241

[18-May-2011 13:50:48] PHP Warning: preg_replace() [<a href='function.preg-replace'>function.preg-replace</a>]: Unknown modifier 'a' in /home/a2679801/public_html/catalog/includes/modules/pages/popup_image/header_php.php on line 41

[18-May-2011 13:57:50] PHP Warning: preg_replace() [<a href='function.preg-replace'>function.preg-replace</a>]: Unknown modifier 'a' in /home/a2679801/public_html/catalog/includes/modules/pages/popup_image/header_php.php on line 41

[19-May-2011 01:43:19] PHP Warning: preg_replace() [<a href='function.preg-replace'>function.preg-replace</a>]: Unknown modifier 'a' in /home/a2679801/public_html/catalog/includes/modules/pages/popup_image/header_php.php on line 41

[19-May-2011 02:47:21] PHP Warning: file(/home/a2679801/public_html/catalog/temp/2011_05_18th) [<a href='function.file'>function.file</a>]: failed to open stream: No such file or directory in /home/a2679801/public_html/catalog/mysecretadminarea/easypopulate.php on line 1223
[19-May-2011 02:47:21] PHP Warning: Invalid argument supplied for foreach() in /home/a2679801/public_html/catalog/mysecretadminarea/easypopulate.php on line 1301

[19-May-2011 05:05:02] PHP Warning: preg_replace() [<a href='function.preg-replace'>function.preg-replace</a>]: Unknown modifier 'a' in /home/a2679801/public_html/catalog/includes/modules/pages/popup_image/header_php.php on line 41

To make matter worse, FTP connection to the site seems to time out after just a short amount of inactivity and I have to reconnect.

Can anyone help please? I'm really at my wit's end. Thanks.

[dbltoe]

Looks like everything is pointing to EP. If you are at the beginning, I'd start fresh, carefully load the latest EP, and use it to load about 20 items to make sure it's working before doing the entire 3700.

[schoolboy]

MOST problems with EP are a result of errors in the DATA file - not the program.

True... the program is very fussy, but you must get your TAB-DELIMITED TXT file absolutely correct before you load the product data.

See my WIKI tutorial: http://www.zen-cart.com/wiki/index.php/Easy_Populate

[double-happiness]

Thanks for the responses.

I did try to uninstall EP using /easypopulate.php?langer=remove but nothing happened.

Here's a sample of my file for what it's worth:

v_products_model v_products_image v_products_name_1 v_products_description_1 v_products_url_1 v_specials_price v_specials_date_avail v_specials_expires_date v_products_price v_products_weight v_date_avail v_date_added v_products_quantity v_manufacturers_name v_categories_name_1 v_categories_name_2 v_categories_name_3 v_categories_name_4 v_categories_name_5 v_categories_name_6 v_categories_name_7 v_tax_class_title v_status EOREOR

1 92544.jpg 666: D.E.V.I.L. 2x12" 666: D.E.V.I.L.<BR>2x12"<BR>House Nation DST 70713-12<BR>Germany 2000<BR><BR>D.E.V.I.L. (Break The Spell Mix)<br>D.E.V.I.L. (What The Hell Mix)<br>Alarma!<br>Diablo<br>Amokk<br>D.E.V.I.L.<br>Bomba!<br>I'm Your Nitemare<br>Paradox<BR><BR>Condition media / cover: Very Good Plus (VG+) / Generic<BR> 3.99 450 1 Trance --none-- 1 EOREOR

Maybe special characters in my category names are causing problems, I've used these:

& , - / '

[double-happiness]

So just use letters, nothing else? I don't know what is the exact defintion of a special character...

[schoolboy]

You are using " to indicate INCHES... Change these to In.

The " character can cause problems.

So can ' .

[schoolboy]

And as I said... the problems are most often data quality.

You should TEST one product (yes... just one product in a TXT file).

If this works then EP works... Any subsequent issues will be with DATA.

[double-happiness]

Wow, that is a bit of a suprise.

I don't quite know what to make of that as my main sale items are 12" singles.

The galling thing is, all my stock is uploaded and my shop displays fine, it's just the admin area I'm having problems with. It would be quite a blow not to be able to use the primary search term my customers are looking for. It's too bad I don't sell CDs...! I am almost exclusively a vinyl trader! Hmmmn...

[CoolCarPartsOnline]

OR invest $75 for the commercial version. Even though it hasn't been updated in 3 years and there are no support for it, It works every time even with special characters such as (", ').

I can understand Free is good, but the tool the allow you to import/export your store files is worth few bucks.

The Free version is limited and from what I read in it's support thread (Which is very lengthy) hard to add or change fields for the templates.

EP Advanced work on my stores with more than 200,000 products, I can upload 10000 product in one click.

[double-happiness]

I'll bear that in mind.

I guess at least with my inventory up (in spite of all these incorrect additional categories) and a working store (apparently) the best thing to do would be to bide my time and see how things go, at least until I next need to do an update on my stock.

When I had an OSCommerce store it got hacked and was deleted by my webhost, so there is still lots of time for things to go catastrophically wrong before I start tinkering with things!

At least I feel a bit calmer as I have a better idea what is probably causing the problems, so that is something. It really never occured to me it could be something as simple as a quotation mark.

Thanks all. Any other pointers are welcome of course.