In order to support @regis point, I can also confirm that the various
shoppingcart_ related tables were part of our Native Koa installation.
For the sake of completion, here are some personal notes I took when we first looked at migrating our Open edX instance from Native to Tutor for Koa. Please understand that our Open edX instance also started way back with Aspen, so there might be a lot tables creep over the various releases from Aspen to Nutmeg. So I basically compared what we had accumulated over the years and what a default Tutor installation for Koa contained.
We also discovered a few differences between the tables under Native and Tutor when we installed Koa.3.
The tables with < are in Native and the tables with > are in Tutor pour edxapp / openedx database. This is taken from a diff of “show tables” in each environment.
< | notifications_articlesubscription |
> | shoppingcart_certificateitem |
> | shoppingcart_coupon |
> | shoppingcart_couponredemption |
> | shoppingcart_courseregcodeitem |
> | shoppingcart_courseregcodeitemannotation |
> | shoppingcart_courseregistrationcode |
> | shoppingcart_courseregistrationcodeinvoiceitem |
> | shoppingcart_donation |
> | shoppingcart_donationconfiguration |
> | shoppingcart_invoice |
> | shoppingcart_invoicehistory |
> | shoppingcart_invoiceitem |
> | shoppingcart_invoicetransaction |
> | shoppingcart_order |
> | shoppingcart_orderitem |
> | shoppingcart_paidcourseregistration |
> | shoppingcart_paidcourseregistrationannotation |
> | shoppingcart_registrationcoderedemption |
> | thumbnail_kvstore |
< | wiki_articlesubscription |
For notifications_articlesubscription and wiki_articlesubscription, I do not understand. They are empty in our Native environment. Should we remove them before the dump or should we edit them in the dump file before restoring the data? It doesn’t cause a problem to leave them in the database as they are unused.
We have not used the old shopping_cart in years. The tables are still in our Native environment though. I don’t understand why the diff considered them missing? shoppingcart_certificateitem is definitely not empty in our Native environment. shoppingcart_order, shoppingcart_orderitem, shoppingcart_paidcourseregistration aren’t either. Old sales from old courses from before Oscar and Otto, and dating back from 2015-08-28 to 2016-06-27 according to the created field in shoppingcart_orderitem.
The “shoppingcart” functionality is deprecated as of the Dogwood release, and it will be removed in a future release. Similar services are now provided by the E-commerce Service.
I assume we switched to ecommerce around 2016-06-28 and before we installed Dogwood. I can’t find the exact date but it seems we migrated from Cypress to Dogwood around that time. Dogwood was released in early 2016 and that would fit with these dates. The first entries in the table order_order in the ecommerce database are from 2016-10-14. That fits.
The old thumbnail_kvstore table has caused us a lot of issues in the past. It does not seem to be in Maple anymore.
The migrations from Koa to Lilac to Maple may have removed some of the differences between Native and Koa since the thumbnail_kvstore table and the shoppingcart tables are no longer in Maple under Tutor.
Supporting the sales from between 2015-08-28 and 2016-06-27 could be difficult.
All that to say that the the various
shoppingcart_ related tables were really part of our Native Koa Open edX instance and were removed at some point during migrations from Koa to Lilac or from Lilac to Maple.
I am sorry @Engr_James_Lusuegro if I cannot be of more help at this point.