Easy Populate 1.2.5.4 support

[freshstart]

Hello MakeUp4Brides,

As you know from my previous post, I am no expert. Have you forgotten to put EOREOR at the end of each of your lines of product information?

Best wishes,

Freshstart

[makeup4brides]

will give it a go but that wasn't on the first product line either but still listed ... ?

[makeup4brides]

:) That did it ! ;)

Only problem is the images are not showing still ...

[awev]

Makeup4Brides,
FreshStart was correct, EOREOR denotes End of Row/End of Record. That helps EP know when one record/row ends and another begins. As for the images, did you upload them before trying to import the EP file?

Makeup4Brides and FreshStart,
Take a look at http://www.zen-cart.com/forum/showpo...&postcount=856. It was a post I did a few pages back as a quick and ugly FAQs for EP. A couple post below it is another one for attributes by another user. I am updating my sig to provide quick links that should show up on all of my posts.

[MikeyG]

I am getting this error when I try to creat the model\attibute file. What might cause it and what can be done to avoid it

Fatal error: Allowed memory size of 8388608 bytes exhausted (tried to allocate 3672703 bytes) in ...\admin\easypopulate.php on line 1041


thanks MG

[awev]

Hello MikeyG,
You may of ran into a problem that you have no control over.

I am getting this error when I try to creat the model\attibute file. What might cause it and what can be done to avoid it

Fatal error: Allowed memory size of 8388608 bytes exhausted (tried to allocate 3672703 bytes) in ...\admin\easypopulate.php on line 1041


thanks MG

The above error message is generated by PHP. Translated it means that PHP is configured to use 8MB of RAM, and it tried to use about 3.6MB for EP. That means that other processes is using at least 4.4MB of RAM, so there is not enough RAM left that has be allocated to PHP to execute the command - in this case EP.

With this being an issue with PHP you may be restricted in what you can do, depending on if you host the site yourself or if it is being hosted. If you are hosting the site yourself you can just change the php.ini file, and increase the requested memory to 32MB, or anything else you may chose (just don't go overboard). If it is a hosted site you may not be able to change things yourself, just depends on what is in the agreement, and how comfortable you feel changing things. If your server is co-located then you should be able to change the file, otherwise you may have to speak with tech support and see if they are willing to change it for you.

A lot of things will just depend on what you are allowed, able, and willing, to do. If your hosting provider will not allow changes to the php.ini file then you have to find other solutions. If you are at this point then you have to make some hard choices. You will have to disable something, or just turn something off while trying to work with EP. You can't turn off ZC, yet you may have to turn off something like an image module. If this is not an option then see below for the final idea.

Worst case:
========
Worst comes to worst use the SQL patch tool under the tools section. You would start by installing MySQL (or another SQL RDBM [Relational Data Base Management] program of your choice) on one of your computers, maybe even doing a complete install of Apache, PHP, MySQL and Zen Cart with modules - for local testing. It may be a good idea to use the ZC install script to create the database so both the local and remote databases match in structure.

Once you have MySQL installed you can then use LOAD DATA INFILE to import your product information from the original source(s). Preform any needed operations to work the data into a form you need. Now export the database - you can use the backup command, and make sure it includes the needed commands, such as insert and update. You may have to edit the file in a text processor so as not to introduce unwanted control information from a word processor, and to insure the commands are correct.

Upload the file to your site, and then use the SQL patch tool to import it, or the MySQL tools included with your hosting package. You should be able to just execute things as all of the information and data is there. You could also brake the file up into small chunks to help fit within the memory constraints.

This this the hardest way of doing things as you have to know something about MySQL to help insure everything goes correctly. Also, you need to know how ZC lays out it's database, what tables you have to update, etc. Because of the technical nature of things this is not for the faint of heart.

Good luck Mikey G

[awev]

Hello TreeWoman,
I made a mistake in answer to the question you posted.

Here is my next issue -
Products Quantity Box Shows: Yes, Show Quantity Box No, Do not show Quantity Box

Is there a way to change this checkbox from the no to the yes on ALL my 8000 products? I don't want to change each and every product.

Thanks again.

Using the Install SQL patch under tools in the admin section we are able to change the show quantity box status. The command is:

UPDATE products SET products_qty_box_status = '1'

The '1' turns it on, while '0' would turn it off. I found the info here

[stoscano]

So i've done a successfull import of around 1500 items to my shop.
But now I want to slightly adjust the prices, I have adjusted the prices in my spreadsheet. Can I just import this new spreadsheet and will it just overwrite the current items? Or would i end up with double items?
NOTE: the spreadsheet is exactly the same, except for the prices.

[tj1]

If you import the new file it will overwrite/update the current items.

It's not necessary to have all the columns in the new file to update prices. you just need the model, price and EOREOR columns.

[kai920]

~snipped~

Dag nab it, why did you have to ask such a hard question?

Hey awev, I haven't logged on in a while. Just want to say thanks for your detailed answer!