Feznizzle:
No, still unresolved! Still hoping to buy someone some coffee! :D
Yes, a table appeared but it contained no data. The data I was trying to insert was new, not a replacement for existing data.
I don't think a value of zero was inserted because, right after posting, I decided to go thru and manually insert price breaks the hard way (using ZC admin functionality). No price break tables existed yet, despite the fact that an empty price break chart was showing up.
I went back thru and searched for trailing/leading spaces, found none. In fact, I searched the entire file, found no spaces anywhere.
Your question about new data applying to only "one" product is intriguing. I will poke around and see, but I'm fairly certain that the model numbers are unique, thus it should not have applied to the wrong prod.
This brings me to my one and only gripe about this mod. Why in the world does it tie everything to model number??? Makes zero sense to me, why not just use the system already in place, created naturally by ZC? If I abandon this mod, that will be the reason.
Even if we set aside the simple fact that two dif manufacturers might have the exact same model number, there are still plenty of logical reasons to not have unique model numbers. One of my websites sells parts for medical equipment. Some of those parts can fit on multiple machines. So one model number may have as many as 10 unique description pages, all with unique titles (Mod# 444 - 2" circular blade for cast saw; Mod# 444 - 2" circular blade for autopsy saw;) and unique –application specific– product information.
I would love to change the default controller from model to prod_id... is there a way to do that?
Okay, so to address first the original issue. When you went back to produce/modify the price break for the items that you had imported, was there or was there not data that related to what you imported?
Again, because I am not specifically familiar with price breaking, the next question would be if the table name convention for the table in your database equal the name expected by the mod?
As for model number issues, my thought on it if I were to start from scratch is this: what piece of information do I have control over that is not affected by the routines of ZenCart, typically wouldn't change, would be more likely to be unique and such that I can reuse the file regardless of the cart to which the file is being applied without increasing the data fields in the cart.
Model Number could be one of those; however, in your case, have many products that are the same thing (same model, but different descriptions which of course necessitates that you keep your list up-to-date as to how that product can be applied.)
The other issue though is that, if the product_id is used or even another attribute, you would need to have a way to differentiate between data for existing items and data to indicate a new item. (Ie, either the number for the product_id or a designation such as NEW, a negative number, or a value of zero to indicate that the item is to be added.
As for this mod, one thing Chadderuski has done is make the program relatively modifiable to add additional methods of exporting and importing data. Perhaps the hard part is understanding that there is a sequence of events necessary to make that happen, like to add attributes to a product, first or in parallel have to have a product and an attribute to apply, and then to apply the attribute. (Or maybe it is already encoded to do both actions in one, I haven't gotten into the meat of that part yet myself as I have/had been working on a stock by attributes direction.) He has also asked in times past for additional input on things desired, so I would think that your input would still be of benefit, but I know (and like myself) that he has some other priorities currently above this mod as it stands. A new update is in the works with clearer documentation, and from the sounds of it there is a major code change, so it may be difficult at the moment to incorporate a change immediately.
Back to the problem though, was also thinking what information was/is in the datafile that was sent on to EP4 for processing as it relates to your price break? Was there an equation, a value, etc.? And what I was referring to about a value of zero being provided is something like price is 1, price break is 1, thinking that 1-1=0 and therefore a value may not be displayed.
