how do you add price per word or price per letter into the excel spreadsheet to be used with easy populate? i could add the prices and weight but cant for all others..
Printable View
how do you add price per word or price per letter into the excel spreadsheet to be used with easy populate? i could add the prices and weight but cant for all others..
Can anyone recommend a stock_by_attribute plugin that works with EP4?
Hello Chadd - While reading the thread, on found this post of yours. Is it possible?Quote:
Originally Posted by chadderuski
I can't even imagine trying to manually keying in the quantity in stock for attributes. If you have 100s of products, with a size attribute of 5-7 different sizes! :yuck:
How do people do this in Zen?
I've never used the stock by attributes mod, and would have to either examine the contrib to see what files it modifies. I'm insanely busy right now, and really need to finish the docs for EP4 and submit it to the zencart team before doing any MORE changes to it...Quote:
Originally Posted by Kevin205
Diva probably just coded it herself :p
I understand. Thank you.
hey chadd, im wondering, is there a way to add the price per word value using easy populate?Quote:
Originally Posted by chadderuski
Dennisz,Quote:
Originally Posted by denniszc
Please drop me a PM so we can chat off line. I've never done anything zencart that used documents, or price by work so I'll need you to give me a run down of your work flow...
-chadd
it's per "word" :pQuote:
Originally Posted by chadderuski
anyway, pm sent
Hi,
I was trying to search info about disabled "Advanced Smart Tags" in the module. Is there a version working with that? We used to have with the older EP it working pretty ok, and the need would be for simple paragraph tagging, or bold text formatting, maybe bullets in the text.
Is there a way to place filter and filter for "Categories", "Manufacturer" and "Status", for exporting of the "Attrib-Detailed-EP" CSV?
As it is done for
Complete Products,
Model/Price/Qty and
Model/Price/Breaks
Attachment 12169
I don't see a reply to this thread, but I have been spinning my wheels with the same issue. Some of us newbies are way over our heads with a lot of ZC; so even "simple" instructions often need to be broken down into smaller pieces. In my case, I have a small wine shop, so my products are wines from a large number of producers, and I want categories of about a dozen regions, a few price ranges, and a few colors. Not that complicated. After loading several sample products and categories, I downloaded the product file and found that each product was listed several times, once for each subcategory, and that seemed wrong.
However, I don't know how to make use of this statement: "To achieve this, each v_categories_names_1, v_categories_names_2 correspond to a language installed in your system, and individual category names are separated by the Carat "^" symbol. For Example: Bar Supplies^Glass Washers^Brushes" A sample file illustrating this would be extremely helpful, along with some details about how the sample file accomplishes this. Not to mention, I have NO idea what the term "language" means in this context...!
Then the question after that would be, okay, what are the rules for naming and uploading my data file? I see the download file has a name like "FullEPYearDayTime.csv," so no help there.
Btw, my site (under construction) is www.artisanwineclub.com...
All help appreciated, thanks.
how do you add categories for other languages?
Not currently...Quote:
Originally Posted by Kevin205
This is how I would do it:Quote:
Originally Posted by tenashi
First create Region categories (top category, ie: California, Italy, French, ...)
Attachment 12190
Second create Color categories per region (subcategory, ie: Reds, Whites, Roses, ...)
Attachment 12191
Third create Wine bottle for specific region and Color (Products. ie: Wine Red A, Wine Red B, ...)
Attachment 12193
When you export from EP4, Complete Products (with Metatags) You should get a csv file similar to the following (The Horizontal record 1,2 & 3 and NOT rows 5 through 37, I transposed it, for you to see all cells!)
Attachment 12194
As for the language, I only use English, so I guess it's for carts that offer multilingual carts?
I hope it helps.
Ok. Thank you.Quote:
Originally Posted by chadderuski
I found a mistake myself, v_products_model should not be similar.
Yo Kevin205, Thanks for taking the time, much appreciated, and much food for thought. Still hard to operationalize with the aging brain, though.
So do categories have to be related linearly, as in your example: wines(products)= subset of colors = subset of regions. Is it possible to have wines=products, but with category1=regions, category2=subregions, category3=price group, etc., where each wine/product belongs to several categories of the same level? Where does v_categories_name2, etc. fit in? If all my products are wines (most are, but not all), does that mean all the wines would have to be under the same parent category (in this case, "region")?
Thanks!
Btw, some years ago I explored ZC for another site of mine, and found it too complicated. Lately I explored WPEC and found it too complicated, so came back to ZC. That decision was based on the observation that ZC is way more of a community, and even though a lot of this is a stretch for me, I really appreciate the fact that people here actually read and respond to these pleas for help. In today's world, that's a rare and beautiful thing. So thanks again.
Please note that unless you have more than one language, you will only have an _1 for your name, descriptions, categories, etc.Quote:
Originally Posted by tenashi
Please review the documentation or the first couple pages of this thread where this was discussed in detail...
However you wish to categorize and subcategories, ending at a product. I always think of as a tree, by drawing a flowchart from top down.Quote:
Originally Posted by tenashi
Not sure if this has been mentioned before, but when uploading things that have quotes in them (such as html tables and such) MAKE SURE QUOTES ARE ESCAPED. using open office, all my quotes were escaped with additional quotes after exporting back to csv, solooked likeHTML Code:<table border="0">
when it needs to look likeHTML Code:<table border=""0"">
i was annoyed that my product's descriptions weren't updating, and that was the culprit. :)HTML Code:<table border=\"0\">
Yes, the one MAJOR drawback in using CSV as the file format for Easy Populate, is the enormous potential for errors when content contains commas or quote marks.
EP version 1.2.5.4 used a TAB-DELIMITED system, which is far, far safer and more reliable than CSV - because TABS are not used anywhere in the formatting of the content.
I do not use EP 4 because it is a huge mission to clean up the content, and I have had too many disasters where a single comma (missed in the clean-up) has caused major damage to the site's product data and configuration.
If EP4 created TAB-DELIMITED files, it would be an excellent module.
Open Office properly encapsulates commas, tabs, single and double quotes. MS Excell seems to do it's own thing which changes from version to version.Quote:
Originally Posted by fairestcape
There are some complications with utf-8 data and certain odd characters. This usually results when incorrectly opening files of different encodings, especially certain windows encodings.
How would you properly format and send
1'6" x 1'9"
through EP4? It is used in v_products_options_values_name_1.
If you use open office and use: FILE > SAVE AS > Text CSV (.csv)Quote:
Originally Posted by Kevin205
Open Office will encapsulate it as:
"1'6"" x 1'9"""
You don't need to do anything special.
-chadd
Still having trouble, probably something simple. Link to sample file I am trying to upload below. The categories are already in place. Not sure what the protocols are for "model" field. I can enter products manually, and those products appear and download appropriately. But when I upload I see the .csv file (using OO and utf-8) listed but products do not appear in the catalog. What's up?
https://docs.google.com/file/d/0B6FE...it?usp=sharing
Thanks!
Okay, got it sorted out; info was in forum, just reading it wrong...doh!Quote:
Originally Posted by tenashi
Hey Tenashi,
Sorry, was down all week end. Glad you found solution though.
-chadd
Not to worry I seem to have at least one baffling new problem a day! Today's may or may not be related to EP4. The situation is that after I upload several test products, the "What's New" box on my main page lists them all twice. If I remove all products, the box is empty. When I reload the four products with EP4, each appears twice in the box. I also have been using Copy Categories and exploring different ways of setting up category structure. So maybe something to do with that, or with cached data...? Ideas?
View site
Thanks!
It may be that linked products (the same product in multiple categories) is why your seeing it listed more than once. I'd ask this question in the general forum. EP4 does not affect how new products are listed.Quote:
Originally Posted by tenashi
ok thanks for narrowing it down, will try that next.
I just installed Easy Populate V 4 with the latest zencart and am having trouble a csv file im using open office but get this error when i try to import the file to easy populate
No model field in record. This line was not importedG-vibe 6 f | | 99.73 | 49.87 | The G-Vibe | In Stock | Fun toys | ELD | 2013-02-04 | http://fee | Vibrators | Luxury | | 5060320510 | 1.2 |
No model field in record. This line was not imported2013 playb | | 17.93 | 8.97 | Enjoy some | OOS | Vivid | ELD | 2012-08-02 | http://fee | Extras | Books | Cards, Cal | 1847091310 | 0.96 |
No model field in record. This line was not imported2013 playb | | 16.73 | 8.37 | It'll | OOS | Vivid | ELD | 2012-08-02 | http://fee | Extras | Books | Cards, Cal | 9781554842 | 0.5 |
No model field in record. This line was not importedSex smarts | | 11.17 | 5.59 | This page- | In Stock | | ELD | 2011-09-23 | http://fee | Extras | Books | Cards, Cal | 1847091210 | 0.96 |
No model field in record. This line was not imported2013 olivi | | 16.73 | 8.37 | Fan-favori | OOS | Vivid | ELD | 2012-08-02 | http://fee | Extras | Books | Cards, Cal | 1847091391 | |
Could you please help
hey, want to ask, everytime i import a file, instead of updating the existing products, it created a whole new category and whole new product listing, meaning i will have a duplicated of all products and categories.. is this suppose to happen? how can i fix this?
could it be because i edited the categories sort order? in that case is there a way to insert the sort order for categories in the excel file?
No, not because of sort order.
How LONG are your category names? If they are longer than the database can hold (I believe the default is 32 characters) then you will have problems.
Are you using english, or a multi-byte language (like greek/russian).
If you can zip and attach a portion of your csv file that will help.
-chadd
Please zip and attach a portion of your CSV file.Quote:
Originally Posted by Shane Anthony
Did you add a product from the admin then export it to get your file headers? If you spelled "v_products_model" incorrectly or left it blank, you will receive this error...
-chadd
i've calculated, the categories is within the 32 character limit.. im using english and chinese, i tried updating it without editing the sort order and it works, it's only when i edited the sort order did it duplicated all the products and categories.. so it's quite clear the problem lies with that. attached is a portion of my .csv fileQuote:
Originally Posted by chadderuski
Hi Dennis,Quote:
Originally Posted by denniszc
Could you tell me exactly how you are editing the sort order? Are you doing this in the admin: Catalog > Categories?
If that's so, it's possible that I'm not pulling the sort order! So I'll have to look at that code again...
-chadd
Hi
Is there a thread that explains what each field is called and what each field means and what info you put into the field? I have a new install of ZC 1.5.0 and I have installed EP 4.0. Should I use a different version of EP since 4.0 is beta?
TIA for any help
John
Hi John,Quote:
Originally Posted by jpmill
If you first add a couple product through the admin, then do your export, I think most of the columns will be self explanatory. The "beta" is quite stable and you should not have any concerns about that. I'm working on getting my submission for the zencart team, but writing good docs takes time, and paid work trumps the free stuff and I've been very busy.
-chadd
ok thanks sir, I did export it and I don't know what v_products_type means. What do I put in that column?
hey chadd, yes that is exactly how i did it, is it possible to sort the order using the .csv file?Quote:
Originally Posted by jpmill
wrong quote, how do you edit a post?Quote:
Originally Posted by chadderuski
Dennis,Quote:
Originally Posted by denniszc
Strange. I used your data, installed the simplified chinese language pack and was able to import your supplied file, modify sort order in the admin, and re-import the file and NOT get any duplicates.
I did notice in your CSV that your have spaces between your category names, which you should not.
Try this and tell me if it makes a difference:
Open: includes/functions/extra_functions/easypopulate_4_functions.php
Scroll down to the function ep_4_curly_quotes($curly_text) function...
change:
return $clean_text;
to:
return trim($clean_text);
Let me know how that works for you. The spaces in UTF8 for chinese may be causing your problem.
-chadd
v_products_type will be 1 for most people unless you are doing music related stuff or have created your own products type.Quote:
Originally Posted by jpmill
did you modify for the sub categories as well? modifying th main category will work, but modifying the sub category is what causes the problem.. okay i'll try it outQuote:
Originally Posted by chadderuski
okay i tested the trim function and it works! everything is working fine now, thanks chadd for the help
chad, just been going throught the readme and just wondered, it mentions about being able to create atributes and assisgn them to products, but does it still have the abilty to assign existing attributes to products?
thanks
Phil, I am sure you have look at this. If you haven't go a head and export the following and look at the .csv content. I am sure it clears a lot for you.
Attribute Export/Import Options
Basic Products Attributes (basic single-line)
Detailed Products Attributes (detailed multi-line)
You can view the existing, and apply new ones as well.
Hello
I'm using zencart 1.5.1 and Easy Pop 4.
Firstly thanks to this great product.
I have started to import Attributes for a product.
This went ok except the drop down box has "TEXT" displayed when first displayed.
I cannot see where this is coming from;
http://www.mapkiosk.co.uk/MapStore/i...oducts_id=1042
Any ideas how to remove or change to "Please select from list"
Thanks in anticipation
David
Use the developers tool kit in the admin and search for "Please Choose"Quote:
Originally Posted by Sky_Blue
http://www.zen-cart.com/content.php?...lopers-toolkit
Hey David,Quote:
Originally Posted by Sky_Blue
This is probably in a language file, but i'm not sure. Verify your attribute option names and values from within the admin, also use the attribute controller to preview from within the product catalog.
TEXT is your default values, but note that when you add the map without having selected a map, the cart does not show a map name. So I'm thinking it's a combination of language file, or attribute setting. Also, you'll want to set your attribute as required so people don't checkout without having selected a map...
-chadd
Okay, I had to go poking around how I did this myself (it's been a while!).Quote:
Originally Posted by Sky_Blue
What you did is added an Options Values Name that was "TEXT" .... you can edit this in the admin to "Please select a map".
You will then need to go to that map via Categories and click on the Attributes controller and change this option to "display only".
I attached an image of where you do that:
Thanks Chadd for your prompt reply
I'm beginning to understand it now!!
I would also add the third button from left (Brown) sets the Option value as the default one.
Yes, you can also set the default.
I don't want to get you confused, but these options can also be set using the detailed attribute sheet.
-chadd
Can't download exported files
Hi,
I just installed EasyPopulate 4.0, as downloaded from Github. I'm using ZC 1.5.1.
All looks to have worked ok, but I cannot download exported files...
If I click on the Download link for a file I just get an error message in a new tab:
"Forbidden
You do not have permission to access this document. "
I'm using Firefox.
Any suggestions to fix this?
Thanks.
@chad, first of all, thanks for this, product import works beautifully.
however I am not able to import exisitng attributes onto my test product for some reason? perhaps I am doing something wrong?
here is what I did.
I downloaded full model/category/metat tage sheet, deleted all entries and used as a template to upload my product model: TEST001 (as I said, worked great)/
then I downloaded the basic products attributes file and did the same, deleted all entires apart from one to use as a template which already had the attributes I want assigned and changed the model number to TEST001
when I click import it says:
Filename: attribtest01.csv
UPDATED! - Model: TEST001 | 0 | Size | Choose Siz |
when I go to the product TEST001 there are no attributes assigned to it?
the csv looks like this:
Attachment 12378
hope its something stupid? bit worried what the code is going off doing if when i go and check the product there is nothing set to it?
cheers
just found the answer, was because i wasnt naming the file correctly!
Attrib-Basic-EP_whateveryouwant.csv as per a previous post!
Mate you are genius, this is going to save me soooooo much time!
is there a way to set the 'display only' etc feilds on the attributes? not a problem if not as they are all the same so I can just run an sql query to do it in bulk. just wondered?
also notice that the sort orders don't adopt my defaults on the attributes, all set to 0?
but that said there is a admin function that can do that somewhere right?
You should be able to set display only using the detailed sheet. I don't remember off the top of my head if sort order has been incorporated in the the attributes code.Quote:
Originally Posted by philip937
No probs mate, I think you can do sort orders using store manager?Quote:
Originally Posted by chadderuski
The display only ill just set in phpmyadmin, I like the basic sheet don't really wanna mess with the complicated one ;)
Thanks again for this and to anyone else that may have contributed.
I guess the next improvement could be the inclusion on the basic attribute feild a in a main product import sheet? Or are they seoerate for a techical reason?
Are you looking to display and explanation for a product's attribute? For example Product Material: Plastic. The plastic part which displays text only can be set and defined by Option Name Manger>Option Type, Read Only? That displays text, for that attribute.Quote:
Originally Posted by philip937
Downloaded Easy Populate CSV
Why would this be happening?
Everything fine but when I try to Upload the EPFile the revised changes back into the admin panel I am getting a time out issue?
Sorry not sure I follow what's you've said here.Quote:
Originally Posted by Kevin205
Quote:
Originally Posted by philip937
What do you mean and what are you trying to display?
Quote:
Originally Posted by philip937
Can you confirm which version of EP you are using? This thread is for EasyPopulate 4.0 ... which shows in the title and tool pages as 'Easy Populate 4' ...Quote:
Originally Posted by haredo
Chad,
Sorry I posted in the wrong support thread ....
Hello Chad – What is the best way and what do you recommend, when it comes to merging prices for price by attributes?
When you have the following scenario:
Product A is priced by size attribute
Product Name > Size Attribute Name > Size Attribute Price
Product A > Size 1 > $5.00
Product A > Size 2 > $10.00
Product A > Size 3 > $20.00
Product A > Size 4 > $30.00
Obviously you would have to first import all attributes for different products, to table using via Basic Products Attributes (basic single-line), but how do you add / merge prices to Detailed Products Attributes (detailed multi-line) to update their corresponding prices
Is there a method that you use?
While trying to import attribute size, with values similar to 1'-8" x 3'-7", via Attrib-Basic-EP_02_Size_OO.csv, I am getting the following error. Data is prepared in Excel (.xls). I have tried both excel .csv and Open Office .csv. Both produce similar errors. Any ideas?
How else can this formatted?
How many records can be in a .csv file?
I am getting the following errors:
Quote:
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 '" x 3'-7"'' at line 10
When executing:
SELECT
a.products_options_id,
a.products_options_values_id,
b.products_options_values_id,
b.products_options_values_name
FROM zen_products_options_values_to_products_options as a, zen_products_options_values as b
WHERE
a.products_options_id = '1' AND
a.products_options_values_id = b.products_options_values_id AND
b.products_options_values_name = '1'-8" x 3'-7"'
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 '" x 3'-7"',
'1')' at line 9
When executing:
INSERT INTO zen_products_options_values
(products_options_values_id,
language_id,
products_options_values_name,
products_options_values_sort_order)
VALUES (
'108',
'1',
'1'-8" x 3'-7"',
'1')
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 '" x 3'-7"'' at line 10
When executing:
SELECT
a.products_options_id,
a.products_options_values_id,
b.products_options_values_id,
b.products_options_values_name
FROM zen_products_options_values_to_products_options as a, zen_products_options_values as b
WHERE
a.products_options_id = '1' AND
a.products_options_values_id = b.products_options_values_id AND
b.products_options_values_name = '1'-8" x 3'-7"'
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 '" x 3'-7"'' at line 10
When executing:
SELECT
a.products_options_id,
a.products_options_values_id,
b.products_options_values_id,
b.products_options_values_name
FROM zen_products_options_values_to_products_options as a, zen_products_options_values as b
WHERE
a.products_options_id = '1' AND
a.products_options_values_id = b.products_options_values_id AND
b.products_options_values_name = '1'-8" x 3'-7"'
This is how it's saved:Quote:
Originally Posted by chadderuski
Field delimiter: '
Text delimiter: ""
Attachment 12438
While importing the following:
v_products_model,v_products_options_type,v_products_options_name_1,v_products_op tions_values_name_1
1-GREEN-TOM,2,Size:,"1'-8"" x 3'-7"""
1-GREEN-TOM,2,Size:,"2'-3"" x 3'-6"""
1-GREEN-TOM,2,Size:,"2'-3"" x 1'-6"""
1-GREEN-TOM,2,Size:,"3'-11"" x 3'-7"""
1-GREEN-TOM,2,Size:,"1'-3"" x 3'-6"""
1-GREEN-TOM,2,Size:,"4'-7"" x 2'-6"""
1-GREEN-TOM,2,Size:,"3'-10"" x 3'-10"""
1-GREEN-TOM,2,Size:,"3'-6"" x 2'"
I am getting also getting the following warning right after the import on top of the admin page.
Warning 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
I look at it the .csv file with "Notepad++", and there are no tabs in the file / records.Quote:
Finished Processing Import File
Updated records: 6
New Imported records: 1
Errors Detected: 0
Warnings Detected: 0
Memory Usage: 2855256
Memory Peak: 2911048
Execution Time: 0.1918740272522 seconds.
1'-8" x 3'-7"
Sorry for multiple posts, I keep on getting kicked out.
I can import without any errors, only if the cell is formatted as shown in my previous post (#971).
But it really looks ugly, when you are adding size attributes to other products through admin, and you are choosing among 100s of similar looking sizes.
ps. I also tried using OO to export the .csv using Unicode (UTF-8) character set. I get the same errors.
Kevin,Quote:
Originally Posted by Kevin205
I think the problem you are having is that you are not using BASIC single and double quotes, but "smart" quotes.
have you tried setting EP to convert smart quotes to standard quotes?
Also, Excel and be a REAL B**CH about quotes, so you need to look through your preferences to ensure it's NOT using smart quotes.
-chadd
Also, when you come across these type of issues, it make ALL the difference in the world when you zip and attached the problem file.Quote:
Originally Posted by Kevin205
Also, look at how zencart interpreted your character codes in the quote .... these are standard characters... also be sure you have in your EP4 settings to conver chr(92) to standard single quote....
Chad - Thanks for the reply.
How do you distinguish between BASIC single and double quotes and "smart" quotes?
As I mentioned when I look at the .csv in Notepad++, it looks like ' and "" basic to me.
I will try your suggestions this evening and will inform you. Thank you.Quote:
Originally Posted by chadderuski
I sent you a pm.
Hey Kevin,Quote:
Originally Posted by Kevin205
I believe I know what is going on here. Will see if I can fix it without breaking the attribute importing code :p
I'll let you know when I believe I have it working...
-chadd
Kevin,
Attached is a replacement easypopulate_4_attrib.php file. Give this a try.
Note that you should set Configuration -> Easy Populate 4 :: Convert Curly Quotes to 1 - Replace with Basic Characters
I tested your file and it imported correctly. I have not tested the advanced attribute import yet, but this should get you on track.
-chadd
Kevin,
The detailed attribute import should be fine since it does not modify the options_name or options_values_name
That file MAY not work for you. I've been making a lot of changes to EP of late and you may have to wait for me to update github...
-chadd
Hello Chadd - I used easypopulate_4_attrib.php, you had supplied and imported with out any errors also. I also added prices for the size attribute through Attrib-Detailed-EP_ and it imported correctly as well.Quote:
Originally Posted by chadderuski
Thank you.
When ever you get a chance would you please explain what is new and updated for EP4 at github. Thanks.Quote:
Originally Posted by chadderuski
I originally posted this message in the "General" and someone suggested that I post it here instead.
I use Excel 2003 for configuring my wholesalers inventory file and then upload them via Easy Populate. I had my file completed and went back this morning to refine some things and my model numbers are not in Text format anymore. I have tried to use the CSV walkthrough and selected TEXT for the model number and it will only stay in General Format. Does anyone know how I can fix this, very frustrating.
Thanks
Mark
firstcapitalfirearms,
Get Open Office - it is free
Scrap MS Excel
Hi Guys,
I'm a bit confused about Easy Populate; I already use a easy populate version for ZC 1.3.8 for about 3 years. Now i'm going to set up a new shop for a new niche product.
What is the difference between Easy Populate CSV (http://www.zen-cart.com/downloads.php?do=file&id=868) and this one?
Thanks already!
Best regards,
Maarten
Kevin, you're encoding should be UTF 8 which should match the encoding of your databases.Quote:
Originally Posted by Kevin205
If you EXPORT your CSV file from OO with the wrong encoding, then import it into a database of some OTHER encoding, you risk getting a lot of "garbage" character in your descriptions, names, etc.
If you are on Zencart 1.5x, you are using UTF 8 unless you did something custom.
-chadd
I cannot speak for that version. You CAN installed EP 4.0 and that other one and not have a conflict (other than possibly confusing yourself). Just note that the FILE FORMATS are NOT compatible.Quote:
Originally Posted by MaartenJ
A lot of custom stuff in EP 4.0, working attributes import, custom products fields, vast performance improvements to name just a few.
-chadd
Hello Chad - I am using UTF-8.Quote:
Originally Posted by chadderuski
Hi All!
I am new to EasyPopulate 4.0, I'm super excited! I have two questions.
FIRST:
How can I be sure I'm using the latest version? I have a ZC 151 with Easy Populate 4.0.22 - Beta 6-10-2012 that I installed a few months ago (just getting around to using it!). I checked the GitHub link supplied on the first page, but I have no clue what to look for.
SECOND:
Today I want to upload a couple hundred categories. It has about 12 top categories, the rest spread out under it. My site is currently populated with Sample Data, so I went into EP4 admin area and exported both category file types [Model/Category & Categories Only (with Metatags)].
The Category Only file is the one I want to use, but I see no way to specify path during the creation of new cats. I can see that path can be specified in the Model/Cat file (ex, Top Category^Sub1^Sub2)... but how do you do that when creating new categories?
Thanks,
Mike
That is the latest of github. I'm trying to get an update and also submit to the zencart team but time has not been cooperating.
Categories: Categories are automatically created when you import a products and specify it's category. This is the only way to automatically create categories.
Currently, the Categories Only (with meta-tags) is NOT used to create categories, but ONLY to update meta information. Use it carefully, and don't make changes to your store (like add/removed categories) between updates. This import is 1-to-1, working of the categories database ID, not the name, so be careful.
As ALWAYS! use Dr. Byte's MySQL Database Backup Tool before running an import. It will be a life saver should you mess something up :p
-chadd
Quote:
Originally Posted by Feznizzle
Hello Chad - I don't know whether you have noticed or read this thread.
I am trying to fix the error message mentioned in the above thread by trying to place " with. No matter what i do i can not getQuote:
& # 3 4 ;
to show up in the SQL table. (Note: i removed the space in between so it shows up here.)Quote:
& # 3 4 ;
As a reference, I replaced the easypopulate_4_attrib.php, as per your suggestion to eliminate the errors I was getting.
Now I need to go back and place html chatracterQuote:
Originally Posted by chadderuski
for quotation marks back in. What a mess:yuck:Quote:
& # 3 4 ;
The error message in this thread does not tell me whether the error is getting generated from single quote or double quotes?
Any ideas?
Hi Chadd,
Thanks for the help! I was able to use the info to create a ton of categories. I love your mod! I'm really digging in today, expect to have more questions soon.
And you're right, Dr. Bytes backup mod is a lifesaver!
Thanks,
Mike
Quote:
Originally Posted by chadderuski
Can I use Attrib-Detailed-Ep_ to to import and revise the products_options_values_name values in the zen_products_options_values SQL table ?
I know I can add to new value to products_options_values_name through Attrib-Basic-EP_.
As I try Attrib-Detailed-Ep_ it will not change the value of products_options_values_name. How can I achieve this?
When I use Easy Populate to update product discriptions I find that if the product description is in plain text that I can see the product description in the on-line store....
... but I can not see the product description in the 'product description' field when I use the admin panel to view that product.
Worse if I hit the update button I loose the description on the on-line store.
Help what am I doing wrong?
OK I have solved the problem their were some characters "�'¯Â¾Â£" in the product description field that were causing the problem.Quote:
Originally Posted by Liamv
Hi,
i am trying to add this to my site, i have unzipped the files and uploaded the admin file to my root directory as well as the extra files for 1.5. when i log into admin easy populate isnt there, what am i doing wrong?
thanks
suzi
Hi,
i am trying to add this to my site, i have unzipped the files and uploaded the admin file to my root directory as well as the extra files for 1.5. when i log into admin easy populate isnt there, what am i doing wrong?
thanks
suzi
Hey, i'm sorry if this was already covered somewhere in this massive thread, but i was wondering if theres a way i could add fields from new product type that i created. its a format very similar to music, just slightly modded for DVDs, and i wanted to be able to add the equivalent to "record_companies" through easy populate. is this possible? or has anyone else done this? i don't mind modding the php a bit, i'd just need to know which files to tinker with. Thanks for your awesome work on this plugin!
Hi Suzi,Quote:
Originally Posted by sinfully
You are most likely not putting the admin files into YOUR admin directory. So if your admin is called "myZenAdmin" then
you have to upload the files to that directory, not the root.
-chadd
These "funky" characters usually occur when you are converting text between character encodings. Open Office does a pretty good job of handling this, but you have to tell it the character encoding of the file you are opening (say ISO8859-1) and again when you export your CSV which should be UTF8 .... now that zencart is UTF8 by default.Quote:
Originally Posted by Liamv
Your databases must also have the correct encoding, which you can check via phpMyAdmin. If you did a full instally manually (not using some script from your web host), zencart will use the correct UTF8 encodings.