Easy Populate 1.2.5.4 support

jdw1979:

I have searched through this thread and have not found any mentioning of this issue, and I apologize if this subject has already been covered.

I have a large inventory of items (48000+). When trying to download a Froogle (Google Base) feed, and when, in fact, trying to download any of these .csv/.txt files, my Admin area times out.

When I uploaded the inventory, I used a simple CSV splitter program to break up the upload file into 1000 item chunks...and I'm sure that if I were more PHP savvy I'd be able to code something to do the same thing but...I ain't. Any suggestions?

:frusty:

Thanks in advance,

Dale

It might be as simple as going to admin>configuration>my store and changing the Admin Set max_execution_time for processes to something longer, we have it set to 6000 seconds and then we get to the server's timeout issue. The server issue is set in the php.ini file located on your server. You may or may not have access to this, depending on your host, and you should be able to put one in the root directory of your site to control site-specific php. There is a setting in the php.ini for timeouts.

I tried setting the Admin timeout. It didn't work. Well, phooey (I would say something else but it's a family forum)...I'll take a stab at creating a php.ini. I use Godaddy, so the actual file isn't available to me; though I have created one before to do something that I can't remember...a mind is a terrible thing to waste. I'll let you know how the php.ini edits go.

Dale

Oh how often I feel this way -->:lamo:

I am using easy populate and I want to have one main image but I also want to add a second image to the site like this site as in the listing how do I add that to my csv or XL sheet to upload?

As far as i am aware, you can not add additional images with the basic version of EP, i think this is a Advanced EP feature.

Failying that, it just as quick to ftp up the additional images, as you dont need to go into each product and add each one... all you need to do is a make sure they are named correctly

I was just wondering if anyone knows if it's possible to hack EP to be able to upload a customer database?

touchclothing:

I am using easy populate and I want to have one main image but I also want to add a second image to the site like this site as in the listing how do I add that to my csv or XL sheet to upload?

Use FTP to add your images.

You need to name your images correctly so they show properly in the product info pages.

IE: Main image = 1001.jpg

additional images

1001_01.jpg
1001_02.jpg
1001_03.jpg
etc etc

You only need to add the main image in your EP file the rest will automaticly show on the product info page.

Hope it helps :)

I use EP to import my products but as I am VAT registered I need the prices that import to be the price including VAT.

When I check the prices after importing all my products the VAT is added on top of the price I imported.

IE: Price incl VAT = €10

If I set the price in csv file to €10 and import it will show in the site as €12.15 (Adding 21.5% VAT)

What I need is when I add an item at €10 it shows in the cart as €10 (including VAT)

I have tried to calclate the price before VAT in excel but it doesnt add up properly when reverse engeneering VAT calculations. The percentages are different and it uses about 6 or 7 decimal places to get the exact pricing right. And when I put it back to 2 decimal places the doesnt add up right.

As these values will be used in my bookkeeping they need to be spot on or the tax man will on to me LOL.

Has anyone done this or can someone maybe point me in the right direction.

Thanks a mil in advance for any help.

I have just installed 1.2.5.4 and when I go to to upload my file its says
Upload Results

File uploaded.
Temporary filename: /tmp/phpx2tMDF
User filename: lynyrdskynyrd.txt
Size: 17635

Upload Complete

But nothing shows up in my store what am I doing wrong

The way that I handled a batch import of customers was this...I took my existing customer datasheet (which I had exported from phpMyAdmin), and exported a customer datasheet from the "customers" database in the Zen Cart database. I cut and pasted the necessary data, imported the data (again, via phpMyAdmin) and then ran a script that I found on this forum that batch processes all unencrypted passwords into encrypted passwords and then, voila...I had all my customers in my new site. The only problem that I can think of with this methodology is that it doesn't address order histories. I hope this helps.

:blush:

~Dale

jdw1979:

The way that I handled a batch import of customers was this...I took my existing customer datasheet (which I had exported from phpMyAdmin), and exported a customer datasheet from the "customers" database in the Zen Cart database. I cut and pasted the necessary data, imported the data (again, via phpMyAdmin) and then ran a script that I found on this forum that batch processes all unencrypted passwords into encrypted passwords and then, voila...I had all my customers in my new site. The only problem that I can think of with this methodology is that it doesn't address order histories. I hope this helps.

:blush:

~Dale

Dale, thanks for the direction. I've got it partially working. I've tried adding a single customer to check by phpMyAdmin. I've added them to the following tables: customers, customers_info and address_book.

