Printable View
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.
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.
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.Quote:
Originally Posted by treewoman
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.
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.Quote:
Originally Posted by freshstart
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.
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.Quote:
Originally Posted by gabbytwin
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.
Thanks :)Quote:
Originally Posted by tj1
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:
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...
Here is my next issue -
Products Quantity Box Shows: http://docbrownmedical.com/admin/images/pixel_trans.gif 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.
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?
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
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:
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:
will give it a go but that wasn't on the first product line either but still listed ... ?
:) That did it ! ;)
Only problem is the images are not showing still ...
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.
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
Hello MikeyG,
You may of ran into a problem that you have no control over.
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.Quote:
Originally Posted by MikeyG
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
Hello TreeWoman,
I made a mistake in answer to the question you posted.
Using the Install SQL patch under tools in the admin section we are able to change the show quantity box status. The command is:Quote:
Originally Posted by treewoman
UPDATE products SET products_qty_box_status = '1'
The '1' turns it on, while '0' would turn it off. I found the info here
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.
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.
Hey awev, I haven't logged on in a while. Just want to say thanks for your detailed answer! :cool:Quote:
Originally Posted by awev
Hello Makeuo4brides :smile:Quote:
Originally Posted by makeup4brides
Glad I was of help (was a surprise for me) with your EP issue. Did you manage to get your images issue sorted?
Best wishes,
Freshstart
Hello AwevQuote:
Originally Posted by awev
Many thanks for your previous advice and support. I have just been introduced to EP and as you will have seen from a recent post I am not the sharpest tool in the box when it comes to understanding it.
Would you be willing to outline for me (very simply) what it is that you actually have to do to get stock information onto your website. I am having difficulty understanding your previous post and how to put that advice into practice :frusty:
What I am trying to eventually do is download stock information via a XML live feed from a supplier, import that into a spreadsheet, since the info will not transfer directly to Zencart. Then from the spreadsheet to Zencart in the form of a tab delimited text file.
Up to now I have installed EP onto a test site with no issues. I have saved the XML info to a Excel text file. I am unsure of exactly what to do with it from there?
As with Makeup4brides example I understand that I would need to place stock information underneath a line of text, produced within a downloaded EP file, then upload that to my site?
Do you think you can offer me further simple advice?, or refer me to a source of further information. I am a total beginner :frusty:
Best wishes,
Freshstart
Hello FreshStart,
Open your XML live feed in Excel as you have, and check the info. Is it all there? Can you tell what is what? Would you mind sending me a copy so I can look at it and tell what is going on?
Have you entered a couple products manually yet into ZC? If so then download that info using EP so you have a template to use, and something to refer to. Open it as a new spreadsheet in Excel. You will be switching between the XML and the EP spreadsheets, copying info from one and pasting into another.
What you will do is copy the stock level info from the XML live feed and paste it into the EP spreadsheet under v_products_quantity.
If you have a database that supports the importing/exporting of XML info you may be able to just use that, along with an update command.
Myself, I use OpenOffice for a number of reasons, so I may not be the best one to help you. I don't care to us Micro$oft products if I can help it. I prefer open source, and that includes Linux. I haven't used Excel, Access, or even M$ Word for close to a decade. I did get a copy of M$ Office 97 when I built a computer back in 1998, yet I haven't used it since (came as a bundled package with windoze 98 for cheap.)
Well Kia920,
What was the answer? Did you need help on entering the HTML code, the style of the text, the tools to use, or what? That last question was so open-ended that it did make it hard to answer. So, what have you come up with? A little more feedback would be nice. Ok, I just want to know what details you are thanking me for.
You set out a plan on how you would go about uploading your images, and product info using EP. Did that work out for you? And what about IM2? Was the people over on the IM2 forums able to help you as well?
I can wait another three (3) weeks for an answer. I know real life makes demands of all of us, and we can't be here all of the time (my cable internet was out for the weekend - real life stinks at times).
Hope all is going well.
Hello Awev,
Hello FreshStart,
Open your XML live feed in Excel as you have, and check the info. Is it all there? Can you tell what is what? Would you mind sending me a copy so I can look at it and tell what is going on?
I have sent you a PM with the information you requested.
Best wishes,
Freshstart :smile:
Hi Awev, I know how to add additional fields to EP thanks to your other post.
I was wondering if you know how to add additional fields (ex. alias, catalog_page_no, sku, etc) to the database.
There's this post http://www.zen-cart.com/forum/showthread.php?t=57924 that explains how to add additional fields to the same products table, but I think putting the additional fields on a different table would be better when the time to upgrade comes.
Hello TJ1,
That is an easy thing, just go to the Patch SQL Install and issue a couple commands.
First, we will start with a simple command,
SHOW DATABASES;
This tells us the database name that we will use. Next, issue the
SHOW TABLES FROM db_name;
We use the database name(s) returned from the SHOW DATABASE command in place of db_name in the above command. This lets us see if there is a prefix that we need to use.
Next, we use the CREATE TABLE like the following, what I lifted from the address book part of ZC:
Things to note: 1) CREATE TABLE "zencart"."zc1_address_book" means create the table zc1_address_book in the database zencart. In this case I am using the prefix zc1_ so we would use that in creating a new table. 2) I don't know if you need a crash course in MySQL syntext or not, yet I'll cover a couple basic things. For more info you can go to http://mysql.org. 3) int(11) means an integer value extending to 11 places left of the decimal point, while varchar means up to 32 charters in the field. 4) PRIMARY KEY ("address_book_id") indicates what field will be the primary key, while it shows a second key being created called "idx_address_book_customers_id_zen" that is based on the field customers_id.Code:DROP TABLE IF EXISTS "zencart"."zc1_address_book";
CREATE TABLE "zencart"."zc1_address_book" (
"address_book_id" int(11) NOT NULL auto_increment,
"customers_id" int(11) NOT NULL default '0',
"entry_gender" char(1) NOT NULL default '',
"entry_company" varchar(32) default NULL,
"entry_firstname" varchar(32) NOT NULL default '',
"entry_lastname" varchar(32) NOT NULL default '',
"entry_street_address" varchar(64) NOT NULL default '',
"entry_suburb" varchar(32) default NULL,
"entry_postcode" varchar(10) NOT NULL default '',
"entry_city" varchar(32) NOT NULL default '',
"entry_state" varchar(32) default NULL,
"entry_country_id" int(11) NOT NULL default '0',
"entry_zone_id" int(11) NOT NULL default '0',
PRIMARY KEY ("address_book_id"),
KEY "idx_address_book_customers_id_zen" ("customers_id")
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
The easy part is done. Now you have to insert the needed code in the correct pages in the correct areas, with the correct fields to be displayed and for data entry.
Just some questions to ask yourself:
A) What fields do you need in the table?
B) What type of fields - decimal, charter, integer, text, blob, etc, and how much information will be contained in each field.
C) What areas do you need the info displayed in? Is is just for the administrator, the administrator and customer?
D) Will you use the new data in calculations, and if so, how? Do you have any test data where you already know the answers to that you can use to test the new code with?
Good luck with your project.
Hi, I greatly appreciate any help anyone can give with the problem I'm experiencing.
I have a .txt file of categories/subcats and their corresponding images and descriptions that was generated by Easy Populate Advanced. I'm trying to import that list on a fresh site using Easy Populate Basic, the last release. I keep getting a "Model not found, line was not imported" error message when trying this.
Is this just a compatibility issue? What can I do to work around this? Thanks.
I haven't really used EP advanced, so I'm not sure I may be able to help. I used it once but found it a bit more complicated and just dropped it.
Anyway, with EPA I think you first create categories before being able to upload any products.
EP standard works differently, categories can only be created if there's an associated product model. Or, for the same matter, you cannot update/create anything if there's no product model in the file you upload.
Thanks. How can I work around this?
Quote:
Originally Posted by Dionysian
This has been said in many different ways, but here it goes again. On the site you are trying to upload to, download a full EP text file. Open both your text file and the one you just downloaded and compare the top lines (using a spreadsheet). Obviously, they don't match since you are getting the errors.
Copy/paste the data from your text file into the downloaded one, using the last word on the top line as a guide. You will need to assign a model name for all products (1st column), and it needs to be unique. If you need an easy way to do this, just copy/paste the image names into that column and do a replace after highlighting that column. Just replace .jpg (or whatever) with a "null", since the products should all have a unique image, that should work. The first column must be v_product_model and the last colum must be EOREOR, anything in between is what you want to include. Save your changes to a tab delimited text file and upload. Backup your site first so that if something goes astray, you can just restore it back to what it was before the upload.
I just tried to implement my tab-delimited .txt file and I got this error after inserting into the database:
Warning: move_uploaded_file(/hsphere/local/home/cisaacs7/doctorsmedicalsupplies.com/catalog/temp/DMS_Products_20071009 modified.txt) [function.move-uploaded-file]: failed to open stream: Permission denied in /hsphere/local/home/cisaacs7/doctorsmedicalsupplies.com/catalog/admin/includes/functions/extra_functions/easypopulate_functions.php on line 57
Warning: move_uploaded_file() [function.move-uploaded-file]: Unable to move '/tmp/phpmKFwUn' to '/hsphere/local/home/cisaacs7/doctorsmedicalsupplies.com/catalog/temp/DMS_Products_20071009 modified.txt' in /hsphere/local/home/cisaacs7/doctorsmedicalsupplies.com/catalog/admin/includes/functions/extra_functions/easypopulate_functions.php on line 57
Warning: file(/hsphere/local/home/cisaacs7/doctorsmedicalsupplies.com/catalog/temp/DMS_Products_20071009 modified.txt) [function.file]: failed to open stream: No such file or directory in /hsphere/local/home/cisaacs7/doctorsmedicalsupplies.com/catalog/admin/easypopulate.php on line 1201
Warning: Invalid argument supplied for foreach() in /hsphere/local/home/cisaacs7/doctorsmedicalsupplies.com/catalog/admin/easypopulate.php on line 1301
None of the new products show up, what could be the problem?
Since the first error mssg says "permission denied", I would try a chmod 777 on the temp folder.
That fixed the error I was getting, but the products still don't show up. Could it be that I don't have the columns from the spreadsheet in the right order (like I have the category column before the model number column)?
Hello Dynamica,
Most likely one or both of two things are happening. First, you are on a shared host from the look of things, so you are competing with a number of other people for the server's resources, and it just may be overloaded trying to update everything. Their is not much you can do about that.
The second is a cache somewhere, most likely on your computer. Try flushing the cache in your browser and see if that helps. My internet provider offers PowerBoost, which is them implamenting a passive proxy cache, which makes things look faster than they really are if you reload static content.
OK folks.
I have installed the mod.
Now my question is this..
will this upload an XML feed file and will it automatically upload the items to my site?
Yes, the model column has to be the first one.Quote:
Originally Posted by dynamica
I cleared the cache and still no products show up, but I think I am on a shared server. The catalog file has about 2000 products on it, am I going to be able to implement this many products on a shared server?Quote:
Originally Posted by awev
It will not work with XML (RSS) file, yet you can get around that. Just open the file in OpenOffice/OfficeStar or micro$oft office. Follow the directions for creating a couple items manually in your store and download the file from EP, and open that.Quote:
Originally Posted by TJR Stores
The XML file will look a lot like HTML code, with tag pairs. EP will look like a spreadsheet with with column headings.
The XML file may look like:While the EP file will look like:Code:<record_1>
<item_number>001</item_number>
<item_name>name_1</item_name>
</record_1>
<record_2>
<item_number>002</item_number>
<item_name>name_2</item_name>
<record_2>
Just copy the info from within the tags in the XML file to the proper fields in the EP file.Code:v_item_number | v_item_name | eoreor
001 | name_1 | eoreor
002 | name_2 | eoreor
Sorry, it has been a long day, so I will provide a more detailed answer in the near future. Just one question - are the items disabled? Did you have a 0 or 9 set in your EP file where you should of had an 1 instead?Quote:
Originally Posted by dynamica
If you have EP up and running, then 2000 items should not be a problem, while 200K+ may be, if you don't have the disk space for all of the photos, and if the database space counts against you.
IS there any way to include the product URL when you want to have a link to another page at the bottom of your item in the database? What would be the heading?
Heres my EP file, I don't think anything is disabled, but I'm not sure if the format I'm using is creating a problem (I've left out a lot of columns and put them in different order)...
http://www.doctorsmedicalsupplies.co...20modified.txt
If you are looking to insert a link, and have it retrieve the product info, then Zen Cart, and hence EP, can't do it. You can stick a link into the bottom of a product description if you want, or place the link under the column heading of v_products_url_1.Quote:
Originally Posted by Peaches
I haven't seen anything where the column order has been customized so much. I believe in the last 10 posts or so someone has mentioned that the product number has to come first, and I would not be surprised by that.Quote:
Originally Posted by dynamica
The other thing is you need EOREOR (End Of Row/End Of Record) at the end of each product/item. Because a product description could be up to 64K in size (or larger with things set correctly), not that I would suggest including a whole book in the description, EP looks for the EOREOR on the end of a record/row. Adding EOREOR would be the first thing to try. It is kind of like a run-on sentence/paragraph, without the proper indication you don't know when to breath. It helps let the program know when to stop with one item and begin with another.
The distribution kit for EPA comes with a GPL license. I believe what you are asked to pay for is support. However, for reasons unknown, support does not seem currently available by any means provided by the author to paying customers. I hope this is not due to some mis-fortune or illness on the authors part.Quote:
Originally Posted by awhfy99
I did not know that EPA came under the GPL licensing scheme. It seems as if Nicklaus took the original code and reworked it so much that in it's current form it doesn't resemble the original. Because of that he is byte-encoding it, doing something similar to how java is encoded for speed, and it makes it hard to decode (it is still possible to decode, and reverse engineer, just something the average person is not able to do). The byte encoding is a copy protection scheme for php, if you will, in addition to a speed boost. And to get the byte code for downloading you have to pay for it. If it is still under the GPL license then the source code should be available for review, yet I have not seen it.Quote:
Originally Posted by kiddo
EPA has a limited audience, being those who use osC or derivatives, and not all computer users employ it like a word processor or spreadsheet. Even if he is a programmer by profession, and has his own business, we would represent small beans compared to a major contract. On the osC side of things EP is well into version 3, and has different branches based on what you need it to be compatible with. OsC does have a larger user database, and so more people are working on supporting it.
Take the above with a bag of salt. Most of what I state I have concluded based on what I have seen, what little I know about php, and a few other things. I hope what I have posted is correct, as I don't like making mistakes, nor be misinterpreted as slanderous. If there is hard and fast info, and not something inferred from the internet, then please share. I don't mind being corrected.
I haven't seen any encoded script (but I haven't looked at all of it). My employer purchased it for a client and sent it to me to install. When I unpacked it, it includes a GPL license file, and the parts I did look at contain a GPL notice at the top of the code.
Perhaps there may be some code among the files that is not GPL. But I would suspect if that was the case, it would somehow indicate that at the beginning.
Either way, it does seem to be a well written and fairly comprehensive mod. I am not sure if I am using the very latest release. 3.something... I simply try to point out to poster, that just because it is GPL, doesn't mean it HAS to be handed out for free.
First, let me thank the authors of Easy Populate, this is an invaluable tool.
My question is about quantity discounts.
In my source database I have a database field that shows 3 quantity discount prices.
example:
1 or more = .76
3 or more = .46
6 or more = .34
the data entry in my source file for this example appears like this:
0.76:1:0.46:3:0.34:6
I have over 5,000 of these, how do I get them into the SQL database using Easy Populate?
Hello WebGuyGary,
If that is a discount that applies to all items, regardless to the group or person ordering it, then you should be able to set the discounts globally, and just upload the standard pricing.
If you set the discounts differently based on the item then you most likely need a special pricing mod, and find out what fields needs to be updated. Once you have gathered the needed info you can then refer to the links below, in my signature, for more detailed info on how to modify EP for your needs.
If the pricing changes based on the group, i.e., regular shopper, university, large corporation, etc, then you would set everything by the special pricing module you have chosen.
Sorry if I am not able to be very helpful at this time, it depends a lot on what you have installed, and how the programs/modules expect the data, and where and it is stored.
Hi guys.
I have a problem on a new site when using EP v1.2.5.4 [zen-cart 1.3.7.1 and PHP v 5.2.4].
I have manually added a few products, and then downloaded an EP file so that I can add more products to the existing category structure.
When I upload the modified EP file all appears to upload successfully, but no new products appear in the catalogue. If I look in admin>catalogue>products>category the product quantity appears to have increased but if I drill down to the level where I would expect to be able to edit the new products, only the original products are there.
Any suggestions greatly appreciated.
the discounts are always 1, 3, and 6 or more, but the prices are different per item. does that mean that you say I can do this?Quote:
Originally Posted by awev
example:
1 or more = .76
3 or more = .46
6 or more = .34
the data entry in my source file for this example appears like this:
0.76:1:0.46:3:0.34:6
HELP!
I am new to Zen Cart, and find it an amazing, comprehensive tool. I am having the following problem:
I'm using a WinXP machine (testing for now):
ZC 1.3.7.1
PHP 5
MySQL 5.0
Apache 2.2.6
I have installed Easy Populate 1.2.5.5 per the install.txt file. I copied all files into their respective folders. When I click Tools>Easy Populate I get the Easy Populate 1.2.5.5 page. However, on top of the page is a pink line that reads "Easy Populate Configuration Missing. Please install your configuration by clicking here". When I click on the "here" link I get a message saying - 1366 Incorrect integer value: '' for column 'configuration_group_id' at row 1 in:
[INSERT INTO configuration_group VALUES ('', 'Easy Populate', 'Config options for Easy Populate', '1', '1')].
I'm not sure what I'm doing wrong, but if somebody can tell me what to do I would really appreciate it.
P.S.
I have been reading the posts in this forum for about 6 hours now and can't find an answer (also searched the posts for the error and google).
Murphy's Law at Work !!!
Regarding Error Message:
1366 Incorrect integer value: '' for column 'configuration_group_id' at row 1 in:
[INSERT INTO configuration_group VALUES ('', 'Easy Populate', 'Config options for Easy Populate', '1', '1')]
I found an OScommerce forum that suggested disabling Strict Mode in MySQL 5.
I did this using the MySQL Administrator under:
Startup Variables>Advanced>SQL Mode (uncheck this box)
Now, on to figuring out how it works.
Thanks for having such a great tool.
WebGuyGary,
I do believe your figures will work. If I purchase one item that normally retails for $10 I get for $7.60, and if I purchase another item that is regularly priced at $15 then you would only charge $11.40. If I was to order 3 of the first then the price would drop to $4.60 each, for a total of $13.80. And for 6 of the $15 item I would be looking at $5.10 per item for a total of $30.60
tcarney.,
Sorry you had to spend 6 hours to find your solution. Yes, right now you need to do somethings slightly different if you are using MySQL 5.0 or later. You seem to have a good setup, using version 5 of PHP and MySQL. With PHP discontinuing support for version 4 by the end of the year most hosting companies will be upgrading from version 4 to 5. Some hosting companies still use the first version of Apache. Since you got EP to work with MySQL 5.x you are good to go for years to come.
will easy populate work with the MAP module? everything for both modules is installed and working. but, when i create the ezpopulate text file, the MAP pricing is not there.
any advice?
thanks.
I have read through all the posts and have not found my problem mentioned. EasyPopulate works fine if I have the complete category hierarchy in the DB. If I don't, it hangs. I would really like to solve this problem to be able to start with a clean database and populate it iwth the proper products and category hierarchy.
Any idea why easypopulate hangs when the categories do not already exist in the DB?
I had a slightly different problem, and upon review, I came to the conclusion that the best practice is to manually create the catagory structure before adding any products. I bit of a pain if you have a lot of catagories, but important to avoid troubles.Quote:
Originally Posted by rge
Hi, I'm sorry if this is a VERY stupid question but I am lost and having a REALLY bad day! :lamo: I have ep installed and configured, it has automatically created a file in temp. Here's where I am lost, what do I do now??? I am trying to copy one of my categories to another category. Oh and the category I am copying has LOTS of attributes, so how do I do that too!
Thanks for all of your help!!
I have installed EP in my new Zencart, which I switched to from OSC. I get the following message on the EP screen:
Warning: dir(/home/myacct/public_html/zencart/temp/) [function.dir]: failed to open dir: No such file or directory in /home/myacct/public_html/zencart/admin/easypopulate.php on line 994
However I have installed all the files in the DL. What am I missing?
TIA
I'm not sure how that solves my problem, could you be so kind as to elaborate in greater detail?Quote:
Originally Posted by awev
thanks.
Help I just installed dual pricing and now my easy populate comes up with this error
Fatal error: Call to a member function on a non-object in /home/luke/public_html/1310/includes/functions/extra_functions/easypopulate_functions.php on line 587
I hope one of you zen cart pros out there will be able to help
Ok I"ve installed easy populate on my cart I've found easy populate under my Admin/tool. But I get these error.
Warning: dir(/home/mdr/public_html/test/temp/) [function.dir]: failed to open dir: No such file or directory in /home/mdr/public_html/test/admin/easypopulate.php on line 695
Fatal error: Call to a member function on a non-object in /home/mdr/public_html/test/admin/easypopulate.php on line 697
Also where do you get the excel file to load your stuff?
Dave:D
Dave - the way I did it was to use the feature called "Download Complete tab-delimited .txt file to edit". Then I used this as a template to reconfigure my source database ( used Micro$oft Excel). Once I had all the fields properly populated into the template, I used "Upload EP File", found the .txt file I had saved on my hard drive, uploaded it, and all the data was populated into the SQL database.Quote:
Originally Posted by daver1510
This worked fine for me until I got to the quantity discount problem I'm currently facing. I need to find a way to invert my pricing data.
That seems to have worked, the products are showing up now, but the pictures still don't show up. The product name is displayed twice instead of the picture... you can see the problem here: http://www.doctorsmedicalsupplies.com/catalog/ . Also, I think the prices are not displaying either.Quote:
I haven't seen anything where the column order has been customized so much. I believe in the last 10 posts or so someone has mentioned that the product number has to come first, and I would not be surprised by that.
The other thing is you need EOREOR (End Of Row/End Of Record) at the end of each product/item. Because a product description could be up to 64K in size (or larger with things set correctly), not that I would suggest including a whole book in the description, EP looks for the EOREOR on the end of a record/row. Adding EOREOR would be the first thing to try. It is kind of like a run-on sentence/paragraph, without the proper indication you don't know when to breath. It helps let the program know when to stop with one item and begin with another.
HELP... I have been reding the 107 pages but am confused. I have EP and cant work out how to add new products with this. Can anyone help please ????
this is what i get on the page after inserting file into database
File uploaded.
Temporary filename: /tmp/phpfeCd3y
User filename: EP2007Oct30-1705.txt
Size: 940
| img104.jpg | ALAN JACKS | TRACKLISTI | | 19.95 | 0 | 0 | 0 | | 0000-00-00 | 0 | | Country | | | | --none-- | 1 | !New Product!
| 1460 | | AUSTRALIAN | | | 9.95 | 0 | 0 | 0 | | 0000-00-00 | 0 | | Pop / Rock | | | | --none-- | 1 !New Product!
| | | | | | | | | | | | | | | | | | |
No products_id field in record. This line was not imported
Do the products show up in the Catalog?
The problem I am having is that the product appears to upload just fine. The category is created, but the product is empty. Using PHPMyAdmin I find that the products table is empty, products_description and products_to_categories have their data. :unsure:
No the products dont show up at all. i am thinking it is something to do with this.
No products_id field in record. This line was not imported
When i add a new products manually it gives it a number. There is no field in the download that references to this number. i cant get any new products to add in this way ?
Quote:
Originally Posted by dynamica
your database entries for the image location on the server are incorrect. each entry should be /listings/13974.jpg, not the complete url. This is because the default location for images is:
http://doctorsmedicalsupplies.com/catalog/images/
Thus, it's adding your complete url again, whereas all you need in each data entry is /listings/13974.jpg.
Does this make sense?
anyway, I'm still trying to solve this issue:
My question is about quantity discounts.
In my source database I have a database field that shows 3 quantity discount prices.
example:
1 or more = .76
3 or more = .46
6 or more = .34
the data entry in my source file for this example appears like this:
0.76:1:0.46:3:0.34:6
am I correct in understanding that these need to be inverted to
1:0.76:3:0.46:6:0.34 ?
if so, what's the easiest way to do this inversion?
I have over 5,000 of these (of varying prices), how do I get them into the SQL database using Easy Populate? Is this the correct format for multiple discounts, and what field do I need to add these to?
Quote:
Originally Posted by Press Play Music
Can anyone help with this or give me some idea who i could contact to help ?
I opened the PHP file and had it print the SQL error message. I do not know the maintainer of EP, or the bug reporting procedure, but this is what I found.
I downloaded easy_populate_from_osc_2.76dmod3a.zip. In catalog/admin/easypopulate.php at line 2203, the INSERT statement's list of database fields does not match the data fields. I added products_priced_by_attribute and all is well.
I do not know what version of EP you have, so I do not know if you are impacted.
When trying to:
Download Complete tab-delimited .txt file to edit (Attributes Not Included)
I get the below error but when I use any of the other links, they work with no problem.
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /usr/local/4admin/apache/vhosts/ronmichelle.com/httpdocs/admin/easypopulate.php on line 706
Warning: Cannot modify header information - headers already sent by (output started at /usr/local/4admin/apache/vhosts/ronmichelle.com/httpdocs/admin/easypopulate.php:706) in /usr/local/4admin/apache/vhosts/ronmichelle.com/httpdocs/admin/easypopulate.php on line 1074
Warning: Cannot modify header information - headers already sent by (output started at /usr/local/4admin/apache/vhosts/ronmichelle.com/httpdocs/admin/easypopulate.php:706) in /usr/local/4admin/apache/vhosts/ronmichelle.com/httpdocs/admin/easypopulate.php on line 1075
Warning: Cannot modify header information - headers already sent by (output started at /usr/local/4admin/apache/vhosts/ronmichelle.com/httpdocs/admin/easypopulate.php:706) in /usr/local/4admin/apache/vhosts/ronmichelle.com/httpdocs/admin/easypopulate.php on line 1079
Warning: Cannot modify header information - headers already sent by (output started at /usr/local/4admin/apache/vhosts/ronmichelle.com/httpdocs/admin/easypopulate.php:706) in /usr/local/4admin/apache/vhosts/ronmichelle.com/httpdocs/admin/easypopulate.php on line 1083
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_products_cost 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
Please help,
I have uploaded one product via admin and then uploaded 19 products more using EP.
They all show on the store but when you click on any of the pictures, it says "Sorry, the product was not found."
It only works with the one product I have uploaded not using EP.
you can check at www.butterflieshome.com/store
Thank you for your reply
Hi,Quote:
Originally Posted by cbar126
I tried to find your other products, but could only see the one. (ie: no other products at all, although strangely, the catagory says "20".
Best practice for Easy Populate is to create a couple of products manually, then download the the full products list. Then, copy the format with your new products and upload them.
With respect to images, I always upload them first, not sure if this is actually required, but that's what I do. I have had plenty of problems, but few with EP.
Good luck! :)
I install Easy Populaten and works fine.
But i need one more field, the "id_product" how can i add this field?
i have a few issues. i guess start at the top:
when i first go to the EP module i have a error banner stating "1 partially deleted product(s) found! Delete this dross to prevent unwanted zencart behaviour by clicking here."
clicking 'here' tells me it failed and i should read the error logs.
when i read the logs, it tells me:
Product debris corresponding to the following product_id(s) cannot be deleted by EasyPopulate:
8:91627b10f753ee314dbb959b0511ee2c
It is recommended that you delete this corrupted data using phpMyAdmin.
what do i do with this information. i tried searching for that string in phpMyAdmin and drew a blank.
cudaboy71 - known issue search this thread for fix...
ooi...the problem may be known. but, the solution is evasive. i've been reading for 1/2 hour and find nothing.Quote:
Originally Posted by Scrat
if anyone who makes following this thread a habit cares to throw me a bone, i'd be appreciative.
Quote:
Originally Posted by rge
Does anyone have any info on this problem?
Have you checked the length of the product_name. I found if I exceeded the field length of 64, I would experience similar behaviors for all the products that followed.Quote:
Originally Posted by bifficus
hi there,
Need a bit of help with EP, I'm new to zen cart but reasonably old school at php and the like.
I'm running EP Advance version 2.76d and Zen Cart version 1.3.7
I've installed the EP system ok and got things running, however I had some issues wrting from MS Excel, did not like the .txt files when I tried to upload. I turned on MS excel safe output etc... on, so now I'm working with the csv files which is fine.
When I upload the files, i get the following:
File uploaded.
Temporary filename: /tmp/phpsJ4WVB
User filename: now.csv
Size: 1185
| Product Mo | topHeader. | Test Syste | This is th | http://www | 2200 | 0 | 100 | 0 | | 7/11/2007 | 1 | | Computer S | | | | GST | 1 !New Product!
| PC-60B | topHeader. | Jablotron | This is th | http://www | 55 | 0 | 100 | 0 | | 7/11/2007 | 1 | | Computer S | | | | GST | 1 !New Product!
| PC-60A | topHeader. | Jablotron | This is th | http://www | 55 | 0 | 100 | 0 | | 7/11/2007 | 1 | | Computer S | | | | GST | 1 !New Product!
| AN-01A | topHeader. | Jablotron | This is th | http://www | 49 | 0 | 100 | 0 | | 7/11/2007 | 1 | | Computer S | | | | GST | 1 !New Product!
| JA-60U | topHeader. | Jablotron | This is th | http://www | 165 | 0 | 100 | 0 | | 7/11/2007 | 1 | | Computer S | | | | GST | 1 !New Product!
Now this is just a test with a few products, but I assume getting this means that it was succesful, however the products do not show up in my shop, nor are they available in the admin side of things.
If I try to export a list of products, they do not show up in there ether. This leads me to think that there is a problem writing to the mysql database. Is this something I have missed in config etc...?
Cheers
Would love to get this going, thanks:smartalec:
had a weird version isntalled, reinstalled now I get:
EASYPOPULATE_MSGSTACK_DROSS_DETECTED
I can't see where I got hte language files wrong, am I missing something?
I also get BOX_TOOLS_POPULATE in the tools dropdownn, am I missing something?
cudaboy71 - a great tool to use is >> thread tools -> search this thread... at the top of the thread...
Nicholas originally post 19th June 2006
Quote:
sorry for not being available the last few weeks. A little 4.5kg boy is keeping me busy
I'll address any unanswered questions in turn. regarding the dross not being dleted, this is a bug. Ignore the error message for now. You can, if you wish, remove the offending table names the function checks in /admin/includes/functions/extra_functions/easypopulate.php:
Code:
TABLE_CUSTOMERS_BASKET,
TABLE_CUSTOMERS_BASKET_ATTRIBUTES
I am working very hard to release the 1st advanced version in the next 2 weeks, and will at that time apply the bugfixes to the free version for all to enjoy.
##############################___
Nicholas
I am having a download problem. I hope some one can help. When I click on download complete tab-delimited link the page times out. I was told from my host company that the server will time out after 10sec. They will not change this becouse I am on a shared server. Is there any way to fix this problem with out missing with the server.
Quote:
Originally Posted by cwd
do you maybe have the improved attributes controller addon installed?
I noticed the same problem after I installed that addon, don't know what the connection between them are though..
Though I found a way to be able to download it, with only one of the browsers, either iexplorer or mozilla, can't remember which one: ctry clicking on download complete file or create complete file. one of those two will put the file in /tmp dir, and you can download it via yuor favourite ftp program and update it and reupload it using normal easy populate way.
this works for me, try it out :)
Does anyone know the difference between the two easy populates in the downloads section?
1. Easy Populate Free - from langer / modhole
Last Updated by: oeginc - r shady - orig by langer Dec 01 2006 v1.3.6 v1.2.5.5
2. Easy Populate From osc
Last Updated by: web28
Is one better or easier then other?
You can't use the OSC version with ZenCart.
You want to use the one for ZenCart, which is the one last update by langer.
I always get this.Quote:
Originally Posted by cwd
EP worked perfectly the first few times, but after processing big files (one with thousands of products) it seems like some sort of switch is activated and now it always times out, although it continues to run in the background.
For this reason when I need to download a file I just click the 'create file in temp folder' instead and download it from there.
I use EP on three sites, two of them are relatively big and have at least 15,000 products each. On these two sites EP always times out(receive 'the page cannot' be displayed' error, even if the file I process is small and only has one product. But EP always keeps running in the background until done.
The third site I have has less than 3000 products. EP has never timed out on this one yet. However, I'm pretty sure that once I process a bigger file, it will turn out just like the other two sites and it'll display 'the page cannot be displayed' even if I only process a file with one product.
I have EP 3 installed in my regular store and it works fine. But I've set up a test store to test new mods in and I'm trying to install EP in it as well but there's a hitch. Every time I go to Admin/Tools/Easy Populate it takes me back to the admin login. Any idea what's going on here?
Thanks!
Jason
I'm having this same problem, however all the categories are being created just none of the products are being imported. I created one item "by hand" exported it, formatted my product list to match the downloaded format...uploaded, imported and got 0 products 15 new categories.Quote:
Originally Posted by 33driver
Any Ideas?
TIA
-Aaron
I'm looking for some tips on ep upload problems. I use MS Excel to make the tab-delimited.txt files. I use a download from ep admin as the template. I have had uploads work before with ep.
A few of the items that uploaded wrong had " at the beginning of the description. But I can't delete these out of the spreadsheet, they don't exist in that cell. ??It's like they are hidden.
Other items upload a new random category with lots of subcategories that look like it is using the weight, date available, or other info (along with the cats I told it to go into) to create these categories......??? I can't figure out why.
Of course there are missing prices, missing weights, or both in almost all these new items. And linked items also appear.
I have read the forum and done the following: used upload to delete products, manually split the file, did a fresh upload. Nope, didn't work.
Reset main cat id, and price sort.......Nope
Deleted items, Made the cats in admin first then uploaded again, Nope, didn't work.
I suspect some sort of formating in the Excel file but of course I really have no idea. I'm in over my head. Any tips on copy and paste inside excel or tips to figure this out would be much appreciated.
:frusty:
It sounds like excel is using "" to delimit text within the file. I have a scalc program that does the same unless you tell it not to. No idea as to how to option it differently, as my excel97 is not set that way. There should be an option when choosing "save as" to select how it is to be saved and may be worth playing with to find out how.
Suggestion:
Open the saved tab delimited text file that you created with notepad. If it shows quote marks enclosing any text, just delete them all before uploading. To do so, select replace, enter " in the first field and leave the second field empty and chose replace all.
A very large file may take a few minute to process as notepad is not the fastest program in the world.
Thank you for the reply.
I've tried looking for " at the beginning of cells, but they don't appear untill I do the find option and sift through " for inches in descriptions, then will come across one at the beginning of a cell, but when I click to edit, it isn't there for me to delete it.
I will try your suggestions and see what happens.
:unsure:does anyone have a easy populate for dummies anywhere. I have it installed but not sure where to go from there?
I am using EP 1.2.5.4. I am trying uploading files priced with attributes but each product uploading does not have the Price by Attributes setting on so i have to go to each one and turn it on. Not fun.
I have the setting v_products_priced_by_attribute for each product to "1". Should it be another number?
Dale
Also, I would like to upload the sort order for products, but that does not seem to upload. I do have a column for the sort order.
v_products_sort_order
Dale
######################################################################____ Upload EP File
######################################################################____Split EP File
######################################################################____Import from Temp Dir (temp/)
######################################################################____Download EP and Froogle Files
Download Complete tab-delimited .txt file to edit (Attributes Not Included)
Download Model/Price/Qty tab-delimited .txt file to edit
Download Model/Category tab-delimited .txt file to edit
Download Froogle tab-delimited .txt file
Download Model/Attributes tab-delimited .txt file
Create EP and Froogle Files in Temp Dir (temp/)
Create Complete tab-delimited .txt file in temp dir (Attributes Not Included)
Create Model/Price/Qty tab-delimited .txt file in temp dir
Create Model/Category tab-delimited .txt file in temp dir
Create Froogle tab-delimited .txt file in temp dir
Create Model/Attributes tab-delimited .txt file in temp dir
can someone explain what each of these things do? :D
Not sure if this is where I post this?
I have easy populate installed. When I try to download the Model/Attributes file to either file or to Temp. This is what happens.
I click on the link to download the file. It acts like it is doing something then goes to a blank page. No offer to save to file. nothing.
When I click on save to temp it acts like it does something and goes to a blank page. I check the temp folder and it has a file in there. Has most of the products listed.
I get no error messages of any kind.
I do have SEO urls installed. Not sure if this would change anything or not.
I am using Zen cart 1.3.7 and easy pop 1.2.5
any help would be appreciated.
Mack
Hi, I clicked to download the attributes data template using easy populate in admin but at the same time received the following warnings:
Progress: >
Warning: fwrite(): supplied argument is not a valid stream resource in /home/dealbyet/public_html/admin/includes/easypopulate/classes/eclipse/FileWriter.php on line 63
Warning: fwrite(): supplied argument is not a valid stream resource in /home/dealbyet/public_html/admin/includes/easypopulate/classes/eclipse/FileWriter.php on line 63
Warning: fclose(): supplied argument is not a valid stream resource in /home/dealbyet/public_html/admin/includes/easypopulate/classes/eclipse/File.php on line 196
What does these mean?
Some dump questions:
How do you clean out all those files that are created in your temp folder?
Also does the restore file come from the temp file or from the excel file on your pc that you down loaded?
If it comes from the temp folder: why does have to do that.
Totaly lost!:smartalec:
Not sure if this got answered elsewhere... what you are asking for is not supported in EP. However, I wish it were... I really want this functionality too.Quote:
Originally Posted by helpme
We need to be able to copy and rename a subcatagory, including all products, just as we can duplicate a product.
Not sure this is the right place for this post as I believe it is a zencart admin functionality enhancement. I have seen this elsewhere in enhancement requests from a year back. Not sure if there are plans to implement it.
Hi All,
I recently was suffering from some upload issues on EP that gave me errors on lines 1223 and lines 1301 in EP.php.
I think it is because my catalog is starting to get big, (about 700 subcats on four levels so far) but few products yet, about 25 actual ids.
Anyway,
I split out the new stuff I wanted to upload, but stupidly saved it as a CSV file. When I tried to upload the CSV, it transfers and says, "upload complete", but it does not display the proper feedback, such as:
UPDATED! - Model: Sony-NP-BG1 | camera/Son | Sony NP-BG | | | | | | 29.95 | 0.5 | | 10/28/2007 | 0 | Sony | Camera | Sony | Sony-Cyber | | | | | Taxable Go | 1 |
It has been posted elsewhere, but I thought I would write it again since others are still having trouble with this.
Uploads must be in Tab delimited format. Also, if your catalog is big, upload your changes to the temp directory and process the changes from there, rather than the 'upload'. That way you can ensure that your upload was correct (using filezilla).
This seems to be important for some reason even if the upload is small (ie: if the catalog is big, and the upload is small, trying to upload with the "single step" creates the 1223 and the 1301 errors.
I also made the attributes 777 on my temp diectory. But the real problem for me was the (duh) CSV.
Hope this helps somebody! :flex: