Yes. This is the latest on github. I will try to get the new work posted this weekend.Quote:
Originally Posted by SPH
-chadd
Printable View
Yes. This is the latest on github. I will try to get the new work posted this weekend.Quote:
Originally Posted by SPH
-chadd
I'm not quite sure what you are referring to...Quote:
Originally Posted by darthun
Do you mean Category Images? If you want to set category images (and category descriptions and metadata) you need to use the "Categories Only (with Metatags)"
download option.
NOTE: This is a one-to-one export-correct-import. It works off the category id NOT the name. You do not want to alter your category between export/import.
Keeping that in mind, it is very useful for setting all your category information.
Hope this is what you were looking for.
-chadd
yes, i'm trying to fix a category image using easypopulate, but i don't know how.Quote:
Originally Posted by chadderuski
Do you recommend just exporting using easypopulate, and then look at the generated file, and then do the same to link a category image ?
else, i don't understand how.
Thanks chad, :) i just had to export category only and look at how it was done, and import it back. Wow !! this will save me alot of time.
Hello Chadd, just want to say thank you for your work on this version of EasyPopulate, it is so much better than any of the others I have installed, I`ve had to export, and re-import over 100k of products, and it works flawlesly on 4.0
Keep up the great work
Regards
Sam
That's great news Sam! I'm glad the improvements in performance are making a difference!Quote:
Originally Posted by sam_m
I am loading a shop with 4 languages. I am currently filling in the csv file.
My problem is I am using Russian and typing in Cyrillic, when I reopened my file the Cyrillic came up in ????????
Can I upload with a tab deliminated txt file or only a csv file??
Thank you,
Andi
Hi Andi!Quote:
Originally Posted by andiHPI
Awesome, Russian!
Couple of questions: What version of zencart? 1.5 or 1.39? 1.5 is native UTF-8, but 1.39 is Latin1 and will not show your input correctly.
How are you saving your CSV? Are you using OpenOffice and specifying UTF-8?
If you send me a PM and include your sample data, I can check on a testing server with UTF-8.
Thanks!
Chadd
Thanks for all your hard work on this Chadd, it's very helpful to the community. Are there any plans to post this to the Add-ons section for easy finding?
Hi Jackie,Quote:
Originally Posted by jackie.taferner
Yes. I will submit to the zencart team once I'm done with 'beta' ... which is very close. I have been too buried this past week to push to github the new attribute importing tools, but should this weekend life permitting.
I also had a request to add Featured Items to the import/export, which I'll work on after I push these latest changes.
-chadd
really excited about this mod...but i have a dumb question (among my many others thus far! i'm new to zen cart) where IS the temp folder that i'm supposed to rename? i cant find it. am i suppose to create it myself and then name it something clever? and where do i put it? the warning message says it resides here: /home/content/32/9206932/html/. but where is that at??? please help, i feel like such a dork.
thanks!
aloma
www.alomasantiques.com
Hi Aloma,Quote:
Originally Posted by sweetaloma
The default "temp" folder is locate in your root directory, and is specified in the EP configuration as "temp/" (no quotes).
Yes, you are encourage to rename this to something obscure!. The root directory is the same location that you uploaded your site to.
You do have to manually create temp and upload it if it does not exist on your site.
Hope I explained that clearly.
thank you so much! i got it working now...whew <----> :blush:
That's fantastic, thanks Chadd!Quote:
Originally Posted by chadderuski
Hi,
I just installed this on a site and am using it for export only at the moment. I notice in admin/Tools/Easy Populate 4, down the right hand side, there are a number of things listed. In particular there is this...
Custom Products Fields
Product Short Descriptions: FALSE
Product Unit of Measure: FALSE
Product UPC Code: FALSE
Google Product Category: FALSE
Manufacturer's Suggested Retail Price: FALSE
I would like to set the first of those, Product Short Descriptions, to TRUE. Where are the settings that affect these? I don't see anything under the Configuration/Easy Populate 4 menu.
I would also like to export the number in stock.
Thanks for working on this great mod.
Rob
Hi Rob,Quote:
Originally Posted by rstevenson
There are some mods that I have add support for. These are auto detected (the script check the database to see if the column exists). So to use these fields, you would need to install the mod.
Product Unit of Measure (UoM) is my own unpublished mod (may get around to it once done with EP) that lets you ad the UoM to the price: $12.95 ea
Product UPC can be added from Numinix's products fields (not all his are supported here at this time).
The Products short description is quite old. I don't know if it's been updated for 1.39 or 1.50.
-chadd
I see.
I didn't ask the client why they wanted this, but I'm guessing they don't need the entire description in the download. Is there a way that I can customize the script to just use the first 100 characters of the description or something like that?
Rob
It may be possible, but you risk them using this data for the import and truncating any existing descriptions.
As I said, they only want to use this for downloading. I'll take a look at the files and see what I can find.
Rob
hey chadd been awhile!Quote:
Originally Posted by chadderuski
. actually did a native zenmagick version of EP .. but with most of the same code internally for products (for the moment).
I ended up writing importers for reviews, coupons and order status history. I also made it so you could map your own header file format to the internal names via a yaml file.
I never did finish it for export though since i've been busy with zm core dev.
I doubt i'll ever work on a zencart native version of EP again, but i'd still be interested in seeing your code.
(especially since the next version of the zenmagick admin mostly works as a dropin replacement for the zc admin without any file modifications)
Thanks,Quote:
Originally Posted by igi2011
this could make what I am trying to do a little easier. I have the same issue as several others and thought that ep4 could help fix them.
I have noticed that there are several posts on how to change the product type from 1 to 2 and I thought that by adding the fields
v_product_type
v_product_music_extras
v_record_artists
v_record_artists_info
v_record_company
v_record_company_info
v_music_genre
to ep4 would help in the creation of the new products before the old ones are deleted or just to add new products to Product - Music.
Don't know if I am on the right track or not, so I would appreciate your thoughts on this.
If you hold off for just a little bit, I'll be posting soon with complete support for products type 2 for music (and also supporting the artists and record company info).Quote:
Originally Posted by awhfy99
Initial testing looks good, but I need to comb through the code a bit more. Just give me to Sunday!
-chadd
I will do.Quote:
Originally Posted by chadderuski
Looks like I posted the fields before I throughly checked the db structure, which I'm sure that you noticed!
Thanks for not exposing my oversight!
Hi,
I have issue with inserting subcategories.
I have added subcategories in .csv file but however its not working.
Here is the .csv attached.
Can you tell me what is the issue?
Hi,Quote:
Originally Posted by nlinksolution
You should read the first post over again carefully. One of the main changed from 1.2.5.4 to 4.0 is the category handling.
Your top level category, and subcategories are now concatenated under v_categories_name_1 like this:
Skincare^Body Care
v_categories_name_2 would refer to the second installed LANGUAGE, not a sub-category as in 1.2.5.4. This allow people to actually populate a multi-lingual store and have the category names language appropriate.
Hope this helps!
I have gotten all my languages to work using open office. Thank you so much.
Now my question is , I have 500,000 products in four languages. I have learned that I can break it into 50,000 items at a time and upload via http, and then have EP break the file and run each one of those. Is there any easier way to upload?
Hi!Quote:
Originally Posted by andiHPI
What you can do is upload your main file of 500,000 products, and then use the Split function to break into 50,000 record chunks. Just be sure to check your Configuration->Easy Populate 4 settings so that "Split on Number of Records" is set to 50,000.
You will also want to set "Verbose Feedback" to false to save on memory and speed up the import. You will still get warnings and error displayed on the screen.
What four languages are you using?
-chadd
The Http upload will only allow 32 MB files, the 50,000 item csv files are 29 - 30 mb. That is my big question - Can I ftp the file then select it for upload?
I have Russian, French, Spanish and English.
How do I uninstall Easy Populate. I clicked on the un-install link. It gave me the following message. "Easy Populate Configuration Missing. Please install your configuration by clicking here
I do not know what it did - but it did not uninstall, reinstall, or change anything.
Thank you,
jund (John Underwood)
You can first use an FTP program to put your files on site, then they will show up on your EP4 page. To import, just click the Import link next to that file name.Quote:
Originally Posted by andiHPI
You may want to try with just a few dozen records. Is your data pretty clean? Curly quotes and hex char (92) can cause some issues. You may want to set those to "basic" characters on the Config page.
Be sure to use Dr. Byte MySQL backup tool so you can roll back if you have issues.
-chadd
p.s. I would be interested in a sample set of your data for testing if you are will to share (only testing mind you!). Also, do have a language id=1 defined?
Hi John,Quote:
Originally Posted by jund
This is actually correct. It has un-installed the configuration variables from the database. Now you would need to remove all the files from your site using an FTP program. This is common with nearly all zencart plug-ins.
Just to clarify, to use this mod to populate my website, I will have to edit the v_categories_name_1 and add the full subcategory path for each and every product?Quote:
Originally Posted by chadderuski
Yes:Quote:
Originally Posted by Boggled
"Top Level^1st Sub Category^2nd Sub Category"
Can anyone please tell me how to import products into a subcategory pls? Every time I use categories name 2 all I get is another root category.
Look at post #333 above yours.
sph
prommart com
easy populate 4.0
zen 1.5
mazdaproject.com
I Installed EP 4.0 on my site and was able to upload my spread sheet.
But I am having a problem downlading my product.
Will need a bit more information ... after exporting a sheet, you will have a "Download" link. Depending on your browser/settings you may need to right-click the link and "save target" or "save link" to your local machine.Quote:
Originally Posted by shopsfm
And then there is always ftp.
I did as you said and did import the file using Category1^Category2 and it did import.Quote:
Originally Posted by SPH
One question for people would be, does the name of a category have to be unique? The example being can there be a main category of the same name of category in a subcategory?
Category names do not have to be unique outside of their tree structure:Quote:
Originally Posted by darkmarauder
"Intel^Processors"
"AMD^Processors"
You have to different TOP level category names with the same (but different) sub-category.
NOTE: Category names are case sensitive: processors <> Processors and will produce two entries in your category tree.
Announcement: Easy Populate 4.0.20 Beta Posted to Github
This new version adds many features and enhancements:
-Attributes are now "round-robin". You can import-export-import your attributes to add/update as needed.
File naming requirements: The basic import must begin with "Attrib-Basic-EP" and the detail with "Attrib-Detailed-EP".
I am still awaiting feedback on what common columns would be useful in the Basic import file. I do not want to duplicate the Detailed, but
I'm sure there are a number of fields that users would like here. Attributes import is now multilingual.
-Added 'products_priced_by_attribute' to FULL file to support attributes.
-Added Featured Products support
-Added Support for products type 2. You can now import all relevant info for music products (artist, record label, genre).
-Expanded handling of "curly quotes" characters and character 0x92
BUG FIX: When import a mixed file of updated and new products with only a select number of columns, the data from an updated product was being inserted into a new product.
Download here: https://github.com/chaddro/EasyPopulate-4.0
Looking forward to your feedback,
-chadd
I haven't tried yet chad but just wanted to say thank you for your efforts. I'll have a go today at some point and let you know if I experience any issues.Quote:
Originally Posted by chadderuski
Moe.
This is great chad, it seems to import and export attributes smoothly and without any issues. I love how it displays the products attributes vertical rather than horizontally. The other way created many issues when you had significant option names and values attached. Your method of pulling the information also displays the product name above the attribute prices which will save many hours of work matching product name to product model and attribute
So far all is working as it should. :thumbsup:
I can not get it to work. i have tried eevrything. I upload the fiels and all seems good but then I go into my admin it doesn't show up and it doesn't give me any warning. Any suggestions?
Which version of zencart are you using? There are additional files that need to be uploaded for these to work and show up in your admin.Quote:
Originally Posted by outeredge2
You should physically check to ensure you have the files in their proper location. So far, the only failures with installation have been user error.
-chadd
I'm loading it onto a brand new site with 1.5 on it.Quote:
Originally Posted by chadderuski
I did load Ep 1.2.5.4 before this one. Can that be causing it error out? It's the only add-on I can't get working. I got all others (lightbox) sidebox, etc). not saying it's not user error, I just can't figur out why it's not working.
So I went through and check all of the files. They are all apreaing to be in the right locations.
I check the ensure that I had the 1.5 files included as well. Everything seems to be all located fine.
:blink:
EDIT:
So i got it working. I'n not sure what happend but I went through and removed all the old EP 4 things and then re-uploaded them and it works!!
P.s I have been reading more about this and the spread sheet style such as the drop down box options and everything.... WOW.... It rocks! Thanks for an amazing mod!!
Glad you got it working! It was more than likely a corrupted file.Quote:
Originally Posted by outeredge2
-chadd
No matter what I do, all of the products that I upload are given a product type of "2", which is apparently "music". How can I keep it from doing this? I need all oif my product types to be "product general".
On your import file, add column v_products_type and set the value to 1.Quote:
Originally Posted by hockey2112
I'll look into this. The default should be 1. Did you enable the music products under the configuration?
Quote:
Originally Posted by chadderuski
I don't see any spot in EZPop config to enable/disable the music products.
Here are my columns:
v_products_model v_products_image v_products_name_1 v_products_type v_products_description_1 v_products_price v_products_weight v_products_quantity v_categories_name_1 v_tax_class_title v_status EOREOR
And I do have a "1" in the v_products_type fields for each product.
Thanks!
First off: EOREOR is NOT required for EasyPopulate 4.Quote:
Originally Posted by hockey2112
Music products are disabled by default. From your Admin: Configuration > Easy Populate 4 > Enable Products Music Data
How do you change the database field lengths? I keep getting these errors
WARNING! - Model: SPST8116A - Products name: "17 GATOR ORANGE REAR TAILLIGHT SPST8116A " exceeds max. length: 21.333333333333
SKIPPED! - Model: SPST8116A - Category name: "Power Wheels and Ride on parts" exceeds max. length: 10.666666666667
this is what it says on my admin page
Database Field Lengths
categories_name:10.666666666667
manufacturers_name:10.666666666667
products_model:10.666666666667
products_name:21.333333333333
but on the database the char limits are much higher than that
Ah, I see that config now. I must have overlooked it right under the Meta Data item. It is, and was before, disabled.Quote:
Originally Posted by chadderuski
I removed EOREOR and uploaded a new copy of the CSV file with several new products included. The "update" products retained their product type, but the "new" products are still being added as "product type 2", even though they are marked as "1" in the spreadsheet...
I got it figured out. Its in the easypopulate2.php in the admin folder the values were divided by 3
Did you install zencart 1.5 with iso-8859 or utf8?Quote:
Originally Posted by rosrooster
UTF8 is multibyte... and you need to divide by 3 to get character count. However, if your store is set UTF8 and your databases are iso-8859 it may be confusing the script.
This is a prime example why I strongly recommend to always use Dr. Byte's MySQL Backup tool. You should run a backup before you import any files to ensure you understand them correctly.Quote:
Originally Posted by hockey2112
If you have a problem, you can simply roll your store's data back by restoring your backup.
To fix the products_type error, you will need to delete these and re-import them.
Okay. Bug in code. You must have had music products enabled. Do this:Quote:
Originally Posted by hockey2112
Open easypopulate_4_import.php with a plain text editor.
go to line 962
change:
to:Code:if (isset($v_artists_name)) {
$v_products_type = 2; // 1 is default, 2 = music
} else {
$v_products_type = 2;
}
-chaddCode:if (isset($v_artists_name)) {
$v_products_type = 2; // 1 is default, 2 = music
} else {
$v_products_type = 1;
}
I strongly second that. I've long since learned to back-up before any EP upload (and I try to get my sister and her people to do the same on her sites.)Quote:
Originally Posted by chadderuski
And Dr. Byte's back-up mod really simplifies that, no longer having to go in to cpanel and myphpadmin (or whatever its called) to manually download the DB. In fact, first mod I install now on my various demo sites is this DB back-up mod, as I'm always messing around on those sites. (Only thing: this DB backup mod doesn't seem to work well if your DB/UN password has strange characters other than numbers and letters.)
GITHUB UPDATED WITH PRODUCT TYPE FIX
Default product type has been fixed. If you enable music products in the config, and enter an artists_name, the product type will be set to 2,
otherwise it will be set to 1.
This is a quick fix. Will look into something more detailed later.
-chadd
Quote:
Originally Posted by rosrooster
I am receiving the same error. On the right side it shows:
Installed Languages
1-en: English
Default Language: 1-English
Internal Character Encoding: UTF-8
DB CharSet: DB_CHARSET
Database Field Lengths
categories_name:10.666666666667
manufacturers_name:10.666666666667
products_model:10.666666666667
products_name:21.333333333333
Running Easy Populate 4.0.20 - Beta 5-20-2012
on Zencart 1.3.8
I do not have a easypopulate2.php file as referenced in a previous post.
How can I increase this limit?
thanks!
"easypopulate2.php" was posted in error. This file does not exist.Quote:
Originally Posted by Bigjohnjps
Your problem is that your Database Character Set is not defined, i.e. DB_CHARSET
Since you are on zencart 1.38, I'm assuming that your are using collation: latin1_general_ci
Since EP doen't know what character set is correct, it is assuming UTF8, and dividing your field length by 3 (necessary for multi-byte character encoding).
Open easypopulate_4.php and go to about line 126. You'll see a number of variables with "/3" ... just remove this block of code.
I'll work on a better way to check for collation. I believe this was fixed in 1.39, and 1.5 uses UTF8 by default.
You should consider upgrading ... 1.38 is getting QUITE old.
-chadd
My site uses attributes this way.
Width
24
24
25...
Length
30
31
32.......
Will EP 4.0 support this?
It would help to see an example on your site. But if you can create the Options Name/Options Values in Zencart, you can also with EP4.Quote:
Originally Posted by larryweiss
I have a problem importing attributes with prices and weights.
Somewhere, a zero is added, like a string, for the price displays as "0$7.50" and the weight is "00.10"
Not sure if it's me or EP atm, but I know I don't have doubled 0's in my weights, and the prices are just weird.
"
Adding the item to the cart will yield the right price, however.
It would help if you could attach your Basic and Detailed attribute files so I can see if I can duplicate on my end.Quote:
Originally Posted by Microchip
Also, have you tried to edit the attribute in question from within the Admin interface to see what happens after you save?
If you mean editing/saving attributes after import, yes. It didn't seem to change things.Quote:
Originally Posted by chadderuski
However, I think I figured this out, but it's kinda obscure. In my original attempt, I just copy/pasted the prices and weights from the one set of attributes to all the others that I was adding prices to.
My latest test I copied all attribute data aside from unique data like product ID, etc., and pasted this into the attribute to be changed, and it worked.
If you still want my attribute files, let me know.
One this that is important to remember!Quote:
Originally Posted by Microchip
The BASIC import can be used to CREATE and MODIFY the options names and options values names attached to a specific product.
But the DETAILED is ONLY used to UPDATE a specific products model, option name, options values name combo. This is why those first columns must remain untouched. The _id's are used to find and update that specific combo. Although not very flexible, this works well and is quick.
I am waiting for feedback on what COMMON additional columns would be useful for the BASIC import, but have not received any feedback on that yet.
I hope this clears things up.
Quote:
Originally Posted by chadderuski
In my case, I was updating the price and weight info, the attributes were already created and assigned to products.
hi there i have installed your EP4 as followed on my zen cart v1.5.
it shows in the admin menu - thats fine
it shows importing and exporting files listed - fine
but each time i export "Complete Products (with Metatags)"
and ad new products to the list in the same way as the rest of the products in the table
and import it (saved as a .csv) through open Office
it says it was imported fine (green highlight on top of admin)
but when i look in phpMyAdmin or the zen cart store, its not updated :/
any reasons for this?
kind regards and thank you for developing such a system :)
all the best for future updates/ upgrades
Please either attach or PM me your data file, or a portion there of.Quote:
Originally Posted by oj226
You are clicking on Import after Uploading the file?
-chadd
Quote:
Width
24
24
25...
Length
30
31
32.......
Sure. A relevant page is:Quote:
Originally Posted by chadderuski
http://www.sofabed-mattress dot com/sleeper-sofa-bed-mattresses/premium-sofabedmattress.htm
Announcment: New version 4.0.21 posted to github
https://github.com/chaddro/EasyPopulate-4.0
Fixes in this version:
- products_type on import bug
- admin security error when using admin profiles in v1.5
- new way of checking database collation... to fix mult-byte issues when UTF8 is not used.
Getting close to submitting to zencart team! Thanks again to everyone for testing and your feedback!
-chadd
Hi Chadderuski
Thanks for the great work. I installed the version 4.0.21 and compared with the Easy Populate CSV 1.2.5.7 that I am using. The "custom field", a function in the Easy Populate CSV 1.2.5.7, are very useful. If possible, hope you can add this function to the EP4.
SU35
I agree I need to add "custom fields" , "Cost" (my cost) and "Warehouse" (where I get the item from) to my spreadsheets in a hidden field but not sure how to do it.Quote:
Originally Posted by su35
sorry again for so many questions and THANK YOU for the quick responses.
Hi Shopsfm and su35,
I will look into it. However, my version makes adding your own custom fields rather easy. A good "how-to" was posted earlier in this thread. You can add your own fields for the products database in something like 15 minutes work.
I'll see where I am at in my list of to-do's. If 4.0.21 goes well, I'll want to submit to the zencart team and exit beta.
That takes priority. I also need to flesh out the docs... something along the lines of what Schoolboy did for 1.2.5.4.
I appreciate the feed back. Keep it coming!
-chadd
I think I found how to add database custom fields
http://www.zen-cart.com/showthread.p...t-Thread/page5
http://www.zen-cart.com/showthread.p...-Thread/page21
hopefully this works.
Yep, Igi2011 did a great job laying it all out in post 205. Just note that the line numbers have changed.Quote:
Originally Posted by shopsfm
Also, if you follow the formula and add your fields as a "mod", you will be able to easily patch them into newer releases.
I will look into the custom fields of Easy Populate CSV 1.2.5.7 when time permits. A lot of the current work I've done may actually make that easy to do... we'll see.
-chadd
:frusty:
did not work
followed post 205
Here is what I did.. Trying to impout a hidded field "Cost"
easypopulate_4.php
line 102
$ep_supported_mods['Cost'] = ep_4_check_table_column(TABLE_PRODUCTS,'products_Cost');
*********************
easypopulate_4_import.php
line 30
if ($ep_supported_mods['Cost'] == true) { // Cost - chadd
$default_these[] = 'v_products_Cost';
line 322
if ($ep_supported_mods['Cost'] == true) { // Cost- chadd
$sql .= 'p.products_cost as v_products_Cost,';
line 936
if ($ep_supported_mods['Cost'] == true) { // Cost
$query .= "products_Cost = '".addslashes($v_products_Cost)."',";
line 1025
if ($ep_supported_mods['Cost'] == true) { // Cost
$query .= "products_Cost = '".addslashes($v_products_Cost)."',";
*************************
easypopulate_4_functions.php
line 79
if ($ep_supported_mods['Cost'] == true) { // Cost
$filelayout[] = 'v_products_Cost';
line 160
if ($ep_supported_mods['Cost'] == true) { // Cost
$filelayout_sql .= 'p.products_Cost as v_products_Cost,';
any help or link to a tutorial would be greatly appriciated.
Chadd,Quote:
Originally Posted by chadderuski
ZC 1.5, this product:
http://www.webdivision.prommart.com/...roducts_id=191
We think we know how your Basic Attributes work.
But we probably really need the Detailed Attributes sheet to do our V-Lookup thing off of the column headings I mentioned some months ago.
I guess my question is: Can I use the Detailed Attributes sheet to ADD another color to this product? If so, how.
I tried and think that I am stuck on column A...v_products_attributes_id
I tried adding what should be the next number in order, but didn't work.
Thanks.
Steve
Hi Steve,Quote:
Originally Posted by SPH
First, from an earlier post:
One this that is important to remember!
You cannot use the detailed sheet to add colors. What you'd do first is run the basic with the products model number and options name to add options values name.Quote:
The BASIC import can be used to CREATE and MODIFY the options names and options values names attached to a specific product.
But the DETAILED is ONLY used to UPDATE a specific products model, option name, options values name combo. This is why those first columns must remain untouched. The _id's are used to find and update that specific combo. Although not very flexible, this works well and is quick.
Then export your detail sheet which will now have all the colors assigned to that products.
Does that help to clear things up?
we are having a problem with Quantity Units errors after updating our qty in stock via easy populate. So far the only way we have been able to find to fix the error in through the catalog in the admin section, going into every item individually and updating them. This is not reasonable for us as we have 16,000+ items. Is there any way to fix this or are we doing something wrong?
Easy populate 4
Zencart 1.5
I have tested this and do not believe it is a problem with the script. Also, you did not describe what error you are getting. Have you done an export with a small sub-category, downloaded it, changed the v_products_quantity column, resaved as CSV and uploaded/imported to see if the values recorded correctly?Quote:
Originally Posted by jandm-ent
I just did this, and it worked find. Now, if your column header is "v_products_quantity " <--- see that extra space? That will kill the column, and it will not import.
General note to all:
When having issues like this it really helps to attached a portion of your import file. And when testing, don't start with a massive import! First verify that you know your columns are working correctly by importing only a couple records, then carefully check each record's entry for accuracy. I have done this literally hundreds of time.
Now, most times it's the CSV data, but sometimes it's the script. So you should always include the version number in your posts. You should all update to 4.0.21 because of the mixed update/new data error I discovered when importing sheets with reduced columns (that had to have been in there for sometime!) ... along with all the other corrections and tweaks.
-chadd
Believe me, something as simple as a misplaced single or double quote or missing parenthesis can drive you bonkers, not to mention 5-way inner joins on sql database queries.Quote:
Originally Posted by shopsfm
Trying to quote the code doesn't help. You left out parts. Better to PM or attach the files so I can look at your work. I bet I can spot the error quickly. Believe me, I fudged things up enough myself in the beginning! It's easy to do.
-chadd
BTW: use phpMyAdmin and double check your table column's name products_Cost <> products_cost in some implementations.
I did notice a couple of things that I would like to see changed, if possible. I have been using it for several months and checking the posts to see if they were mentioned there. If I missed them, my apologies in advanced and I will download it again.
The specials fields are pre-populated with an expiration date when none is set. This requires that field to be cleared before uploading or your specials will all be expired.
The other thing I noticed is that the down-loaded products default to status 1, so if you need both the 0 and 1 statused items, you will need to download the products twice. This is a small hassle when changing quantities and restocking at the same time.
Otherwise, this is one of the best contribs that I have found!
I will have to look into this one. Didn't know it was doing that!Quote:
Originally Posted by awhfy99
This should be fixed in the 4.0.21 6-1-2012 currently at github! Definitely update to the latest version for other minor fixes.Quote:
Originally Posted by awhfy99
PLEASE NOTE: CUSTOM PRODUCT FIELDS coming soon!
I've had several requests to add the ability to define custom products fields. This turned out to be quite easy, and will be in the next version pushed to github. I added a configuration field where you can enter your products table fields (existing or custom) and the script checks for them before exporting/importing so you know you entered them correctly.
Needs a bit more testing, but should be able to push in a couple days.
-chadd
Hi,Quote:
Originally Posted by chadderuski
I tried to import option names and option values, and I saw them imported via admin. When I click on each product to view it on the product infor page, I did not see any option names as well as option values displayed.
Below is a link to my file. Please take a look and give me your advice. Thanks!
http://www.theladystuff.com/temp/DD.csv
Hi John,Quote:
Originally Posted by johnn196703
To use the attribute feature in EP4 you need to first import your products using the Full sheet. You will then create a Attrib-Basic-EP csv file with columns:
v_products_model, v_products_options_type, v_products_options_name_1, v_products_options_values_name_1
Also EOREOR is not required with EP4. And file naming conventions must be followed otherwise the script will not know what to do with the file.
Check the examples folder for more information in the attribute_types.txt file and a sample basic attribute import csv file.
-Chadd
Hello -
I'm a brand new user to EP 4, and my cart has been recently upgraded to 1.5. I'm trying to wrap the product description in DIV tags it appears that the import is adding a ? where there should be a space within the html tag. So the tag is <div class="info-text"> but when I look at the page source (or edit the html of a freshly imported product) it appears like this <div?class="info-text"> --- I was initially using excel. So I opened my csv file with notepad to see if the output was adding the ? - the ? wasn't present. I also tried generating the csv file with OpenOffice Calc -- same result.
Any ideas?
Be sure you are not using smart quotes in your csv, or go to Configuration > Easy Populate 4 and set "Convert Curly Quotes" to 1 which will replace smart quotes with a regular quote.Quote:
Originally Posted by Terrill_Taylor
I tested this on my end using your example and it worked fine....
Announcement: Version 4.0.22 now available on github.
https://github.com/chaddro/EasyPopulate-4.0
Added to this update is the ability to add your own User Defined Products Field Names.
Be sure to click Un-Install EP4 then Install EP4 to load the new configuration variables.
Then go to Configuration > Easy Populate 4
New option to add your field names. Field names are comma separate with NO spaces. Remember, NO SPACES!
When you return to the Easy Populate 4 screen, you will see your User Defined Products Fields listed with either FALSE or TRUE next to them.
TRUE means the script was able to verify your field name, FALSE mean you either spelled something wrong, or you have not added that field name
to your product database.
Character, String and Numeric values will import fine, but be sure you import the correct data for your database types. Also, do not exceed your database field lengths, you will get unpredictable results.
Also note that there is no "cleaning" for character/string data. Be sure your data is correct for your database collation and character set (UTF vs ISSO-8859).
Let me know if you have any issues!
-Chadd
hi Chad,
thanks for the updated version of EP4!
im glad to hear others in this forum are having good luck with updating mass products, but unfortunately im not :(
ive done as you asked in the readme files, opened in OpenOffice and under 'seperated by', selected Semicolon and Comma, for 'text delimiter' selected by " (double quotes)
ive updated the current product prices/ quantity and also added afew more products, filled them out as accordingly.
saved the file from open office as a text CSV file format (.csv).
i going into my admin > tools . Easy populate 4
i have Easy Populate 4.0.21 - Beta 6-1-2012, ive changed my temp folder, it allowed me to change it from the configuration (which it has selected on the right side) which is correct.
i browse for my file and i click upload. once finished uploading, the green stripe on the top saying that "my file name" was uploaded correctly.
i go to check the files in my shop and, nothing was changed.
is there any possibility i could send you my file?
kind regards, Oj
Just a reminded: After you UPLOAD the file you must click on IMPORT to actually put the data into your database. It's a two step process!
Chad,
I just went to github and downloaded, but I don't see the new place for adding custom fields under configuration. In tools it says my version is Easy Populate 4.0.21 - Beta 6-1-2012
I uninstalled before re-installing.
Did I get the correct one? Actually, it looks like the one I just had.
You are correct, there is something off. I will check this when I get home as the new 4.0.22 code is not showing on github!Quote:
Originally Posted by SPH
Just... need... a couple... hours! Sorry for the fudge-up!
-chadd
thanks Chad!
abit clueless here haha
not quite sure if this has been covered, but when importing Categories, it needs 'Model field'.
just did it and none of my categories were updated.
since it doesnt update anything, it just stacked the categories into my list, so in other words, my list was doubled.
kind regards,
Oj
This is covered in the documentation. The v_products_model is required for each product. Not sure what you mean by "my list was doubled" ... Are using the model/category list or Categories (with metatags)? Please read the first page of this thread, a lot covered there also.Quote:
Originally Posted by oj226
Hi Chadd,
Thanks for you support. I have been trying to follow the guideline, but I cannot import the attributes for option names and option values.
Do you have any tips regarding this issue?
Thanks for your help and support.
John
Quote:
Originally Posted by chadderuski
Please try this: Describe in plain English the attribute and attribute values that you want to assign to one product. Note that the product must already exist in your database.Quote:
Originally Posted by johnn196703
For example: "I have a product widget that I want to assign the attribute Color with values red,green,blue as a dropdown box"
Then your CSV will look like:
hope this helpsQuote:
v_products_model,v_products_options_type,v_products_options_name_1,v_products_op tions_values_name_1
"widget","0","Color","red,green,blue"
I just updated to the latest version listed above, and my product info is no longer being added to my site. The file uploads fine, and then when I click "Import" next to the file it gives me the "File Import Completed" message, but no products are added to my catalog. Any idea what would cause this?
The only major change I made recently was the installation of my SSL.
--EDIT--
I'm an idiot. It had to do with the file name of the CSV file. I removed the spaces and the & and it now works.
A separate issue... I have Product Category ! and 2 filled out for a few products that should be listed in a subcategory, but all of those products are just getting lumped into the primary category. Any idea what might fix that?