[Michael McHugh]

Because “WCMp Stripe Marketplace” is creating Suborders for each order in order to split the payments, they are showing up as duplicates in integrations we use to send orders to ShipStation and QuickBooks Online.

We need a way to stop these duplicate suborders from being exported via those integrations.

Both integrations let us filter exported/imported orders by Status, so is there perhaps a way to set all the Suborders to some custom status other than the typical Processing, On-hold, Completed, Cancelled and Shipped? (see attached screenshots for the integrations)

Or some other way to hide them from the ShipStation and QuickBooks Online integrations?

Please advise.

Thanks,
Michael

[Raju The Cool Guy]

Hi,
This third-party plugin gives support with woocommerce rest API. We have provided support with woocommerce v2 rest API (/wp-json/wc/v2/orders). You you use this rest API then the suborder will not be visible.
Thanks

[Michael McHugh]

Hi Raju,

Which plugin are you referring to? The ShipStaion plugin does not use the Rest API it’s got its own integration section.

The QuickBooks integration does, and it IS getting all the suborders, so not clear what your response was addressing.

We need for both not to get the suborders somehow.

-Michael

[Raju The Cool Guy]

Hi,
Then this QuickBooks plugin uses rest API. Use /wp-json/wc/v2/orders this woocommerce API for fetching orders. Here suborder was deleted.

[Michael McHugh]

I really do not understand your responses.

There are two integrations. One is the ShipStation plugin, and the other is an offsite QuickBooks service (Atandra T-Hub) which uses the rest API.

Both currently are getting all the suborders which appear in each platform (ShipStation and QuickBooks) as duplicates.

We need away to prevent BOTH those platforms from retrieving the suborders.

[Michael McHugh]

To be a little more specific, the ShipStation integration is their standard plugin:

WooCommerce – ShipStation Integration
https://woocommerce.com/products/shipstation-integration/

The QuickBooks Online Integration is provided by Atandra T-HUB Online which connects to WooCommerce via the Rest API

Atandra T-HUB Online
https://atandra.com/t-hub-online/

Both of these integration are getting the main orders and the suborders, which is very confusing, and creates a ton of clean-up work needing to be done.

We need a way to prevent both of these integrations from getting the suborders at all.

Please advise.

Thanks,
Michael

[Raju The Cool Guy]

@Michael McHugh, we have added support of this API version /wp-json/wc/v2/orders

Both QuickBooks and SHipStation use WooCommerce REST API. So, can you please ask them which API version is used by them? So we can assist you accordingly.

[Michael McHugh]

From WooCommerce regarding the ShipStation integration:

> Thank you for your patience.
>
> Our developers confirmed the ShipStation Integration sends data through XML to ShipStation.
>
> > WCMp has added support of this API version /wp-json/wc/v2/orders
>
> They confirmed the correct approach for this would be to use V2 which is what WCMp appears to be using.
>
> Let us know if you have any additional questions.
>
> Best regards,
>
> Sunday U.
> Happiness Engineer @ WooCommerce.com | WordPress.com | Automattic

So it appear both ShipStation and QuickBooks Online integrations are using v2, but both are still getting all the Suborders, which appear as duplicates, which we really need to prevent.

Suborders should not be sent to either.

Please advise on how to stop the suborders from being sent along with the real orders to these, as you statement that they do not if they are using Rest API v2 is not correct:

> Then this QuickBooks plugin uses rest API. Use /wp-json/wc/v2/orders this woocommerce API for fetching orders. Here suborder was deleted.

Please advise on a solution.

Thanks,
Michael

[Raju The Cool Guy]

Hi,
We have recreated this issue on our end for v2. We have added the fix to our GitHub. Please use our GitHub version from here https://github.com/wcmarketplace/dc-woocommerce-multi-vendor. And let us know if the issue is fixed or not.
Thanks

[Michael McHugh]

Okay. I’ll install it and see how it goes.

Thanks!

-Michael

[MVX Support Ninja]

Sure

[Michael McHugh]

