My client just contacted me to say that a product option is not showing on a particular order, neither on the invoice or on the Sales -> Orders page.
I checked in the database using phpMyadmin and sure enough, no options were saved for that particular product, even though that product has options that must be selected when ordering.
Should I be concerned? And why would this occur? The shop has processed hundreds of orders without this happening, and the same product was on a previous order and the option showed OK.
The version is 1.4.9.3
This can happen when a customer saves a particular product + option to their cart and the store owner later removes the option. When the customer comes back and completes the order the option is missing.
-Ryan
Same issue here. v 1.4.9.3, Only happens occasionally, definitely not related to removing options from products. Any help would be appreciated.
If you ever removed an option then re-added it it's a completely different option to OpenCart, even if all the values (name, price, etc.) are the exact same. OpenCart only cares about the product_option_value_id. I'm sure if you looked you'd see it's happening to the same product (or small number of products).
If you're using 1.4.x you can upgrade to 1.4.9.6 which actually fixes this (it drops the product altogether). There's no fix in 1.5.x right now.
If you're using 1.4.x you can upgrade to 1.4.9.6 which actually fixes this (it drops the product altogether). There's no fix in 1.5.x right now.
-Ryan
RPH - so if I were to delete the product with the missing option and put it back into the site that should fix the issue? Or do can I just delete the option and then re-insert it again? This should make it reference the new product_option_value_id right?
No, but if you're using 1.5.x that would function as a work-around, I suppose.bobstrupp wrote:RPH - so if I were to delete the product with the missing option and put it back into the site that should fix the issue?
-Ryan
I'll let you know if it works. I am going to try removing the options, saving, then adding the options back in. I am pretty sure a few products are referencing options I setup when testing the site during the build process and later removed.
I'm having a similar issue. Now I can't even re-add the text based options back in. The dropdown options will lose the option attributes. for example I'll have a color option with attributes of red, green, blue, black. randomly, a color will go missing. This is really causing major problems for me.
No, don't do that. That's what causes the problem in the first place.bobstrupp wrote:I'll let you know if it works. I am going to try removing the options, saving, then adding the options back in.
-Ryan
rph - Let me explain:
I did NOT remove any of the options from catalog>options. I removed the options from each product that was giving me missing option values from orders.
Here is the process:
1. Navigate to catalog>products
2. Find the product that is giving missing order options.
3. Edit the product and then click on the "options" tab.
4. Remove every option and SAVE.
5.Add the options back in and SAVE. (so they are now referencing the correct product_option_id)
6. Done. I no longer have missing options.
7. Repeat this for every product that has missing options in the order.
NOTE:
I did this because my client had copied over products I was using when I setup the site. These test products were referencing product options I deleted after I was done testing. The options I setup for testing had the same names as the options they have on the site now.
I did NOT remove any of the options from catalog>options. I removed the options from each product that was giving me missing option values from orders.
Here is the process:
1. Navigate to catalog>products
2. Find the product that is giving missing order options.
3. Edit the product and then click on the "options" tab.
4. Remove every option and SAVE.
5.Add the options back in and SAVE. (so they are now referencing the correct product_option_id)
6. Done. I no longer have missing options.
7. Repeat this for every product that has missing options in the order.
NOTE:
I did this because my client had copied over products I was using when I setup the site. These test products were referencing product options I deleted after I was done testing. The options I setup for testing had the same names as the options they have on the site now.
I know. That's what causes the problem.bobstrupp wrote:rph - Let me explain:
I did NOT remove any of the options from catalog>options. I removed the options from each product that was giving me missing option values from orders.
-Ryan
I have done this but they go missing again (from the product) after a random amount of time.bobstrupp wrote:
Here is the process:
1. Navigate to catalog>products
2. Find the product that is giving missing order options.
3. Edit the product and then click on the "options" tab.
4. Remove every option and SAVE.
5.Add the options back in and SAVE. (so they are now referencing the correct product_option_id)
6. Done. I no longer have missing options.
7. Repeat this for every product that has missing options in the order.
I seem to have found my problem. It is max_input_vars. my host has it set at 1000, I upped it to 4000 and everything works fine. It only is an issue for products with lots of options. see the thread below
http://forum.opencart.com/viewtopic.php ... 4&start=20
http://forum.opencart.com/viewtopic.php ... 4&start=20
This thread seems to have gone off topic. I think the original issue is that, a "required" product option is not showing up in an order (or in the database). This happens randomly to me in 1.5.4.1, say maybe once every several dozen orders. Does anyone have an idea why this is happening?
RPH, I appreciate your help with this but I don't think we are talking about the same issue. My issue does not occur with the same product. In fact, I recently had an order where the customer added an item to the cart and then added the same exact item. One time the size option was there. One time it wasn't.
I read this post carefully and of course have searched the forum for a solution. Any other help you can provide is appreciated.
Thanks
PS...I'm in Omaha.
I read this post carefully and of course have searched the forum for a solution. Any other help you can provide is appreciated.
Thanks
PS...I'm in Omaha.
Who is online
Users browsing this forum: No registered users and 38 guests
