Resolved Export orders based on Order status

Woohoo! It appears to be working as expected with your latest patch and directions, Roland! I even used my version of the template rather than the one you provided above. I will put it through the paces to make sure there are no issues but as of now, it looks like problem solved!

THANK YOU SO MUCH for sticking with me on this and not just telling me it works and there is nothing more you can do. I actually had a developer recently do that to me. I hired a different dev who found a bug in his code that was causing me problems!

Your support, as always, is nothing but the best!

Hello,

Glad to hear everything is working out

Roland,

A new problem has popped up with this after updating to the latest version, 6.5.4. If you recall, I have a site where I migrated old orders over to the new site. I did NOT migrate old items though and choose to create all new items from scratch. I have a number of old orders that I need to export that have item skus on them that are no longer in VM on the new site. When I try to filter in the template options for this item, I get no results to add to the filter. Example, the old product is CJC1R. If I type in CJC1R in the search box in options-filter, I get other products who's sku begins with CJC1R but not the old product. I have checked and I ABSOLUTELY have orders with CJC1R on them so that is not an issue. See the screen shot of what I am seeing:



I had conflicts with new VM products using the same VM Product ID, so a while back I did a sql query and changed the VM Product ID to 10000 in virtuemart_order_items table. Not sure if that makes any difference. Before the update, I was able to export these old orders just fine after applying the patches you provided.

I am guessing the problem is because the product is no longer in VM. I thought about just creating a new product in VM, then changing the productID in the database for that product to match the product ID used in the old orders but am concerned what that may do to old order balances, etc.

Any help you can provide on this would be greatly appreciated. I know you have probably already deleted the database I sent you but if you still have it or can recover it, please feel free to use it if you need to.

Alternatively, I can downgrade to the previous version and use it until I get past the old orders if that would be best. I take orders for products that have to be built. Once I get past them and am working with new orders placed on the new site, I could upgrade. Is there any trouble downgrading or anything special I would need to do if this is the easiest way to handle this?

Hello,

I am guessing the problem is because the product is no longer in VM.

The problem is not that the products are no longer there because the search only happens on the order item table. The issue is that the list is limited to 10 products and you have more than 10 products that start with the same 5 characters in your case. Usually you would continue typing to match the full SKU but your SKU ends at the first 5 characters. The search works on both the SKU or product name. You can filter the list on the name of the product to get that CJC1R product.

A work-around in your case would be to change the file administrator/components/com_csvi/addon/com_virtuemart/helper/com_virtuemart_json.php on line 106 and change the 10 to a higher number if you want more products to show up.

This is nothing new though, it has been there since a long time. It just happens that your database returns these 10 records as first items.

A downgrade is not necessary I think since you can filter the list on product name or that won't work either?

Nevermind. Filezilla was acting up on me.