Re: EasyPopulate 4.0 Support Thread
Quote:
Originally Posted by
mc12345678
Well, there's a couple of things for me to look at before I can comment on how it is expected to operate as compared to how it is operating. But I would like to take a moment to point out that now that you see how to add a single product, adding multiple should be relatively easy in comparison. Sort of the tree/forrest thing. So you have a column that you would end liking to have all the same value. Your working with a spreadsheet. Copy/paste, done. Focus on the fields/data necessary first and then fill in the fluff, can even resequence the columns to suit so that the columns to end up needing such a "global" copy and paste are on the right side. Take the row before, highlight the cells, drag down (depending on how "intelligent" the editor is it may increment one or more fields, but that's the workbook editor not EP4).
Another side note, understand that if your plan is to add one product at a time (just for discussion), then I would say that the product probably should be added using a different method. There is a sort of trade off in using something like this depending on how much is being added/modified.
Hello!
I wanted to report that after adding v_products_discount_type v_products_discount_type_from to the CSV file, it worked!
I added those two columns and tried creating a new product via CSV and it imported with no problems :smile:
I also tried to move those two columns to the end of the CSV just to make sure it's okay to re-arrange the CSV and it was good as well! this is great news as you mentioned it would be SO much easier to focus on my commonly used fields first then copy/paste the remaining info that isn't relevant to my products.
Thanks so much again!! Much appreciated!
Re: EasyPopulate 4.0 Support Thread
zc 1.5.5a, Responsive Sheffield Blue 2.0, Dynamic Filters, Easy Populate 4.0 and numerous other mods. This exercise on WAMP test site only.
I'm trying to change my category set up - Currently ie, Master Category (ie Socks), several sub categories (ie Small Socks, Medium Socks) then products within the subcategories. The sub categories have a sort order and the products do not.
Change I'm making is to eliminate sub-categories and move all products into new Master Categories, then assign v_product_sort_order so products would appear in sequence similar to previous set up. My original setup won't show Dynamic Filters on Master Category if there are sub-categories. (So -Master Category - Socks, then all products with product sort numbers so they appear in correct sequence - ie all Small Socks - sort order 10, all Medium Socks - sort order 20. Products also have read-only attributes - so Dynamic Filter will give visitor the option to filter by size, or if on mobile - scroll through the products in a meaningful sequence.
I downloaded EZP file, opened in Open Office, edited product sort numbers from '0', saved, browsed, uploaded, and imported. Messages on EZP page show everything imported successfully, and I can see the sort numbers in the verbose feedback.
However, when I go back into my admin the product sort numbers remain '0' for any product that is linked. None of the linked categories are master categories, though all are top level categories. Only the non linked products have the sort order successfully changed.
I have tried making each sub-category into a top category and making that category a master category, and have also tried copying all the products within a sub-category to a new category, un-linking them from original sub-category, and making the new category a master category.
Assigning sort numbers to the products within sub-categories was easy as they were already sequenced in the file because of the sub-category sort order. But the linked categories are all over the map - very big job to un-link/ re-link everything.
And now, my question:
Should I be able to successfully assign a v_product_sort_order to linked products, and if so, is there something I've missed in procedure I've tried?
Re: EasyPopulate 4.0 Support Thread
Quote:
Originally Posted by
soxophoneplayer
zc 1.5.5a, Responsive Sheffield Blue 2.0, Dynamic Filters, Easy Populate 4.0 and numerous other mods. This exercise on WAMP test site only...Should I be able to successfully assign a v_product_sort_order to linked products, and if so, is there something I've missed in procedure I've tried?
I may have this sorted. Still have to try and replicate.
I followed same procedure as in previous post but this time I cropped the working .csv file down, leaving only the new master categories, and cutting off the categories to which products from the former are linked. As is happens, my original sub-categories sort numbers placed them at the top of the file while the categories to which many products have links were lower on the page.
Perhaps the '0' product sort in the linked category, being lower on the page, was overwriting the new sort number in the product's master category placement.
Oy.
Re: EasyPopulate 4.0 Support Thread
Quote:
Originally Posted by
soxophoneplayer
I may have this sorted. Still have to try and replicate.
I followed same procedure as in previous post but this time I cropped the working .csv file down, leaving only the new master categories, and cutting off the categories to which products from the former are linked. As is happens, my original sub-categories sort numbers placed them at the top of the file while the categories to which many products have links were lower on the page.
Perhaps the '0' product sort in the linked category, being lower on the page, was overwriting the new sort number in the product's master category placement.
Oy.
Glad you got this sorted out. To be honest I thought you were trying to do something slightly different which I was going to advise is not possible in a default store.
If the problem is/was, that the sort order of a product could not be imported to change, and the import file contained the same primary key (typically products_model) on two or more rows, then yes the last row in the file would be what everything becomes.
There are a number of ways to address this, and it really comes down to your own business model, ability to work with/around it, etc... even another product may be of interest/use or to use different product for different reason, whatever the case... it's important to understand how the software works (instructions), how it fits into ZC (exported results as compared to contents of the zc_install/sql folder and any modifications made by other plugins/programmers), and the effect of an import/manual change (import, export of data or viewing from the admin).
Again glad that it was something that seemed like could be figured out and resolved.
Re: EasyPopulate 4.0 Support Thread
Fyi,
I've pushed an updated copy of EP4 to https://github.com/mc12345678/EasyPopulate-4.0 that should address all of the problems that have been identified "recently". It does not yet directly address sort order of attributes, but it does correct things like requiring fields that are typically 0 or 1 and that if 0 they need to be directly listed, it adds some improved user operations upon upload of a csv file (presents an import button in-line), the issue of manufacturer's information in ZC 1.5.4+ not fully being properly stored, improved indication of the default data related to the status dropdown, other corrections related to the import sanitization, the import file has been reduced by pushing the one-off import files to separate module files which should improve operation a little and improve code readability, modified the alternate primary key operations to offer some consistency, and other minor administrative changes.
Also posted the software to ZC, will notify if/when I discover that it has been updated; however, for those that have installed the version from the site should receive notification through program use.
2 Attachment(s)
Re: EasyPopulate 4.0 Support Thread
okay guys/gals, I have been working on this for a long time with no luck maybe someone can simplify it. I have attached screen shots i have download my full shop list etc... it never inports. I am using a mac with open office and zen cart 1.5.5a
Not sure what the heck is wrong but have no clue
:frusty:
Re: EasyPopulate 4.0 Support Thread
Well, there doesn't appear to be any properly named files in the folder used by EP4.
Please step through the process you are using, or follow this and report results.
In the upper left area, click the blue link that reads: Complete Products (with Metatags).
After a period of time, the screen should update and a file should appear towards the bottom of the list on that screen and associated with full product.
There should be buttons/a link next to that file, the link is download, the buttons to perform other action such as import, delete, split the file, etc...
If the store is properly setup to be fully compatible (each products_model is unique) then you could/should be able to import that file and technically nothing would change about the store.
The other thing is when you say it never imports, to what part of the process are you referring? As used for EP4: export: take data from database and create a file on the server that contains that data.
Download: copy the contents of the file that contains the exported data and place the copy on the local computer.
Upload: transfer the contents of the file on the local computer to the server so that the server can eventually access the file.
Import: process the contents of a server file with consideration of the filename's "prefix" to update/modify the database.
1 Attachment(s)
Re: EasyPopulate 4.0 Support Thread
Quote:
Originally Posted by
mc12345678
Well, there doesn't appear to be any properly named files in the folder used by EP4.
Please step through the process you are using, or follow this and report results.
In the upper left area, click the blue link that reads: Complete Products (with Metatags).
Okay got file wont let me download error 403. but was able to download it from server through filezilla attachment included.
After a period of time, the screen should update and a file should appear towards the bottom of the list on that screen and associated with full product.
There should be buttons/a link next to that file, the link is download, the buttons to perform other action such as import, delete, split the file, etc...
If the store is properly setup to be fully compatible (each products_model is unique) then you could/should be able to import that file and technically nothing would change about the store.
The other thing is when you say it never imports, to what part of the process are you referring? As used for EP4: export: take data from database and create a file on the server that contains that data.
I upload file back in and it shows at the bottom of the list the one with all the missing files.....after i add a product as the others are setup in the file save it.
Download: copy the contents of the file that contains the exported data and place the copy on the local computer.
Upload: transfer the contents of the file on the local computer to the server so that the server can eventually access the file.
Import: process the contents of a server file with consideration of the filename's "prefix" to update/modify the database.
this is where iam at this moment just frustrated would love to get this working as i put 200 to 500 items in my store at a time maybe its just something i am not sure of
Re: EasyPopulate 4.0 Support Thread
Okay, so from that it sounds like you have setup your download/upload folder as a folder in your admin directory. Because the admin directory has default permissions on it to prevent "random" file types from being accessed, a little additional file is needed to be added to the folder to prevent the error that you are seeing. It is located in the download zip file in the folder htaccess4AdminTempFolder... now care should be taken in applying that file as it should not just replace another .htaccess file if it exists.
As to the file handling described above, I do not understand what is not understood. I believe what has been said is that the file has been uploaded, but the import button not pressed. The previously provided images don't support that part of the discussion though. The previous images show no files on the server.
Be glad to help, just need to understand the current settings, the current setup, and what is or is not understood. If you can continue to communicate on these issues, then can get through.
Re: EasyPopulate 4.0 Support Thread
Quote:
Originally Posted by
mc12345678
Okay, so from that it sounds like you have setup your download/upload folder as a folder in your admin directory. Because the admin directory has default permissions on it to prevent "random" file types from being accessed, a little additional file is needed to be added to the folder to prevent the error that you are seeing. It is located in the download zip file in the folder htaccess4AdminTempFolder... now care should be taken in applying that file as it should not just replace another .htaccess file if it exists.
As to the file handling described above, I do not understand what is not understood. I believe what has been said is that the file has been uploaded, but the import button not pressed. The previously provided images don't support that part of the discussion though. The previous images show no files on the server.
Be glad to help, just need to understand the current settings, the current setup, and what is or is not understood. If you can continue to communicate on these issues, then can get through.
Okay lets start with the .httaccess file i do have one in my admin folder is that where I need to copy the one from the zip folder? or does the one in the zip folder go into the temp folder where ep uses (sorry i am stupid when it comes to this)
then we can go on to fix the files not found.
Did you look at the cvs file i uploaded i dont use product model when i add a new product i just do name cost description how many file upload of picture then set product weight
MY SITE IS www.patchesrus.net
