Zen Cart Logo
Forums / Addon Admin Tools / Easy Populate 1.2.5.4 support

Easy Populate 1.2.5.4 support

Views: 1,300,988

Results 1,001 to 1,020 of 3,834
3 Oct 2007, 11:23 PM
#1001
tj1 avatar

tj1

Totally Zenned

Join Date:
Mar 2005
Location:
California
Posts:
628
Plugin Contributions:
0

Easy Populate 1.2.5.4 support

The version everyone should download is 1.2.5.4 last updated by langer, the other one is older and has many bugs.

Direct links to download EasyPopulate:
http://modhole.com/modhole/index.php?module=documents&JAS_DocumentManager_op=downloadFile&JAS_File_id=60

or

http://www.zen-cart.com/archived_contributions/admin-tools/ep_v1.2.5.4.zip

There's really no need to read any of the post in this thread to be able to successfully install and use EasyPopulate, installation and usage instructions are included in the download.

The standard and free download works on the latest version of ZenCart. No need to purchase the advanced version unless you need more advanced features. I tried the advanced version once and I actually found it a bit more difficult to use so I just stuck to using the standard version.

4 Oct 2007, 12:42 AM
#1002
treewoman avatar

treewoman

New Zenner

Join Date:
Apr 2007
Posts:
26
Plugin Contributions:
0

Re: Easy Populate 1.2.5.4 support

treewoman:

I keep getting this error upon checkout -
Please update your order ...
Product Name: Bariatric Mattress Only 48 W ... Quantity Units errors -
You ordered a total of: 1 Min: 0 Units: 0

I only get this error with the products I entered using epa.
The minimum, units and quantity all show up the same in the products manually entered as the products entered via epa.

I have tried to turn off any type of inventory control using the stock, listing and product type edits but nothing takes this error message off. The only way it disappeared was when I went into an item (first entered using epa) manually and changed the product quantity from 1 to 99999. I have over 8000 products that I entered using several different databases. I really don't want to go into the databases and change all the quantities again. I just want to disable any type of inventory control (which I thought I did). I don't have inventory issues.

One more epa related problem - I cannot add or change the quantity of products ordered on any of the items entered using epa. The manual products all have a quantity altering button available at the product description page and the checkout page but never for the epa loaded products.

Any ideas?

Does anyone have any ideas about this? I am really in need of help to get my site live.

4 Oct 2007, 2:31 AM
#1003
tj1 avatar

tj1

Totally Zenned

Join Date:
Mar 2005
Location:
California
Posts:
628
Plugin Contributions:
0

Re: Easy Populate 1.2.5.4 support

Did you set 'Product Qty Units' to 0 ?
This should be set to 1 or more.

Anyway, I just noticed you mentioned EPA, which I guess it means you use the advanced version because there's no way you can set this with standard EP, unless you modify the code.
If you use EP Advance, you should be able to get better support from the place you purchased it.

4 Oct 2007, 4:38 AM
#1004
awev avatar

awev

New Zenner

Join Date:
Mar 2007
Posts:
42
Plugin Contributions:
0

Re: Easy Populate 1.2.5.4 support

Hello TreeWoman and FreshStart,
Welcome to our little corner of the ZC world.

First TreeWoman, I will try to answer, it just may not be what you are looking for.

treewoman:

I keep getting this error upon checkout -
Please update your order ...
Product Name: Bariatric Mattress Only 48 W ... Quantity Units errors -
You ordered a total of: 1 Min: 0 Units: 0

I only get this error with the products I entered using epa.
The minimum, units and quantity all show up the same in the products manually entered as the products entered via epa.

I have tried to turn off any type of inventory control using the stock, listing and product type edits but nothing takes this error message off. The only way it disappeared was when I went into an item (first entered using epa) manually and changed the product quantity from 1 to 99999. I have over 8000 products that I entered using several different databases. I really don't want to go into the databases and change all the quantities again. I just want to disable any type of inventory control (which I thought I did). I don't have inventory issues.

One more epa related problem - I cannot add or change the quantity of products ordered on any of the items entered using epa. The manual products all have a quantity altering button available at the product description page and the checkout page but never for the epa loaded products.

Any ideas?
As TJ1 mentioned, you should be asking at the location that you purchased EPA, or EPA's site. The code is most likely byte-compiled, meaning it is not open to the public for review, or modification. Now the good news. Instead of changing the product quantity one by one, and even with the ability to do so removed by using EPA on individual editing pages, there is one easy way of doing so.

In ZenCart, in the admin section, not the catalog the customers view, you will see a tab labeled Tools, and under that Install SQL patches (Tools > Install SQL patches). What you will do is issue an UPDATE command, just make note if you created the databases with a prefix (i.e, zc_) or not. The command is as follows:

UPDATE (prefixIfNeeded)products SET products_quantity = '9999' WHERE products_quantity < '9999';

