Okay, solved. I formatted the column as a number with two decimal places, and then it worked. Didn't think that would have been relevant in a tab-delimited text file.
Printable View
Okay, solved. I formatted the column as a number with two decimal places, and then it worked. Didn't think that would have been relevant in a tab-delimited text file.
thank you for your help . I change 60 instead of 30 it is works now .
I have been using Easy Populate to load prices to 2 decimal places with no problems.
I have now started uploading prices to 4 decimal places successfully.
My problem is that when I download the products using EP, the created file rounds the price off to 2 decimal places.
eg upload price as 0.3043.
Check price in ZenCart Catalog and it shows 0.3043
Download list using EP and it is shown as 0.3
Can this be overcome to download as whatever price is stored?
glad to hear that it is working... how is your utf-8 encoding working?
I have had problems with it in the past....
I added the 'product_sort_order' field to my easy populate v1.2.5.4. It works fine on existing products. But I tried the 'dipstick' test where I removed products and then tried re-adding them.
I'm getting the MySQL error 1136. I noticed my debug log says:
MySQL error 1136: Column count doesn't match value count at row 1
When executing:
INSERT INTO products (
products_image,
products_model,
products_price,
products_status,
products_last_modified,
products_date_added,
products_date_available,
products_tax_class_id,
products_weight,
products_quantity,
master_categories_id,
manufacturers_id)
However I already updated my easypopulate.php to include 'products_sort_order'. It still doesn't seem to work though. I believe this is what is causing my Error, because it's not counting my sort_order column while updating new products.
(In my easypopulate.php)
$query = "INSERT INTO ".TABLE_PRODUCTS." (
products_image,
products_model,
products_price,
products_sort_order,<-------
products_status,
products_last_modified,
products_date_added,
products_date_available,
products_tax_class_id,
products_weight,
products_quantity,
master_categories_id,
manufacturers_id)
Thanks for the help!!
Please scratch the above post.
Below that 'Insert Into Table Products' code, the Values were out of order.
Still getting used to looking at code! :D
I manually entered test products (by copying and pasting existing orders with new model numbers) and uploaded via EasyPopulate v1.2.5.4.
The test product shows in phpmyAdmin under the products table, but it doesn't flow through to my Catalogue- Catagories/Products on the site.
I uninstalled and reinstalled EP, but the same issue occurs. What could be causing this?
Please anyone? This issue has been stressing me out to no end. I've read almost every page of this thread. I've tried other versions of EP and reinstalled EP a few times.Quote:
Originally Posted by hitz310
What would cause EP to upload to the Products table in PHPMyAdmin but NOT Categories.php on the site? If it's in PHPMyAdmin database, shouldn't it show on my site?
So confused...
Hitz,Quote:
Originally Posted by hitz310
Have you tried to "Reset ALL Products Master Categories ID" under Tools -> Store Manager?
Also, have you installed Dr. Bytes MySQL Backup? If you use the backup mod, you can backup/restore all your data quite easily. This will save you a lot of grief should you ever have an EP update fail or mess something up, your you make some other mistake.
Also, Read Schoolboy's wiki on EP. He put a lot of effort into that and it is quite helpful.
Chadderuski- thank you for your response. I've tried the "Reset all products master categories ID" from seeing it mentioned in this thread but it doesn't solve this weird issue I'm having.Quote:
Originally Posted by chadderuski
I checked the Wiki, but it doesn't mention my issue.
I know EP is working because I see it in my Products table with a new product ID and all of the information I put in. But that last step of flowing through to my Categories.php is not working. Working in the other direction- creating a product manually on the site it appears fine in my database & spreadsheet.
How is EP -> Products -> Categories linked?
Thanks!
You could also try to run the Price Sorter...Quote:
Originally Posted by hitz310
You didn't mix products and categories did you? THAT will definitely mess things up. How many TOTAL products do you have in your store? Best I can suggest is that you do a full export via EP and either post it here, or send me a PM with a link and I'll take a look at your data.
You could also do a "reload" ... BACKUP -> Export all products via EP -> Delete all Categories & Products -> Optimize DB (from Under Tools) -> Reload All Products via EP.
Make sure you are not Mixing Products and Categories. This can really mess things up, and I don't think 1.2.5.4 dealt with it well.
I did what you suggested above. When I tried to reload all products via EP, what happened was 1. the categories were created just fine, but 2. the categories were empty- none of the products uploaded. But they were just fine in phpMyAdmin products table.Quote:
Originally Posted by chadderuski
So I uploaded my backup directly via phpMyAdmin and it uploaded fine into my Categories.php. All of the products/categories are there.
So somehow, the link between just EP -> Categories.php seems to be off in my case. Is this action of uploading products defined in "admin/products_to_categories.php"? To my knowledge, I've never touched this file...
Chadderuski, if you don't mind I'll send you my txt file to take a look at.
Thank you SO much for the help!
hitz310:
I took a look at your data. I believe that you need to put info in v_products_name_1 and v_products_description_1 ... there is something in the script that is done when handling these columns that zencart needs.
Here's a test for you. Trim your file down to 4 items, assign the name and description. Do your upload. I'll bet this fixes your problem. I discovered that my EP4 also has a bit of a bug in regards to v_products_name_1 and v_products_description_1 not being filled in ... one or the other is required or the script doesn't work correctly.
let me know how that works.
LOL. Sorry for the poor english. Not much sleep last night. Someone firebombed a car outside our apartment complex late last night!Quote:
Originally Posted by chadderuski
It looks like the EP 1.2.5.4 needs the name and description to properly import your data and get things indexed/linked properly. Zencart WILL let you add a product without a name/description, the for now this is probably a must for EP.
Wow, you're the best. I didn't think it was something as simple as that. I was blinded by the idea that there was something horribly wrong with the code somewhere in my site and I was going nuts!Quote:
Originally Posted by chadderuski
Just to upload via EP I need to fill in something under Name and Description. After that I can delete the added text on the site and re-download my txt file and I can make changes to the product via EP just fine!
Thank you thank you!!
ZC v1.39
I've got a really head scratcher for you folks.
I've been saving my works regularly while editing product data so my info isn't getting lost but the format is a mess.
Example:
I need to enter a lengthy description in v_products_description_1 so I make the entire column wider. (either manually or using the Format Cells pull-down).
After entering all of the info I save the document, upload to my site and close the workbook.
When I reopen the workbook to add more products the cells have all reverted back to their former narrow state and my data is now a jumbled mess.
So how do I keep my cells wide enough on the EasyPopulate spread sheets?
If the file format is CSV, the short answer is you can't using Excel or Open Office. Neither of these programs retain columns widths in CSV files.. (they only display them when you have the file open)
Quote:
Originally Posted by Serious
Excel Tab Delimited file.
Serious,Quote:
Originally Posted by Serious
If you need descriptions longer than 255 character, then you will need to use OpenOffice to edit and save your tab-delimited files. Excel will truncate to 255 characters.
Also, the column width is a feature of excel/OO, and not CSV or tab-delimited TXT files. Each time you open or edit them you will have to adjust column width.
Sigh......
Guess I need to learn how to use OO now.
I hate my life.....
The trick is to save in either xls or ods while you are editing and only save a copy in csv when you need to upload.Quote:
Originally Posted by Serious
=======
Can I ask a question?
I have a store with about 200 products. Recently I have taken on a new supplier and need to add 2000 more products. Over the past few weeks I have been in spreadsheet hell trying to get everything perfectly categorised and in order. In the process, I have decided on a better category structure. I've also broken an EP rule and changed some product titles and even model numbers. I can probably fish out the products that are already in the store, but I'm wondering if it wouldn't be better to just remove everything and re-add it.
Is this advisable? What might the consequences be?
I need help installing Easy Populate to a Zen Cart 1.3.9 installation. The install.txt file 1. requires changing "the name of the "admin" directory in this package to suit your zencart installation." Does this mean change it to the exact name of the admin folder? 2. "Upload all files in their respective directories." Does this mean upload the downloaded folder formerly named "admin" to the Zen Cart installation folder, which in my case is bzg\shopping\adminurrhtcqw, or some other subfolder? Won't the system reject a duplicated folder name?
Hello.
I've been using Easy Populate only for a couple of days now and it's working great for importing products. but the problem I'm now having is some of my products use attributes. I downloaded the "Download Model/Attributes tab-delimited .txt file" change it for the products I needed to have attributes and which ones. and uploaded it. it said product uploaded, but there are no attributes on the product. and if I try to add attributes manually, when I hit insert in brings me to the front admin page. anyone know why this is happening? Thanks
1. Yes you rename the admin folder to match YOUR admin folder exactly. Depending on how you had it installed your admin folder might be something like zc_admin or whatever you have changed it to (it is recommended to change it for security reason if you have not yet done so). so find your admin folder in the root directory you had zen cart installed and change the name to match that. 2. the files would be uploaded to your store root directory, it will not reject it as a duplicate folder it will just add/replace the files needed for easy populate and keep everything else the sameQuote:
Originally Posted by bazaargenie
Sleer,Quote:
Originally Posted by sleer
None of the posted versions of EP have working attribute import. You only have two options for this.
1) Langer's EP 3.0 Advanced, which is a paid version with no support. It's quite questionable if you even receive your product after paying for it. He does allege to have a working import for attributes. Langer fell off the scene several years ago...
2) My BETA EP 4.0 available here:
https://github.com/chaddro/EasyPopulate-4.0
I have tested basic attribute importing and believe it is working correctly. However, this code has not been completed and made "user friendly" ... I do have some instructions on how to use it. Also, my EP4 can be installed along side your current version of EP. It does use CSV files, and you MUST use OpenOffice to export your CSV file for the import script to work. READ ALL NOTES CAREFULLY, AND BACKUP YOUR DATABASES BEFORE USE! That should always be the case, but people forget!
No support for EP4 is offered in this thread. You'll need to PM me for any questions. I'm hoping to get some time this fall to finalize this and get it out of beta, but paying jobs prevails.
-cj
Hi, all,
Using zc 1.3.9h
I already have Quick Updates and Email Archive Manager installed; that's it.
I'm trying to install Easy Populate as well. I put the two files in the root of my admin and in includes/languages/english, but nothing's happening (there's no listing under tools). Is there an additional step to the installation I'm missing?
Thanks,
Pete
There is one EP version that does upload and insert product attributes even when they do not already exist. We got it here some time back, but I just re-downloaded and notice that most of the files are no longer in the download:Quote:
Originally Posted by chadderuski
http://www.zen-cart.com/index.php?ma...roducts_id=460
This has been the most reliable EP I've used. I recently installed it on a brand new zencart/domain...no data base sql to insert:
www.fashion-mart.biz
I uploaded product colors the other night, inserting them when they did not exist. (You do have to assign an attribute id no.) As I recall, with "regular" EP versions, you had to manually enter the attributes into the admin before uploading the product/attribute sheet.
This EP version is also great in that you can DOWNLOAD by category...don't have to be all or nothing.
Only thing is, it didn't generate the attribute spreadsheet properly. We found out that we could use the attribute spreadsheet generated by regular EP 1.2.5.4.
Anyway, I'm here at EP thread as I need a meta tag sheet, so I'll install a "regular" EP version on a test site to get the download sheets.
I would be interested in the EP that apparently allows one to insert additional fields in the admin. Would that work for the CEON URL Mod I wonder?
sph
www.prommart.com
www.fashion-mart.com
Zen Cart v1.3.8a
Unknown site addons/customizations.
------
Info: I just started working with a company that uses zen cart and easy populate for their store. They are a rent to own company, and so every item has weekly, monthly, and cash options using radio buttons. They set these options' default state manually when they create the product.
Problem: They downloaded an easy populate form, changed the prices, and re-uploaded the form. However, the upload caused ALL of their items to be set to 'active', and cleared the default state on their radio buttons. I have looked all over the place and haven't found anything resembling this issue anywhere.
They have been using the model/attributes tab delimited text file.
Possible Solution?: I think they can circumvent the inactive to active item setting by downloading the full (no attribs) file, and copying the status column, then downloading the model/attribs file and pasting the status column into it...however there is nothing anywhere for the radio buttons' default states. Shouldn't easy populate NOT alter things that aren't included in the text file? I.E. if status isn't a column in the uploaded file, shouldn't status not be touched one way or the other?
I appreciate your time and hope to hear back on this soon :smile:
Also...I'm posting as a reply - is this one thread used for ALL easy populate issues?
Thank you for reply I have changed max_execution_time = 360 it is still not working . Please help againQuote:
Originally Posted by chadderuski
I get data from my vendor in a completely different order than in the easy populate column format. Does easy populate just look for the header names in the column?
Put a different way it would be far easier for me to take my data form my vendor, chop out a column or two, label them with the easy populate column names and import than try to paste the vendor data in in the order that the columns appear in the template for easy populate.
Does the order of the columns matter or does the import script just look for the column names regardless of order?
If you are using 1.2.5.4, order should not matter except perhaps for the categories. EP processes by column headers. You will need the EOREOR column.Quote:
Originally Posted by rolo550
your host may be limiting you and killing the process despite your over-ride.Quote:
Originally Posted by sunriseimports
try to break the file up into smaller chunks, say 2,000 a pop and increase until you start to time out again.
else contact your host and trouble shoot with them.
my beta version supports product and category meta-tags and also multi-lingual category names. it installs independently of other EP versions, and also has download filters.Quote:
Originally Posted by SPH
i completely rewrote chunks of code, hacked out much garbage and archaic code, cleaned up and fixed many known bugs, and combined good code and ideas from several coders:
original OSC version, langer, phazie (spelling?) and myself. jrobeson at github also had a sophisticated version, but I believe it's requires zenmagik now.
i wrote attribute handling from scratch (some inspiration from "Attributr") ... still not quite done!, re-wrote and re-conceptualized category importing to support languages and meta-tags.
added many useful fields, and also wrote category-breaks. oh, and two custom fields for price_uom, and products_upc.
still needs spit and polish, and attributes to be rounded out for completion. there are several problems with zencart's attribute model that make importing and creating attributes from
scratch a challenge, so I do have a limitation or two that I spell out in the documentation. there is a logical way to solve these problems, but would require major core file changes involving
attributes.
give it a try, perhaps you'll like it!
-cj
So I finally figured out how to install Easy Populate (YES!!!). Now I have a question regarding how to populate.
My vendor has files that I can download to import and they say I can also use as a data feed, but do not know how. Here is my issue. There are 4 files.
File 1 is an excel file with the current price list with product, weight, price.
File 2 is an excel file with newest items only with product, weight, and price.
File 3 is an excel file with product description including category and image file name (category section is one column with categories separated by commas).
File 4 is a pipe delimited options and attributes of the products.
Then there are numerous image files.
So, my problem is I do not know how to configure it all to import with EP.
Am I supposed to configure each of these files myself to follow the v_... that EP says to do or combine them all into one file or what? Or am i to use them as a data feed and if so how?
I am absolutely clueless how to do this and need as much help as I can get.
Thank you,
Lee
Quote:
Originally Posted by OhSoNew
Have you seen my WIKI tutorial?
http://www.zen-cart.com/wiki/index.php/Easy_Populate
Schoolboy,
Yes, I read through the entire wiki tutorial and it is helpful. I get the basics how it works, but my vendor having 4 separate files throws me off.
If one file only has the product model, name, weight, and price and I import that, i'm missing the description and category. So how would I get that part from the other file in there? Am I just uploading all 4 files and easy populate just matches all the information up?
Also, their category column is different. It lists their categories like (wedding, wedding-favor, paperweight...) it is one category column with the categories separated by commas. Do I have to delete that and make my own categories using v_.... or will Easy Populate read that category column with the columns and set it up accordingly?
Also, that one pipe delimited text file with the options and attributes is confusing. It opens in notepad and just has (A|EB1037|label_type|radio|<strong>Label Type</strong>|0|0|1|||1|0) and when opened in excel it shows the same thing all in one column, so how do I import that file with EP?
Like I said, I am just new to all of this and am just having a hard time understanding how this works, so any step by step or dummied down instructions you could give me would help. I went through the tutorial and everything made sense, and then I saw my vendor's files and all the sense went out the window. Please help!
Thank you,
Lee
OK... here's the beef...
1. Easy Populate is relatively INFLEXIBLE when it comes to the format of the EP upload file. It has to have a certain structure, and some fields are obligatory - my Tutorial highlights all of this.
2. So forget about EP at this point... your PRIMARY challenge is getting all the data (currently in a mish-mash of csv and "pipe" delimited formats), into one single file.
This requires a knowledge of spreadsheet formulae, and you will need to do a variety of (possibly detailed) cross-lookup functions, and possibly even a pivot function or two, to get the different spreadsheets to "amalgamate".
Unfortunately, this is not a zencart issue, and you would be better getting help on forums that discuss the operation of formulae in spreadsheets.
You will not be able to begin the structuring of the EP sheet until you have merged all relevant data.
... I would add that you should kick your supplier in the a$$ and insist they provide the data in a way you can use it.
Generally they can... all they need to do is configure and export using the fields you require. If they are using SAP, or something similar, getting it to output a report (export) is not that complex.
They may tell you "it's not possible"... but don't roll over to have your tummy scratched. BARK LOUDLY at them and tell them that THEY will benefit (from sales) just as much as you will, so it is in their interests to assist you.
Thank you. At least i'm not super crazy in thinking them putting 4 different files is dumb. Nonetheless, I did attempt changing the column headings on the product description file and imported and it did work. However, it appears it is going to be quite a challenge as I will have to compile my own category columns as theirs is BS, which means a lot of work figuring out categories for 400 plus products that can go into multiple categories (for example one product can go into wedding favors, baby showers, bridal shower category etc.). This is just too time consuming.
Then there is the matter of products having multiple pricing tier. For example, one product can be purchased in different quantities. If they buy 1-11 products each price is XXX. If they purchase 11-20 the price is XXX. How would that work? The quantity with respective pricing is in the excel sheet, but how would I label the columns to have EP import that information?
It is just too much. Is there anyone out there willing to do this and I will pay? lol Seriously.
Hi ,
I get this message :
An SQL error has occured. Please check your input data for tabs within fields and delete these. If this error continues, please forward your error log to the Easy Populate maintainer
and I think I know where Ive gone wrong.
Ive added 4 new fields to the database :
products_supplier_code
products_gb_code
products_price_markup
products_priceWS
and tried to reference them all in EasyPopulate.php, but I think I have the following part (the update (insert into or update) part) wrong...would one of you wizards please check for me and Ill magic a pint of beer over for them!...Thanks.
code is: (my additions are in red)
$query = 'UPDATE '.TABLE_PRODUCTS.'
SET
products_price="'.zen_db_input($v_products_price).
'" ,products_image="'.zen_db_input($v_products_image);
// redundant image mods removed
$query .= '", products_weight="'.zen_db_input($v_products_weight) .
'", products_supplier_code"'.zen_db_input($v_products_supplier_code).
'", products_gb_code="'.zen_db_input($v_products_gb_code).
'", products_price_markup="'.zen_db_input($v_products_price_markup).
'", products_priceWS="'.zen_db_input($v_products_priceWS).
'", products_tax_class_id="'.zen_db_input($v_tax_class_id) .
'", products_date_available= ' . $v_date_avail .
', products_date_added= ' . $v_date_added .
', products_last_modified=CURRENT_TIMESTAMP' .
', products_quantity="' . zen_db_input($v_products_quantity) .
'" ,manufacturers_id=' . $v_manufacturer_id .
' , products_status=' . zen_db_input($v_db_status) . '
WHERE
(products_id = "'. $v_products_id . '")';
$result = ep_query($query);
if ($result == true) {
$display_output .= sprintf(EASYPOPULATE_DISPLAY_RESULT_UPDATE_PRODUCT, $v_products_model);
foreach ($items as $col => $langer) {
if ($col == $filelayout['v_products_model']) continue;
$display_output .= print_el($langer);
}
} else {
$display_output .= sprintf(EASYPOPULATE_DISPLAY_RESULT_UPDATE_PRODUCT_FAIL, $v_products_model);
}
}
In what TABLE did you add these fields? They may need to go into the products table.
Then, look at the post by LANKEEYANKEE that shows how to ADD FIELDS TO EASY POPULATE (search for that thread.)
If, after following his method, you still get errors... ask your vicar to seek help from a higher authority...
Problem solved...(I think) I didnt follow this:
http://www.zen-cart.com/forum/showthread.php?t=57924
Sorry Schoolboy didnt see your response.
Ive added all fields in product table, I have them all working now apart from one thing.
One of the fields is wholesale price, one is a % field. The price field is populated by a formulae between these fields , basically giving a , say, 25% markup on my wholesale price. now THATS the bit I cant get to work yet.
I have all field showing on admin so I can add one test product in Admin with all the fields, then I download an ep file with the one product in. When I add another product in the EP txt file and try to upload it it gives the SQL error and suggests I look to see if I have any spaces in my cells (or something like that)...
Sorry if that makes no sense at all, Ill post the solution when I find it!:frusty:
Thanks Again
Hiya OhSoNew!Quote:
Originally Posted by OhSoNew
I think that I can help you with your multiple issues, but you would need to use my EP4 beta version. I call it beta, but it's very stable. I have several avid users doing 100K item imports/updates with it... but they probably are on either a VPS or running a full server. I can help with the tier pricing (which I wrote myself), categories in one field, and I have a "way" to do linked products that seems to work okay ... as long as you work within restrictions.
Also, there is a cool little Excel script that I use for doing things like sorted matched merges on multiple tables provided you have a common column to key on.
Please send me a PM. Your issue is too complicated to solve in this forum and I'll need to see your data. You can install EP4 along with 1.2.5.4. They are completely independent, so you won't break anything doing so.
https://github.com/chaddro/EasyPopulate-4.0
LOL! Schoolboy! My day job just made the move to SAP! The stories I could tell about the cluster-fudge this move has been!
-cj
Okay I think this is the right place to post my question. I have the files in the /temp/ folder of my site but I can't import them using EP. i just keep getting reverted to the login screen. I have tried switching browsers AND refreshing my cache, I look and I don't see any errors in the error log. I am not sure what to do. I am on a linux server and both my admin and temp folders have 755 permissions.
What files are you talking about and how did they get there?Quote:
Originally Posted by autumnlights
Does temp have 777 permissions?
yes temp has 777 permissions and its the .txt product files the sample ones and the one that I uploaded using FTP from my vendor. I can't get either to load on a linux server.
Are you using https for all your admin access?Quote:
Originally Posted by autumnlights
I believe ep 1.2.5.4 has problems when you set your admin to https and results in kicking you back out to login.
try changing your config.php for your admin and remove https.
let us know how that works.
i uninstalled and reinstalled everything. I ran it on my other server that's powered by Debian (I have two hosting sites) and it was able to upload the files but nothing populated to the tables. I manually broke the files up and got the same problem. I think there is a functionality issue with running on Linux with Hostgator but iPage I had no problem's uploading on Debian.
In regards to my previous question, I have crafted a solution together. For those of you who are trying to use easy populate with products with attributes - it seems that EP operates like this when uploading:
Step 1: Delete all items (and their attributes) from the database.
Step 2: Insert all items into the now 'empty' database, and set them active by default.
The issues with this are that:
(A) All inactive items are set active - and status isn't included in the attributes download - therefore items you have inactive (say for records/bookkeeping purposes) are set active and there's no check to set them as inactive.
(B) If you have products priced by attribute, you will have to turn around and manually set each item's default attribute or you will end up with order for items that total $0.00
How I fixed this:
Quote:
Search for:
And change "true" to "false"PHP Code:if ($products_with_attributes == true) {
//include attributes in full download if config is true
// VJ product attribs begin
(In my file it was around line 400)
What this has done, is force the attributes to be included in the full download (The one that says "Attributes Not Included"), so you can update their status, their attributes, etc. without having to download/upload two files.
While there is most likely a multitude of ways to do this...this is the way I was able to finally get it to work. I have minimal amount of PHP knowledge to still be able to say "Yeah...I know some PHP", and the file I have to work with was already heavily customized. (There are entire BLOCKS of code that have been commented out, as well as what seems to be a running conversation in parts of the file via comments as well.) So this has been one frustrating experience. I hope to relieve some of the frustration others might experience.Quote:
Search for
And comment out those two lines of code.PHP Code:$attributes_clean_query = "delete from " . TABLE_PRODUCTS_ATTRIBUTES . " where products_id = '" . (int)$v_products_id . "' and options_id = '" . (int)$$v_attribute_options_id_var . "'";
ep_query($attributes_clean_query);
(In my file it's around line 2180)
What this does is it kills the whole "Let's delete all the data and start fresh, even though we're not going to update the default_attribs value" process.
Help!!!
I have done something very silly!! I have uploaded an old txt file in error and now it has updated and added files going back to June.
I don't have any recent txt files and wondered if anyone knows how to restore what was in my previous backup if this is possible. I have no idea where to start.
I really hope someone knows the solution otherwise I will need to go through all of my items and check each one individually :no:
Thank you!!
I apologize if the question has already been done, but I can not find it.
My site2 is the mirror of site1; some products on site1 was deleted, and when I import data on site2, the products deleted on site1 still remain alive on site2. Is there a way to delete (or mark as red) the products that not imperted from site1? I hope I'm clear
I have installed the EP, but when I click on it under the tools, it is just a blank page. And when I click on it under the configurations, it is a blank page with headers.
What is wrong with it? I am missing something?
I was not successful installing manually, so i did the sql ptach, and still did not work.
Any ideas will be greatly appreciated.
Thanks
I haven't used Easy Populate for awhile until now because Apsona isn't working on my new server.Quote:
Originally Posted by drago
But, it sounds like all you files didn't upload correctly. I'd try uploading them again and then check.
Hope that helps.
Gary
Thank you sir.
That worked just fine. I think i was missing something.
But my next question is... I able to upload, it says new product in green, however, when i look at the site there is nothing there, and nothing on the products tab on the admin. But the interesting thing is that a new category was created.
Am I missing one step?
so I feel liek my importable file is ok, but all I get is a pile of errors
like
SKIPPED! - Model: - No category provided for this product | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | 5.11 THU | Holsters | 51.6 | 1 | 26 | Thumbdri | 5.11 Tacti | 50023 | | 5.11 Tacti | 511-50023_ | Taxable Go | 1 |
When trying to import - on every single item...nothing imports...using the browse to file/upload option
Attached is a data sample....
http://www.zen-cart.com/wiki/index.php/Easy_PopulateQuote:
Originally Posted by rolo550
Thanks for pasting in the link, but what are you trying to tell me? I was told column order didn't matter...is that what my issue is and you are trying to tell me?
I'm grateful for your taking the time to read my post but a little more specific pointer could be helpful
Hi
I normally find the answer to any problems I have in this forum, but this time I haven't had any luck.
I use Zent Cart v1.3.9d + Easy Populate 1.2.5.4
I haven't made any changes between Easy Populate working and it playing up. My site has been running for over a year.
I thought EP was not working at all at first, but after investigating I realized it will amend existing products but will not add new ones.
UPDATED! - Model: 100001 | Saa_og.gif | Skill at A | Skill at A | | | | | 1.75 | 0.003 | 1 | Garrison P | Qualificat | | | | | | | Taxable Go | 1 |
UPDATED! - Model: 100002 | Saa_og.gif | Skill at A | Skill at A | | | | | 2.75 | 1.003 | 1 | Garrison P | Qualificat | | | | | | | Taxable Go | 1 |
ADD NEW PRODUCT FAILED! - Model: ma073 - SQL error. Check Easy Populate error log in uploads directory
If anyone can suggest what I should try to fix this I would be very grateful.
I can't teach you how to read... but your error says:Quote:
Originally Posted by rolo550
"No category provided for this product"
Seriously... you can't get a more simple report than that...
My tutorial illustrates how category issues are handled.
Again... simple READING tells you:Quote:
Originally Posted by MrsDusty
Check Easy Populate error log in uploads directory
I have pasted the error log below, but I have no idea what it's telling me.
MySQL error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''
products_quantity,
manufacturers_id)
VALUES (
'' at line 11
When executing:
INSERT INTO zen_products (
products_image,
products_model,
products_price,
products_status,
products_last_modified,
products_date_added,
products_date_available,
products_tax_class_id,
products_weight,
products_quantity_order_min'
products_quantity,
manufacturers_id)
VALUES (
'MA073.jpg','MA072',
'1.8333',
'1',
CURRENT_TIMESTAMP,
"2010-07-15 19:30:00",
NULL,
'1',
'0.001',
'2',
'1000',
'17')
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_products_quantity v_manufacturers_name v_categories_name_1 v_categories_name_2 v_categories_name_3 v_categories_name_4 v_categories_name_5 v_categories_name_6 v_categories_name_7 v_tax_class_title v_status EOREOR
ma073 MA073.jpg ITW Grimloc GhillieTEX IR signature reduction technology. Corrosion resistant stainless steel spring. Self purging ports to prevent sand blockages. Attaches to 1 inch webbing. Textured grip for use with wet/gloved hands. Lightweight: 0.01 kg 3.75 1 1 Garrison PRI Qualification Patches Taxable Goods 2 EOREOR
It might be that the insert statements lack a final delimiter...
Line ELEVEN is the final line:-
'17')
The last line should have a semi-colon as the delimiter
'17';)
Just why it is not inserting the delimiter is not something that can be answered without knowing a lot more about your setup.
Perhaps DrByte will chance on this thread and offer us possible reasons. It could be that your EP files have become corrupted.
You might be able to rectify the issue by loading fresh EP 1.2.5.4 files via FTP.
Thank you. I will try a new upload of EP and see if that helps.
You were spot on. A new install and it's behaving like a dream.Quote:
Originally Posted by schoolboy
No one suggestion for my trouble? Must I full delete my sql products table and then import by easy populate?Quote:
Originally Posted by 100asa
Quote:
Originally Posted by 100asa
Product information is put in MANY places in the database.
You should use Easy Populate to create a DOWNLOAD of all your product data.
Then, to DELETE product data, you edit the spreadsheet to change v_status to 9 for all products you want to delete. Then you "run" that file through easy populate.
Hello I am using easy populate but for some reason when you load the file prices that have a value example $2,520.99 will load on my site as $2.00. It seems to me that easy populate sees the Comma (,) in larger numbers as a decimal point.
Any suggestions Please,
Thanks
Lexxie
I don't understand why everyone has to be such a smartass in this forum. I looked over your tutorial searching for category and categories and its just general info with "fix it" if you get errors...Quote:
Originally Posted by schoolboy
If one looks at the file i pasted in, one will see that I have clearly defined a category column...so that leaves us with why is it not being pulled in...I realize its says "no category" in the error, but why? I have the categories name column in my file and every single product has a category assigned...
Rolo, your problem is quite elementary: You have NO v_products_model column. This column is mandatory in order for EP to work as it is the main key the script uses for either adding or updating product information. This is clearly stated in the wiki.Quote:
Originally Posted by rolo550
If you do not want to use products_models, then you cannot use ep 1.2.5.4... you will have to look for Langers' Easy Populate Advanced 3.0.3 PAID module who has unfortunately fallen off the scene for years now... but his site still seems to be up... (!?!?!?) just be aware that you MAY NOT get what you pay for!
NOW....
Before accusing Schoolboy of being a "smartass" please note his 7,248 postings since 2005. He is one of a very few number of people that come into this forum, and also this thread to offer FREE unpaid support for people on a nearly DAILY basis... Quite a few people contribute from time to time, but very few are hear daily. Also, this thread is nearly 3500 entries long... with MANY of the exact same issues being repeated over and over. I think you can understand how one can become exasperated - which I've seen happen to the point that an avid supporter drops off the boards.
Schoolboy wrote his WIKI to help stem the flood of questions until someone writes a better module. (which BTW I've partly done... EP4 beta is posted at GITHUB)
So, be kind, and rewind on that statement! :P
-cj
No I get it, I mean, I feel how people repeat questios and all, but literally every time I have posted anything, the responses have been caustic...I'm on dozens of forums and this one is by far the nastiest...i get it, I'm a noob and <insert poster> is the all knowing God of this small little world - yes I don't know ########, and no i cant find this answer anywhere else, and yes maybe it is posted and I missed it - but I have looked sorry..there is no excuse for all the snottiness tho...I respect what people are doing here, totally, and I appreciate it and am grateful, but its just unnecessary is all I'm saying, I appreciate much schoolboy and his ilk...
Now that that is aside, I do in fact have a vproducts model column as well...I'm sorry if my file is confusing, maybe you didn't see because its out of order? I read order matters not, but maybe it does? I haven't had time truthfully in like a week or two to mess with it...I need to just paste it in the order of the sample...my error is category based though, and again, I did put categories, so that is where I'm getting confused... Thanks a million for the response...
Rolo,
I think your best bet is to do an export of your products after you have entered some manually through the admin.
This will give you the layout of the file. Maybe this will help you identify the problem.
You should be able to do an Export, then turn right around and Import that same file (without ever opening it!),
and it should import just fine. Do this, and let me know what the outcome it. If this file Uploads without
error, then you definitely have something wrong in your posted file.
Also, better to work with just a couple lines at first until you get the hang of it.
Okay, I looked at your posted file again and I see you did include v_products_model. I usually keep them in order, but that's just me. Sorry. It does come up though!
However, I see that you have two empty columns. Don't know how EP 1.2.5.4 is going to react to that. You have no column heading for the column after v_products_quanty, and the
column after v_products_model.
ANOTHER potential problem is that you have "data" in the empty columns AFTER the EOREOR column. Yes, nothing there but spaces, but these spaces will break EP 1.2.5.4. Open your spreadsheet and hi-light a dozen or so columns AFTER your EOREOR column and delete them. Do the same thing at the bottom of your spreadsheet for any blank rows. This is more than
likely your issues.
The parser langer wrote uses EOREOR to mark the end-of-record,end-of-row. It's doesn't really respect the end of line or carriage return characters because these can be different on different
operating systems. But what happens is that next empty data after EOREOR becomes the first element for your column 1 entry. It shifts everything out of order and breaks the script.
Fix these two issues and post back the results.
-cj
GADZOOKS!
On thirds look, you have several dozen empty columns you are importing. You may be better off hi-lighting your data columns and pasting them into an new empty sheet.
Must be 30 or 40 empty columns there!!
Lol @ gadzooks...don't hear that exclamation often...Quote:
Originally Posted by chadderuski
Ok I think im goind to not try to take my data file and paste in the headings, but instead take the EP headings and paste in my data...
I need to just start form the start again...I should have done that already...
I was kinda hoping to avoid the big pain in the ###### of having to paste column by column, instead just opening my data, which changes almost daily, and pasting in the headings, but it appears i need to just do it the long way...
Thanks for the response, much appreciated...ill follow up
I'm planning on attempting to use just the Model/Category text file generated in EP to move products between categories. Does it work like I hope - on an upload of the modified file, EP will look up each model# and change the master category ID for each?
This is unlikely to work... At best, you will just find that EP DUPLICATES the products - possibly turning them into a LINKED product.Quote:
Originally Posted by fakeDecoy
It is possible to add the MASTER CATEGORIES ID field to EasyPop, and this may be the better option.
Search for "Add Fields To Easy Populate" by LANKEEYANKEE
Quote:
Originally Posted by Alexiss View Post
I got it. UPC/ ISBN now works. Question is can I do this for manufacture image? Is there any extra step i would have to make.
Thanks
Lexxie
I really need some help with this. How can I make it to also import images for manufactures? Do I do the same thing? How do I tell easy populate how to import the image and where to import it? I really need to be able to do this cause I have over 1000 venders that have manufacture logo. Please any one who can help. I am not a programer but I am learning all that I can.
Thanks,
Lexxie
I have posted a few post with no luck getting help yet. Maybe I am posting in the wrong place.
My question is I was able to add additional fields to my easy populate. I need to add one for importing manufacture images. But I am not sure if it works the same by just adding p.manufacture_image in the same way as adding p.url. How do I tell it where to import the image and what file it is pulling from.
Thanks
Lexxie
Hi,
I've never used this mod and am about to install ZC 1.5 on a test directory in the hopes of moving it to my main site. I see there is yet no version of this mod for 1.5, but assuming one will soon come out, can I create the spreadsheet in the meantime? I figure that part wouldn't change, right?
Cheers,
R
I'm posting this here to let visitors to this thread know about my recent experiences with APSONA.
I have (and may remain) an advocate for Easy Populate (1.2.5.4 and the commercial Ver 3.)
When Apsona introduced their Store Manager some years ago, I was invited to trial it. At the time, I was cautiously in favour of it.
This week, we were presented with a mammoth project, uploading over 3,000 products to a database, and with most having between 50 and 100 separate attributes. The data came from the supplier in a simple linear format (Excel), with every product variation allocated a product code.
That's a dbase with over 150,000 product options!
After examining a range of data-loading alternatives, including, bespoke SQL queries, EP 3, and even hiring an army of temp workers, I decided to load Apsona.
Wow... it has matured and improved since I tried it a few years ago.
The good news is that (using pivot table functions in Excel and a variety of other formulae), we will be able to load ALL products and ALL attributes in probably a couple of hours.
I think I might just abandon EP completely now, in favour of Apsona.
Interesting SB. I tried Apsona relatively recently and was underwhelmed. Perhaps I'll try it again.
After recently adding 3000 products to my store, I know what a task this is. I'd love to know the processes you took and the formulae. Any chance of an explanation?
Well... each person's needs are unique, largely because the data one works with tends to be uniquely compiled in a spreadsheet.Quote:
Originally Posted by wizer
So I cannot give a "one-size-fits-all" tutorial on this.
The key to our solving the issue was to FIRST understand how APSONA handles data imports... and then to work BACKWARDS, getting OUR spreadsheets to comply with Apsona's format.
We watched all Apsona's video tutorials, and quite quickly determined how their system operates.
Then it was a case of getting our data into the same formats.
This does require a fairly good knowledge of Excel formulae, and how to create "pivot" tables to show the data's internal relationships.
Our supplier's spreadsheet listed EVERY product, replicated for each possible option value;
eg:
51400 - - Diningroom Table - - Beech - - 2000mmX1000mmX900mm - - Bevelled Edge
51401 - - Diningroom Table - - Beech - - 1800mmX1000mmX900mm - - Bevelled Edge
51402 - - Diningroom Table - - Beech - - 1600mmX1000mmX900mm - - Bevelled Edge
51403 - - Diningroom Table - - Beech - - 1400mmX1000mmX900mm - - Bevelled Edge
51404 - - Diningroom Table - - Oak - - 2000mmX1000mmX900mm - - Bevelled Edge
51405 - - Diningroom Table - - Oak - - 1800mmX1000mmX900mm - - Bevelled Edge
51406 - - Diningroom Table - - Oak - - 1600mmX1000mmX900mm - - Bevelled Edge
51407 - - Diningroom Table - - Oak - - 1400mmX1000mmX900mm - - Bevelled Edge
51408 - - Diningroom Table - - Beech - - 2000mmX1000mmX900mm - - Round Edge
51409 - - Diningroom Table - - Beech - - 1800mmX1000mmX900mm - - Round Edge
51410 - - Diningroom Table - - Beech - - 1600mmX1000mmX900mm - - Round Edge
51411 - - Diningroom Table - - Beech - - 1400mmX1000mmX900mm - - Round Edge
51412 - - Diningroom Table - - Oak - - 2000mmX1000mmX900mm - - Round Edge
51413 - - Diningroom Table - - Oak - - 1800mmX1000mmX900mm - - Round Edge
51414 - - Diningroom Table - - Oak - - 1600mmX1000mmX900mm - - Round Edge
51415 - - Diningroom Table - - Oak - - 1400mmX1000mmX900mm - - Round Edge
(and it went on for a total of about 100,000 lines, across 20 datasheets)
So, using PIVOTS, we could establish just how many attributes needed to be set up (Pivoting will achieve this).
Then, we created a set of DUPLICATE sheets. One set was used to build the product info. The other was used to build the attribute info.
Ironically, while there is no mechanism in ZC to list attributes by product CODE, the fact that the supplier had given each product variation a code actually helped us - as it ensured that after we SPLIT the work (attribute sheets / product sheets), we still had a unique identifier in both sheets.
Later, we will have to lose the suppliers codes - but they were very helpful to start with.
Very good work. Thanks for explaining. Will definitely have a look (after I fix this bloody paypal issue)
I am having a strange issue...
First of all, easy populate works. It gets products up to the cart and downloads them fine as well. The problem comes when trying to Search my products in the admin section. I get no results of the products uploaded by easy pop. There are other products in the store and queries all seem to work with them. It just seems easy populated products are invisible to it.
Known issue? I have searched the forums and this thread as well with no luck.
Thanks!
using zencart 1.3.9d
ok i got easy populate to install, and am able to generate the files. but when trying to populate the file i get a 500 Internal Server Error.
any ideas?
-Stephen
Hiya Schoolboy!
I think my EP 4 would have done what you needed. The basic attribute import lets you associate an attribute by product code one per line. So as long has you know your product codes, you can build the attributes at import, and even apply multiple attribute (like size and color) at import.
Perhaps the only caveat is that you'd need to name your attribute options, i.e. "Color" ...
-cj
Under Tools -> Store ManagerQuote:
Originally Posted by Phaylon
Try running Reset ALL Products Master Categories ID and Update ALL Products Price Sorter.
And that solved the problem! Thanks for your help chadderuski!Quote:
Originally Posted by chadderuski
Hi,Quote:
Originally Posted by chadderuski
I just tested your EP4. It looks very good but for one glitch which I'm having with another EP.
We now need to use the meta tag function. The full upload with metatags goes good. However, when we upload our color/attribute sheet it wipes out the metatags, leaving a blank metatitle in View Source.
Same problem with the EP with group pricing and metatags we also recently tested.
Any idea why an attribute upload would wipeout the custom meta uploads?
Only solution so far that might work: use your EP4 for full/meta uploads. Then use our old and extremely reliable EP from OSC for the colors/attributes...which looks like it may work, but unweildly. My initial test with attributes/colors did not wipeout the metas. The fact that your EP4 is independent from other installed EP's may allow two EP's to function, using different sheets.
Thanks.
sph
Test Sites
www.prom-mart.com
www.wedding-mart.com
Also re-visiting Apsona after testing a year ago. Maybe it's an/the answer, but for some reason I still don't understand its import/export enough to get it to function properly.
sph
The principles are pretty standard in the world of database populating. Like practically all these systems, Apsona requires you to ASSOCIATE the fields in your spreadsheet (or csv file) with the fields in the database tables.Quote:
Originally Posted by SPH
It says: "Hey... you are showing me the following columns, where the column headers are 'ABC', and 'DEF', and 'GHI'. In my database, I also have a field called 'ABC', and another called 'GHI', but I can't seem to find one called 'DEF', so here's a dropdown list of tables that I do have and now you need to tell me which of MY fields matches up with your 'DEF' column, and then you must SELECT that field so I can associate your data with my structure..."
The nice thing about Apsona is that you can be very flexible in the selection of fields, and it also VALIDATES all the data before loading it.
Thanks, I'll study Apsona some more. Playing with it yesterday, I think I have the general idea, things just didn't go correctly. It does look like it will do everything I'm trying to do with the various EP's.
I just don't understand why the EP's with meta support get the metas turned off doing an attribute upload; perhaps a column is not correct. We could never trust such a situation, never being certain that our meta titles are on without constantly checking.
Unfortunately, when the upload turns off the meta titles, it does not default to the zencart metatitle using product name. Just a blank meta title in View Source.
Hopefully, Apsona will not do the same.
1.3.9h
i have successfully loaded my categories via my template. if i make an addition..new cat and sub cat with entirely different names.. the existing sub cats are loaded again so i end up with duplicate sub cats for the cats that were already there. luckily the top level categories dont duplicate just the sub cats. why is this happening and how do i stop it? thanks in advance.
Hi SPH,Quote:
Originally Posted by SPH
I haven't looked at that code in some time, but I do not see how that could be happening. If you could PM me and include the some sample test data that would help. The attribute import code doesn't touch meta-tags, so I find this really odd. Please send me some of your test data for testing and I'll look into it.
Group pricing with metatags? I'm not familiar with this ...
Thanks for the reply! It's midnight now at my end so I'll PM something tomorrow.Quote:
Originally Posted by chadderuski
The other EP we recently tested and first discovered the missing title tags is the 1.3.9.gp.meta.f downloaded here:
http://www.zen-cart.com/index.php?ma...oducts_id=1424
Haven't yet seen its support thread.
Just discovered your EP4 here on this thread. One really great function you have is the ability to download by category, rather than the entire site. Similar to our old Easy Populate for OSC 2.77H also at ZC downloads. Very reliable but lacks meta support.
BTW, finally got Apsona full sheet to work; I overlooked final submit button to upload. But looks like attributes import doesn't readily work, so may not put further effort in to it.
Your EP4 looks exactly like what we'd like.
Later.
sph
This is my reply to a question regarding problems with my meta tags.
I believe my problem lies with Easy Populate as explained below.
I checked my Meta tags the next day and again they had reverted back to No. BUT, I beleive I found the problem this time, I realized that I had done a easy populate of my site, which I do about 4 times a week, Just the day before.
So what I did is revert all the meta tags to yes and auto populated my site again and Voila the meta tags on 285 items out of 823 had reverted back to No.
Now the problem is I don't know why. I'm trying to study the script to see if there is anything there that is returning meta tags to their default settings.
Would anybody out there know if this is at all possible and if so what is the remedy. :cry:
My site is www.tte.ca
I am using EP 3.0.3 and found a problem:
I search my store for an item (using model#) and find nothing, but every time I download the store file, I would see the item in there.
I also search the item in admin/catalog and cannot find the item either.
Whats the problem and solution?
Thanks
Hi,
I have been searching for hours and hope you can help.
zc - v1.3.9h
ep - 1.2.5.4
I am having trouble with quantity discount attributes.
I am unsure how to have products with prices for:
1-5 ... $2.00 each
6-10 $1.75 each
11-15 $1.25 each and so on.
I have no clue how to implement this into ep.
I have over 10k items and each have different price discounts for quantities purchased.
Thanks,
Kevin
Hi All,
I've just uploaded Easy Populate and I tried to upload one product for a test. Now I have this error message when I go into the sub category where the product should be and I don't know how to get rid of it??
Help?
Anyone?
Please?:dontgetit
Can't create/write to file '/tmp/#sql_446f_0.MYI' (Errcode: 28)
in:
[select p.products_image, pd.products_name, p.products_quantity, p.products_id, p.products_type, p.master_categories_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, pd.products_description, IF(s.status = 1, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status =1, s.specials_new_products_price, p.products_price) as final_price, p.products_sort_order, p.product_is_call, p.product_is_always_free_shipping, p.products_qty_box_status from zen_products_description pd, zen_products p left join zen_manufacturers m on p.manufacturers_id = m.manufacturers_id, zen_products_to_categories p2c left join zen_specials s on p2c.products_id = s.products_id where p.products_status = 1 and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '1' and p2c.categories_id = '40' order by p.products_sort_order, pd.products_name]
EP does not handle quantity discounts. These are in a separate table, not associated with the EP structure.Quote:
Originally Posted by kevinoneil68