Printable View
The field can take whatever your store will be able to process provided characters are properly escaped.Quote:
Originally Posted by fjbern1943
For a default ZC store, the field contains the path to the base image that is then used to identify additional images. It is not the image itself, just a "pointer" to the location of the image. That pointer is then used in your store to complete the path to the picture.
v_products_image refers to the main image and assumes the image is located in <website root>/images/ folderQuote:
Originally Posted by mc12345678
if you organize your images INSIDE the /image folder, then you would add that to your image path
say your image is:
<website root>/images/books/bible.png
then you would put "books/bible.png" in your v_products_image column.
For multiple images, review the instructions here:
https://www.zen-cart.com/content.php...s-to-a-product
hope this helps :p
Thank you for your responses Gentlemen. However, what I am trying to avoid is to have to add additional images using Image Handler to add additional product pictures manually for each individual product. I am looking for a way to be able to add the additional picture links within the EasyPopulate plugin to accomplish this task. Product A would point to imageA.jpg and imageA_1.jpg etc.Quote:
Originally Posted by chadderuski
Best regards,
Frank
Additional product images are 'assigned' buy the file name of the image file. They are not assigned to the product in any way. This plugin does not upload any images, those need placed on the server separately. Use this to assign the main image. Upload the main image and any additional using the proper naming convetion.Quote:
Originally Posted by fjbern1943
We were both saying the same thing in different approaches.
As chadderuski stated, if the image for Product A is product_A.jpg and the image is to be in the images/category_i_chose_directory folder then in EP4 no matter how many additional images there are, you would populate the field with category_i_chose_directory/product_a.jpg.
Then product_a.jpg would be the main image and product_a_1.jpg would be loaded just like all of the other additional images.
EP4 does not upload the image, it uploads the path in the database field used to present and process images.
In order to upload all of your actual images you could use ftp to do so, after they have been named to align with the primary/main image filename base as described in the link chadderuski provided and as you have indicated to want.
So let me see if I understand this correctly. As long as I populate the v_products_image column in the easypopulate csv file with productA.jpg and then upload via ftp two files into the same directory. One being productA.jpg and the other productA_1.jpg the product info page in the storefront will show both images??????Quote:
Originally Posted by mc12345678
Frank the Confused!
Well I'll be a Monkeys uncle, I just tried it and it works AOK. Now all I need to figure out is how to get the additional image to open up with lightbox like the original image instead of a regular browser popup window. Any hints!
Thanks to all.
Frank
Wrong thread to discuss, but usually involves making sure the javascript is installed to the correct includes/modules/pages directory and/or properly merged the applicable files. It also depends on other factors, but usually its all about the install.Quote:
Originally Posted by fjbern1943
QUOTE=mc12345678;1320326]Wrong thread to discuss, but usually involves making sure the javascript is installed to the correct includes/modules/pages directory and/or properly merged the applicable files. It also depends on other factors, but usually its all about the install.[/QUOTE]
Of course you are right , I thought that when I asked the question. I will move this part of the discussion to the right thread. Thanks for your help.
Frank
Never hurts to ask. :)Quote:
Originally Posted by fjbern1943Of course you are right , I thought that when I asked the question. I will move this part of the discussion to the right thread. Thanks for your help.Quote:
Originally Posted by mc12345678
Frank
curious problem here. I installed EP4 to my test site. the configuration menu is not working. every item shows the "Uploads Directory" configuration setting, but the options are true / false not a text entry box. If I pick one of those, eavy item on the page is changed the that selection. All true or all false. That's just all kinds of wrong /smile/
I did the uninstall option, deleted all the files, and deleted the configuration items left behind by a different version, and reinstalled the current cersion. same result.
version installed is: Easy Populate 4.0.36.ZC - 07-05-2016
Any ideas?
Very curious indeed.Quote:
Originally Posted by jsteggy
Did you happen to try logging out and then back in after trying the install?
What's really odd here is a few things:
1) multiple configuration_key columns have been uploaded (which must all be unique otherwise would error out and not get imported)
2) with each unique id the same "settings" are applied.
3) the database install uses an insert command not a select so caching (ZC cache anyways) should not be a factor for a default store.
4) if there was a previous version of EP4 installed, the queries are written such that they attempt to insert, if unsuccessful then they move to the next query all except one which updates itself if there is a "problem". And that query doesn't even provide a result in a "normal" configuration area.
Would you mind trying something for me?
In the includes/function/extra_functions/easy_populate_4_functions.php file, there is a section related to install. In that install section is a series of: $db->Execute( statements
At the end of each one, could you replace:
with:Code:);
Could you also identify more about your system's setup (posting tips information for starters)? What program/version was previously installed?Code:, false, false, 0, true);
That's very interesting because in my testing I didn't come across a situation like that.
And try that?
How to exclude the domain name from the metatags_title
Generally a combination of modifying: includes/languages/YOUR_LANGUAGE/YOUR_TEMPLATE/meta_tags.php and includes/modules/YOUR_TEMPLATE/meta_tags.phpQuote:
Originally Posted by su35
If the file does not exist at the end location, then suggest copying it from the directory above (removing YOUR_TEMPLATE) or the default language of English as well.
YOUR_TEMPLATE is the folder name given to the template you use which ideally should not be any directory that exists in a default zc install but instead a template folder added as part of your build.
EP4 does not add this information as part of the process.
Thanks replyQuote:
Originally Posted by mc12345678
The domain name is part of the content in the databasse (table:meta_tags_products_description, culumn:metatags_title). The same file, if I import on local host, the content of metatages_title includes the local domain name; if I upload and improt on living site, it includes the living site's domain name. That suggests that the domain name is induced in the EP4 proccess.
I didn't say that EP4 couldn't have an effect on the metatags, but if you did not enter the content into the import file for metatags_title, if they are not appearing in your exported file and also are not appearing in the imported file, but they are appearing on the website, then it is the file(s) on the website that are preparing the information for display. EP4 can turn on/off meta information for a product. It can add/or import specific content to be a part of specific product meta tags, but it does not add the domain name to any of the content.Quote:
Originally Posted by su35
The fact that importing an EP4 file causes the same response but with different information means that EP4 is triggering the code to show that type of information, but it is not "aware" of what information should be shown and it does not magically add that content.
If you would like, please provide the header row and one row of data for a product that is showing something that you are not wanting and also explain what it is that you do want to have happen.
Thanks nc12345678. I find a few products haven't such problem. It looks like that there is some error in my data prepare code.
Hi all
I have just changed from OSC to Zencart and have a very basic install, but EP 4 is not exporting a file ( I only have 1 product at present) to test it as I need the correct headings
I have been using EP in OSC for about 8 years now and have recently done a new OSC 2.3.4 BS Edge website, but where I list my products do not have a compatible product feed yet, so I had to change
While loading the new site with a new version of EP for OSC I had to change my headings for me to load the 15 000 items I list
I have tried to download this 1 item to see the headings but all I get is a blank screen
Any help out there please?
Thx
Russel
When you say a basic install, can you please identify what ZC version, what php version?
When a blank screen is provided, this typically means that an error has been caused and if the error occurs during the after a ZC trigger point, then it should be logged where ZC logs it's error logs (see this FAQ on blank or partial blank pages).
Which type of export was attempted, from what path? (ie. Dropdowns at top, links along side?) is the one product an active product or is it marked as out-of-stock.
Ie. Details help to be able to see how to reproduce the issue, what might be causing it, and how to prevent it from occurring again.
Hi there
I googled and found a wiki entry that lists the headings
I have the latest 1.5.5b installed, and the latest Easy Populate 4.0.36.ZC
Server OS: Linux 2.6.32-642.11.1.el6.centos.plus.i686, Database: MySQL 5.6.33, PHP Version: 5.6.24 (Zend: 2.6.0)
Product is active, selected from drop down menu for just that category or all
Error log says easypopulate_4_filelayout.php is missing - checked now and saw all files for modules were missing!
It worked now - will test after converting my current file
Thx
A couple of things, if not mistaken the wiki entry of specific fields hasn't been updated in some time (some may have been added/changed), but it is a good resource with which to begin. The EP4 code permits export of additional product table fields, but those fields must be identified to EP4. They can be found by review/comparison of the fields in the products table of your database.
Glad it's working for you now and welcome to ZC!
For what it's worth, EP4 version 4.0.36.ZC (available for download from https://www.zen-cart.com/downloads.php?do=file&id=2069) has been tested against ZC 1.5.5d with no issues; however, there has been a reported issue with ZC 1.5.5d and a change introduced in versions c and d that may need to be undone in admin/includes/functions/database.php as referenced in this post although that issue did not appear in my testing against product addition or modification either manually or with EP4.
Please, where can I find a sample csv file in order to load my products?
I have to load products by model without attributes but with sub categories. Where do I have to look for a sample csv file in order to know the column order and column names?
Export data from your database. There is no better sample than that...Quote:
Originally Posted by solo_400
In otherwords: install EP4, goto tools->Easy Populate 4, on the left side, use either the dropdowns along the top or select one of the text based links. Each link will export a different formatted file, it sounds as if you will be using the full products options. Then a file will be generated and shown below. If you have chosen your admin directory to hold your download folder, then to actually download the file you should have also added the .htaccess file to that download directory or else you will have to ftp the file to your computer.
Column order is unimportant to EP4. It doesn't care what is first, last, or order in between. There is/was a sort of reason for the sequence of some fields on export, but that is for reader's potential understandability more than anything.
Lastly, please read the instructions at least once. The above is actually covered there, and further, because of the intimacy of this with your database: BACKUP before use and after use... BACKUP the database... BACKUP!!!
If I get it right, you suggest doing an export in order to get an idea about import file format. Right ?
Yup.Quote:
Originally Posted by solo_400
Sorry.
Yes.
Thank you very much !
I have installed on my 1.5.5 ZC
Some issues:
1. Every time I go in admin panel Tools->Easy Populate 4 page an error log file is created:
[xx-xx-2017 23:20:13] Request URI: /myshop/myadmin/easypopulate_4.php, IP address: xx.xxx..xxxxx.
error:14090086:SSL routines:SSL3_GET_SERVER_CERTIFICATE:certificate verify failed
Trying file_get_contents() instead., /var/www/html/myshop/includes/functions/plugin_support.php, 68, Array ([plugin_file_id] => 2069,[version_string_to_compare] => 4.0.36.ZC,[new_version_available] => ,[lookup_index] => 0,[url1] => https://plugins.zen-cart.com/versioncheck/2069,[url2] => https://www.zen-cart.com/versioncheck/2069,[ch] => Resource id #169,[response] => ,[error] => SSL certificate problem, verify that the CA cert is OK. Details:
error:14090086:SSL routines:SSL3_GET_SERVER_CERTIFICATE:certificate verify failed,[errno] => 60))
#1 trigger_error(CURL error checking plugin versions: 60:SSL certificate problem, verify that the CA cert is OK. Details:
error:14090086:SSL routines:SSL3_GET_SERVER_CERTIFICATE:certificate verify failed
Trying file_get_contents() instead.) called at [/var/www/html/myshop/includes/functions/plugin_support.php:68]
#2 plugin_version_check_for_updates(2069, 4.0.36.ZC) called at [/var/www/html/myshop/myadmin/easypopulate_4.php:84]
[28-Jan-2017 14:42:37] PHP Notice: CURL error checking plugin versions: 60:SSL certificate problem, verify that the CA cert is OK. Details:
error:14090086:SSL routines:SSL3_GET_SERVER_CERTIFICATE:certificate verify failed
Trying file_get_contents() instead. in /var/www/html/myshop/includes/functions/plugin_support.php on line 68
Any idea ?
2. CEON Uri mappaing links are not regenerated after import. I need all options available today in order to take a decision for solving this.
Looks like CURL is misbehaving. This could be a server setting (php.ini) - but I am not well-versed in that stuff.Quote:
CURL error checking plugin versions
You could try REMOVING the plugin_support.php file, or re-naming it to something like plugin_support_php.SUS and then try using Easy Populate.
I really don't know if the plugin support PHP file relies on other files... but try this. If things go even more pear shaped, then re-name the file to it's original name.
Look for CURL problems/configurations in the server settings.
Item 1 yes is related to EP4 using the ZC version check code to identify the presence of an update.
To item 2, EP4 does not come with the built in ability to manipulate CEON URI Mappings. It is discussed in this thread as well as in the CEON URI Mappings thread about how one can find software that merges or brings EP4 and CEON URI Mapping together. Even then, the operation (update/generation) is performed on database export rather than import.
After some tries I got new products imported default disabled. I have tried to import by placing v_status both "0" or "1" with same result, product status is disable in admin. Quantity is greater than 0. Is there some logic behind, maybe other fields must be set in order to load active products ?
I'm sorry. I have found wrong field on my feed.Quote:
Originally Posted by solo_400
Glad you figured that out. :)Quote:
Originally Posted by solo_400
v1.5.1
I am using EasyPopulate 4 to upload products from a few different sites into a single site listing all products from every site and all is working very well (it is a great plugin) .... until I need to update a file. The problem is I need to have 'broader' category names on the combined site and then have sub categories (which are actual categories on the site where the file is generated) so I am encountering an issue whereby the sub category name on the new site doesn't necessarily match the category name on the exported file. So when I upload the file it loads as a complete category in top where as all I want to do is upgrade the products in that now sub category.
Even if I change the 'broad' category on the new site to match the category name from the file generating site the file still wants to upload in to 'top'. I am exporting the file as complete products by category by active status.
Is there a way to have the file load into a specific sub category?
cheers, Mike
p.s. by giving the exported file a totally different name I can move it into the broad category and then delete the 'old' file and then rename the new file which achieves the aim but it is very messy
So I can't say that I fully follow the part about the file naming, as perhaps there is some incorrect terminology used there, but if I understand correctly, the issue could maybe be explained like this:
Multiple stores, each store has its own category structure such that the root of store1 has x categories, store2 has y categories, etc...
Some of the categories in store1 may overlap with those of store2, but the goal is to create/have main categories such that all of the product in store1 might show under a main category call it category1, the data of store2 to show up in category2, etc...
So the goal becomes, after export of product from store1, want to import/update the product in "master store" category1.
So, now the part about the category structure (covered in the instructions). The category path in EP4 is built by separating each category name with the carat symbol (^). So if one of the main categories was "first", then in the "group" store if that data was from store1, the category would need to become category1^first.
Because you would be working in a spreadsheet (Open Office recommended), it is easy to concatenate two strings together, copy and paste/etc... so you could prepend that category to all of the categories in the file. (not going to go into the basics of working with spreadsheets here, please seek such assistance via the internet.)
Now the important/tricky part is making sure that the primary key (default is products_model) from one store is different than any other primary key in the other store(s), otherwise data will get overwritten.
As to what I understand about the file naming discussion (or think I do), EP4 does not have a limit of files that can exist on the server. Next, there are a few particular names that the file(s) must have in order to process a particular way. The specialness of the filename(s) exists only in the first part of the filename up to and including ep (upper or lower case), after that, ep4 doesn't pay attention to the rest of the filename so use it as you wish and it is allowed.
In fact, it is suggested that if you download a file, that modifications made to that file are saved with a different name. Afterall, how often do you modify a backup of something instead of creating a new one from the backup?
Not sure if I answered your questions, but seemed like what was being asked.
Thanks for your response MC - maybe if I am more specific this time (was trying not to write a book).Quote:
Originally Posted by mc12345678
Example:
Take the site www.harmonyballpendant.com - the site name indicates its primary product line so in that site the prime product, Harmony Balls, is set up with categories such as Traditional Balinese, Gemstone Harmony Balls, Harmony Ball Bracelets etc etc but not a category 'Harmony Balls' as that would be superfluous. The same applies to the other sites that I am extracting product from into the new 'mega store' - each site has a number of categories that are breakdowns of the types of the prime product which is part of the domain (e.g. TreeOfLifeJewellery.com and SterlingSilverRings.com.au) so no need for a category of that name.
So that the new site (mega store) makes sense to the user I have established 'main categories' that encompass the individual 'prime' product groups out of necessity - then in each category is sub-categories that actually represent the 'categories' of the individual source sites. So using the harmonyballpendant.com example I have created a main category for these products on the new site called 'Harmony Balls' which does not exist on the harmonyballpendant.com site - from this main category I have established sub categories that are duplicates of all the categories on that source site.
If I use the category Traditional Balinese Designs which exists on the source site to which I have just added 20 new products to since the original file generated and uploaded to the new site - so I am updating that subcategory products list, and I generate a 'new' (products complete) export file in EP4 and upload it to the new site I have no control over where it loads - it simply loads into 'categories' for the new site whereas I would like to have it load into category Harmony Balls > subcategory Traditional Balinese Designs and overwrite the existing file ... rather than have to manually add these 20 new products one by one into the new site (or change pricing on 300 items in a category) .
To solve this I can delete the existing sub category Traditional Balinese Designs and then 'move' the just uploaded new file Traditional Balinese Designs which is now a 'category' into the 'main category Harmony Balls' so that it now becomes the updated 'sub category' Traditional Balinese Designs replacing the one I just deleted. My concern, if it is one, is the potential DB issues?? with all the deleting,adding and overwriting.
This above example is multiplied by some 30 categories across 4 sites - all the categories for 3 sites so far have been successfully uploaded into the new mega store and then 'moved' into 3 newly created 'main categories' - a simple process which speaks highly of the EP4 plugin - it is just when modifying the original site 'category' it becomes an issue as described above.
I was kind of hoping there may have been a simpler way. (upload file to 'X destination' rather than just upload).
As stated, it is only an issue when modifying/adding additional products and also when prices or quantities change.
I hope this better explains my query.
cheers, Mike
Okay, so please understand, if it is category destination that is the issue/concern, in the column: category_name_x, whatever you have there for each "instance" of the product is to which it will be tied.
If you want to have a product in main category Traditional Balls and sub-category Traditional Balinese Designs, then the category_name_x (sorry if I have the wrong field name at the moment) for the given product would need to be: Traditional Balls^Traditional Balinese Designs.
How you get there, that would/could depend on a number of things, but the important thing is that you can manipulate the data as much and however you would like to be able to end up with the store "arrangement" desired.
Basically, you have to assign/designate the category structure that you would like the/each product to have prior to uploading. Once uploaded, categories may get generated that are irrelevant or desired to be removed.
So, I'm not exactly sure (still?) what the confusion is or if it is just a matter that it takes "so much" to set it up the first time.
Ohh, yeah, so if you already have the product in the mega store where you want it and you don't want to add the product to any different categories, then simply delete the related category_name_x field(s) from the file being imported. That way, the product is not applied to any new category(ies) and is simply updated. Of course if taking data from the mega store to an individual store, want to be sure that the data fed to the "individual" store only applies to that store or at least is not carried over from something.
Thanks MC - seems from what you are saying I can manipulate the files prior to uploading - something I have not tried as yet so I will give that a shot.Quote:
Originally Posted by mc12345678
cheers,
Mike
Absolutely!!!Quote:
Originally Posted by shags38
That is one of the main concepts of use, the ability to manually modify the data in any desired way to target a final goal. Like, if one wanted to increase all product that meet a certain criteria by a particular amount, the data could be sorted and the price(s) so adjusted. Or product description could be revised, etc...
I just want to give my compliments to the people behind this module and once again to the fantastic ZC community and those helped me to find what I needed.
It certainly is more than one person behind this software. Feedback and input has been the most helpful to make modifications/improvements. I think that's the way with any plugin out there.Quote:
Originally Posted by solo_400
Glad that it's working for you!
I think another configuration option that would be very useful is to limit the export to canonical or master product only, thus eliminating duplicate linked products in the file. Currently I have to manually do this following the tip from the open office forum. Thanks for making this great module even more useful than before, I love where this has been going.
Take a look at my github master branch... Already ahead of ya'.. :) Had a few other things to fix before posting to the ZC forum (want to be able to reduce the columns that are needed when uploading attribute related files and possibly add a little direction about how to prevent changing attribute related columns to zero's instead of +'s or -'s... Something else too, I forget at the moment, but not yet ready to release as a package, but what is there works...)Quote:
Originally Posted by lankeeyankee
Very nice, thanks!!
Do be sure though to understand that if the category is changed on one of those records before uploading that a linked product will be created whne the file is imported. Also and the obvious thing is that export using that feature will not identify whether the product is or is not linked.Quote:
Originally Posted by lankeeyankee
It is still possible to use the status of 7 to assign the current category that is on the row as the master_category_id which will remove the product from the previous master category if it had one or will establish the then current category as the master category if there was one not assigned for some reason.
Is it possible to add the "categories_id" to the export file?
Tony
Quote:
Originally Posted by tonyreynolds
Would have to ask what is the need for the category_id?
If you obtain the current copy of EP4 from the link above, then the export without linked product will include the master_categories_id for the product which is the same category_id for the category on that line.
I have the most recent release of EP4 installed from GitHub.
I need the categories_id to build custom pages and I use the categories_id as a separator for the differing pages.
As long as the master_categories_id matches the categories_id I am good ,but I do not see that field in my csv export.
Is there a flag or setting ge or special export master_categories_id in the csv only the category description?
Tony
So, the export to which I was referring was the product export with no linked product. That is where the connection of category and master_categories_id is coded. To better support what you appear to want/need, would require a little more "fiddling" with the code. Specifically the categories export it sounds like. Two places to touch: the file_layout area to include the field in the file, and then in the export section of the categories to include/set the database field to the file layout so that the number (in addition to the name(s)) would be populated.Quote:
Originally Posted by tonyreynolds
Thanks. I will give things a more detailed review.Quote:
Originally Posted by mc12345678
Tony
Ok. I was able to edit the easypopulate_4_filelayout.php and the easypopulate_4_export.php to get the categories_id to appear in the cvs and the output propagate from the query to the csv.Quote:
Originally Posted by mc12345678
I have looked through the easypopulate_4_import.php and am not sure I even need to edit the file since it already acts upon the category using the categories_name. However to be consistent I do want to leave the categories_id in the csv to be imported. Will that cause any problem?
Tony
First "rule" of trying EP4: test. :)Quote:
Originally Posted by tonyreynolds
But, that said, the only thing is if you or whomever is using the software thinks that the categories_id actually identifies to EP4 that it should act on it will it be a problem.
The software, as you have said/seen only acts on the fields/columns that are "anticipated" or needed to update what is programmed. So, I would say you should expect no problem from the software with it, but it may not match up with what one would expect by seeing the number and the name.
My apologies if this is a duplicate but I can no longer import metatags into my website.
ZC version 1.5.1
EP version 4.0.24
So the process is.... I download my csv file from EP 4, update the metatag fields using Open Office Calc, and then import the updated file into EP 4. There are no errors on the screen and it appears that the fields have been modified correctly but when I go into the individual items, the metatag fields are blank.
And this is where I go blank. I honestly can't remember if I have succesfully modified the metatag fields with EP 4 or if this was done when I was using EP CSV. My database has 5300 items and all but 600 have been updated with metatags.
My gut feeling is there is an incompatibility between these two versions but I'm not a programmer so it's difficult to trouble shoot. Any help is GREATLY appreciated.
Even though you're using a very old version of EP4, some of the basics should still apply. 1. Verify that in your configuration for EP4 that meta tags are being handled.Quote:
Originally Posted by mrcastle
2. Be sure that the file you are downloading to modify was in fact generated by EP4 (described process doesn't specifically indicate what program created the csv), then after uploading (which isn't described), then import the uploaded file. Now. With that many records, you may need to split the file before importing so that the code doesn't timeout from trying to process too many records at one time.
thanks for the input MC. I was tinkering around and realized that row Z (v_metatags_title_status) was set at zero. I changed it to 1 and all of 3 of the metatags (title1, keywords1 & description1) uploaded and now display properly. I'm not exactly sure why that fixed the problem but I'm happy I didn't have to spend a ton of time on this! Thanks again.
Even though much of the data can be transferred from file to database relatively easily, there are some things that were done because they make sense. For example why upload data about a product that isn't going to use the data? There are other ways and places to stash away data if so desired.Quote:
Originally Posted by mrcastle
Glad you were able to figure it out though, the next suggestion would have been to export the data, manually adjust one item in that list, the export again and see what is different.
We're having trouble updating metatags for products. I'm unclear about the file naming convention required. I tried CategoryMeta- but get "SKIPPED! - Category ID: - Not Found!"
Using "Full-EP" results in the file importing but the metatags do not update.
This is on ZC 1.5.4 and EP 4.0.28.
Any help is appreciated.
Apologies for the delay, had to get into a position to review code from 4.0.28...Quote:
Originally Posted by jeking
If updating product metatags, then the following must be established:
In the configuration for EP4, need to have enabled Product Meta Data.
Then, the import file needs to be one that would be processed as a full product file which is basically any filename that has the extension .csv that doesn't meet one of the "special" or unique other filters.
The field v_metatags_title_X must have data.
The value of X in the above v_metatags_title_X field corresponds to the language number (id) that is to be populated. Such number to language is shown on the EP4 screen on the right side and that number must exist in the store.
Then of course there is the ZC side of metatag information.
Beyond that, the table meta_tags_products_description is involved and if there are issues with it then it could be associated, but my guess is the metatags_title part. The latest copy still has that as an expected value to be included in the import file.
No apology needed!Quote:
Originally Posted by mc12345678
With your answer I was able to determine the store owner removed several columns from the csv, specifically:
v_metatags_products_name_status v_metatags_title_status v_metatags_model_status v_metatags_price_status v_metatags_title_tagline_status
With those in the file, all is good now!
Thanks for the help.
Hi, I'm trying to figure out how to remove one of two categories selected for several items using EP4 All of the items were originally placed in the category "miscellaneous" but since then I have created more specific categories like "Bach" "Bartok" "Beethoven" etc. When you do a search on "miscellaneous" all of the "Bach" "Bartok" "Beethoven" items are still listed. So I want to remove them all from the "miscellaneous' category and just have them in their own unique category. I think using EP4 may save me several hours of doing this one by one. Please note: all of those items are using "miscellaneous" as the master category, so I would need to somehow change master category first. Thx
Actually, if the master category is currently associated to the product and it is desired to remove them from that category, then it takes a little bit of logic/thought, but it is simple.Quote:
Originally Posted by mrcastle
Here are two scenario that would work to remove a product from a category *AND* ensure maintaining a master_category.
If the standard output file that shows linked product is reviewed (sorted at least by the primary key) and there are two or more entries for the product: then either 1) remove the row that includes the row having the category that is the current master_category which is supposedly also the one from which to remove the product or 2) be sure that the category from which it is to be removed is in a row above/before the one in which it is to end up/stay.
Change the products_status to a value of 7 for the row that contains the category to which to change to master_category. This will perform two things. 1) it will change the master_category of the product to the category assigned for that row and will remove the product from the category from that which was identified as the master_category for the product.
If the product is not linked (only one record in the linked product export of a full set of the database, then simply changing the products_status to 7 and the category assignment to that desired will assign the product to the category and update the master_category to be that of the same and will remove the product from the previous master_category.
There are a number of ways to evaluate, discover, etc.. information related to the above, but as said, basically the product status of 7 will assign the current row's category as the master category and remove the product from the previous master_category. So there are a number of swaps that can be made to remove the product from each linked category by assigning the product to a new master category. Any record that follows the last status change to 7 will be added/updated to reflect the data on that row.
My apologies, the answer is within the ZenCart posts but I didn't understand it the first time through. For anyone else trying to do the same thing, you select the category, and then use copy function. At the bottom of the screen you will see a "multiple categories link manager". As a suggestion, perhaps it might be easier to find this feature under the tools menu ? Anyways, it is a very clever app and (once you understand it) and it works without any problems. For myself, I was able to move hundreds of items into new categories just by entering the current category number and then the new category number to replace it with. As always, make SURE you backup your database using the backup wizard.
Yes, there is more than one way to accomplish something. That particular additional tool is accessible off of at least the tools/area of copying a product, when in the attributes controller with a product within a category "shown", or in the products price manager (found in the catalog menu).Quote:
Originally Posted by mrcastle
Specifically to your issue if all product in question existed only in the miscellaneous and in the designated composer folder, then delete all rows in the file that had the miscellaneous category. Enter 7 in the products status field in the first row, copy that down to the end of the data, save the file (suggest modifying text towards the end so that still have the original file) upload and then import, would have been done. But glad that you found a way that didn't take too much time.
Can I do this https://www.zen-cart.com/showthread....-Bulk-Products through the help of easy populate? Thank you for the advice.
Yes, but I suggest working with EP4 (or any such software) in a test environment first to understand what is needed and how it works. The hardest part of using EP4 is working with whatever editor to save the file in a suitable UTF-8 CSV format. EP4 simply provides the doorway between the database and the data file.Quote:
Originally Posted by aurum.genesis
A couple of things would be needed/needed to be done to accomplish the described task: product added to store, attributes made to exist in the store and detailed information applied to all of those.
Take a moment to read through the instructions. There are a lot more concepts than just press button, watch action that are described.
I had a hard drive crash so I am installing zen cart with EasyPopulate 4.0 for some reason it will not import the csv file that I have as a backup (it was created by EasyPopulate 4.0 file name Full-EP2017Apr01-050757.csv).
I have one product and category in the database right now . Don't know if it's a file permission thing or what.
output from EP4....
header message: File Import Completed.
bottom of page message:
Finished Processing Import File
Updated records: 0
New Imported records: 0
Errors Detected: 0
Warnings Detected: 0
Memory Usage: 4057016
Memory Peak: 4876000
Execution Time: 0.00025701522827148 seconds.
database not changed..
if someone could point me in the right direction I would be great full there is 1500 products to setup
Could you please provide the header row, the first row of data and the language information that is on the right side of the tools menu identifying the language number(s) applied to each language and as well the version of EP4 installed?
first the csv file was made by ep4 (exported) so everything there is right... silly me figured out that it was firewalld stopping things from working right... Lol fixed it and all 1500 products were imported without a problem...
I LOVE THIS ADDON!!!!!!!!!!!!!!!!!!!!!!!!!!!
Glad that it got sorted out. Understandable that it was exported by EP4 and would be expected to import, but there are a few things that could have been different between the old database and "rebuilt" one that could have possibly caused an issue or at least warranted further review/discussion. :) but, alas it was something else. :)Quote:
Originally Posted by hivtop
Happy zenning!
Hi, I have a problem when I import a CSV-file using "EasyPopulate 4 Master", and I want to download the file, I get following error message:.
"Forbidden
You don't have permission to access /admin/temp/Full-EP2017Jun20-205456.csv on this server.
Additionally, a 403 Forbidden error was encountered while trying to use an ErrorDocument to handle the request."
Is it a server problem at my Webhost, or am I just doing something wrong?
I have installed Easy Populate many times in Zen Cart, and I have never had this problem before.
I do have to admit, that I am not sure if I have installed it correct, but no matter what, if I have installed it correct or not, I still never had the problem before, but by some reason I get the error now.
I would appreciate if someone could let me know if I have done the installation correct or not please, and if I have done it wrong, how should I do it then please?
The way I have installed it, is following:
I uploaded the unzipped content from the Admin floder to the Admin folder on the server, and i installed it in Admin, as it tell me to do. I created an empty "temp" folder in Admin at the server. I am not sure about the .htaccess file. I've tried to place it in the created "temp" folder, and I have also tried not to upload it at all. No matter if it is in the "temp" folder or not, the CSV-files get importet to my "temp" folder. Before I could also download the CSV-files to my computer without any problem, but now I get the error message.
I would appreciate very much if someone would take the time, and help me out with this problem please.
The .htaccess file that is included in: htaccess4AdminTempFolder should alleviate that issue. Because the temp folder is within the admin, and the admin .htaccess does not specifically permit .csv files to be downloaded, something needs to be added to permit that operation. Instead of the entire admin being able to access the .csv files, only the folder that contains the generated CSV files needs to have that permission and the included .htaccess file in that folder should permit that.Quote:
Originally Posted by pubaolao
If it does not specifically resolve the issue, then model the commands within it similar to what is provided in your admin directory. The goal is to allow csv and txt files to be downloadable.
3 things to check.Quote:
Originally Posted by pubaolao
1. Admin -> Configuration -> Easy Populate 4: Uploads Directory
- make sure it shows: temp/
2. /admin/temp/
- make sure permissions are 755 for the 'temp' dir.
3 /admin/temp/.htaccess file
- add the following at the bottom
Code:# allow access to just *certain* necessary files:
<FilesMatch "(?i).*\.(csv|CSV|txt|TXT)$">
<IfModule mod_authz_core.c>
Require all granted
</IfModule>
<IfModule !mod_authz_core.c>
Order Allow,Deny
Allow from all
</IfModule>
</FilesMatch>
I am using Zencart 1.5.5e with Easy Populate 4.0.36.ZC - 07-05-2016
I am trying to add attributes using the Detailed products attributes file, but I keep getting this error:Here are the first two lines of my csv file:Quote:
SKIPPED! - Attribute Entry on : - Not Found!
I have named my fileQuote:
v_products_attributes_id v_products_id v_products_model v_options_id v_products_options_name v_products_options_type v_options_values_id v_products_options_values_name v_options_values_price v_price_prefix v_products_options_sort_order v_product_attribute_is_free v_products_attributes_weight v_products_attributes_weight_prefix v_attributes_display_only v_attributes_default v_attributes_discounted v_attributes_image v_attributes_price_base_included v_attributes_price_onetime v_attributes_price_factor v_attributes_price_factor_offset v_attributes_price_factor_onetime v_attributes_price_factor_onetime_offset v_attributes_qty_prices v_attributes_qty_prices_onetime v_attributes_price_words v_attributes_price_words_free v_attributes_price_letters v_attributes_price_letters_free v_attributes_required v_products_attributes_filename v_products_attributes_maxdays v_products_attributes_maxcount
3699 331 EV101-11 1 Choose a Standard Phrase (Free) 0 1 I Love You 0 2 0 0 0 0 1 1 0 0 0 0 0 0 0 0 0 0
The other half of the problem is that if I name the file anything else, it uploads and imports, but DOES NOT follow the option sort order that I entered. EP does it's own thing and assigns default sort orders on it's own. That is my main issue actually. Getting the default sort orders that I entered into the csv file to take hold.Quote:
Attrib-Detailed-EP-options.csv
Couple of things. Where's the commas within the csv file, though based on the success of the import/upload by renaming (meaning that the file will likely be treated as a full import type file) I am not being shown above the raw csv file data.Quote:
Originally Posted by wtashby
The other thing, with regards to the options_id, options_values_id, products_id, and products_attributes_id, where did these values come from for this and/or the other product in your file?
What is the setting for your primary key?
Do this version full support UTF8 and non-English?
Since I am using easy populate CSV, but download the csv open at Excel 2013, all Chinese text are "Monstor" Word ...
Short answer, yes plugin supports UTF8, expects the import file to have been saved in a UTF8 format.Quote:
Originally Posted by explorer1979
This module does fully support UTF8 and the only reported language to have difficulty has been Russian, otherwise there have been reports of Chinese and Japanese working. As to using Excel, well there is a "problem" with Excel in that it doesn't exactly store UTF8 formatted files (which this plugin expects). Open Office and similar programs support UTF8 file generation, but one needs to review the instructions applicable to the workbook program to be sure that the content of the generated CSV file is not technically different from the original (ie. open a file, do whatever is necessary to save the file with a different name in utf-8 format and then compare the text between any quotes to verify that the content is the same (may be single double quotes instead of double double quotes that's okay), if it is then the import should be fine.
I have seen Open Office though change a + or a - to an integer for some reason if the appropriate settings are not used when saving/exporting the content back to a csv file. That is the issue most troubling.
Hi,
I'm updating 20k+ products on a legacy site. The site is a zc139h and the client does not want an upgrade. So I downloaded and installed the latest version of EP4 a couple days ago, then hit a wall.
The problem is that zc139h uses iso-8859-1, but EP4 uses UTF8. The data on the site currently looks fine, but when exported funny characters show up ( Â ).
Converting the site to UTF8 is impractical. How hard would it be to convert EP4 to iso-8859-1?
I could revert to an early version of EP4, but I really, really need the ability to use product_id as the control.
Any thoughts would be deeply appreciated.
When say impractical to convert the site to UTF-8, not sure I follow. What has been the result of attempting to use the database converter db2utf8 on a backup of the database and the few file changes directed within?Quote:
Originally Posted by Feznizzle
As to a change to EP4, I believe the change needed would be in the main admin/easypopulate4.php file where the encoding is set to utf-8 and changing that to the encoding used on the site. Then when using open office following the recommended process to open and also save the file using the same encoding...
See #28 ... before and after.Quote:
Originally Posted by mc12345678
Thanks, DrByte. :)
@mc, I looked at the file and it seems changeable. Only, this line stumped me:
$zco_notifier->notify('EP4_COLLATION_UTF8_ZC13X');
Any chance you could take a look at the code and specify the changes needed?
I also found UTF-8 references (in notation) in two other EP4 files. Can that be ignored?
That particular notifier that stumped you was added when notifiers were added to support expansion of the capability to support the bookx mod that was being developed by another zenner. It is only in "play" when being observed.Also, thank you DrByte for tieing the conversation together and not requiring reiteration. In my previous post, I HAD focussed on the database. After posting I thought about the files and other language that might have been also affected and at that time figured I would have to address it (but it was covered in that thread).Yes, can take a quick gander in a litle bit, but I think considering the situation that the change in the main file will correct the issue for this site.Quote:
Originally Posted by Feznizzle
Thanks, MC!
Would these changes do the trick?
Also, the reason I highlighted the reference to 1.3.9 is that the site I'm working on is a 1.3.9h. Should I change that as well?Code:if ($ep_uses_mysqli) {
$collation = mysqli_character_set_name($db->link); // should be either latin1 or utf8
} else {
$collation = mysql_client_encoding(); // should be either latin1 or utf8
}
if ($collation == 'latin1') {
if (function_exists('mb_internal_encoding')) {
mb_internal_encoding("iso-8859-1");
}
}
if (($collation == 'latin1') && ((substr($project, 0, 5) == "1.3.8") || (substr($project, 0, 5) == "1.3.9"))) {
//mb_internal_encoding("iso-8859-1");
$category_strlen_max = $category_strlen_max / 3;
$categories_name_max_len = $categories_name_max_len / 3;
$manufacturers_name_max_len = $manufacturers_name_max_len / 3;
$products_model_max_len = $products_model_max_len / 3;
$products_name_max_len = $products_name_max_len / 3;
$products_url_max_len = $products_url_max_len / 3;
$artists_name_max_len = $artists_name_max_len / 3;
$record_company_name_max_len = $record_company_name_max_len / 3;
$music_genre_name_max_len = $music_genre_name_max_len / 3;
$zco_notifier->notify('EP4_COLLATION_UTF8_ZC13X');
}
Thanks again!
Couple of things. Let's start with what looks like a little bit of a history lesson on ZC (based on some independent review of old ZC code and system response to by a ZC 1.5.1 site) and why some of the above code is present. It would appear that back "in the day" (ie. before ZC 1.5.0), that the includes/configure.php and admin/includes/configure.php did not include a DB_CHARSET setting. Therefore part of the interface with the database was to respond/identify whatever characterset was otherwise associated or set in the database itself. A little bit about that though means that if the database responded that it was using UTF-8, then the maximum field length report for the associated fields would be reported related to UTF-8 sizing but expect that the software wouldn't be able to properly encode the characterset back into "multibyte" related utf8 (or in other words identify that there are more "letters" available than what the field would actually be able to take, basically reporting back the size of the field to be 3 times what it would accept). Now most of this was already written before I came along and looking back in the history these changes were incorporated ever more to maintain support for older systems while continuing to develop or provide for newer systems. The test for 1.3.9 looks at the first 5 characters of the $project variable.. Regardless of which sub-version of ZC 1.3.9, the first five characters are 1.3.9, so there is no change needed in that particular portion of the code.Quote:
Originally Posted by Feznizzle
Basically all that to say, that in the second part of the code, you wouldn't want to reduce the size of the available fields if the $collation was identified as latin1, therefore that section would remain unchanged.
A "bigger" problem though in using the more recent software is that it appears that there is a response indicating that the database may be responding back with utf8... And that is causing the "conversion" that is occurring of unusual characters in the csv file (when viewed in iso-8859-1 format)... If the problem is visible that soon in, then I have a few recommendations to "test" or check, but yes generally it looks like changing the code in this area is all that is necessary. (There may be an issue with the character used for the category name separator, but one step at a time).
So, here's what I suggest first:
The first "addition" is present to see what the actual returned value is, because in order to accomplish what is desired it may be necessary to not let EP4 think that it should be able to communicate in utf8, but instead push/force latin1 style formatting as a result of the observed outcome. There are other factors to review/confirm as well in the setup of the store and associated collation information. Basically EP4 expects the store to be setup correctly.Code:if ($ep_uses_mysqli) {
$collation = mysqli_character_set_name($db->link); // should be either latin1 or utf8
} else {
$collation = mysql_client_encoding(); // should be either latin1 or utf8
}
echo 'collation: ' . $collation . "\n";
if ($collation == 'utf8') {
if (function_exists('mb_internal_encoding')) {
mb_internal_encoding("UTF-8");
}
}
if ($collation == 'latin1') {
if (function_exists('mb_internal_encoding')) {
mb_internal_encoding("iso-8859-1");
}
}
if (($collation == 'utf8') && ((substr($project, 0, 5) == "1.3.8") || (substr($project, 0, 5) == "1.3.9"))) {
//mb_internal_encoding("UTF-8");
$category_strlen_max = $category_strlen_max / 3;
$categories_name_max_len = $categories_name_max_len / 3;
$manufacturers_name_max_len = $manufacturers_name_max_len / 3;
$products_model_max_len = $products_model_max_len / 3;
$products_name_max_len = $products_name_max_len / 3;
$products_url_max_len = $products_url_max_len / 3;
$artists_name_max_len = $artists_name_max_len / 3;
$record_company_name_max_len = $record_company_name_max_len / 3;
$music_genre_name_max_len = $music_genre_name_max_len / 3;
$zco_notifier->notify('EP4_COLLATION_UTF8_ZC13X');
}
After making the first above change, when viewing the EP4 screen you should see text above the standard ZC admin screen indicating either utf8 or latin1. I am expecting that it says latin1 based on all of the discussion.
Can you also indicate what is displayed on the EP4 admin screen associated with the screen item: 'Internal Character Encoding:'?
Does it provide a result or does it say something like: ''mb_internal_encoding not available"?
The next thing to do after reporting all of that information would be to attempt to export, review the data.
When successful, export something "small" like a single category (disabled with disabled product?) that may have a single product with a really long product name, then without opening the file, attempt to upload that one product back and see if there are length/truncation result(s) reported (not expected). Then also look at the product itself and see if/what got modified about it (Should be nothing). Again export the product, compare the two files to see what if any differences now exist (again expect nothing).
Then attempt to open a copy of one of the files, turn around and save the file, again remembering the encoding.
Upload and then import the file (should be no changes on site).
Again export and compare that export with one of the previous (again no differences expected).
You're in an "opportune" position to be able to test/validate the operation because of the setup involved.
Yes, it says latin1.
Internal Character Encoding says ISO-8859-1, same as before.
When I exported, imported, and then re-exported, the only difference between the export files is that the date/time changed to 0000-00-00 00:00:00. I don't think anything was truncated.
But when I opened the file to make some changes, I found garbage right away. I chose a category containing products with ™ symbols in the name. The symbols were replaced with: ô
Uggg.
So, there were two files exported. First, did both present the same "garbage" second, what encoding/viewer was used to view the file(s)?Quote:
Originally Posted by Feznizzle
Unusual that the date got set to 0000-00-00 instead of the database preferred 0001-01-01 style, but if the site itself could export and import the exported file without any character encoding issues, then that means that EP4 is doing its part just fine. The problem is in the next "tool" which is reading, expecting or converting the file to be utf8 which is then causing the observed "garbage" ie. looking at latin1 in utf8 can cause characters to look as junk.
Yes, garbage in both files. I use Open Office. Can I switch CharSets in there?
Of course.Quote:
Originally Posted by Feznizzle
When opening the file, you should be presented with an option to import text. The first box is the character set. Change that from unicode (utf-8) to Western Europe (ISO-8859-1) then follow the remainder of the settings to support import. I provide this information based on Apache Oppenoffice 4.1.3. I haven't updated or attempted to update recently to identify if/what differences might exist in the options to reach various features. That aspect is something that should be addressed through the tool of use's help/assistance.
Doh! Can't believe I missed that. Well, the garbage is gone... but so is the trademark symbol. :(
Did it remain between import/export of the original file and only disappear when loaded into open office?Quote:
Originally Posted by Feznizzle
I found this which suggests you may want to also adjust the font style in the process: https://wiki.openoffice.org/wiki/Doc...mark_symbol%3F
Otherwise I thought that there might be some differences that may help by using Libre?
Same thing occurs in Libre.
I just downloaded, added trademark and registration symbols to product titles. TM works but still no dice on ®.
At the top of the screen, I noticed this message: "collation: latin1 "
In Libre/OO, I can choose:
Unicode (utf-8)
Western Europe (ISO-8859-1)
Latin 3 (ISO-8859-3)
Notably missing:
Latin 1 (ISO-8859-1)
Could that be the problem? What if I switched EP4 to Latin 3 (ISO-8859-3)?
Hope that's not horribly dumb, just tossing out thoughts.
Though doesn't/didn't seem like it should have an effect, what special conversions are setup in the configuration of ep4. It could be that maybe that character should be replaced with the html equivalent?Quote:
Originally Posted by Feznizzle
See, in Open Office they said that to add such a symbol would require using a particular font, I don't know if the character is otherwise always there but not visible like if the font is chosen, the character entered, then the font changed, and then possibly changed back, does the character magically "disappear and reappear?". If so, then for peace of mind would use "that" font while editing but understand that the font won't exist when saving though the characters should still be present and then upon upload they should still be there as well...
As far as encoding changes? Otherwise it's testing time to see what can be done to get what is desired...
I'll try replacing with html equivilent again.
In the mean time, I went to the DB using Sequel Pro and clicked Table Info (was looking at products-description). Found this info:
I don't understand SQL (or any coding, really), but looks like the db wants utf8... is that right??? If so, then EP4 should have worked off the shelf. But EP4 seems to have improved since switching away from UTF8.Code:CREATE TABLE `products_description` (
`products_id` int(11) NOT NULL AUTO_INCREMENT,
`language_id` int(11) NOT NULL DEFAULT '1',
`products_name` varchar(150) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`products_description` text COLLATE utf8_unicode_ci,
`products_url` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`products_viewed` int(5) DEFAULT '0',
PRIMARY KEY (`products_id`,`language_id`),
KEY `idx_products_name_zen` (`products_name`)
) ENGINE=MyISAM AUTO_INCREMENT=11640 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
Naaaarg. lolz
Okay, would like to regroup a little.Quote:
Originally Posted by Feznizzle
Right now, what is going on is that the database is prepared to handle utf8, but everything about the store is "in the past" and pushing latin1/ISO-8539-1 to the database (and expecting everything that comes from the database to be in the same format regardless of how it is stored). The next thing about all this as pointed out earlier, export followed by import of the same file made no changes to the content which is everything about EP4 functionality did not affect the encoding. Therefore, EP4 never was a problem from what can be determined. The problem has been in editing and properly storing the edited file to be able to be handled by EP4.
Right now the store is in a mixed state which is typically undesirable and could become problematic with upgrading as well considering that latin1 is trying to be pushed to utf8 instead of latin1 to latin1 and utf8 to utf8. But that all is a different topic.
Again, EP4 is not the issue regarding the character encoding with the upload or download. Right now it is finding a suitable editor that will allow the full use of the characters that have been presented to the database. Without completely installing a system with similar setup which may or may not be possible based on the age of software and availability of similar setup, all I can really do at the moment is offer guidance/suggestions of ways to work around it. I might be able to setup a local server and platform on my computer, but seems like it would take up several hours of time to do.
Thank you for the offer, I'd happily buy some coffee to make it worthwhile for you. But I'm hoping that won't become necessary because I'm now thinking that maybe the solution is simply changing the site files to expect UTF8, per these instructions:
https://www.zen-cart.com/content.php...8859-1-to-utf8
Of course, because my db is already expecting utf8, I won't need to run that mod... just change language and config files.
I'll give that a quick whirl, report back.
YAHOOOOOOO!
Houston we are a GO!
I have no idea when/how/why the site's db got upgraded and I'm beyond stumped about why the config/language files did not also get upgraded... but holly-frikken-lujah it's working like a charm baby!!!!
Awesome. Thank you so much for the help, MC!
Hopefully there will be no other repercussions from changing that, like payment processing or some other mod wanting iso-8539-1. But if there are, I'll deal with it later.
As eluded/discussed by DrByte and I have seen this, you may want to take a peek at the define pages at a minimum to validate that they are not already encoded in "latin1" then also other "places" where specifically latin1 was used (though that would be easier to identify through a comparison program of old to new or original to edited).Quote:
Originally Posted by Feznizzle
Congrats that things are working (better). :P would suggest updating the referenced thread to summarize the "solution" or at least the condition.
Great advice, I will grep the php files for any references to latin1 and/or iso-8539-1.
And I'll update the original thread. TTFN! :)
Now that I'm able to use EP4, I have a question related to creating categories.
When you export products, a category path comes with it. But when you export "Categories Only (with Metatags)", no path is given. This becomes a problem when you have a lot of categories (I have 1351) and you wish to add blurbs to each (category description/meta data).
Quick example using pets:
Dogs^Brown^Furry
Cats^Brown^Furry
I now have two "Brown" categories and two "Furry" categories, but no way to know which refer to Cats and which refer to dogs... thus I'd don't know where to put which descriptions.
So my question:
Is there a way to ask EP4 to include a category path column with the "Categories Only (with Metatags)" export?
Thanks!
Sorry I missed seeing this earlier.Quote:
Originally Posted by Feznizzle
Yes, can be added. Export setup would need the field added to be captured, incorporate the same/similar "building" from the product's export, and done.
Now understand that it would be/should be only for informational purposes. Ie. Won't be able to modify it and make it do anything when importing by the intended filename. Otherwise, (and perhaps it was an omission) it has always seemed like that the category field modifications would be done somewhat along side the store's admin viewer where the category number is "obvious" for each such category.
But, I can see the benefit also. :)
I'll see what I can put together and upload to github.