The following article explains what to do if you are unable to start or open One Stop Order Processing (OSOP) and it says the database needs to be repaired
If you are trying to start One Stop Order Processing and it was working correctly previously you can use the following approach to repair the last site used.
1 Run a command shell. Hold the Windows key and type R.
2 Type in
and press enter.
3 Type in
and press enter
NOTE: This is where the main One Stop Order Processing program runs from.
and press enter.
5 This should start One Stop Order Processing and repair the last site used.
If you are still having problems you can use the following approach.
a Run the ODBC Administration tool. The easiest way to do this right click on the Windows icon and select Search
b type in
c From the shown list select
ODBC Data Sources (32 bit)
d from the User DSN tab scroll down and select a Name that contains yout site name (e.g. MERPCNAME_website130 is for website1)
e Click on the Configure button
f Click on the Repair button
g Then close the dialogs shown and restart One Stop Order Processing
If you are still having problems with repairing not working do the following:
(i). Run CMD (hold Windows Key and click on R).
(iii). Click Enter key
Using One Stop Order Processing with eBay, Amazon, Magento, Shopify, Etsy, Onbuy, Flubit, X-Cart, eBid, SellerDeck, Oxatis, CubeCart, osCommerce, Interspire,CRE Loaded, ekmPowershop, Pinnacle Cart, Rakuten, RomanCart, Paypal, Asos, WooCommerce , PrestaShop, Groupon, Weebly, Mail Order, Telephone Sales, CDiscount,OpenCart, Channel Advisor, Royal Mail, MyHermes, UKMail, DPD, Yodel, UPS, Metapack, Parcel 2 go, Quickbooks, Sage, Xero, Parcelforce and Stripe