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 23 replies, 4 voices, and was last updated 6 years, 11 months ago by
.
-
Posts
-
Hi WC Vendors Team
Your plugin is working like a charm except…when vendors export to CSV two things happen, which shouldn’t:
1) The Customer Field is blank. On their dashboard dit shows the email address, but in the export, nothing. I would prefer it shows both their first/last name and their email address for ID purposes (at events) but even email is OK…
2) The export only shows the most recent purchases- even if I change the start/end dates and “Update” on the dashboard…can you help please?
Many thanks.
Alexandra,
I am not certain that the export ever showed the name or email- but I will be submitting an issue for the date picker– which I can see is not working — and I will add the email and name suggestion to the issue.
Thank you for letting us know this is not working correctly.ETA: I am seeing the customer name and address on my exports. The date is ignored, however.
There is no customer email added- so I will request this in the issue I submit.Thanks for the swift response Anna but as you can see from the attached, the Custoemr column is most certainly blank so vendors can’t match purchase with anyone. Even if it was just the email address as it is when I view it online is OK….what would be ideal is an email address and First/Last Name though.
Alexandra,
Ok- thank you. I will see if I can sort out why this would be occurring.
What are you using to open the export?The export opens automatically on download in Numbers (Mac) but it is the same in other programs too.
I’m so sorry Anna, me again. The vitally important part of the ticketing information on download is also not showing- the product Variation/Attribute, i.e. 5 x Bossa Nova Sunset Club: Nordestino
Date + Time : Fri 19 May @ 7:30pmWithout this info. the vendor doesn’t know which date and time someone has bought for…can I go in and edit a template file somewhere? Any tips on an easy way to do this?
Sorry for all the questions!
Hi Anna
Can you clarify that you are seeing the customer name on the export? I see only the product name on export with total price, shipped (which I don’t need), order date and order number. What I’d like is:
– order number
– customer name & email
– item ordered incl. variation
– total price or total items ordered…Can you point me to which file dictates what is in the csv export please?
Hi Anna
I have found the file: wc-vendors-pro/public/class-wcvendors-pro-export-helper.php and it looks like I need to amend these two lines to get what I want:
$new_row[‘ customer’ ] = str_replace(‘<br/>’, ‘, ‘, $order >get_formatted_shipping_address() );
$new_row[‘ products’ ] = $products;
I can change shipping to billing and that populates the customer line with too much information including street address etc.- what would I put in there to simply pull email address? With products- what can I change $products to to get products at a variation level?
Many thanks in advance.
OK, so no news from you but I am one step closer…For others who want email addresses on CSV export it’s a simple fix:
$new_row[‘ customer’ ] = $order->billing_email;
But I am still at a loss to get a formatted $new_row[‘ products’ ] = $products; that includes variation/attribute details as per what is on the order dashboard (front end)…any ideas? Even if you just point me to the file that builds the order items on the vendor dashboard it would mean I could figure this out for myself…
Alexandra,
I am glad you are working to get this formatted to suit the needs of your site.
I believe you can find the information you may need within wp-content/plugins/wcvendors-pro/templates/dashboard/order/order_details.php (look around line 120)
and also perhaps within wp-content/plugins/wcvendors-pro/public/class-wcvendors-pro-order-controller.phpI’m still trying to get the Product Name + Variation/Atrribute text to appear in the CSV export for Orders- I can get the $products but I just can’t seem to get it to appear like it does on the dashboard…can any help?
Along these lines, my vendors would like to see the address exported in pieces, so that it can be imported into PayPal’s bulk shipping system, which does let you map columns on upload. So, no specific format change, just exporting the address pieces in separate columns instead of all together with the customer name.
I’d really really really love to find a solution to this! I figure if I can just add the correct code to this line in wc-vendors-pro/public/class-wcvendors-pro-export-helper.php then its sorted:
$products .= “$item_qty x $item_name \r”;
Please help. I just need to know how I can get the product variation just like it is on the vendor dashboard before export….
OK, I want to include the item meta in the export and the following exports the item name and should export the meta but it isn’t. It just says “Product Name x Array” instead. I am so very very close to getting the export functionality I actually want- it is just this tiny thing!!!
$item_meta = $item[‘item_meta’];
$item_name = $item[‘name’];
$products .= “$item_name x $item_meta \r”;Alexandra,
Unfortunately “just this tiny thing” is turning out to be quite a pain for me.. I am trying, though. 😉
If I cannot get this sorted soon I will pass it up to Jamie to see if he can assist.
I wanted to check in to ensure that you knew you were not being ignored.@ANYWHEREFEST @DVRCTHEWRLD
If you have a second, how did you get this working?
On class-wcvendors-pro-export-helper.php: I tried pasting the new lines David provided and removing lines 102-119; I tried pasting it above line 102 and also below 119. All these attempts either led to errors, or in the one case there was no error – it just showed me a blank CSV (with only the old headings in Row 1).
Where should I be pasting this?
Thanks in advance 🙂Hi Nadav
I replaced from:
foreach ( $_order->order_items as $key => $item ) {
to close }
i.e. $shippers = (array) get_post_meta( $order->id, ‘wc_pv_shipped’, true );
Alexandra,
Thanks for your response.
I tried this again and it’s still pulling in the same details as before to CSV: just the six columns showing Order, Customer, Products, Total, Shipped, Order Date.Just to clarify: we are talking about class-wcvendors-pro-export-helper.php?
If it’s not too much trouble, would you mind posting the whole file so I can just copy and paste it all in one go?
- The forum ‘WC Vendors Pro Support’ is closed to new topics and replies.