Reseller-Bookings not shown in Magento

Modified on Wed, 27 Jul, 2022 at 12:35 PM

Problem Description

There was one product in the master data, which was not enabled for re-seller.

So as a first step the website "Reseller" needs to be assigned to all product types (configurable and virtual products).


Then we needed to set all booking with this product manually to NEW in the database (they had status ERROR). Afterwards we checked, if the cron job did pick up all booking in status new and transferred them correctly to Magento.

UPDATE `jfb_b2bcashdesk_order_item` SET `transfer_status`='new' WHERE `sku`='ADDON.RESERVATION.INFOSYSTEM.GEX' and `transfer_status`='error'
UPDATE `jfb_b2bcashdesk_order` o JOIN `jfb_b2bcashdesk_order_item` oi ON oi.order_id = o.id SET o.`transfer_status`='new' WHERE o.`transfer_status`='error' 

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article