I installed the new version—which did not have a different version (both v, btw, and we’re still getting duplicate orders going into ShipStation. See attached screenshots.

The SubOrders are still being pushed out over the API v2 to SHipStation and QuickBooks, so the problem was not fixed in the GitHub version provided.

Also, the new version caused double order processing on an order causing it to be submitted and charged twice! Something is wrong, so I need to revert to the previous version ASAP.

Please advise.

[Michael McHugh]

There were actually a few charge attempts before then incorrectly creating a 2nd order and 2nd charge for the same amount. We had to cancel and refund that order.

[Michael McHugh]

In refunding the order, by the way, the customer was erroneously notified that both #19978 and #19979 were refunded, which just caused customer confusion, because they are not supposed to even be aware of the suborder. That should be fixed as well.

Should we not mark orders as “Refunded” in WooCommerce at all? The refund process is very muddled with WCMp Stripe Marketplace, and should be cleaned up, so that it can all be done via WooCommerce, and the customer does not receive any notifications regarding suborder numbers.

At the very least customers should not be receiving any emails with sub-order info, as it just confuses them.

-Michael

[MVX Support Ninja]

Hi,
As per our flow whenever we refund a sub-order of any customer, the parent order also gets refunded.
For this reason customer recieves mail of both the sub-order and parent order.
Now if you want to send the customer only one mail you have to do custom code.
Kindly confirm which order mail you want to disable so that we can assist you accordingly.

[Raju The Cool Guy]

Hi,
We don’t face any duplicate order issues. We have verified the rest from the postman. You can see it here https://www.loom.com/share/ac69da6895ab453e84aa35a9cd171671.
Thanks

[Michael McHugh]

Tithi,

>>Kindly confirm which order mail you want to disable so that we can assist you accordingly.

Ideally the customer should never see any emails referencing the sub-order, as that’s not the order# they receive initially from WooCommerce. They should just get the standard WooCommerce Order Cancelled and/or Order Refunded emails referencing the parent order#.

Guy,

>>We don’t face any duplicate order issues. We have verified the rest from the postman. You can see it here

The actual duplicate order in this case might have just been the customer’s browser resubmitting, or customer error.

However the fact remains, that the issue of Sub-Orders going out over the API to ShipStation and WooCommerce remains. These appear as duplicate orders, as the only thing different in the info sent is the order #.

You can see this in the data ShipStation received with the screenshots I attached showing order #s 19965 and 19966, which are the same order—parent and suborder— and appear as two separate orders in ShipStation.

Again, we need Sub-Orders not to go out over the API at all. How can that be fixed?

-Michael

[Michael McHugh]

Sorry, meant “Sub-Orders going out over the API to ShipStation and QuickBooks Online remains.”

-Michael

[Raju The Cool Guy]

Michael, the scrrenshot you have shared is of WooCommerce Order.
So, can you please share the corresponding screenshot on ShipStation and QuickBook’s end, so we can assist you accordingly?

Now to stop the refund mail, please add this code in the function.php of the theme :

/**
** suborder email restriction
**/
add_filter( 'woocommerce_email_recipient_customer_refunded_order', 'customer_email_recipient_change',10,2);
function customer_email_recipient_change( $recipient_name , $object_name ){
   $parent_order_id = wp_get_post_parent_id( $object_name->get_id() );
   if( $parent_order_id == 0 ) {
       return $recipient_name;
   } else {
       return;
   }
}

Copy

[Michael McHugh]

The ShipStation screenshots were posted in a previous post above, but here they are again. I will get some from the QuickBook integration from our accounting dept. and post them later.

[Michael McHugh]

Here’s a screenshot from the QuickBook Online Integration — Atandra T-Hub — showing the parent and sub-orders being imported.

Atandra T-Hub (https://atandra.com/ecommerce-integration-quickbooks-online/)

-Michael

[Raju The Cool Guy]

Hi, It is difficult for us to give you a solution by checking the images because third-party plugins make all these things. They have used rest API.So please ask them to check woocommerce version 2 API (siteurl/wp-json/wc/v2/orders) in postman. We have checked this and do not found any suborders. Video URL is here https://multivendorx.com/support-forum/topic/suborders-show-as-duplicates-in-shipstation-and-quickbooks-online-integrations/#post-136353. Please ask them to check.
Thanks

[Michael McHugh]

I am not clear what this means:

>> check woocommerce version 2 API (siteurl/wp-json/wc/v2/orders) in postman

They’ve both confirmed that they are using the Rest v2 API.

Also, the video link you provided just links to this support thread page.

-Michael

[Raju The Cool Guy]

Hi,
Everyone checks the rest of the API through the postman app. So if you check (siteurl/wp-json/wc/v2/orders) this through postman, you will find your site parent orders. if you find any sub orders then please let us know.
Here is the testing video — https://www.loom.com/share/ac69da6895ab453e84aa35a9cd171671
Thanks

[Michael McHugh]

I’d submitted this last week, but it looks like it never posted here…

It seems when I test the URL via postman (https://airphotos.org/wp-json/wc/v2/orders) it just errors. Should it work for me? Or are you saying the developer has to test something else specific to their integration?

[Raju The Cool Guy]

Hi,
This is woocommerce API. Nothing related to us. for testing woocommerce API you have to create a key from woocommerce settings. You will find a doc from the woocommerce site.
Thanks

[Author]

Posts