[CommunityCorals]

Great, thanks

[CommunityCorals]

Hello, it seems like this conversation is dead 🙁

Could you please just let me know if you are planning to address this issue or not? If yot I will urgently have to find a custom solution. I just would like to avoid customizing things that you are planning to fix anyways.

Thanks
Dominique

[CommunityCorals]

Hi, did you get any feedback. Please note that there is also a translatable text for wallet in WCFM for which the translation has no effect.

[CommunityCorals]

We are just reviewing the database. Even if I have module analysis deactivated there are loads of data saved in wcfm_detailed_analysis.

Also there are lots of empty and duplicate entries in postmeta for WCFM related data. It takes 2 seconds for every page just to run through postmeta as it is quite massive. Any idea how to make sure that datastructure can be kept as slim as possible or even more urgent how it can be cleansed to improve loadtimes? Website is getting slower from month to month. Check screenshot.

Your help is much appreciated.

Attachments:

You must be logged in to view attached files.

[CommunityCorals]

I also just used the media cleaner plugin to erase 19.000 unused images. Unfortunately the plugin also declared the store banners and logos as unused images. I have a copy of the system where those images are still available.

Do you have any idea how to filter for those images and extract those?

I know that is not really your concern but any idea would be very welcome :-/

P.S. Strange is that the images are still visible on store listing but not in store page.

[CommunityCorals]

– Where you get drop-down for time input?

In which browser you are checking this?

Please check screenshot. This is in vendor settings and I used Internet Explorer. I think same view is in Chrome.

Attachments:

You must be logged in to view attached files.

[CommunityCorals]

Very good ! Thank you guys you are amazing!!

[CommunityCorals]

– Did you browsed vendor store page after added that line of code ?

Yes, I just tried again. I activate code -> Go to https://www.communitycorals.de/farmer/community-reef-supply/ as admin and scroll to buttom. Open page 2. Scroll to bottom –> but no change in Category on store page.

Do I have to scroll through all products on all store pages before it has effect? If ok for you I can provide access.

[CommunityCorals]

Yes, categories are correct. Please check screenshot. I also can filter them in woocommerce shop.

Attachments:

You must be logged in to view attached files.

[CommunityCorals]

That´s interesting. I don´t see them. See screenshot

Vendor and admin functioanlity is also different. From admin settings I can type in times. Also like 13:00 which is 1:00 p.m.

From Vendor view I get a drop down to choose times but there is just 1:00 twice but no a.m. / p.m.

Maybe due to regional setting? In europe we usualy have 0-24 o´clock time format.

BR
Dominique

Attachments:

You must be logged in to view attached files.

[CommunityCorals]

Yes, that´s right.

[CommunityCorals]

Hello,

text could be: “Please add your payment details as plain text like e.g. “Paypal: paypal.me/communitycorals/”. The customer gets this information as soon as order has been placed”.

What I have to say is that the payment information is shown for every order item. My average is like 8 items per order so this is kind og messy and not what has been specified. Would be great if you could also check the code in regards of this issue. Actuually it was planned to print the information per vendor rather than order item.

Below FYI the original specs:

The paypal.me option also is supposed to be presented in the form of a button to the customer. This button should consist of the paypal.me url and the price of the order so that the amount the customer has to pay is directly populated in the paypal.me link.