When I do a search for them in admin, I find them, however I have the following errors:

Warning: array_merge() [function.array-merge]: Argument #1 is not an array in /home/actforms/public_html/cart/admin/customers.php on line 1035

Warning: array_merge() [function.array-merge]: Argument #2 is not an array in /home/actforms/public_html/cart/admin/customers.php on line 1037

Warning: reset() [function.reset]: Passed variable is not an array or object in /home/actforms/public_html/cart/admin/includes/classes/object_info.php on line 29

Warning: Variable passed to each() is not an array or object in /home/actforms/public_html/cart/admin/includes/classes/object_info.php on line **30

**And when I click on "edit" none of the information is filled out. Any idea what table I am missing?

Thanks for the awesome help though!!

any ideas I will take anything

I have just installed 1.2.5.4 and when I go to to upload my file its says
Upload Results

File uploaded.
Temporary filename: /tmp/phpx2tMDF
User filename: lynyrdskynyrd.txt
Size: 17635

Upload Complete

But nothing shows up in my store what am I doing wrong
touchclothing is offline Report Post Reply With Quote

touchclothing:

any ideas I will take anything

I have just installed 1.2.5.4 and when I go to to upload my file its says
Upload Results

File uploaded.
Temporary filename: /tmp/phpx2tMDF
User filename: lynyrdskynyrd.txt
Size: 17635

Upload Complete

But nothing shows up in my store what am I doing wrong
touchclothing is offline Report Post Reply With Quote

I'm not sure about this but, don't the import files have to be in a .csv format? Not .txt? I know they're very similiar (often considered to be the same thing, in fact) but that might be where the problem lies.

Scrat:

Please read the title of this thread:

Easy Populate support for Version 1.2.5.4 namely Langer's version from Modhole not from ZC's download section.

The problem I am seeing is that with so many versions of EP floating about people are getting all sorts for issues and bugs and not being clear which version they are using.

Would it be an idea to start some new threads with the title of the versions of EP you are using ??

e.g
Easy Populate support for Version 1.2.5.4
Easy Populate support for Version 1.2.5.5.csv.2
Easy Populate support for Version 1.2.5.5
Easy Populate support for osc Version 2.77H

Just a thought :huh:

This is quoted from page 236 by Scrat,

It really looks like this thread should be seperated. There seems to be too many problems and questions refering to different versions of Easy Populate.

So far I have only used 1.2.5.4 on 5 stores, added and changed some field names, deleted unused download lines in the easypopulate.php file and uploaded anywhere from 52 products on one store to over 14,000 on other stores and have never had a problem uploading.

Perhaps someone will continue to a new thread for 1.2.5.5.csv.2 and keep it seperated from 1.2.5.4
I still consider 1.2.5.4 from Modhole to be the easiest and best version to use.

jdw1979:

I'm not sure about this but, don't the import files have to be in a .csv format? Not .txt? I know they're very similiar (often considered to be the same thing, in fact) but that might be where the problem lies.

yea we have done it with both and nothing happens

Hi Zenners,

Preface, EPv1.2.5.4 from modhole.com

I had originally installed Easy Populate CSV v1.2.5.6 and then decided to go with EP v1.2.5.4 because it seems to be much more supported here in the forums and it has been mentioned that it is the most stable version.

So I contacted schoolboy because he seemed to have an in-depth knowledge of v1.2.5.4 and wanted his opinion on the matter. I liked his response and proceeded to uninstall EP CSVv1.2.5.6. Everything went well except for an MySQL error! So I contacted schoolboy, briefed him on the situation and he gave me the following advice/instructions to solve the error and it worked like a charm!

I told schoolboy that I was going to post this for anyone else who has done the same as I have done. So here it is, hope it helps.

schoolboy:

autoace:

Hi schoolboy,

I have installed EP v1.2.5.4 (from modhole) and am just about done, except I have one mysql error that I hope you can help me please fix.

I did delete the tempEP from the previous install and uploaded the temp folder from the EP v1.2.5.4. And then I ran the sql file in my phpmyAdmin because I noticed the different folder names (tempEP vs temp) for the temp folder. Any suggestions as to the fix. Should I just simply rename the temp folder to tempEP or is there something else I should do. I intend to post this on the forums as soon as I have it fixed in case anyone else has done what I did! Thank you for your help. MySQL error is....

Error

SQL query: Documentation