This will update everything to a quanity of 9999 if it is not already set to that value.

FreshStart, as noted above by TJ1, the older 1.2.5.4 version is the better of the two, and he provided links to it. As to the second part of your question, I'll give it a shot, and like my answer to TreeWoman, you may not like it.

freshstart:

Dear Colleagues,

New Zenner here. I note that there are two EasyPop versions available on Download. One is Easypop Langer and the other is Easypop from OSC. Which one is the best, in your opinion. In the meantime, I shall endeavour to read all of the post's associated with EP and try to locate an easy to read and understand method of installing the mod into Zencart.

On another note, why has the issue of there being no way to import XML live feed into Zencart not been resolved yet? If it has been resolved, please post details. On this latter issue, I have read the following article;

http://www.sitepoint.com/article/php-xml-parsing-rss-1-0

Thx.

freshstart.

I started to read the article that the link pointed to, I just didn't get past the opening paragraph or two. My first question is where would you get the live feed from? Do you know what the structure is? Everything is broken down into blocks, and that makes it easy, like reading an index card, yet harder if you don't know what order the information is presented in, the tag names, what can and can't be repeated, etc.

Do you realize that there is at least one module/add-on that I am aware of that exports XML? Yes, it is the one for Google, as Google requests the information that way for there on-line shops. There is also two or three modules that use XML to actively communicate with a third party in real time to verify information and update ZC (USPS/UPS [count as one big module, or two specialized, as you wish] and FedEx shipping modules). You can re-use some of the code provided to validate an address as it is entered when creating a new customer (though I don't see that happening in the code I have looked at), and it is used to verify the shipping address when an order is placed. It is also used to retrieve rate and estimated delivery time when an order is placed.

I don't want to discourage you, as the examples above show it is possible to use XML within ZenCart, even interactively. I have a vendor that puts out a data file that can be used with OSC with OSC's version of EP - version 2.74. I take the raw data from the file and work it over to conform to what I need, adjusting the product categories and set my sale prices mainly, yet I also look for bad links and typos that should not be there. Also, I will adjust the description more if I think it is needed, and to help keep it from looking like the exact same thing that a search engine has seen a hundred times before. You may just want to get the live feed on your own local computer, use a program to convert it to database entries, and check it over. Then you can export it, add the needed header line, and use EP to upload everything. I do believe it can be done in ZC, even if no-one has published a module for it.

4 Oct 2007, 5:13 AM
#1005
awhfy99 avatar

awhfy99

Zen Follower

Join Date:
Feb 2007
Location:
Burleson. Texas
Posts:
196
Plugin Contributions:
0

Re: Easy Populate 1.2.5.4 support

gabbytwin:

Hi,
hope someone can help me with an easy way of listing the product at their NETT price with any taxes included.
I have a lot of products to go and edit prices with if I need to work out each one minus the taxes.
Any idea will be great , did a search and couldnt find anything :(

If what you are asking is how to determine the starting price of an item when you only have the tax rate and the "total with tax", the anwser is fairly simple math.

Example:

Tax rate = 6.5%

Total (including tax) = $72.42

X = unknown price before tax

("/" means divided by)

X + (.065X) = 72.42

is the same as

1X + .065X = 72.42

therefore

1.065X = 72.42

X = 72.42/1.065

X = 68

You would want to set a formula in an Excel spreadsheet to something like the below example. Say your after tax data is in column D and you are using column M for your formula.

In the first cell (say it's row 2) in column M, input this =(D2/1.065), then copy/paste that cell into all of the remaining cells in that column.

You would then need to save the spreadsheet as a text file (tab delimited) to leave just the data, and not the formula. Then open it back up with the spreadsheet.

4 Oct 2007, 7:45 AM
#1006
makeup4brides avatar

makeup4brides

New Zenner

Join Date:
Jul 2005
Posts:
74
Plugin Contributions:
0

Re: Easy Populate 1.2.5.4 support

tj1:

The version everyone should download is 1.2.5.4 last updated by langer, the other one is older and has many bugs.

Direct links to download EasyPopulate:
http://modhole.com/modhole/index.php?module=documents&JAS_DocumentManager_op=downloadFile&JAS_File_id=60

or

http://www.zen-cart.com/archived_contributions/admin-tools/ep_v1.2.5.4.zip

There's really no need to read any of the post in this thread to be able to successfully install and use EasyPopulate, installation and usage instructions are included in the download.

The standard and free download works on the latest version of ZenCart. No need to purchase the advanced version unless you need more advanced features. I tried the advanced version once and I actually found it a bit more difficult to use so I just stuck to using the standard version.

Thanks :)

4 Oct 2007, 10:29 AM
#1007
freshstart avatar

freshstart

New Zenner

Join Date:
Jul 2007
Location:
England
Posts:
84
Plugin Contributions:
0

Re: Easy Populate 1.2.5.4 support

AWEV & tj1,

Many thanks for your responses. At present, I am of the view that I do not have a clue what I am doing. I am not a coder and reading and working iwth code is not coming at all easy. Back to the drawing board.

Best wishes,

freshstart :lamo:

4 Oct 2007, 1:07 PM
#1008
treewoman avatar

treewoman

New Zenner

Join Date:
Apr 2007
Posts:
26
Plugin Contributions:
0

Re: Easy Populate 1.2.5.4 support

Yes I use easypopulate advanced. I agree, I SHOULD be able to get better support from them. I just cannot wait that long. It seems to take forever to get through to them. They figure out the problem when they get to it - but when that is we'll never know...

4 Oct 2007, 1:10 PM
#1009
treewoman avatar

treewoman

New Zenner

Join Date:
Apr 2007
Posts:
26
Plugin Contributions:
0

Re: Easy Populate 1.2.5.4 support

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.

4 Oct 2007, 9:23 PM
#1010
awev avatar

awev

New Zenner

Join Date:
Mar 2007
Posts:
42
Plugin Contributions:
0

Re: Easy Populate 1.2.5.4 support

Hello again TreeWoman,
In this case you set a default from the admin area, under Configuration > Product Listing. Looking in the products database I don't see anything else.

FreshStart,
I had forgoten something, the RSS thingy for letting your customers know the latest news at your site. RSS is pretty much XML - going out. You may be able to find out who has writen these apps, and maybe send them a message asking if they would consider working with you in developing the module you are looking for. Even if they develop the add-on they will need someone to test it, and guess who that could be?

5 Oct 2007, 12:44 PM
#1011
makeup4brides avatar

makeup4brides

New Zenner

Join Date:
Jul 2005
Posts:
74
Plugin Contributions:
0

Re: Easy Populate 1.2.5.4 support

Can someone point me to why this is happening

I am listing my items in the txt file but only the first product lists ? even thought it says upload successful ...

File attached.

Can someone have a little look and tell me what is wrong?

edited to add ... also the images aren't showing

5 Oct 2007, 12:48 PM
#1012
freshstart avatar

freshstart

New Zenner

Join Date:
Jul 2007
Location:
England
Posts:
84
Plugin Contributions:
0

Re: Easy Populate 1.2.5.4 support

Cheers Awev,

As I have yet to use EP yet (I have managed to install it onto a test site only), I am very inexperienced with the software. I would appreciate being signposted to a simple 'idiots guide' to how the damn thing is supposed to work. I have read many dozens of posts about the software and still cannot understand it, although I really need to if I am to get around the problem of uploading several hundred / thousand images and bits of product information individually.

I am based in Manchester, England and I was just thinking, it would be nice if some kind soul would arrange a local beginners course on this subject asap.

Best wishes

Freshstart :lamo:

5 Oct 2007, 12:57 PM
#1013
freshstart avatar

freshstart

New Zenner

Join Date:
Jul 2007
Location:
England
Posts:
84
Plugin Contributions:
0

Re: Easy Populate 1.2.5.4 support

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 :frusty:

5 Oct 2007, 1:02 PM
#1014
makeup4brides avatar

makeup4brides

New Zenner

Join Date:
Jul 2005
Posts:
74
Plugin Contributions:
0

Re: Easy Populate 1.2.5.4 support

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

5 Oct 2007, 2:17 PM
#1015
makeup4brides avatar

makeup4brides

New Zenner

Join Date:
Jul 2005
Posts:
74
Plugin Contributions:
0

Re: Easy Populate 1.2.5.4 support

:) That did it ! ;)

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

5 Oct 2007, 8:25 PM
#1016
awev avatar

awev

New Zenner

Join Date:
Mar 2007
Posts:
42
Plugin Contributions:
0

Re: Easy Populate 1.2.5.4 support

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/showpost.php?p=410120&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.

6 Oct 2007, 12:16 AM
#1017
mikeyg avatar

mikeyg

Totally Zenned

Join Date:
May 2005
Posts:
515
Plugin Contributions:
0

Re: Easy Populate 1.2.5.4 support

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

6 Oct 2007, 2:24 AM
#1018
awev avatar

awev

New Zenner

Join Date:
Mar 2007
Posts:
42
Plugin Contributions:
0

Re: Easy Populate 1.2.5.4 support

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

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
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

6 Oct 2007, 4:18 AM
#1019
awev avatar

awev

New Zenner

Join Date:
Mar 2007
Posts:
42
Plugin Contributions:
0

Re: Easy Populate 1.2.5.4 support

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

treewoman:

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

8 Oct 2007, 2:37 AM
#1020
stoscano avatar

stoscano

New Zenner

Join Date:
Aug 2007
Posts:
6
Plugin Contributions:
0

Re: Easy Populate 1.2.5.4 support

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.