does this work with 1.5.5a?? i can't get it to work.. it says file uploaded successfully but there are no products in the database and i get what looks like these error messages?
Attachment 16526
Printable View
does this work with 1.5.5a?? i can't get it to work.. it says file uploaded successfully but there are no products in the database and i get what looks like these error messages?
Attachment 16526
Sigh... have you 1) read the instructions, 2) read even the last page of posts or 2?Quote:
Originally Posted by lidlchris
Upload... to provide files to the server, been a term used for like 30 years to represent movement of files or information from a local system or area to a remote location.
Try importing... the listing of files presented in the above image is incomplete... there is no "error", there is an indication that nothing is present...
Quote:
Originally Posted by mc12345678
yikes, must be late there?? i'm sorry if you had a bad day. i really like this plugin and have used the older version many times with success. and yes i'm been in data processing/programming for 37 years now so i know what 'upload' is.. and yes the file has records in it. i'll include a link to the csv file here. and yes i created it in both excel and openoffice with the same results. i'm sure i'm doing something dumb but i'm not an idiot.. and i did do a search and will continue while waiting for a reply.
http://criticalsystemsincshop.com/te...openoffice.csv
make that http://g8x.net/delatec-test-upload-openoffice.csvQuote:
Originally Posted by lidlchris
Do you really have 14 languages installed?Quote:
Originally Posted by lidlchris
Incorporated the patches described over the last several pages?
What is the primary language used on the site, what number is assigned to that language when viewing the tools->EP4 page in the upper right corner?
Also, though it doesn't matter for this particular file, the filename is important to identify what filter type will be applied, the above file is and will be treated like a "full" export/import file.
yes i only should have English.. i missed that in the original instructions. hopefully i can uninstall the others.. primary language is English and it is a 1. and yes i wanted a FULL import, unless i'm missing something? i think all the fields are on that csv i sent you?Quote:
Originally Posted by mc12345678
i did not incorporate any patches.. where exactly do i find them.. i just downloaded the latest version today - shouldn't that have all the patches in it?Quote:
Originally Posted by mc12345678
Up to the point of additional patches identified. See, those that process uploaded plugins do so on their own volunteer time like just about everyone on this site. As such, their time is considered valuable and I for one don't care to waste it by uploading what would have probably been at least two if not three different versions since 4.0.35.ZC was pushed to the ZC site. As well, each such version if it made it to the site would have notified users of the plugin to download and reinstall (though only files were modified, not the database). That just adds aggravation to the users as well.Quote:
Originally Posted by lidlchris
So, like other plugins, if a bug is found, it is first discussed and or corrected here in the forum thread (one reason to read from the end of a thread backwards). When corrected it should be uploaded as a new version. The issues have been corrected in version 4.0.35.ZC.1 available from github however there remain a few display issues to be addressed related to the selected primary key and associated "error" on upload, so it has not been pushed to ZC yet. All of these things are discussed over the last several pages including what change(s) are necessary to repair the software.
Yes, the files that have been posted will be treated as full imports because they don't meet the criteria to be uploaded as a unique file type. The data presented in each of those appears to at least import to Open Office without issue, so that implies that they are satisfactory for import to ZC.Quote:
Originally Posted by lidlchris
Now, having looked at the files, it appears that the goal is to push the product to the database in a disabled status. When stating that the product is not in the database, what is the method of review employed? What is/are the messages that appear at the bottom of the screen after selecting to import the associated file(s)? If product exists with the associated products_model, then they will be updated, not added anew. If using the store front as the verification, then the product won't be seen (v_status =0), if using the database itself, verify looking at the correct database, and then within that, make sure looking at the correct table(s) such that their prefix matches your setup. If looking in the admin, again if updated, then should be a change if the product previously existed or should be locateable using the category(ies) assigned to the product.
Regardless, assistance can only be provided based on the information posted/presented. The initial post was about how an upload did not get to the database after selecting upload. Other than providing copies of the file(s) attempted, little additional information has been provided. As a result and in spite of that, multiple paths of what is going on have been provided. This is instead of cutting the conversation short and just simply asking for more information... hopefully it helps narrow down the cause and then here and anywhere else that this issue has been posted about will reflect the solution or reason for the observations already made.
Looks like it was a simple 'fix' on my end.. i uploaded the files and they said they uploaded fine and then finally i noticed an 'import' button next the files at the bottom. i clicked on 'import' and the products were all there using the same file i sent you guys. maybe because i used the older product, the 'import' is not intuitive. i would think the 'upload' would upload to the products database.. but thank you all for helping.Quote:
Originally Posted by mc12345678
Is anyone else having an issue where the upload feature in Easy Populate 4.0.19 isn't working? I'm wondering if it is a firewall or a timeout issue.
I wouldn't be surprised if it is far more than EP4 that is affected. What file size(s) have been tried? Have you also tried setting up a catalog product that allows uploading a file and seeing if the same file can be uploaded via that route? What environment is this operating on (ie. Php and ZC versions?) just to name a few things to check. :)Quote:
Originally Posted by utefan
I ran into a very odd issue tonight with a brand new install of 1.5.1. I installed EP4.0.19 and everything was working great. However, after installing a bunch of other mods (37), it appears that EP4 was broken somewhere along the way. All I am getting now is a blank white page when I try to go the EP4 via the admin panel. I am getting the following message in my error logs:
PHP Fatal error: Function name must be a string in /home/corg/public_html/admin/includes/functions/extra_functions/easypopulate_4_functions.php on line 512.
Here is what line 512 looks like in that file:
$string = ($ep_uses_mysqli ? "MySQLi" : "MySQL") . " error ".($ep_uses_mysqli ? mysqli_errno($db->link) : mysql_errno() ) . ": ".($ep_uses_mysqli ? $mysqli_error($db->link) : mysql_error())."\nWhen executing:\n$query\n";
If I remove the dollar sign in front of "mysqli_error($db->link)" above, the white page goes away and EP4 comes up in the admin panel, but there is an error message that says, "Warning An SQL error has occured. Please check your input data for tabs within fields and delete these. If this error continues, please forward your error log to the Easy Populate maintainer".
I have seen other posts in here with the same message, but different error logs. I'm thinking this must be a different issue. Any ideas about what might be happening on this one? Thank you.
Thanks for your response. I'm running I'm running ZC 1.5.1 and PHP 5.6.16. This is a very odd case. Not only was I having trouble loading files via the file upload utility in EP4, but I was also having the same issues from my laptop via filezilla. File transfers through the cpanel were working fine. I shut off my antivirus software and suddenly my computer was able to upload fine through Filezilla. That is what got me thinking about maybe there being a firewall issue. I'm curious what would happen if I moved my temp folder out of my admin directory. I'm going to test that next. I'll share if I find anything of interest. Thanks again.
BTW, this is a different build than the one where I was having the upload issue. Thank you.
I've tried different sized files with the same upload result. I haven't tried the catalog product upload. Thanks for the suggestion.Quote:
Originally Posted by mc12345678
Have you also tried a more recent version? There are/were reasons why the software was updated. Particularly PHP versions were at play and you are likely to run into other troubles running PHP 5.6 with ZC 1.5.1. Why didn't you install a more recent version something released less than 4 years ago?
Yes in 4.0.19 there was that dollar sign issue, as well as a number of other things that have been addressed or corrected since then. I would suggest the version available at https://github.com/mc12345678/EasyPo...e/v4.0.35.ZC.1. It is compatible as far back as at least ZC 1.3.9 up to at least ZC 1.5.5 (hasn't been tested on ZC 1.6 yet)
I just bought a store from someone else that was on 1.3.9. I decided to move the store to 1.5.1 initially because that is the latest 1.5.1 version that supports all of the mods that replicate existing functionality. I'm hoping to upgrade from there once I get the 1.5.1 store working as expected. I'll try a newer version of EP. Thanks for the heads up.
Hello,
looking in files I saw the v_status could have the "7" value.
What is the use of 7 value?
Thanks.
It was a feature that was added back in v4.0.31 August 2015 to allow reassigning the master_category for a row of data to the category of that row for that product. It is discussed in here, but hasn't been highly advertised because of the effect it can have on your store if used improperly or even in some cases properly. :)Quote:
Originally Posted by mcevoli
So the original vision for it was to not modify the export file as those using ZC have come to "enjoy" but allow modification/removal of say linked product. Linked product provided when a products_id is applied to a category that is not the master_category. In a default EP4 install, two rows that have the same products_model data but have different category information will result in generating a linked product for that products_model because the "second" instance will get the product added to the products_to_categories table if it is not present. All product in order to appear in the cart need to have at least one instance of a record in that table. So new product as well as modification of existing product should be covered by the EP4 code.
Thing is that there was not previously a "delete a linked item" option... Further, there wasn't exactly a clear cut way to suggest how best to do that, considering a lot of *that* issue relates to what products_model record is read first while processing the file, and which record was updated by the user.
Any rate, the following was logic was applied but look at bullet 3 for the short and skinny:
If the status is 7,
1. check to be sure that the product does or does not have a master_category assigned. If it does not, then assign the current product the master_category associated with that record, no further action required. (Unfortunately there have been those that have processed data or manually modified their database at one point and neglected to associate product to a category/master_category and therefore their product doesn't appear as expected/designed.
2. If there is a master_category assigned, and the current row category is not the master_category, then attempt to make the current row category the master_category, attempt to delete the product from the category represented by its previous master_category and then report the results of those actions based on the success of trying to do the two above actions. If the product's master_category couldn't be updated, then a linked product would exist/be generated (the delete operation isn't supposed to fire, because otherwise the next action would cause a product to not have a master_category) with a link being generated to the category identified on the row. If the product's master_category did get updated, then attempt to delete the product from the category that it used to belong. If unsuccessful at deleting that item, then again would have a linked product but this time the link would be to the old master_category with the product having a new master_category. If successful at deleting the item from the old category, then the product would have been successfully moved from the old category to the new category and no link generated. If unable to update the product's master_category, but able to delete the product from it's master category then the code reported deleting the product from the category (which would unfortunately leave it with an unassigned master_category, but that would be because the code was unable to properly execute an update command. Additional "action" could be built in to then try a delete followed by an insert, or to use the replace command, but it seemed that if that caused an issue, then there was probably something bigger going on that would need to be addressed).
3. So, summary: status of 7 is to move the master_category to the category on the row and if able delete the product from the previous category represented by its former master_category and if not previously assigned to a master_category to update the master_category to be the category of the current row. With this operation and proper sequencing of import data rows, all links for a product could be removed leaving behind the product in a single category, or the master_category could be changed without having to delete the product and add it back (previously not something easily maintained/managed but other edits have made something like that possible without losing uniqueness of the product's identifier).
@mc1234567 thanks for getting me pointed in the right direct. I was able to fix the SQL error. I'm posting here in case anyone else comes up against the same issue. It turns out that the issue was related to CEO URI mapping. Some of the tables were missing in my installation. Once I updated the database, the error went away. The log file in EP was the key here. I sure appreciate the development team for EP thinking ahead about making the logs easily accessible. That made fixing my issue much easier. Thank you!Quote:
Originally Posted by utefan
Your welcome for not transitioning to the ZC default code for everything in the plugin which would have placed the associated sql error in the logs directory among any other logs that might have been generated by other processing. (Suggest reviewing those to see what other issues you may have with your system.)Quote:
Originally Posted by utefan
There is a plugin (display logs) that can be installed to make those accessible from the admin and they should always be available by ftp, but are likely hidden if using something like webftp. While it would be good to occasionally take advantage of the cache created by ZC, the level of modification (at least at the time) was too extensive for both EP4 and anything needed to be modified in ZC to support continued use of the "local" error log.
I'm having troubles importing a Detailed Products Attributes file. We're trying to update from one site (wholesale) to another (retail).
I export a Detailed Attributes from wholesale, remove all but one product (to simplify testing) and remove all columns but those listed below. I assumed (this is probably the problem) the v_products_model would be used as the primary field. The model number is consistent between both sites while the v_products_attributes_id and v_products_id are not, which is why I removed those columns.
When importing the Detailed Attributes file, can the v_products_model be used as the key?
The file I imported had the following columns:
v_products_model, v_options_id, v_products_options_name, v_products_options_type, v_options_values_id, v_products_options_values_name, v_products_options_sort_order
and the result was SKIPPED! - Attribute Entry on : - Not Found! for each attribute in the file (five of them).
Yeah, that is/was the problem. For the detailed attributes, the attributes themselves are the important part which are so defined for the software by use of the applicable option/attribute related _id. There is the process at the following post that I provided not too long ago that worked for the individual asking to do the very same thing: https://www.zen-cart.com/showthread....43#post1312443Quote:
Originally Posted by jeking
Thanks for the reference to the post. That was a workable solution.Quote:
Originally Posted by mc12345678
Glad that worked out.Quote:
Originally Posted by jeking
i am using zencart 1.5.5a and have installed the latest version of EP 4,file was uploaded sucessfully,but the bad thing is when i click import,it reminds me ERROR: Import file does not exist:....I am sure the file is indeed there,i also try to upload the file to temp folder..Also one more strange thing,when i click delete file,the file still there and i could not delete,would be appreciate if anyone could help me,thanks
Well that's completely new and unusual.Quote:
Originally Posted by e-standard
It does seem like it would stem from the designation of the path as entered in the configuration panel for the file location.
For starters and without possibly posting your actual admin directory path if it is included, what do you have for the path of the temp directory and what is the setting regarding whether in admin or catalog side? (if your admin directory is included in that path, just use the folder admin or some other obscured entry like XXX.)
Thanks very much for your eply,here is my settting in catalogQuote:
Originally Posted by mc12345678
Attachment 16592
Here is the error i got when i import:
ERROR: Import file does not exist:/home/estanda1/public_html/xxx/temp/AASHTO+2014+CSV.csv
The file also could not be deleted..
Attachment 16593
I find something wired,the file name is AASHTO 2014 CSV.csv,when i change to AASHTO.csv everything works fine,can not not add any bank or other words after it,it should have something with the software itself,what should i do now to solve the problem?
Umm, so almost every reference in this forum to saving a file to the server is to not include a space in the filename. Also, it is generally suggested that filenames be all lowercase. The filenames generated by EP4 use either underscores or dashes for "space". If you are able to ftp to your site you could either rename or delete the file(s) or ask your host. Be advised though that depending on the type of import/export file the first part of the filename is important to the program and should not be renamed. The first part typically includes everything up to and including '-ep'.Quote:
Originally Posted by e-standard
Thank you very much for your help,but i did not find this problem when i am using ZC 1.3.9 and EP 4.0::blink:Quote:
Originally Posted by mc12345678
What version of EP 4 was being used when "this problem" didn't exist? The current version (4.0.35.ZC) continues to work on ZC 1.3.9 also. The significant difference in regards to the file handling of this version to some of the older is the use of $_POST more so than previous versions instead of putting the information on the url using a $_GET.Quote:
Originally Posted by e-standard
This may be the first sanitization issue to come across related to the patches that are expected to be applied to all ZC 1.5.x but come mostly standard to ZC 1.5.5.a. Since that filename format is not one that I would typically use nor suggest, no testing was applied to it.
The version i used for old zencart 1.3.9 is Easy Populate 4.0.19 - Beta 1-28-2012,everything works fine.Quote:
Originally Posted by mc12345678
Expecting updating to solve the problem for zencat 1.5.5a,thank you very much.
Hi There,
I am using ZC 1.5.5a for my store. Someone may have had the same problem or may have posted for help but I have gone through this post and can't find anything.
I am trying to get my Attribute file on EP to work but I keep on getting the word SKIPPED every time I upload it to my store. Any help how to fix this would be a great help. You can see an image of what getting below.
Attachment 16610
If notice, not all records are skipped, just some of them. While the error reporting does not appear very helpful as is, the statement indicates that there is something wrong with the assignment/existence of applicable option values to the product in question. Has a basic attribute file been used to apply the option name/value pairs to all of the products?Quote:
Originally Posted by LittleAngell52
BTW, while not text searchable, the admin folder of the site appears to be presented in the image. Recommendation is to rename the admin directory and not posting it again in the future. :)
It's the new download files that get skipped and can't work out how to add them via ep.Quote:
Originally Posted by mc12345678
The error is related to not being able to find an existing record to be updated. With the detailed attributes file, it is primarily setup to first export the file of known attributes, then to update the individual records (fields) of it and import those changes.Quote:
Originally Posted by LittleAngell52
This is based on the following sql:If that sql comes back with no results then the error in the above image is provided.Code:
SELECT * FROM ' . TABLE_PRODUCTS_ATTRIBUTES . '
WHERE (
products_attributes_id = :products_attributes_id: AND
products_id = :products_id: AND
options_id = :options_id: AND
options_values_id = :options_values_id:
) LIMIT 1;
Right so how do I add or can I add my downloadable files via EP? I always add the products to the store first and upload all my downloadable files.Quote:
Originally Posted by mc12345678
Next would be to assign the attribute to the product using the attribute basic type file, and then the attributes detailed (current file that is only partially working) to provide refined information for the individual product.Quote:
Originally Posted by LittleAngell52
Right, I will give that a try today and let you know if it has worked or not. If it doesn't then I will scream. LOLQuote:
Originally Posted by mc12345678
Aww, it worked and thank you so much for your help mc12345678. :hug:I don't know what I would do without this forum as been so helpful to get things done in my store.Quote:
Originally Posted by mc12345678
Welcome, glad it is coming together for you. :)
Help I have come across a new problem on ep and I can't seem to get it fixed. Ep is adding the downloadable file I add but it keeps skipping the name of the file and how many days you have got to download it and how many times you can download the product. For example, Spiderdancer/CHH-FBC_001.zip is the download name for the downloadable file 7 days and 5 tries. I have had this problem for the past 3 days and can't figure out how to fix it. Any help will be appreciated.
Here is an image of what I get.
Attachment 16633
Ummm... Worked for me when I modified an exported version of the detailed attributes, I modified the three columns:
v_products_attributes_filename, v_products_attributes_maxdays, and v_products_attributes_maxcount
I uploaded the file leaving Attrib-Detailed-EP as the beginning part of the filename (I had modified the text that followed so that I wouldn't lose my original export), I then imported the file (which had also been modified to update only a few records instead of everything) and what I had entered was transferred to the record associated with that particular attribute as viewed in the attributes controller.
So, I don't know what the issue is/was for you, but perhaps you could explain further the actions you took from export to import including filenames involved, error messages at the bottom of the screen just after import, etc...
So, if
It's ok I found the error I was getting this morning and it's all working for me again. What I did do was added the products first and edited what need to be edited. Then I did the basic Attribute file added that to EP. Then I edited the Detailed Attribute File and for some reason under the column v_products_options_sort_order it was putting in a 0 instead of 10. How I found it was I went to the very first line that I added via Ep and went through it with a fine tooth-comb and just typed in the details from that line and hay presto it worked. Why I didn't think of it earlier I don't know.Quote:
Originally Posted by mc12345678
is it possible to add categories using EasyPop?
I have no difficulty dl'ing the file Category/Meta and using it to modify
but have to create a large number of new categories and can't seem to do this
Zen Cart® v1.5.5a
Easy Populate 4.0.35.ZC - 04-29-2016
Firefox 48.0.2
Thank you for any assistance - even the answer is, no EaxyPop does not do that....
EP4 adds categories as necessary when adding product (active or not), it does not have a generate a category "feature". Once the category is created (active or not), then the category's data can be manipulated.Quote:
Originally Posted by wheat
There are creative ways to work around this without affecting database record numbers, such as taking a product (probably preferred to be inactive) and linking it across multiple categories, which is then possible to be removed from those linked categories, but also keep the categories in place and update them.
Well ALL right & thank youQuote:
Originally Posted by mc12345678
Not exactly sure what you mean here, but suspect if I TRY to follow the instructions - it will become clearQuote:
There are creative ways to work around this without affecting database record numbers, such as taking a product (probably preferred to be inactive) and linking it across multiple categories, which is then possible to be removed from those linked categories, but also keep the categories in place and update them.
Hi,
I am using ep for the first time.
I have been able to import over 965 product with categories and parent categories.
I am now trying to populate the atributes, but I can not make the ep to import the file.
If I have ep create the files detailed and basic I can then reimport them without problems but if I empty the pproduct_attributes table in the bd then they can not be imported anymore.
If I dwld the files, open them with openoffice using utf-8 save them and then reload them (without deleting the table products_attributes) they can be reimported.
If I import the file detailed file created with open office I get the following error file SKIPPED! - Attribute Entry on : - Not Found! for each record present in the csv
If I import the basic file created with open office I get the following error
SKIPPED! - Model: XXXXXXXXXXXX - Not Found! Unable to apply attributes.
for each record, but all the product models XXXXXXXXXXXX exists and if I make a search both from the shop and from the admin with the product model XXXXXXXXXXXX the producs are found.
I have cheked the files bothe the one generated and the one I create with open office and as far as I can tell, they look exactly the same as far as the structure is involved.
Can someone help?
Thanks
ciao from Italy
enzo
Hey Enzo, sorry for the delay in responding, I had spent some time trying to look back for the patches to this issue which are published in the thread; however, the simplest solution at the moment is to download and place the files from github found at: https://github.com/mc12345678/EasyPopulate-4.0
I spent some time cleaning up some code last night to try to post a corrected version to the ZC site; however, what is there is functional and corrects the unfortunate issue that you have also come across as well as a few other things.
Hello!
I am having a lot of trouble getting this to work...
When I export the file of 1 test item I manually added then import it (with no alterations, just scrolled down and clicked import) the file import well.
BUT when I opened that same file in Open Office and add one new product (only the model, name and description changed) There is an error.
I checked the error logs and it kept mentioning "MySQLi error 1364: Field 'categories_description' doesn't have a default value"
But in the template of the EP, there wasn't a field called "categories_description"
So I tried adding that in and still error...
I don't understand why. I even kept the file name.... What am I doing wrong?
Attachment 16693
Dimsumgurl, each product when sent to be imported must be assigned to a category, otherwise where would it show up in the store? So to do that, a product is expected to have a category assigned to it. Further, if the category assigned doesn't exist (yet) then it is to be created. Thing with a category is that like a product with attributes, a category has several other characteristics. Those characteristics are/can be assigned separately from the product creation.
You mention that there was no categories_description field, in the import file, which is expectedly true, but was a v_category_name_X field present and populated with something? Where X represents the language number seen on the EP4 tools page on the right side?
It sounds like as the error message eludes, that a new category was generated, but the new category_description could not be assigned because the database is expecting either a value to be provided or a default value on the field.
Hey there!!Quote:
Originally Posted by mc12345678
Thanks so much for your reply and detailed explanations! Yes the v_category_name_X field was present in the sheet with a category name under it. I will attached a link to the file so you can take a look. http://www.filedropper.com/full-ep2016sep23-231700
I removed the category and item and started from scratch by created a new category and item underneath it via admin.
I exported that and imported that same time (nothing altered) and it was fine.
When I opened that same file and added 1 new item under that line, i got an error
So I uploaded that file and both product were added to my test store. Can you identify anything about your setup? Zc version, server info, php version?Quote:
Originally Posted by dimsumgurl
At the moment I'm unable to reproduce the issue, but could see with the way that the categories_description field of the categories_description table that a server may have an issue with the lack of categories_description content, but in this case, the first use of the category is already fully defined or at least enough to then allow the second product to be inserted without having to define the category just add the product to that existing category.
I guess the other question to see/identify where an issue might exist is to identify the source/version of EP4.
This plug in is quite useful and complicate therefore you can expect to have troubles.Quote:
Originally Posted by mc12345678
Thanks for you help however and for this plug in. I love it.
Ciao from Italy
enzo
Well, surprisingly (or perhaps not) the issues being addressed existed for a year and a half without report and was from a consistently applied error at the time of writing. Sadly the issue introduced is one that I have helped others work through with other plugins. Here, just didn't see the issue until a few months ago when someone pointed out how EP4 affected the database differently than a manual entry. Mind you the problem was also introduced/related to improving notification of database changes to try to support PCI tracking information.Quote:
Originally Posted by enzo-ita
Hello again!Quote:
Originally Posted by mc12345678
So I did a clean install (just in case I messed something up from installing other plugins)
ZC 1.5.5a
server info OS Linux.. (not sure what server info you need exactly.. let me know!)
php version 5.3.29
I imported CSV of the default items that were loaded into the ZC store and opened in open office.
I removed all except 3 top lines of the sheet so I can try to add a new item under the first 3 items.
Everything was the same in terms of the description field, meta tag status etc. from the pre-loaded products
I just made a test model number and name.
I still got an error..
UPDATED! - Model: MG200MMS | 1 | matrox/mg2 | Matrox G20 | Reinforcin | www.matrox | | | | 299.99 | 23 | 0 | 0 | 1 | 1 | 0 | 0 | | 2003-11-03 | 31 | Matrox | Hardware^G | Taxable Go | 1 | 0 | 0 | 0 | 0 | 0 | | | |
UPDATED! - Model: MG400-32MB | 1 | matrox/mg4 | Matrox G40 | Dramatical | www.matrox | | | | 499.99 | 23 | 0 | 0 | 1 | 1 | 0 | 0 | | 2003-11-03 | 31 | Matrox | Hardware^G | Taxable Go | 1 | 0 | 0 | 0 | 0 | 0 | | | |
ADD NEW PRODUCT FAILED! - Model: test - SQL error. Check Easy Populate error log in uploads directory
Now that when I checked the error log, it's a different one..
"MySQLi error 1366: Incorrect integer value: '' for column 'products_discount_type' at row 1"
Is the CSV looking for ALL Fields present in the form? How do I customize the CVS headers so I don't have to input every single field? (Plus I would like to add a few since I will be using CAnada Post to ship the items which is measured by dimensions and weight.)
INSERT INTO products SET
products_model = 'test',
products_type = 1,
products_price = '12.88', products_image = '',
products_weight = '1',
products_discount_type = '',
products_discount_type_from = '',
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 = 1,
products_date_available = NULL,
products_date_added = CURRENT_TIMESTAMP,
products_last_modified = CURRENT_TIMESTAMP,
products_quantity = 1,
master_categories_id = 4,
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 = ''
If the field along the top of the first row is present, then whatever data is provided below it will be attempted to be applied. If in this case the value is blank, then it will try to store a blank value. Relatively recently almost all fields have been made optional.
I'll take a look to see if that field when blank should default to 0 but the above still generally applies. I'm preparing a new version to post which addresses identified and discovered issues.
Hey!Quote:
Originally Posted by mc12345678
I just tried to do some testing..
(sorry I forgot to add: Is the latest vers in the first post of this thread? Just so I know I installed the latest one...)
So since the bug log said "MySQLi error 1366: Incorrect integer value: '' for column 'products_discount_type' at row 1"
I added v_products_discount_type in the top field and I entered "0" in the CSV files (just like a majority of the items were entered with I imported the file and checked their fields)
But that threw an error.
Then I though to add products_discount_type into the config>easy pop4>User Defined Products Fields
Then I get another error "MySQLi error 1110: Column 'products_discount_type' specified twice"
As to the other questions, the code does not inspect your admin form to identify anything that may have been added or modified. It was manually put together to consider the base product information with the ability to expand on the use of additional product table fields as user identified fields. So if your additional dimensional fields have been added to the products table then in the EP4 configuration, if you go to the user defined fields you will want to add each desired field. When entering the field(s), separate each by a comma. The field should be entered as shown in the database (do not use the prefix of v_ unless it exists in the database). For example if the field is called products_length, then products_length should be entered in the user defined entry. Export of the products data will produce a v_products_length column and then whatever data is entered into that field for a row will be populated in the database with that information.
What error was thrown when the value of 0 was entered? Did it have to do with the field just below it in the above sql query?Quote:
Originally Posted by dimsumgurl
BTW, good testing. That's the point of the first step of the readme.txt file.
Some things can be predetermined and are known to be required a specific way in order for ZC to function. Some things are/can be modified related to a default store and therefore are not "locked in". Again, will look at that field to see what's going on but the way it is supposed to work is to pull the default value(s) from the database and replace whatever default value with whatever is entered in the csv file if the field is provided in the file, otherwise if the field is not present then to not push the value(s) to the database and allow the database to auto-populate the field with the default value if it's a new record or to leave it alone if the record already exists.
I did two testings:Quote:
Originally Posted by mc12345678
1. The config>easy pop4>User Defined Products Fields is left blank
I added new column and put v_products_discount_type and below entered "0" for my newly created model number. I get the follow in the error log
PHP Code:MySQLi error 1366: Incorrect integer value: '' for column 'products_discount_type_from' at row 1
When executing:
INSERT INTO products SET
products_model = 'wooly',
products_type = 1,
products_price = '255', products_image = '',
products_weight = '5',
products_discount_type = '0',
products_discount_type_from = '',
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 = 1,
products_date_available = NULL,
products_date_added = '2016-09-26 20:25:00',
products_last_modified = CURRENT_TIMESTAMP,
products_quantity = 5,
master_categories_id = 65,
manufacturers_id = 10,
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'
2. config>easy pop4>User Defined Products Fields has "products_discount_type" entered
I then exported a copy of the CSV so the v_products_discount_type column shows up.
I do the same thing as in adding a new item etc
I import that file and got error that says
What i am confused is, how is the integer wrong when all the other items have "0" too??PHP Code:MySQLi error 1110: Column 'products_discount_type' specified twice
When executing:
INSERT INTO products SET
products_model = 'wooly',
products_type = 1,
products_price = '55', products_discount_type = '0', products_image = '',
products_weight = '6',
products_discount_type = '0',
products_discount_type_from = '',
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 = 1,
products_date_available = NULL,
products_date_added = '2016-09-26 20:25:56',
products_last_modified = CURRENT_TIMESTAMP,
products_quantity = 5,
master_categories_id = 65,
manufacturers_id = 10,
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'
Slow down a little and rereview the two errors, the one first reported and the one that occurred after resolving the first and before trying to provide the user_defined field.
The first error had to do with: products_discount_type, the second because of products_discount_type_from which is a different field. Originally both had '', then after resolving the first issue, only the second one had ''. Again will look at how both of those fields should behave, but this is/was the first report of that "issue".
As discussed elsewhere here, either those familiar with the plugin have self corrected it, had someone else do so without reporting the issue, have moved on to something else, or have operated in a way that didn't bring that to the surface. Regardless of their reasons, thank you for reporting this.
Oh my, Thanks for pointing that out to me. I guess I got tired eyes from looking at too many codes and trying to figure this out for too long I'm not reading the error properly.Quote:
Originally Posted by mc12345678
I will go back and add the products_discount_type_from field and go from there...
But like you said, if the field isn't in the CSV, it should just default "0" right? Because right now it's basically forcing me to include every field untill it's all complete before it can import a new items that I am trying to transfer from...
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).Quote:
Originally Posted by dimsumgurl
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.
Had an opportunity to look and am in the process of applying corrections.
Comes down to this: in the quest of rewriting EP4 to provide data sanitization, at one point or another some of the fields for import were posed as strings instead of their respective float or integer as so far found. So I'm going through all of the import records to be sure that the data type of the input matches the datatype of the database as applied against a default database.
In the case of the above issue, the field being empty was treated as an empty string '' instead of an empty integer 0. That is why the empty field (not imported in the file) caused the error/issue. Now that discovered and the code is consistent, it's a lot easier to address and correct all at once. Still takes some time, but a lot easier...
Again, thank you for pointing out that issue. It's really the only way to see things get corrected (when they are a problem) or to know/learn why they are the way they are.
Hey, I have a question. I have over 50 files that I have imported. If I delete those files does it remove any of my products? I just updated my Quantity of products today. If I delete file also will it remove any of my products?
Thanks
Wade
The presence (or absence) of the file(s) on the server has no direct effect on the database. Certainly opening EP4 to see no files may leave one feeling empty as well, but it will not remove or adjust any information in the database by being deleted (just like the that there is no change by uploading the file(s)).Quote:
Originally Posted by wmorris
That said, it may be worth maintaining a certain amount of history of operations/changes, but they do not have to stay on your server.
For others desiring to use EP4 to delete a product, change the status of the product to 9, then import the file/product and it and all of its linked versions will be removed from the database. To reassign a product's master_category_id which will remove it from the previously designated category, use a value of 7 as the product's status and the product's master_category_id will become that of the category for the current row.
Hello!Quote:
Originally Posted by mc12345678
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!
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?
I may have this sorted. Still have to try and replicate.Quote:
Originally Posted by soxophoneplayer
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.Quote:
Originally Posted by soxophoneplayer
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.
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.
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:
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.
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 ofQuote:
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)Quote:
Originally Posted by mc12345678
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
Okay so now i have the .htt file correct that allows me to download the csv file.
What about the rest of the stuff that is showing NO Supported data files? Is this something i should worry about
Attachment 16717Alright as to my other problem with import. I downloaded the file opened with open office got the scrrenshot so after i opened it went to the bottom of the list added 1 item saved it kept format... the clicked on the upload ep file at top browsed for the file and clicked upload file then went to the bottom and clicked import.... it has been 3 mins and nothing shows blank screen
hope this helps....And THANK YOU for helping me
Robert
I did not yet look at the file, because there are/were other issues to address first but I'll get to that in a moment.
The htaccess file provided in the download would go into the temp folder used for file upload/download. There are other reasons not to incorporate it into the main htaccess file of the admin. The file is intended to control/limit access and such permissions are best to be applied at the point(s) where they are needed. Because this plugin only needs to access csv files in the temp (or otherwise named) folder, that folder is the only one that needs the extra rules of the file.
Now, back on the import file. It is possible to use EP4 without products_model, but it is not the default functionality. One of the first/early instructions describe that this plugin uses the products_model field as a primary key.
So what's a primary key? Think of it this way. You live at an address, your address is different than everyone else's. In order to find your house you can either provide the address or you can give very detailed directions that only someone while in the "area" can follow like the big tree on the corner, or the red house on the left. Computers don't tend to do well with the second part, but if enough data exists, it can be done. Anyways, the address of one's house is similar to products_model for EP4. It's the one "unique" piece of information that says hey, this line of data belongs with this product. Now, ZC as a database program uses products_id as the primary key. This option has been added to EP4, but, one should also realize/consider the source of data to populate the database. If it is your own entered information (not from some mass import vendor file), then go ahead, use the products_id or blank_new option (I suggest blank_new if you are not going to hard code the products_id), but even so, you don't want to end up with the same exact product listed more than once as a primary product. It can be linked, but you don't want the same product multiple times in the products table it's not good for ranking and would likely cause an inventory tracking issue.
Anyways, that's a lot of information again. The general process is straight forward. Start with one thing at a time, then work your way to many/multiple items and things. The requirements are provided in the instructions, it's how they are applied/uniquely used that makes this tool something to do things faster. There *is* a learning curve to overcome to gain the most benefit from it and "daily" business.
Nope. It is/was added to show how files should be named if it was desired to upload a file that is/could be processed by that "filter". If it becomes bothersome, there is a setting in the configuration area so that detail is only provided for files that match the type of filter. Or you can go "old school" and completely turn off the extra information and the table at the bottom will only show the filenames, buttons and whatever other data is applicable to that row of the file...Quote:
Originally Posted by Robert Cooper
It was a feature somewhat requested a while back because the instructions were not read or considered on a routine basis. The goal was to improve user understanding of the current status and how to at least name files that were to be used for a purpose. In part it seems to have reduced thee number of questions related to: I uploaded a featured product file and imported it but nothing changed. Can ask: does it appear immediately below the featured file(s) list or below the full products list? If not in the featured list, then won't be processed as a featured file...
Okay, so the above image is of the import of the csv file. When you say you "kept the same format" does that mean you did a save as/export operation and applied the above settings as part of the save? Or did you just click save? There's an entire Open Office FAQ at the open office site on creating a csv file with the various delimiters to be applied.Quote:
Originally Posted by Robert Cooper
As to the three minute import/blank screen. Well, the screen should not change until processing is complete in a routine successful operation. By it going blank, that means that something hasn't quite worked correctly. Further, it should mean that there has been a ZC error log generated and that log should be in the logs directory. You can post it, but please obscure your admin directory name as the issue is/would be admin related.
Okay i went in configuration> easy populate 4 and changed Import/Export Primary Key blank_new. did the complete products (with metatags) downloaded to my computer opened it up in open office. added a product, hit save closed file and clicked browse under upload ep file at top left. hit upload got a green file successfully uploaded. went to bottom clicked import....and it just sits there loading And finally comes to a blank page. could it be firefox that is the issue i am on a mac BTW also Should I just delete everything in the file except the headers and not keep any of my other products in there?
Robert
If products_id is included in the exported file, then it would not be a problem. As to the computer type? Makes no difference as really once the file is transferred to the server, the work is being performed by the server and not your local computer. Otherwise, Open Office is doing the work on your local computer.Quote:
Originally Posted by Robert Cooper
Couple of things, selecting save does not store the file as a proper UTF-8 CSV file. Need to select Save As, then at the bottom of the window that appears (at least on Windows) is an option to edit filter settings. Then presented with options that can be set to values similar to the image(s) above. This is also described in post 8 I think it is/was of this forum.
Again, the blank page should result in a logged error. Mentioned that have 500-600 products to add? How many rows of data are involved? Should the file be split? Certainly reducing the number of rows in the import file will reduce the possibility of something going drastically wrong, but it is not a requirement provided the data meets the expected formatting.
Well i have done save as... and same thing i have right now a total of 1327 items in my store. Maybe if you want to we can do this in PM's I would be willing to give you access to my backend just to see whats going on and would be willing to make a small donation to you rescue effortsQuote:
Originally Posted by mc12345678
Robert
Okay one thing i have done on my local computer is play with zen cart and EP4 i did get it to update the products after putting products model starting at 1001 and all the way down to 2103 something like that. It put in double products with of course the new products model. I fixed that after reloading my DB now my question is (I don't mind having a product number...is there a way i can add the product number(s) with out having to go into every single item and add that under where is say qty?
So a couple of things. Unfortunately my computer's Internet is down so if I were to try to access the computer system it would basically be limited to what I can do through just a browser. Been down for 12 hours now surprisingly. Anyways, there's a few other factors to know, and one that was asked about earlier. Does products_id appear in your exported file after you changed to blank_new as the primary key, what version of EP4 are you using?
To apply a products_model using EP4 requires using some other field as the primary key. You could also use a simple sql query to apply a "calculated" value to the products_model if it is empty for example...
As to your first question I don't se a product_id in any of the downloaded files it has the following hope its not too much
v_products_model v_products_type v_products_image v_products_name_1 v_products_description_1 v_products_url_1 v_specials_price v_specials_date_avail v_specials_expires_date v_products_price v_products_weight v_product_is_call v_products_sort_order v_products_quantity_order_min v_products_quantity_order_units v_products_priced_by_attribute v_product_is_always_free_shipping v_date_avail v_date_added v_products_quantity v_manufacturers_name v_categories_name_1 v_tax_class_title v_status v_metatags_products_name_status v_metatags_title_status v_metatags_model_status v_metatags_price_status v_metatags_title_tagline_status v_metatags_title_1 v_metatags_keywords_1 v_metatags_description_1
the version number is Easy Populate 4.0.35.ZC - 04-29-2016 my products model is empty or blank but if i need to use them i can do a sql to change them to just 1001 to whatever ends up being
Corrected in the version I uploaded Wednesday and available from https://github.com/mc12345678/EasyPopulate-4.0
But if you go to your configuration for Easy Populate and add without quotes "products_id" and then export you'll be able to manage applying a products_model if you wish (primary key of products_id or blank_new), or keep using EP4 in the blank_new/products_id setting...
Or can run a sql query... :)
okay i updated to ver 36 of ep i changed to the product_id and downloaded a new file now it shows v_products_model v_product_id. so what you are saying now i can auto fill my model numbers to 1001 for the first one and it stops at 2401. when i uploaded it up and imported it it added the product models with no dups. now can i change back to product model in import export primary key? and then just add my products from there?
Robert
You can change back to products_model and continue from there. You will need to be sure to always add a products_model as part of the new record(s), and if that products_model is the same as another, the last one "wins" meaning the data from the last occurrence of a products_model will replace the data of any previous one. Only caveat to that is if the categories name is different in a later row, then a linked product will be created for the later one, but all other data will replace the previous. So in effect would create a linked product with all data the same for all "versions" where the products_model is the same.Quote:
Originally Posted by Robert Cooper
Otherwise, if you're just entering your own data with "minimal" updating from some source, then you could leave as blank_new and a new product would be identified as a products_id being blank, an existing product (or if you wanted to assign a specific products_id) would have the products_id filled in. Still recommend caution with that, because of the interrelationship of data in the database and it's dependency on the products_id.
Well I have all my products showing a product number now in my test store. So i did change back to product model done 1 item with the product model being 2401 and went from there it seems to have added it okay no dups or linked products. if i am seeing it correct it adds its own product id when the product is added to the store correct?
I will just keep numbering the products as 2401, 2402, 2403 etc....
Hi Can anyone help?
I have imported all of my attributes successfully but the v_products_options_sort_order column doesn't seem to be importing, does anyone have any idea why. I am so close to finishing this big import and this is the only thing delaying it now :huh:.
Below example... Everything else is fine!
v_products_options_sort_order
1
2
3
4
5
1
2
3
4
5
1
0
v1.5.5a
Easy Populate 4.0.35.ZC - 04-29-2016
Thanks
A little delayed in posting this, but...
Version 4.0.36.ZC has been made available for download. Patches "hidden" throughout the recent months are incorporated as well as the issues recently identified. No that doesn't mean that all of the discussion of attributes is incorporated, but there are/were some improvements made.
Download available at: https://www.zen-cart.com/downloads.php?do=file&id=2069
As is the case with addressing any issue, need additional context.Quote:
Originally Posted by lindsey80
What is the filename (prefix up to and including the first occurrence of ep), what is the primary key? What are the values of the primary key? What is the result of providing the above sequence of sort orders?
The import file for a detailed import appears to support that operation, although in 4.0.35 there remained some bugs that had to be corrected and hence 4.0.36.
BTW, saw this post where the problem appeared to be that the products_model field was missing and to which the above problem appeared to be associated. If you could please clarify what is going on? If you did have the same problem as was experienced by LilleyPadGifts and have since resolved it, could you please add to that thread what was done to resolve that issue? The above message indicates that all is fine which is different than the referenced post.Quote:
Originally Posted by lindsey80
Hello,
I have a question. In my product feed is it possible to list more than one image in the v_products_image column?
If possible what would the entry look like? xxx.jpg,xx1.jpg or xxx.jpg:xx1.jpg, xxx.jpg;xx1.jpg ?
Thanks
Frank