Specs:
Here the seller can choose via checkmark which payment options he wants to offer. Fields that are available are:
• Paypal.me (https://www.paypal.me/ is prepopulated and vendor can fill text field like e.g. CommunityCorals to generate https://www.paypal.me/communitycorals as a result.  This Link should be visible as button in the new order mail.
• Bank account
• Other payment options (Free text field)

In every order confirmation I would provide an “area” where the payment details of a vendor can be found. If there are multiple vendors there should be multiple “areas”.
Like
Area 1 – Payment Details Vendor Korallensucht

Bank Transfer
Name: Korallensucht Peter Maier
IBAN: DE 12094583405834

Paypal
Paypal address: domdeutz@arcor.de
Pay via Paypal.me: (Button Pay now via paypal me  Link to e.g. https://www.paypal.me/dominiquedeutzmann/99,90)

[CommunityCorals]

I have some further remarks.

1. I tested store invoice vs order view without above code beeing active. Here it seems like in invoice shipping is displayed correctly. In order view it is not shown. So there is a different sum. See screenshots.

2. The above code creats following error which also is visible on store invoice.

WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘AND is_refunded != 1′ at line 11] SELECT SUM(commission_amount) as line_total, SUM(item_total) as item_total, SUM(item_sub_total) as item_sub_total, SUM(shipping) as shipping, SUM(tax) as tax, SUM( shipping_tax_amount) as shipping_tax_amount, SUM( refunded_amount) as refunded_amount FROM gxRTKcRxwcfm_marketplace_orders WHERE order_id = 66837 AND vendor_id = AND is_refunded != 1

Can you confirm that you plan to work on the described issues? That would help a lot as I today have a new request from vendor who needs store invoice.

Thanks
Dominique

Attachments:

You must be logged in to view attached files.

[CommunityCorals]

HI, as I haven´t received any feedback it seems like I have to work with what you have send me?

As I can´t wait I unfortunately have to proceed with current status. Is there any possibility to add an explanation to the customer Pay Option? No one will understand how this works.

Also it would be great if the text field can be adjusted in size so that it is bigger.

Thanks
Dominique

Attachments:

You must be logged in to view attached files.

[CommunityCorals]

Hi,

I have included this as a sniippet and browsed vendors products both from customer view in vendor store and also in vendor store but I could´t see any difference in categories displayed on store page.

[CommunityCorals]

Thanks – Customers are asking why they can´t put item into cart – So all good 😀

[CommunityCorals]

Hi,

below I made some screenshots of order view based on different settings.

– If Commission view not active shipping is not part of order total (As it goes to admin I guess)
– If Commission view is active shipping is not part of total but part of commission so the sum does not fit together
– If shipping goes to vendor there are a lot of figures but they do not make 100% sense like e.g. shipping amount.

Maybe you can review on the requirement that I posted in the screenshot as I think this would work for all settings.

Thanks & BR
Dominique

Attachments:

You must be logged in to view attached files.

[CommunityCorals]

Hi,

yes, I am using below snippet. Unfortunately we never finalized it so it does not completly cover the requirement I posted before.

add_filter( ‘wcfm_order_details_shipping_line_item’, function( $is_allow ) {
if( !defined(‘DOING_AJAX’) ) {
$is_allow = true;
}
return $is_allow;
}, 50 );

add_action ( ‘wcfm_order_totals_after_total’, function( $order_id ) {
global $WCFM, $wpdb, $WCFMmp;
remove_action ( ‘wcfm_order_totals_after_total’, array( $WCFM->wcfm_marketplace, ‘wcfmmp_order_total_commission’ ) );

$admin_fee_mode = apply_filters( ‘wcfm_is_admin_fee_mode’, false );
$vendor_id = $WCFM->wcfm_marketplace->vendor_id;
$gross_sale_order = $WCFM->wcfm_vendor_support->wcfm_get_gross_sales_by_vendor( $vendor_id, ”, ”, $order_id );
$order = wc_get_order( $order_id );
$order_currency = $order->get_currency();

$sql = ”
SELECT SUM(commission_amount) as line_total,
SUM(item_total) as item_total,
SUM(item_sub_total) as item_sub_total,
SUM(shipping) as shipping,
SUM(tax) as tax,
SUM( shipping_tax_amount) as shipping_tax_amount,
SUM( refunded_amount) as refunded_amount
FROM {$wpdb->prefix}wcfm_marketplace_orders
WHERE order_id = ” . $order_id . ”
AND vendor_id = ” . $vendor_id . ”
AND is_refunded != 1″;
$order_due = $wpdb->get_results( $sql );
if( !$order_due || !isset( $order_due[0] ) ) return;

$total = 0;
$calculated_total = 0;
$refund_total = 0;

$total = $order_due[0]->line_total;
$calculated_total = $order_due[0]->item_total;
$calculated_total += ( float ) $order_due[0]->tax;
$calculated_total += ( float ) apply_filters( ‘wcfmmmp_gross_sales_shipping_cost’, $order_due[0]->shipping, $vendor_id );
$calculated_total += ( float ) $order_due[0]->shipping_tax_amount;
$refund_total = $order_due[0]->refunded_amount;
if ( $get_shipping = $WCFMmp->wcfmmp_vendor->is_vendor_get_shipping( $vendor_id ) ) {
$total += ( float ) $order_due[0]->shipping;
}
if ( $get_tax = $WCFMmp->wcfmmp_vendor->is_vendor_get_tax( $vendor_id ) ) {
$total += (float) $order_due[0]->tax;
if( $get_shipping ) {
$total += ( float ) $order_due[0]->shipping_tax_amount;
}
}

$tax_percent = 19;
?>
<?php if( !$admin_fee_mode ) { ?>
<tr>
<td class=”label” colspan=”2″ style=”text-align:right;”><?php _e( ‘Line Total’, ‘wc-frontend-manager’ ); ?>:</td>
<td class=”total” style=”text-align:center;”>
<div class=”view”><?php if ( $WCFMmp->wcfmmp_vendor->is_vendor_deduct_discount( $vendor_id ) ) { echo wc_price( $order_due[0]->item_total, array( ‘currency’ => $order_currency ) ); } else { echo wc_price( $order_due[0]->item_sub_total, array( ‘currency’ => $order_currency ) ); } ?></div>
</td>
</tr>
<?php } ?>
<?php if ( $get_tax ) { ?>
<tr>
<td class=”label” colspan=”2″ style=”text-align:right;”><?php _e( ‘Tax’, ‘wc-frontend-manager’ ); ?>:</td>
<td class=”total” style=”text-align:center;”>
<div class=”view”><?php echo wc_price( $order_due[0]->tax, array( ‘currency’ => $order_currency ) ); ?></div>
</td>
</tr>
<?php } ?>
<?php if ( $get_shipping ) { ?>
<tr>
<td class=”label” colspan=”2″ style=”text-align:right;”><?php _e( ‘Shipping’, ‘wc-frontend-manager’ ); ?>:</td>
<td class=”total” style=”text-align:center;”>
<div class=”view”><?php echo wc_price( apply_filters( ‘wcfmmmp_gross_sales_shipping_cost’, $order_due[0]->shipping, $vendor_id ), array( ‘currency’ => $order_currency ) ); ?></div>
</td>
</tr>
<?php if( $get_tax ) { ?>
<tr>
<td class=”label” colspan=”2″ style=”text-align:right;”><?php _e( ‘Shipping Tax’, ‘wc-frontend-manager’ ); ?>:</td>
<td class=”total” style=”text-align:center;”>
<div class=”view”><?php echo wc_price( $order_due[0]->shipping_tax_amount, array( ‘currency’ => $order_currency ) ); ?></div>
</td>
</tr>
<?php } ?>
<?php } ?>
<?php if( apply_filters( ‘wcfm_is_allow_gross_total’, true ) ) { ?>
<tr class=”total_cost”>
<td class=”label” colspan=”2″ style=”text-align:right;”><?php _e( ‘Gross Total’, ‘wc-frontend-manager’ ); ?>:</td>
<td class=”total” style=”text-align:center;”>
<div class=”view”>
<?php
if( $refund_total ) {
echo “” . wc_price( $calculated_total, array( ‘currency’ => $order_currency ) ) . ““;
echo “<ins>” . wc_price( $gross_sale_order, array( ‘currency’ => $order_currency ) ) . “</ins>”;
} else {
echo wc_price( $gross_sale_order, array( ‘currency’ => $order_currency ) );
}
?>
</div>
</td>
</tr>
<?php } ?>
<?php if( $refund_total ) { ?>
<tr>
<td class=”label refunded-total” colspan=”2″ style=”text-align:right;”><?php _e( ‘Refunded’, ‘wc-frontend-manager’ ); ?>:</td>
<td class=”total refunded-total” style=”text-align:center;”>-<?php echo wc_price( $refund_total, array( ‘currency’ => $order_currency ) ); ?></td>
</tr>
<?php } ?>
<?php
if( apply_filters( ‘wcfm_is_allow_view_commission’, true ) ) {
if( $admin_fee_mode ) {
$total = $gross_sale_order – $total;
if ( !$get_shipping ) {
$total += ( float ) $order_due[0]->shipping;
}
$tax_amount = ($total/100)*19;
?>
<tr>
<td class=”label” colspan=”2″ style=”text-align:right;”><?php _e( ‘Net Fees’, ‘wc-frontend-manager’ ); ?>:</td>
<td class=”total” style=”text-align:center;”>
<div class=”view”><?php echo wc_price( ($total-$tax_amount), array( ‘currency’ => $order_currency ) ); ?></div>
</td>
</tr>
<tr>
<td class=”label” colspan=”2″ style=”text-align:right;”><?php echo __( ‘Tax’, ‘wc-frontend-manager’ ) . ‘ (‘.$tax_percent.’%)’; ?>:</td>
<td class=”total” style=”text-align:center;”>
<div class=”view”><?php echo wc_price( ($tax_amount), array( ‘currency’ => $order_currency ) ); ?></div>
</td>
</tr>
<tr>
<td class=”label” colspan=”2″ style=”text-align:right;”><?php _e( ‘Total Fees’, ‘wc-frontend-manager’ ); ?>:</td>
<td class=”total” style=”text-align:center;”>
<div class=”view”>
<?php
echo wc_price( $total, array( ‘currency’ => $order_currency ) );
?>
</div>
</td>
</tr>
<?php
} else {
$tax_amount = ($total/100)*19;
?>
<tr>
<td class=”label” colspan=”2″ style=”text-align:right;”><?php _e( ‘Net Earning’, ‘wc-frontend-manager’ ); ?>:</td>
<td class=”total” style=”text-align:center;”>
<div class=”view”><?php echo wc_price( ($total-$tax_amount), array( ‘currency’ => $order_currency ) ); ?></div>
</td>
</tr>
<tr>
<td class=”label” colspan=”2″ style=”text-align:right;”><?php echo __( ‘Tax’, ‘wc-frontend-manager’ ) . ‘ (‘.$tax_percent.’%)’; ?>:</td>
<td class=”total” style=”text-align:center;”>
<div class=”view”><?php echo wc_price( ($tax_amount), array( ‘currency’ => $order_currency ) ); ?></div>
</td>
</tr>
<tr>
<td class=”label” colspan=”2″ style=”text-align:right;”><?php _e( ‘Total Earning’, ‘wc-frontend-manager’ ); ?>:</td>
<td class=”total” style=”text-align:center;”>
<div class=”view”><?php echo wc_price( $total, array( ‘currency’ => $order_currency ) ); ?></div>
</td>
</tr>
<?php
}
}
}, 9 );

[CommunityCorals]

Just spend a fortune on it :-/

[CommunityCorals]

Hi, I added the informations that are required to make all financial flows and fees transparent in a graphic. I hope this helps to understand what kind of information would be very very valuable to all involved parties.

Looking forward to your response.

Thanks
Dominique

Attachments:

You must be logged in to view attached files.

[CommunityCorals]

– May be! As we never receive complain for any such issue regarding Refund.

Do you provide support for this? I just used your functionality so if something went wrong it must be because of a bug. Issue startet with me deniying a refund. May I provide access to my system so that you guys can Check?

[CommunityCorals]

I think that is actually the problem. In the scenario where zone wise shipping is enabled and shipping goes to admin, admin does not make any revenue and just generates commission. This is financially not correct. Vendor does not have any document for cost of shipping. Please let me know if you guys plan to provide a correct financial documentation for this setting because this is a legal issue I am facing and a justified point of complaint for several of my vendors.

[CommunityCorals]

Yes, that option is quite ugly. I just startet a custom development of a plugin that makes product filtering possible in woocommerce shop based on geo data provided in vendor store. Let me know if you guys have use of this.

[CommunityCorals]

@communitycorals, your solution was for “offline” payment. Just vendor’s payment details sharing with customer.

Unfortunately, the code doesn´t provide the functionality we agreed upon. Its very basic and has still bugs I reported. When I asked to review and improve I haven´t got any response on my mails. Would be great if you could check if there may be any communication issue which caused this confusion? Anyways here a snippet for the other users to check if this maybe provides some help. I can also share a final version once I received revised code.

Thanks
Dominique

add_action( ‘end_wcfm_vendor_settings’, function( $vendor_id ) {
global $WCFM, $WCFMmp;
$wcfm_customer_payment_options = get_user_meta( $vendor_id, ‘wcfm_customer_payment_options’, true );
?>
<!– collapsible –>
<div class=”page_collapsible” id=”wcfm_settings_form_min_order_amount_head”>
<label class=”wcfmfa fa-cart-plus”></label>
<?php _e(‘Customer Pay Option’, ‘wc-frontend-manager’); ?><span></span>
</div>
<div class=”wcfm-container”>
<div id=”wcfm_settings_form_vendor_invoice_expander” class=”wcfm-content”>
<?php
$WCFM->wcfm_fields->wcfm_generate_form_field( array(
“wcfm_customer_payment_options” => array(‘label’ => __(‘Payment Options’, ‘wc-frontend-manager’), ‘type’ => ‘textarea’, ‘class’ => ‘wcfm-textarea wcfm_ele wcfm_full_ele’, ‘label_class’ => ‘wcfm_title wcfm_ele wcfm_full_ele_title’, ‘value’ => $wcfm_customer_payment_options ),
) );
?>
</div>
</div>
<div class=”wcfm_clearfix”></div>
<!– end collapsible –>
<?php
}, 500 );

add_filter( ‘wcfm_marketplace_settings_fields_general’, function( $setting_fields, $vendor_id ) {
if( !wcfm_is_vendor() ) {
$wcfm_customer_payment_options = get_user_meta( $vendor_id, ‘wcfm_customer_payment_options’, true );
$wcfm_customer_payment_options_field = array(
“wcfm_customer_payment_options” => array(‘label’ => __(‘Customer Payment Options’, ‘wc-frontend-manager’), ‘type’ => ‘textarea’, ‘class’ => ‘wcfm-textarea wcfm_ele’, ‘label_class’ => ‘wcfm_title wcfm_ele’, ‘value’ => $wcfm_customer_payment_options ),
);
$setting_fields = array_merge( $wcfm_customer_payment_options_field, $setting_fields );
}
return $setting_fields;
}, 50, 2 );

add_action( ‘wcfm_vendor_settings_update’, function( $vendor_id, $wcfm_settings_form ) {
global $WCFM, $WCFMmp;
if( isset( $wcfm_settings_form[‘wcfm_customer_payment_options’] ) ) {
$wcfm_customer_payment_options = $wcfm_settings_form[‘wcfm_customer_payment_options’];
update_user_meta( $vendor_id, ‘wcfm_customer_payment_options’, $wcfm_customer_payment_options );
}
}, 500, 2 );

function wcfmmp_vendor_order_customer_payment_options( $order ) {
global $WCFM, $WCFMmp;

echo “<br /><br />”;
echo “<h2 style=’font-size: 18px; color: #17a2b8; line-height: 20px;margin-top: 6px;margin-bottom: 10px;padding: 0px;text-decoration: underline;’>” . __( ‘Payment Details:’, ‘wc-frontend-manager-ultimate’ ) . “</h2>”;
echo “<table width=’100%’ style=’width:100%;’><tbody>”;
$order_items = $order->get_items( apply_filters( ‘woocommerce_purchase_order_item_types’, ‘line_item’ ) );
foreach ( $order_items as $item_id => $item ) {
$product_id = $item->get_product_id();
$vendor_id = $WCFM->wcfm_vendor_support->wcfm_get_vendor_id_from_product( $product_id );
if( !$vendor_id || !wcfm_is_vendor( $vendor_id ) ) continue;
$wcfm_customer_payment_options = get_user_meta( $vendor_id, ‘wcfm_customer_payment_options’, true );
if( !$wcfm_customer_payment_options ) continue;
?>
<tr>
<td colspan=”3″ style=”background-color: #eeeeee;padding: 1em 1.41575em;line-height: 1.5;font-weight:600;”><?php echo get_the_title( $product_id ); ?></td>
<td colspan=”5″ style=”background-color: #f8f8f8;padding: 1em;”><?php echo wpautop($wcfm_customer_payment_options); ?></td>
</tr>
<?php
}
echo “</tbody></table>”;
echo “<br /><br /><br /><br />”;
}
add_action( ‘woocommerce_order_details_after_order_table’, ‘wcfmmp_vendor_order_customer_payment_options’, 50 );
add_action( ‘woocommerce_email_order_meta’, ‘wcfmmp_vendor_order_customer_payment_options’, 50 );

[CommunityCorals]

– How? “Add to Cart” not disabled for those products!

Yes, exactly. Evereything works as usual. Just tested again. Same issue.

[Author]

Posts