NOTICE: We've Moved to a Ticket System for Support
As of August 31, 2017 (12am EST) our support forums will be retired (read-only), and we will be moving to a support ticket system. This will allow us to better organize and answer support requests, and provide a more personalized experience as we assist our customers.
For the time being, we will leave our forums open for reading and learning while we work on creating a more robust Knowledge Base for everyone to use.
If you are a WC Vendors Pro customer please open a support ticket here. If you are a WC Vendors user please open a support ticket on the Wordpress.org forums.
The information on this forum is outdated and in most instances no longer relevant. Please be sure to check our documentation for the most up to date information.
Thank you to all of our customers!
- This topic has 7 replies, 3 voices, and was last updated 7 years, 1 month ago by
.
-
Posts
-
Hi WC Vendors team
I had to move a product from one vendor to another and while they can now see that product in their dashboard all the orders for that event have not moved across…can you help?
I checked that the WC orders are correctly assigned to the new vendor but still nothing is showing….any ideas?
It’s actually not pulled from the order data. It’s pulled from the commission log. Here’s how to do it:
1.) Find the products id. Find new vendors user id.
2.) in phpMyAdmin, open the pv_commission table. Find the products id in that table, and each row you do, indicates a sale. Change the vendors id to the new vendors id for rows that match that products id.
It’s a bit manual, but that’s because we dont have any normal facility for you to hack at the steadfast commissions tables unless you do it through the database. Hope this helps!
Thanks so much for the swift reply- much appreciated!! Your solution works perfectly with orders that are not shared between multiple vendors but there are about ten orders outstanding because the customer has bought two tickets for different shows and its allocating only to the first vendor id…it’s weird because it is only showing the other products’ commissions not this one’s…can you help?
I figured it out- duh! The previous sales were allocated to yet another vendor ID so they too needed to be changed.
Thanks so much for your swift replies!
Me again. The problem is, tickets were sold before the product was allocated to a vendor so they were listed with us as the administrator. As you know (!) Administrators can’t be vendors too so about ten orders are not in the pv_commission table at all…what can I do?
I can see all the missing orders in woocommerce_order_items table but do not see a way to move them to the commissions table.
Aah! That’s easy too. 🙂 You can manually inject the rows. Just copy a row and then change the data to the new product id, order id, vendor id, commission total and status. It’s a surprisingly common sense labeled table, each row is for exactly what its title is.
So, rather than “change”, “add”. 🙂
Genius. Done.
While I have your ear…can you help with my export problem (there’s another thread about it)- I really need the product variation (i.e. date and time) to show up on the export but it doesn’t just the $products…what can I add to it to show the product ID but as html like it is in the lovely dashboard table?
Alexandra,
Aside from the location info I gave in this last post from your previous topic, I do not know exactly how this would need to be formatted- that custom code would be up to you to configure for the CSV export formatting. https://www.wcvendors.com/help/topic/export-csv-has-blank-fields/#post-58785
- The forum ‘WC Vendors Pro Support’ is closed to new topics and replies.