Hi Sarah,

I understand that you'd like to display B2BKing offers using the Barn2 Product Table display.

I'm afraid I don't really see a simple / straightforward way to achieve that - the main issue is that these offers are not actual WooCommerce Products, instead they are just information saved in a database. Therefore to make this work I think we need a PHP code snippet to pull the data from the database, and then somehow display it using the Barn2 table.

We are happy to send some PHP code for pulling our plugin's offers information if it would help, but generally I believe you would need to work with a developer on a custom project in order to be able to display that info using the Barn2 table. I think their table might need some changes as well because I'm guessing their table is built to display products, but in this case the offers are not actual products.

Kind regards,

Stefan

Regarding the "Offers use actual products" setting: What this does is that it also adds the real products to the cart, as in this image:

There is the offer being purchased (at the top, 'sweater package'), and then the products inside the offer below. This helps to make sure that for example if the site has an ERP integration, this links correctly with that, as the real products are also in the actual order (although we give them the price of 0, so only the offer is being paid for).

The issue is with the main "offer" package product, as that is a 'helper / dynamic' product, that changes its price and name for each offer (rather than being an actual product that is distinct).

To make an integration with the Barn2 tables plugin, maybe we could do it based on the URL that B2BKing uses when clicking 'add to cart' on an offer - to take that same URL and add it to the Barn2 table.

I think we could start with the following code:

add_action('wp_footer', function(){
    $user_id = get_current_user_id();
    $user = get_user_by('id', $user_id) -> user_login;
    $email = get_user_by('id', $user_id) -> user_email;
    $currentusergroupidnr = b2bking()->get_user_group($user_id);
    // Define custom query parameters
    $custom_query_args = array( 'post_type' => 'b2bking_offer',
              'post_status' => 'publish',
              'posts_per_page' => -1,
              'meta_query'=> 
                    array(
                        'relation' => 'AND',
                        array(
                            'key' => 'b2bking_post_status_enabled',
                            'value' => '1',
                        ),
                        array(
                            'relation' => 'OR',
                            array(
                                'key' => 'b2bking_group_'.$currentusergroupidnr,
                                'value' => '1',
                            ),
                            array(
                                'key' => 'b2bking_user_'.$user, 
                                'value' => '1',
                            ),
                            array(
                                'key' => 'b2bking_user_'.$email, 
                                'value' => '1',
                            ),
                        ),
                    )
               );
    $custom_query = new WP_Query( $custom_query_args );
    $offers = $custom_query->posts;
    foreach ($offers as $offer){
        $offer_title = $offer->post_title;
        $offer_id = $offer->ID;
        echo $offer_title;
        ?>
        <button class="b2bking_offer_add" value="<?php echo esc_attr($offer_id); ?>" type="button">
        <?php echo apply_filters('b2bking_offer_add_to_cart_button', esc_html__('Add to Cart','b2bking')); ?></button><br>
        <?php
    }
});

This code gets all offers of the current user, displays them, and displays an "add to cart" button. 

It results in this kind of output:

Now I am not sure if the Barn2 table has any way to display their table programmatically / with PHP, in a way that would allow us to integrate the above. If you have access to their support, it would be great if you could ask them about that. 

Hi Sarah,

Glad to assist,

I'd like to make sure I'm understanding it correctly: Are you looking to set this in B2BKing offers, or the B2BKing order form, or just generally for the site?

WooCommerce by default does not support quantities such as 0.1 so you would need a larger code snippet to enable that on your site in general. Do you already have something like a plugin or custom code for that, or is this what you're looking to implement right now?

I think we have some snippets we can share to help implement it in general on the site, but it would be great if you can let us know where you're at with it so far.

Kind regards,

Stefan

Please try adding this PHP snippet to your site: 

https://pastecode.io/s/ug1w2xdu

It does several things to set the minimum / step to 0.1 (instead of 1 which is the default). It can also be changed to a lower value like 0.01 in the snippet if needed.

Do you still see any issues with that? If so, it would help if you can share details / screenshots. We can also work on this directly if you can help share a site or staging site login.

Regarding rounding in the mini-cart/checkout, this is a bit hard to say. I am not quite sure if it's a theme behaviour, or related to the specific checkout used (e.g. blocks vs classic, or perhaps a theme checkout like the Divi ones).

Would it be possible to share a backend access to the site, or a staging clone site with us? It would be great if we could look at it on the site directly and try to tweak the snippet to get this to work perfectly.

Kind regards,

Stefan

Thank you for the access details,

At the moment there is an error in cart regardless of quantity:

The error is coming from line 24 here:

specifically related to this $product object not working (it has a 'false' value) here:

I see you have some custom code there using ACF. I am not sure what the goal there is.

For testing purposes, I did the following:

-> I activated the main theme instead of the child theme, to get around that error.

-> I added this snippet here (now deactivated): https://rjchefs2024.sagraphicswebproofs.co.uk/wp-admin/admin.php?page=wpcode-snippet-manager&snippet_id=5535

When testing that way, I can set decimal quantities, and I see they do not get rounded in cart or checkout:

https://www.loom.com/share/474bd0b5305c4457954121de4fa6ff33?sid=30055bc7-5ed5-4fd1-aa84-84e6851f5e6f

Hi again,

Is this on a general shop page or product page? B2BKing does not control the add to cart process on these pages.

I would suggest to check your browser console for any errors during the add to cart.

It may also help to enable or disable AJAX add to cart: https://prnt.sc/Iy8KHRVtOhM6