vonbrocklin

Not sure if this is an EasyPopulate bug, intended behavior, or if I have screwed up something in my code: 1. I had 21 test products in my store, which I manually deleted in the admin tools 2. In my now empty products table, the auto increment products_id is therefore at 22 (the next available number) 3. If I do an upload using EasyPopulate, the system gets tricked by the empty database. When it updates the products_to_categories table and the products_description table, it adds the products_id as "1" instead of "22" even though that is the proper products_id assigned to the first product in my upload. This means that my product is "hidden" from the oscommerce because it does not get assigned to any category. Any insight on how I could change this behaviour? I know I can go manually fix things, but I have a client who plans on doing monthly deletes of the entire product catalog, followed by an EasyPop update. Don't want to face this each time they empty out their product catalog. :shock:

It's not a bug, but it's not a feature either. It was a shortcut - it was easier to program it that way. I've got a version of EP that changes this to the top-down order, and also adds product_url. It's getting beta tested now, and will get released soon. The reverse-ish ordering is discussed in the docs, but it's been a thorn in my side since day one, and pretty soon it won't be a thorn any more! Tim Tim: Did you ever release a version that has the categories in proper order? And if not, what would you think about posting that part of the code or at least pointing me in right direction? Thanks for all your work. Sorry for the delay, been busy busy busy. Anyway, I'm scheduled to spend some time on EP this week, hopefully with a release of whatever I'm able to get pulled together. It will include the "category in the right order" fix as well as additional fields for up and download. Tim Hi Tim: Any updates on the category order fix? I read in another post that you were hurting for time, so perhaps you have not had a chance to do an update. Just curious, because I am getting close to turning over a project and would like to have this in there. If you won't get to it for awhile I will probably just use the old version. Thanks again.

No need to apologize! :D I will hold off making any further changes to my Easy Pop mod in eager anticipation of this next release.

It's not a bug, but it's not a feature either. It was a shortcut - it was easier to program it that way. I've got a version of EP that changes this to the top-down order, and also adds product_url. It's getting beta tested now, and will get released soon. The reverse-ish ordering is discussed in the docs, but it's been a thorn in my side since day one, and pretty soon it won't be a thorn any more! Tim Tim: Did you ever release a version that has the categories in proper order? And if not, what would you think about posting that part of the code or at least pointing me in right direction? Thanks for all your work.

Thanks - That thought occurred to me since I didn't really test EP more than once before I started adding my new fields. So I installed a second fresh copy on an unmodded version of OSC, and sure enough the same message. The UI Geek in me just keeps crying out for a more intuitive finish such as you "Upload Complete!" Good to know all of my modifications are actually working as intended though.

I just followed the basic steps listed about 6 pages back, substituting my field names for the ones listed in this post: http://www.oscommerce.com/forums/viewtopic.php...pulate&start=40 Now I'm just wondering why the code isnt' stopping after hitting the last line. It does not seem to be causing trouble but I would like to get it working properly.

I have added two custom fields to my products table, and have modified Easy Populate to work with these changes. Everything seems to work fine, except that it tries to keep going even after adding the last line: No products_model field in record. This line was not imported Everything up until this works great, and all of my lines end in EOREOR, including the final line. Any ideas as to why my changes would cause this? Does the order of the fields in the spreadsheet (and in the update code) have any bearing on this? Any help appreciated, I'm going back to try and hack this out.