Hey guys, whats the best way to add (if thats possible) custom fields into Attributes to be exported/imported.
Besides the "Price", I need to include the "Part#" to the DropDown Menu.
Any tips?
Thanks.
Printable View
Hey guys, whats the best way to add (if thats possible) custom fields into Attributes to be exported/imported.
Besides the "Price", I need to include the "Part#" to the DropDown Menu.
Any tips?
Thanks.
Have you tried using the export Attributes Detailed link that is below the dropdowns? Or do you need to use the dropdowns for your purpose? And when you say "Part#" are you referring to the existing product_model field in the product database or an additional field that has been added?Quote:
Originally Posted by HarryJL
Zen cart version v1.5.3
easy pop 4
I really need to find a way to apply quantity discounts (same quanity and percentage)
to MANY Items - as many as 450 within a single category
Is there some secret to using Model/Price/Breaks
to import to either ADD Quantity discount & percentag
or modify those that exist
I really do not want to need to do this one at a time
TIA
Well, one thing that is supposed to be secretis your admin folder name. That however has now been shared. Suggest changing it ASAP.
As to secret to use? What has been attempted and what was result?
There really is no secret to it's use, just fall in line with the requirements expressed in the instructions.
can anyone please explain how to tweak it to export full product url also?
thanks.
I forget in which version the option was added, but the latest version offers an admin configuration option to export the uri as seen on the store side... If the option is not in the confguration menu and you have installed the latest version then remove EP4 via the link on admin, tools, easy populate and then click the install link and redo/verify your settings on the configuration menu.Quote:
Originally Posted by RonaldNavarro689
Found it and it works. Thanks for the help. . If anyone is looking for this go to: configuration -> easy populate 4 -> Export URI with Prod and or Cat then set it from 0 to 1.
Cool, glad it was eventually easy to find.Quote:
Originally Posted by RonaldNavarro689
Downloaded, make changes, uploaded - the "listing" indicated the "updates"Quote:
Originally Posted by mc12345678
also tried "adding" some similar products to the csv file - same result
and yes, I see that using cut & Paste for my inquiry had an undesirable result.
What was used to make the edits (Open Office is recommended)? Does the file that is to be imported to the database have proper formatting? (Quoted text, separated by commas with applicable characters escaped?)Quote:
Originally Posted by wheat
Perhaps could either attach the file, post the first couple of lines (please use the # option in the message menu toolbar to surround the information in code tags) or otherwise demonstrate the data that is not producng the desired result?
Hello,
I am trying to upload into a subcategory in my Westminster new zen cart version 1.5.3. I am getting the message it is uploading.
I had two previous item in this category which I used to start the download and then put the new information into the open office calculate sheet. I have tried this several time and the products just don't show up. Any help would be appreciated.
Thanks
Ron
Need a lot more information than what is provided. Enough to be able to duplicate what was done as if you were describing the actions and results to someone that was blind. Btw, glad to see that this was your first post, hope that we can all get the problem resolved.Quote:
Originally Posted by stuffwo
Hi,
This is not my first post to community, seems I some how had two name here, will have to straighten it out later.
Anyway Here is a link to the sheet which I have downloaded and uploaded. http://www.stuffwholesale.com/docume...p23-230347.csv
I have tested the link it seems to work.
Thanks
Ron
Thought that was you, but wasn't sure.:)
First thing that jumped out: no commas... Ts supposed to be a comma separated value file. :) in savng the fle need to include commas between fields...
I saved it as a csv file did it not do this? confused now.
See https://www.zen-cart.com/showthread....20#post1090420 (first post of this forum regarding how to save files to be imported.)Quote:
Originally Posted by stuffwo
Hello,
I read the post but I still am unable to have the products show. I done all the step in this post
1) Select File -> Save As
2) Ensure File type: is Text CSV (.csv)
3) check the Edit Filter settings box
4) click save
In the Export of text Files box,
Select your Character set. Probably UTF-8 is you are on zen 1.5 now.
Field delimiter: Comma ,
Text delimiter: Double quote "
you can leave the save cell contents as show box checked.
I have uploaded the file again into the server for you to look at. http://www.stuffwholesale.com/docume...p23-230347.csv
Could this be the Westminster new template that was installed I had no problems before installing the new template.
Nope, not template related. File to be imported still has incorrect format. Not entirely sure (off top of head) what setting is causing this. There are quotes around all of the text, commas within the text, but none between each column. May I suggest, just so you can see the differences in the files, to open a file using a plain text editor that has been generated for download alongside a fiile saved to be imported... You only need to look at the first line to see the significant difference... Don't even really need to read any of it, just look at the pattern.Quote:
Originally Posted by stuffwo
As for the notification, yes, the file was import (opened) successfully, but it wasn't processed successfully. (Should see a long list of "issues"/information at the bottom of the screen after importing.)
Quote:
Originally Posted by stuffwo
Took a look through the settings of Open Office (OO) versionQuote:
Originally Posted by mc12345678
File, Save As, mark the box that says Edit Filter Settings before clicking the save button.
Then choose the settings:
Character Set: Unicode (UTF-8)
Field Delimiter: , (Is a comma)
Text Delimiter: " (Is a double quote)
Suggest marking the Quote all text cells block
Looks like perhaps the field delimiter was set as a space instead of a comma...
Thought also not sure what caused all of the commas at the end of each row...
Where is the (current) best place to download the most recent version of this plugin?
There is a new version that had some significant changes made to it that if found to be at least moderately acceptable by others will become the latest version for all.Quote:
Originally Posted by lat9
The "stable" release is found as directed in the first post of this thread.
There are new features which are available as documented in post 2082. This is a sort ofdevelopment location prior to incorporating into the mainstream version. Haven't received enough feedback yet to incorporate as is or how many more changes should be made. Have received some comments about menu options but could use some additional independent inspection/comment. This latest version takes EP4 to a new level and puts a lot more capability into the user's hands with little "self-checking" that can be done to minimize the product of the database being overwritten/modified.
Thanks, mc12345678, for the pointers. I'll give the updated version a go and post back here if I notice anything amiss.
Hello,
I have redone a new sheet and this did upload and show these readings at bottom: but no products in the category
Filename: Full-EP2015Sep27-212544.csv
UPDATED! - Model: SSP-100 | 1 | silver/SSP | 5 carat ge | ★Cente | | | | | | | | | | | 60 | | 360 | 0.33 | 0 | 0 | 1 | 1 | 0 | 0 | | 2015-07-24 | 1 | Stuffwhole | Handcrafte | ^Libra est | ^英镑的 | --none-- | 1 | 1 | 1 | 1 | 1 | 0 | 5 cart 7 x | genuine to | 5 cart 7 x | | | | | | | http://www |
UPDATED! - Model: TNE-1000 | 1 | silver/tur | Double str | Double str | | | | | | | | | | | 45 | | 99 | 0.4 | 0 | 1 | 1 | 1 | 0 | 0 | | 2015-07-24 | 10 | Stuffwhole | Handcrafte | ^Libra est | ^英镑的 | --none-- | 1 | 1 | 1 | 1 | 1 | 0 | Double str | Genuine st | Double str | | | | | | | http://www |
UPDATED! - Model: PSC4 | 1 | silver/PSC | 24kt. Gold | Boxed 24kt | | | | | | | | | | | 9.99 | | 30 | 0.025 | 0 | 2 | 1 | 1 | 0 | 0 | | 09/27/15 | 1 | Macy's | Handcrafte | ^Libra est | ^英镑的 | | | | | | | | | | | | | | | | | |
NEW PRODUCT! - Model: PSC9 | 1 | silver/PSC | 24kt. Gold | Boxed 24kt | | | | | | | | | | | 9.99 | | 30 | 0.025 | 0 | 3 | 1 | 1 | 0 | 0 | | | 1 | Macy's | Handcrafte | ^Libra est | ^英镑的 | | | | | | | | | | | | | | | | | |
NEW PRODUCT! - Model: PSC6 | 1 | silver/PSC | 24kt. Gold | Boxed 24kt | | | | | | | | | | | 9.99 | | 30 | 0.025 | 0 | 4 | 1 | 1 | 0 | 0 | | | 1 | Macy's | Handcrafte | ^Libra est | ^英镑的 | | | | | | | | | | | | | | | | | |
NEW PRODUCT! - Model: PSC7 | 1 | silver/PSC | 24kt. Gold | Boxed 24kt | | | | | | | | | | | 9.99 | | 30 | 0.025 | 0 | 5 | 1 | 1 | 0 | 0 | | | 1 | Macy's | Handcrafte | ^Libra est | ^英镑的 | | | | | | | | | | | | | | | | | |
NEW PRODUCT! - Model: PSC8 | 1 | silver/PSC | 24kt. Gold | Boxed 24kt | | | | | | | | | | | 9.99 | | 30 | 0.025 | 0 | 6 | 1 | 1 | 0 | 0 | | | 1 | Macy's | Handcrafte | ^Libra est | ^英镑的 | | | | | | | | | | | | | | | | | |
NEW PRODUCT! - Model: PSC10 | 1 | silver/PSC | 24kt. Gold | Boxed 24kt | | | | | | | | | | | 9.99 | | 30 | 0.025 | 0 | 7 | 1 | 1 | 0 | 0 | | | 1 | Macy's | Handcrafte | ^Libra est | ^英镑的 | | | | | | | | | | | | | | | | | |
NEW PRODUCT! - Model: PSC11 | 1 | silver/PSC | 24kt. Gold | Boxed 24kt | | | | | | | | | | | 9.99 | | 30 | 0.025 | 0 | 8 | 1 | 1 | 0 | 0 | | | 1 | Macy's | Handcrafte | ^Libra est | ^英镑的 | | | | | | | | | | | | | | | | | |
NEW PRODUCT! - Model: PSC12 | 1 | silver/PSC | 24kt. Gold | Boxed 24kt | | | | | | | | | | | 9.99 | | 30 | 0.025 | 0 | 9 | 1 | 1 | 0 | 0 | | | 1 | Macy's | Handcrafte | ^Libra est | ^英镑的 | | | | | | | | | | | | | | | | | |
NEW PRODUCT! - Model: PSC13 | 1 | silver/PSC | 24kt. Gold | Boxed 24kt | | | | | | | | | | | 9.99 | | 30 | 0.025 | 0 | 10 | 1 | 1 | 0 | 0 | | | 1 | Macy's | Handcrafte | ^Libra est | ^英镑的 | | | | | | | | | | | | | | | | | |
NEW PRODUCT! - Model: PSC14 | 1 | silver/PSC | 24kt. Gold | Boxed 24kt | | | | | | | | | | | 9.99 | | 30 | 0.025 | 0 | 11 | 1 | 1 | 0 | 0 | | | 1 | Macy's | Handcrafte | ^Libra est | ^英镑的 | | | | | | | | | | | | | | | | | |
NEW PRODUCT! - Model: PSC15 | 1 | silver/PSC | 24kt. Gold | Boxed 24kt | | | | | | | | | | | 9.99 | | 30 | 0.025 | 0 | 12 | 1 | 1 | 0 | 0 | | | 1 | Macy's | Handcrafte | ^Libra est | ^英镑的 | | | | | | | | | | | | | | | | | |
NEW PRODUCT! - Model: PSC16 | 1 | silver/PSC | 24kt. Gold | Boxed 24kt | | | | | | | | | | | 9.99 | | 30 | 0.025 | 0 | 13 | 1 | 1 | 0 | 0 | | | 1 | Macy's | Handcrafte | ^Libra est | ^英镑的 | | | | | | | | | | | | | | | | | |
NEW PRODUCT! - Model: PSC17 | 1 | silver/PSC | 24kt. Gold | Boxed 24kt | | | | | | | | | | | 9.99 | | 30 | 0.025 | 0 | 14 | 1 | 1 | 0 | 0 | | | 1 | Macy's | Handcrafte | ^Libra est | ^英镑的 | | | | | | | | | | | | | | | | | |
NEW PRODUCT! - Model: PSC18 | 1 | silver/PSC | 24kt. Gold | Boxed 24kt | | | | | | | | | | | 9.99 | | 30 | 0.025 | 0 | 15 | 1 | 1 | 0 | 0 | | | 1 | Macy's | Handcrafte | ^Libra est | ^英镑的 | | | | | | | | | | | | | | | | | |
Finished Processing Import File
Updated records: 3
New Imported records: 13
Errors Detected: 0
Warnings Detected: 0
Memory Usage: 7396432
Memory Peak: 7676528
Execution Time: 0.28616714477539 seconds.
Thanks. I also periodically check other forks off of either version/location to see if there are reported issues/solutions and then try to incorporate. Further I try to venture out to other ZC international sites, most recently trying to check in with the italian website but for whatever reason they refuse to offer me the ability to try to post to help others having difficulty with EP4. It's been 2 months since their last post, maybe/hopefully they have gotten their questions answered some other way.Quote:
Originally Posted by lat9
I'm almost done incorporating the German language found at a german ZC site and of course thus almost done with the language overrides for the english part as well. :)
So I haven't uploaded it here, but I had taken one of the previous files and modified it to the format I would have expected to find it, I then uploaded and imported it to a test site, and all product appeared including the generation of category that didn't previously exist... The site only had two languages and therefore had errors reported for trying to import the third language version.Quote:
Originally Posted by stuffwo
I didn't check the second language version mostly because I don't expect that it necessarily worked properly because the category name began with a carat divider (^) which is the character to be used to indicate a sub-category from the previous category/sub-category. It may result in category population in the sub-category with no problem, but that's a different issue.
Now as for the above product not appearing in the category(ies), where was looked to see if/if not present? Admin? Store-front? Do they differ? Does this category exist already and have other sub-categories in it? From the detail at the bottom, it does appear that something was done where there were product updated and product added...
Hi,
thanks for your help with your suggestion and clicking the show product to 1 I have the products showing. I will try and remember this and do another later this week.:)
Ron
If you inlcide the field status (header should be v_status) with the value set to 1, it will actvate the product on the site. All depends on how you want to manage the process.Quote:
Originally Posted by stuffwo
Hi, I am having problems with easypopulate 4 importing. It says successfull yet no stock imported, can anyone help me. please.
Version of EP4 installed?Quote:
Originally Posted by widget50
Easypopulate 4.0 Master lastest version with zencart 1.5.4
So I added to the store some items categories etc. then i exported the file. add more items to the csv, go to upload and upload the file in easypopulate and it says successfull.
However, when i go to the store none of my stock items are in the store or new categories.
My uploads file is in my admin (as suggested to move) and has a 755 on the directory.
1) "lastest version" is non-specific... There are two versions currently posted and discussed in this thread... The version available from the first post of this thread is version 4.0.30. A soon to be adopted version (assuming some independent feedback) is version 4.0.31 discussed at the top of the previous page.Quote:
Originally Posted by widget50
2) If you've only selected to upload the file, then the file is sitting on your server awaiting to be imported... Until imported, no data is attempted to be modified in the database...
Need to locate the file in the list in the table in the middle of the screen and then select to import the file. BTW, in version 4.0.32, these links will be changed to buttons to support the module submission process which expects database modifications to be made by post parameters rather than get parameters... Currently the database modification occurs based on the data/file provided, but the information in the get parameter does not specifically modify the database, somewhat a fine line (in my opinion), but close enough that it's worth making the change to ensure acceptance as a fully accepted ZC plugin and to provide the applicable/desired security of data transfer and database modification.
OMG thanks :smile: I have been looking at this for days. So i went to the file at the bottom and pressed import. LOL and viola all my stock is there. Thanks you saved my week.
Glad to help. Be sure to review the instructions provided in the download about how to build up the product and use the remaining features of EP4. :)Quote:
Originally Posted by widget50
I am working with Attributes, and trying to update "v_options_values_price" and "v_products_options_sort_order" using Detailed Products Attributes (detailed multi-line)
but I get this error for ever single line:
SKIPPED! - Attribute Entry on Model: - Not Found!
I exported from EP, update the info and reloaded... didn't even change the file name...
any thoughts?
Also getting this on top the page:Quote:
Originally Posted by HarryJL
Warning File Import Completed with issues.
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
First, please identify version of EP4.Quote:
Originally Posted by HarryJL
Second, do you use model#s in your store and does each and every product have a unique model#?
Third, when you say you exported with EP, was that wth this version of EP4? Or some other EP program?
Fourth, could you either paste the first few lines of your csv file as copied from a plain text editor and paste between [code] and [/code] tags? These are easily created by clicking the # button in the message reply toolbar just before pasting.
Background info:
ZC151
EP4.0.31 - Beta 08-01-2015
++++
Hi All!
I'm stumped by something that seems simple. (What else is new, right? lol)
I can't seem to remove the data contained in the v_products_url_1 for about 50 products. I did a full product export for the category with the dead links, deleted the deleted the bad, and uploaded/imported... hoping to overwrite the bad links with nothing.
No dice!
Is there a trick to this? I can probably edit the table directly via phpMyAdmin or do it manually in my carts catalog but I'd rather figure out the correct EP4 method in case something like this happens again.
Any help would be appreciated!
Thanks!
++++
Btw, in the event there is no method available, I'd like to make the following suggestion:
What if you allowed a magic word (say, "Remove_Data") to trigger a DELETE sql response during import routine?
As long as the magic word was unique enough, nobody would accidentally use it.
To confirm the condition in which this is occurring:Quote:
Originally Posted by Feznizzle
1. Datafile name does not begin with the text of one of the specific filename prefixes (capitalization is not important): categorymeta-ep, attrib-, or if installed sba-
2. The field v_products_url_1 is in the datafile.
3. The row of data with the product's unique key (products_model typically) is listed one time or if listed more than once, then the last occurrence has the data for the v_products_url_1 field that is desired.
4. That the about 50 products to be modified are in the import file.
5. That the v_products_name field is included in the datafile.
Regarding the separate "trigger", the expectation is that if the row data below the column header is exported and modified that import will reverse the process with the data that has been modified. The results in a final state of the data to be what was provided in the rows below the column headers. There are two "magic words" that have been incorporated, one is a product status (v_status) of 9 which will delete the entire product from the database following the process that is invoked by ZC. The second is a status of 7 which moves the master_categories_id to the category identified in the row that has status of 7 (creating the category as necessary) and if previously assigned to a master_categories_id removes the product from the category that was the previous master_categories_id. In all other cases, the expectation is that the data presented to EP4 is what will be entered into the database, so a lack of data (blank) in a field will import a blank to the database.
That is the "standard" operation for most of the tables in ZC as the row of data tends to exist for the product whether the data is "blank" or not. An exception to this can be seen in the attributes area when addressing downloads or music. Downloads have an additional table that when that table has data in it for that product indicates that the attribute is download related, no entry in that table and the attributes are "not download related". SBA (Stock by Attributes) operates similarily, a product can have attributes, but not be tracked by SBA. Those products that have attributes and are tracked by SBA appear in the products_with_attributes_stock table. If they are removed from that table, then they are no longer tracked by SBA... Because of the uniqueness of both of these aspects (SBA and ie. downloads), they are each handled separately.
Sorry went off a little in a tangent, but basically, data of import file in the applicable column (field) ought to replace the existing data of the database. If it is not to be modified, either remove the product, remove the field, or don't change the field from export to import... This is also why it is suggested to backup the database before an import in the event that incorrect data is entered that it can be restored...
Huh? That must have been the problem!Quote:
Originally Posted by mc12345678
Because of what you just said, I typically remove any column I do not want modified, leaving only what I am changing, plus the control (model# being EP4 default). Since I wasn't changing product_name, I removed it.Quote:
Originally Posted by mc12345678
But I just uploaded with product_name included (all fields, really) and it went in exactly as expected, removing the foul links.
Thanks, MC! You da man!
I'll take another look at that section of code. I think in the addition of languages/an extended field if found present in the database that the test for that sql to be run or not didn't get updated... It looks like originally that code section was intended only to address the products_name field and to be run only if a name was to be inserted or updated... Then along came some other fields... I expect to revise it to still do a test, but 1) only call the code section if something within is to be acted on and 2) only to include the field(s) with data to optimize the query as able.Quote:
Originally Posted by Feznizzle
That seems so much more logical to me! First hit the index (model# being default), then check field. If the index supplies point of reference, no need to act on anything other than supplied fields.Quote:
Originally Posted by mc12345678
Wait, maybe that's backwards? First check fields to find out what needs action (code needs calling), then apply only to indexed entry.
Having to supply the product name when all I wanted to do is alter product_url seemed illogical.
Anyway, glad your on it! Thanks again!
Glad you like it. :)
I need to modify products_ordered in the products table, I downloaded in Easy Populate 4: Complete Products (with Metatags) but that table column is not in the CSV file, is there another way for it to be download that I'm not seeing?
While I won't leave you with the one liner that would answer this (read the instructions), but if you add the products table field(s) desired in the custom fields section of the admin-configuration then it will appear in the export and be modifiable on the import. Do not include v_ before the field name. Just the field name as it appears in the database for the (YOUR_PREFIX)products table.Quote:
Originally Posted by marcopolo
That was easy, worked perfect! Thanks for quick reply and not giving me the one liner :smile:
Ok so I just tested a single line import worked fine, I figured I better try a couple lines to make sure that works and it gave me the following error:
UPDATED! - Model: 10 | 737 |
UPDATE PRODUCT FAILED! - Model: 20 - SQL error. Check Easy Populate error log in uploads directory
UPDATE PRODUCT FAILED! - Model: 30 - SQL error. Check Easy Populate error log in uploads directory
in the error log I have:
MySQLi error 1292: Incorrect datetime value: '-0001-11-30 00:00:00' for column 'products_date_available' at row 1
When executing:
UPDATE products SET
products_price = '15.1000',products_upc = '',products_ordered = '258',products_image = 'test.gif',
products_weight = '1.2',
products_discount_type = '0',
products_discount_type_from = '0',
product_is_call = '0',
products_sort_order = '0',
products_quantity_order_min = '1',
products_quantity_order_units = '1',
products_priced_by_attribute = '0',
product_is_always_free_shipping = '0',
products_tax_class_id = '2',
products_date_available = '-0001-11-30 00:00:00',
products_date_added = '2000-05-01 22:08:00',
products_last_modified = CURRENT_TIMESTAMP,
products_quantity = '786',
manufacturers_id = '1',
products_status = '1',
metatags_title_status = '0',
metatags_products_name_status = '0',
metatags_model_status = '0',
metatags_price_status = '0',
metatags_title_tagline_status = '0' WHERE (products_id = '4')
In the CSV I have the following only:
v_products_model,v_products_ordered
10,737
20,258
30,304
Ok nevermind, the error above was on my test site. I just tried it on my main site and it worked.
Glad to hear that it works, but I am curious about why it happened... What's different between the two? Does one have a differrent php version than the other? Are the versions of EP4 the same or different?
Recently corrected or tried to anyways an issue with those dates to make sure they work. I wonder if the sign is backwards for the more recent version(s) of php although I didn't test with as few columns as you did. (Not necessarily the intended use at the moment). Further since I'm working on publishing a new version I'd like to have ths addressed if it needs to be.
To be honest I have no idea the reason the test site does not work, I also on the test site can not save when I edit a product I get the following error:
05-Dec-2015 20:37:10 America/New_York] PHP Fatal error: 1366:Incorrect integer value: '' for column 'nestable' at row 1
/functions/database.php on line 53 <== in /var/www/zencart/includes/classes/db/mysql/query_factory.php on line 155
PHP version on test site is: 5.6.12-1 and Database: MySQL 5.6.26
PHP version on main site is: 5.6.11-1 and Database: MySQL 5.6.25
Hope that helps, if I figure it out I will post back more info.
and both sites have same version of EP4
Which is?Quote:
Originally Posted by marcopolo
Sorry :frusty: EasyPopulate-4.0-master - in changlog last entry is: 4.0.28 01-03-2015Quote:
Originally Posted by mc12345678
Saw'right. I would say that a few things are likely now discovered. PHP 5.6.26 is the cutoff for the change in how dates are processed/stored, and that it is advisable to update EP4 to take advantage of the improved code/compatibility. It's not entirely difficult: note the settings in the admin->configuration section, from the tools area select the remove link, upload the new files, select the install at the top, repopulate the settings (and new ones otherwise would just upload and keep on going).Quote:
Originally Posted by marcopolo
Otherwise, the other error doesn't appear to be related to EP4, but I say that because of the "odd" column referenced... It could be something else... Suggest trrying to reproduce the error but with lat9's mydebug backtrace installed...
I figured out why the test site failed! I had to edit my MYSQL my.cnf and comment out the following line:
#sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
restart mysql
then the import worked just fine.
Two questions to confirm/understand, which issue(s) were corrected by the mysql change, and was EP4 upgraded as part of the process?Quote:
Originally Posted by marcopolo
I upgraded to latest version of EP4 first, which did NOT solve the issue. I then applied the fix mentioned above and that fixed both issues.Quote:
Originally Posted by mc12345678
Again need specificity, by latest, which version?Quote:
Originally Posted by marcopolo
Easy Populate 4.0.30 - Beta 06-27-2015Quote:
Originally Posted by mc12345678
Ahh, okay I think (and am still trying looking into it) that the salemaker issue was resolved in 4.0.31, but there is still a minor issue or two to post to that. Meanwhile I have 4.0.32 prepped, but I want to test it a little more before publishing. Have a few different things going on and don't want to negatively impact any users...Quote:
Originally Posted by marcopolo
Hmm... Took a quick look at 4.0.31 and maybe the one thing missing is the longstanding error in the import file that there is one occurrence of $v_manufactureres (notice that misspelt) which occurs at the admin log entry line (1020) for when the manufacturers (notice correctly spelt) name is updated.. This is something that has existed since the first inclusion of the ZC 1.5.4 functionality... Only caught in the last month or so... 10-11 months of not being noticed...Quote:
Originally Posted by mc12345678
There are a few other minor things (do not affect functionality) that would be nice to include there, but they are in 4.0.32 which is as I said just around the corner...
I am using zen cart 1.5.1.
I have uploaded the easypopulate 4.0. If I upload the extras for 1.5 my admin crashes. If I leave it off the site stays up.
When I try to upload I get a blank white screen. I am trying to upload a download product listing from another zen cart 1.5.4 that I have.
The database tables in 1.5.1 all start wtih zen_, for 1.5.4 they all start with zc_. I believe this is the problem, does anyone agree?
The database prefix does not affect EP4, a blank screen wiill generate a log file, check your /logs directory for myDEBUG files. http://www.zen-cart.com/content.php?124-blank-page Post the most recent but obscure your admin directory path. The extras folder for the admin loads a definition to allow the menu option to appear on your admin panel.Quote:
Originally Posted by dspeak35640
What else do you have installed on this system? Please include the answers to the posting tips questions.
Thanks for quick reply.
Nothing else installed, this is a clean installation.
Here is the log file:
[22-Dec-2015 14:38:09 America/Phoenix] PHP Fatal error: Call to undefined function zen_record_admin_activity() in /home/content/XX/XXXXXXX/html/XXXadminXXXXXX/easypopulate_4_import.php on line 976
Thanks again.
Still need more info: version of EP4, PHP.Quote:
Originally Posted by dspeak35640
Missing at least one file: admin/includes/auto_loaders/config.zc154_compatibility.php
Or possibly:
Includes/init_includes/init_zc154_compatibility.php
Or the file(s) look like they are there, but not fully loaded/stored.
Hi there,
I am new to both Zen Cart and Easy Populate 4. I have installed EP4 which is working fine, however when i attempt to download a selected file via Zen Cart 1.5.4 i get "404 (Page Not Found) Error". When i look in my admin/temp folder (which is assigned in the configuration) the file is there and i can download it from my file browser.
John
When you say you can download from your browser, but at the same time that you receive a 404 error, could you please elaborate or explain the difference? As for your settings. If the configuration option was set to use the admin directory, then all that is needed for the path is to enter the subdirectory within the admin directory. No where should the admin directory need to be typed in. Which means if I were to ask for the information that is typed into the temp folder text box, the only path information that should be present in that box is related to temp.Quote:
Originally Posted by allmart
Quote:
Originally Posted by allmart
@allmart, I'm still interested in addressing the issue, but need to understand what it is (if it still is occurring). Haven't heard anything back, so would you mind clarifying the issue, identifying what was done to resolve it, and if not resolved perhaps can assist with resolution/prevention? Would really appreciate the feedback.Quote:
Originally Posted by mc12345678
Uploaded EP4 4.0.32 to https://github.com/mc12345678/EasyPopulate-4.0, with download available from here.
One "issue" identified in trying to make it possible to import the categories/categoriesmeta files without all columns/fields included that if the description field of the applicable file is not included then a SQL error is expected at this time. I realize this is probably the field most desired to be removed if any are, but in developing that code, it looked "too easy". :) a better/appropriate process used for or similar to the products description needs to be incorporated.
Welcome testing and identification of other issues.
Change log:
4.0.32 02-08-2016. Updated for PHP 7.0 compatibility.
Corrected use of verifying that constant is in use and needs to be defined.
Completed incorporation of the German Language version of EP4 which allows for
EP4 to now be translated to other languages. Assistance always welcome!
Converted from storing web page data via $_GET to $_POST operations. Retrieval of files
is still by $_GET when selecting the download link(s) as well as links to generate
new files to modify unless the dropdowns at the top of the screen are used. This
also was a change away from using $_REQUEST to $_POST offering stricter
control of data transport.
Added checks in files that are "required" to validate that the file is being run from within
ZC by verification of a constant being defined.
Incorporated numerous notifiers to support expandability. (A BookX addon is in development by a
third party andwill be looked at for easy incorporation to minimize the effort of it
and other plugins being incorporated.)
Transitioned import queries to using bindVars to minimize errors that introduced by adding to the
code and to better handle the data being imported. This is also in support of packaging
EP4 as a downloadable plugin on the zen cart site.
Revised the Product Description table modification process for updates allowing any of the fields
or a combination of any of the fields to not be included in the update file, though the
base fields necessary would be the products_id (internally identified if not directly
provided), and the language_id which is identified off of the languages installed to ZC.
This also made improvements to the use of the short product description that was added
by chadd.
Added ep4_curly_quotes operations to several of the import fields.
Updated the sql install to clarify the areas affected by some of the settings.
Modified how categories were updated somewhat similar to how products/products Description
were affected; however, it does appear that additional work is necessary with that section
unfortunately as absence of the categories_description with the categories_name in place
will cause a SQL error because of an extra comma before the WHERE statement. :/
Similar process for category metatags was incorporated and has the same issue as categories and needs
to incorporate the processing added to product description updating to prevent a SQL error
if metatags_description is not included in the import.
Corrected an existing issue with short description for products that did not properly account for
a language identifier.
Moved additional file for ZC 1.5.x into the main file path instead of being an additional file/folder
with which to contend. Software remains functional on pre-1.5.x with appropriate action taken
to install that version's needed file(s).
Generated a module file to support the filelayout instead of having it within an additional function
file as a function. This was to support adequate incorporation of notifiers without making
the functions file a class of its own and other work arounds.
Okay, have corrected this:
Still welcome testing of the updates and identification of any issues.Quote:
One "issue" identified in trying to make it possible to import the categories/categoriesmeta files without all columns/fields included that if the description field of the applicable file is not included then a SQL error is expected at this time. I realize this is probably the field most desired to be removed if any are, but in developing that code, it looked "too easy". :) a better/appropriate process used for or similar to the products description needs to be incorporated.
Sorry but i am new at this and would hope for your consideration.
I am using ZC 1.5.4 and EP4 latest version. I am able to import and export the product_upc field but can't figure how to display it in my products/catalog page. i was successful with Group pricing.
Thanks,
Sorry for not getting back to you sooner. To clarify, the problem that i have is when i access the tools-EP4 in Zen Cart...after a csv file is created either by import or export, i have the option to to split/import/delete or download file, if i select the latter (download) i receive a 404 error with the correct address of the file in my temp folder displayed in the browser window. However i am able to open the file with my FTP in the exact same location. Although it is indicated that "page not found", it is clearly visible and accessible through FTP in my temp folder.
Good to hear that in and out is working. Does help to identify the specific version to which you are referring. (For immediate assistance and for others in the future reviewing the thread for similar "issues").Quote:
Originally Posted by allmart
The products_upc field is something that is added to the products table by some other process... EP4 allows updating/modifying it because it recognizes that it is in the database. Because 1) that field is not something created by EP4, 2) it was added by some other process/program, and 3) that there is no issue with interfacing it using this plugin. Technically it is something to address elsewhere in the forum. (The plugin that added the field, or a new thread.) But, that's no reason to not at least provide some more info to possibly be directed elsewhere.
Am curious about which version of EP4 is in use to validate operation.
Ohh, that's ok (time between). That is because csv (and as necessary) txt files are not by ZC default files permitted to be accessed by the uri. The installation instructions indicate that the .htaccess file would need to be modified/created to support that.Quote:
Originally Posted by allmart
For example, in the admin directory (if the files are stored somewhere off of the admin directory) there is an .htaccess file that contains the following line:
[CODE][<FilesMatch "(?i).*\.(php|js|css|html?|ico|otf|jpe?g|gif|webp|png|swf|flv|xml|xsl)$">/CODE]
In ZC 1.5.4 anyways.
This line needs to be updated to include csv and txt (or better to duplicate the .htaccess file to the new directory and have only csv and txt referenced) to allow download of those files from the browser.
So it could become:
[CODE][<FilesMatch "(?i).*\.(php|js|css|html?|ico|otf|jpe?g|gif|webp|png|swf|flv|xml|xsl|csv|txt)$" >/CODE]
If so changed in the admin file, then all sub-directories that "use" that file will also be permitted to access csv and txt files... It is this reason that for "security" sake, that only the applicable folder should have those permissions.
That help?
Thank you for your prompt reply and solution...Problem solved!!!
EP4 version is 4.0.32, any direction to resolution is appreciated.
Quote:
Originally Posted by allmart
Is there anything still needed to resolve? Sequence of posts suggests no and yes, respectfully. :)Quote:
Originally Posted by allmart
Thanks for your help, I have yet to learn how to implement a UPC field to display in my admin product/category page and in the description of product on it's web page but that is not an EP4 issue and will search elsewhere.
Thanks again
Numinix Product Fields might help, it may also come with more than desired/needed, but that's what a development site is for so that you can try something and make adjustments/modifications to get it "right".Quote:
Originally Posted by allmart
Or there is:
UPC/ISBN Product Fields
And other options appear by searching the plugins on UPC...
After reading all this thread because I am working with EP 4.0 again after a couple of years. I am trying to do exactly what the other poster is wanting (make my defined fields show up) .. Think I will try to the Numunix Plugin thanks for pulling me out of a fog :-)
It did, however bring back what is now a fond memory (nightmare then). Back when I was adding code like mad to OSCommerce.. oh yes, many moon ago! I came upon a young EP, and I needed extra fields and I needed them to show. I wrote all the code in the templates for it to display and everything. Man am I getting lazy these days! ... LOL.. Just thought I would share.
Glad the little "note" helped. It *is* another case of multiple plugins in one way or another supporting each other. I can't for certain comment on all of the functionality of that mod. It may still require coding to address the additional fields, but it at least will get things a step further along if all that is involved is acceptable. :)Quote:
Originally Posted by fwood
I am sorry if this question has been asked before; I have uploaded a plugin so that I can add to Product in Category the Products Cost. What do I need to do so that when I use this plugin to make a backup and later restore my products the Products Cost is also backed up?
I have just rebuilt my shop and when I used the backup copy and imported the information the Products Cost is showing zero even though I did put the info in before the backup copy was made
I caution against using EP4 as a backup tool... There are suggested programs such as DrBytes database backup and simply exporting the database from phpmyadmin that will more thoruoghly capture all the necessary data to restore the site's data to the point at which it was retrieved.Quote:
Originally Posted by adb34
That said, if this plugin is going to be used to backup data, a couple of things, and it is really this part that is covered in the instructions and a basis for operation: export, modify value, save as new file but with end of filename slightly changed, import the file, witness that change made to site matches intended action and witness that no other similar undesirable changes were made...
As to this cost field. EP4 does export cost export through a few different export paths, but if something were done to the database to add a field, then need to identify which field in which table is desired to be "preserved". If it is in the products table, then use the custom fields area in the EP4 configuration screen. If a field were added to a table outside of the products table and the field name is not already recognized and handled, then additional coding would be needed to add that field in where desired.
So in short you are saying is, drill down admin/configuration/Easy Populate 4/User Defined Products Fields; add the fields that I want to add. Then this is shown in admin/tools/Easy Populate 4 right hand side half way down is User Defined Products Fields: and under that I should find the plugin I have named.Quote:
Originally Posted by mc12345678
If above is correct, then how do I change the word 'false' in to 'true'?
The plugin information: true/false is based on code being present in EP4 to recognize and associate a field with a "plugin". The addtion of a field to the user defined fields will not modify the existence of a "true/false" field on the right side. It will only modify the list of fields identified in the user defined field. Further, the user defined field is only associated with the products table (at this tiime) therefore if the additional field of any plugin, modifies say the categories table, the user defined field will not assost in retrieviing that field.Quote:
Originally Posted by adb34
I have read your comment more than a dozen times and I do not understand what you have put.Quote:
Originally Posted by mc12345678
Drilling down to admin/configuration/Easy Populate 4/User Defined Products Fields inserted 'Products Cost' which the plugin (Product_Cost_Display) is used to add the cost to me in the products page.
I then go to admin/tools/Easy Populate 4 and on the right hand side under 'User Defined Products Fields:' is the title I put in under admin/configuration/Easy Populate 4/User Defined Products Fields but it is showing 'False'.
Now I understand a bit of what you have put however, do I need to re-install 'Product_Cost_Display' for EP4 to see or what?
The information needed to know is 1) what is the exact name of the field(s) added by your plugin, and 2) to what table(s) does it add the field(s)?Quote:
Originally Posted by adb34
Let's assume the name of the field is product_cost_display and that the field is added to the products table. If that is the case, then the field will appear in the export and will also be imported (when present) to the database when working with the full products type import/export file once the user defined field includes: product_cost_display.
Take it one step at a time:
If there is a field in the products table to be used, then goto the configuration->ep4->user defined field.
Add each field that is in the products table that is not normally exported with each field separated by a comma.
Goto tools->ep4, export the full products data and will see the values associated with the field(s) that were added.
EP4 does not "detect" software installation, it generally looks for fields to exist in the database for "known" plugins or attempts to pull data based on what the user has entered as a custom field.
Help. Newbie here and I love the simplicity of using easy populate but my images are showing up small distorted when new products are added using easy populate. Tried Image handler. Only way they get fixed is if I go in open product to edit and click update. Any help would be appreciated. My site is www.thedragonskeep.net check out the witchcraft/pagan books & calendars category pretty sure some there that are waiting for me to fix.
Thanks
Sandria
So, EP4 does nothing more with an image than a default ZC installation does. It simply populates the database with the location of the main image. If there has been some software installed that must perform som action on the product while stepping through the collect_info and update_product step(s), then that action must be duplicated at some point in the process... (Ie. Custom coding).Quote:
Originally Posted by Amethyst_fairy
As to locating the image(s) that might be a problem, well, 137 product, not sure if issue is visible in the categories listing or if only when viewing the product_info page, also don't know if it is on desktop only or on the particular mobile template that is in use and actually aggravates the daylights out of me because so slow which further was aggravating to scroll down to the last of what seemed like 100s of categories... But then maybe I accidentally expanded a category because of the template. Sorry, I digress... Anyways, point being thank you for identifying the website and the category, but could really use further refinement to help out. Otherwise glad that EP4 is working for you.
Fyi, the FALSE next to the user defined products table field indicates that the field entered doesn't exist...sort of a pre-notification before going through the process of exporting, downloading, opening the file up to then determine that the field desired is not present.. Again goes back to what exactly the field is within the products table that might be desired to export/import. The list of fields associated with the table can be seen through phpmyadmin.Quote:
Originally Posted by adb34
Thanks for the info, mate. I will get my head around this.Quote:
Originally Posted by mc12345678
What plugin is this? What is the link to download it?Quote:
Originally Posted by adb34
Are you sure it's not just adding visible information to the user display side? After installing it was there anything on the admin side that had to be entered new/differently for product in the admin?
Hi,
Thanks here are a couple of links for the products I haven't fixed yet. http://www.thedragonskeep.net/index....ducts_id=23868
http://www.thedragonskeep.net/index....ducts_id=23857
It happens both on regular and mobile theme. As soon I open the product in admin and literal preview, then update without updating anything else it fixes the image so unsure where in the translation it is getting mistranslated :-) This is one I fixed by opening, preview and safe in admin- http://www.thedragonskeep.net/index....ducts_id=23796
Thanks for your help.
First thing I see is that your images are saved with capital letters... Default operations do not like at least the capital extension *.JPG... This could be a source of your issue.... Not sure how the file(s) are saved, but the database should not have them as capital.Quote:
Originally Posted by Amethyst_fairy
Example in order of above:
Apparently in "opening/editing/saving" the product, the capitalization is modified/corrected, but if the file were saved and referenced in lowercase, then this should not happen/need to happen.Quote:
pID: 23868, SITE/images/BMAGWHE.JPG; pID: 23857, SITE/images/BEVEWIT.JPG; pID: 23796, SITE/bmz_cache/7/7cf17543707cfa11e19900d1ab6d5392.image.136x180.jpg
That maybe the issue as I was using the database from the supplier. Quick question before I try a couple of trial ones is it just the JPG that shouldn't be capitalized or the whole file name. If just the JPG then it is happening in both lower case and upper case example http://www.thedragonskeep.net/index....ducts_id=23904 Otherwise maybe an easy fix :-)
Thanks
Sandria
Trying to figure this out. Tried all lower case didn't work.
Here is 2 image HTML from product information one from a product up for awhile.
<img width="93" height="180" title=" 1 1/2" Ankh sterling " alt="1 1/2" Ankh sterling" src="bmz_cache/0/0309ca239ec1515034f168ae193a61d5.image.93x180.JPG">
http://www.thedragonskeep.net/index....oducts_id=4120
And one of the new candles
<img width="100" height="80" title=" 2 Color Gold/Green 7 day jar " alt="2 Color Gold/Green 7 day jar" src="images/CJ72GG.jpg">
http://www.thedragonskeep.net/index....ducts_id=23941
Trying to figure this out :-)
Thanks
Sandria
Attachment 16047
If I right click and click view image full image then shows. Attachment 16048
So confusing.
And the actual file(s)? Are they stored in all caps, small, etc..???
What you have is IH (not sure which version as I have lost track of which ZC you have installed) but the IH version is not the beta from github otherwise the filename wouldn't use the hash folder arrangement for those "modified".
There is something about the filename and file that is not lining up... Further, in past experience I have been advised at the minimum the extension has to be lower case, but preferably the entire name of the file. Whatever is put into the database should have the same name on the server, capitalization counting. There are no extra tables created by IH to "monitor" the filename. It uses the existing ZC database tables and then just provides some user notification during the admin portion about things that have gone wrong. Further, the bmz_cache files are to auto-create/recreate upon visiting the page and the file not existing where expected... But that depends on the early discovery portion...
This is not truly an EP4 issue as EP4 is populating the database with the information it is being provided and retrieving the same type information, but something about what is put to the server is not agreeing with IH4... Might I suggest following this bit of the instructions.
Download a product that is fine and one that is not. May take downloading a few categories, whatever.
See where the image file path is pointing for each.
Visit that/those areas to see how the file(s) lineup, look, etc...
Update the broken file/product....
Export the database entry(ies) that contain that line/product.
Visit the image path identified in that file.
What changed between the exported line and the file at the destination? Meaning what's happening?
Now, for one of the "broken" files. Repeat the action that was performed to it using EP4 as necessary though I don't expect there to be much tha EP4 will fix related to this issue per se....
You are your own best diagnostic agent...