INSERT INTO configuration VALUES ('', 'Uploads Directory', 'EASYPOPULATE_CONFIG_TEMP_DIR', 'temp/', 'Name of directory for your uploads (default: temp/).', last_insert_id(), '0', NULL, now(), NULL, NULL), ('', 'Upload File Date Format', 'EASYPOPULATE_CONFIG_FILE_DATE_FORMAT', 'm-d-y', 'Choose order of date values that corresponds to your uploads file, usually generated by MS Excel. Raw dates in your uploads file (Eg 2005-09-26 09:00:00) are not affected, and will upload as they are.', last_insert_id(), '1', NULL, now(), NULL, 'zen_cfg_select_option(array("m-d-y", "d-m-y", "y-m-d"),'), ('', 'Default Raw Time', 'EASYPOPULATE_CONFIG_DEFAULT_RAW_TIME', '09:00:00', 'If no time value stipulated in upload file, use this value. Useful for ensuring specials begin after a specific time of the day (default: 09:00:00)', last_insert_id(), '2', NULL, now(), NULL, NULL), ('', 'Split File On # Records', 'EASYPOPULATE_CONFIG_SPLIT_MAX', '300', 'Default number of records for split-file uploads. Us[...]

MySQL said: Documentation
#1062 - Duplicate entry 'EASYPOPULATE_CONFIG_TEMP_DIR' for key 2

---

Thanks for your help.

My advice would be to remove everything associated with EP in your files, AND database, and start from scratch.

FILES:
Only in your Admin folder - EP does not exist in Catalog side of ZC.
Find all EP "php" files and delete them all.

DATABASE
BACKUP DB FIRST!

1. use phpMyadmin (or whatever your host provides) to edit your db:

in configuration_group - select browse - find easypopulate - (**make note **of the group ID) - delete that group ID

3. select configuration - then browse - sort by group ID - find the one that you need relating to EP. (there should be 10 different config. ID's for that group) - delete them all.

4. install EP 1.2.5.4 again via FTP.

5. There is usually NO NEED to run the SQL patch. After uploading the php files, go to ADMIN>>>TOOLS>>>EASY POPULATE.
   There will be a message about installing in the header of your admin screen... click that. EP should install itself.

6. Go to ADMIN>>>CONFIGURATION>>>EASY POPULATE and administer settings. Read my WIKI for advice.

7. EP should now be functional.

Thanks schoolboy, worked like a charm. Your step by step was was absolutely excellent. Thank you!

touchclothing:

any ideas I will take anything

I have just installed 1.2.5.4 and when I go to to upload my file its says
Upload Results

File uploaded.
Temporary filename: /tmp/phpx2tMDF
User filename: lynyrdskynyrd.txt
Size: 17635

Upload Complete

But nothing shows up in my store what am I doing wrong
touchclothing is offline Report Post Reply With Quote

Can I get some help on this !!!!!!

touchclothing:

Can I get some help on this !!!!!!
I'm not sure what your file (txt) looks like, but does it have EOREOR on the end and each item has a unique product model number.

Also what about seperate catagories?

touchclothing:

Can I get some help on this !!!!!!

Have you used EP successfully in the past with your website?

touchclothing:

Can I get some help on this !!!!!!

1. What version of EP are you using? REALLY important to know this!
2. Did you have any products in your store to start with?
3. Each product MUST have a unique v_products_model AND you must have at least 1 master category.
4. What is your default language? If it is not english = 1, people have had problems.
5. Have you checked you databases using phpMyAdmin? You can browse the products database to see if anything loaded.
6. Did you set up your temp file location to be writeable?

There are a lot of things that can go wrong with EP (all the versions), but most of them are simple to fix, and generally user error.

However, if you are populating a new empty store database for the first time, you often need to go into Admin -> Tools -> Store Manager and run "Update All Products' Attribute Sort Orders" and "Update ALL Products Price Sorter".

You should really do that after every upload anyway. I have found cases where it seems the indexes do not update correctly (I also use quick updates, and this is very evident when checking new data after upload as the Master Category id's get jazzed up for some reason.)

Seriously: First time EP users need to enter a few products with categories throught the Zencart Admin and THEN do a first download. You can then use this as your template for your other products. You'll still need to manually upload your images too.

Hope this helps.

Find the EP FAQ ... it is quite well written and very helpful.

One other thing! If you have not installed the Admin Backup MySQL tools, you should! And you should have a backup before any attemps at uploading products from any version of EP.

Through no fault of EP, it is quite easy to jazz up your store with mistyped category names, funky dates, etc. etc.