Joomdle Duplication the Hikashop Courses

HI Antonio
After the Joomdle update, it seemed that the Moodle Courses was no long linked via the Joomdle/HikaShop intergration through Joomdle.
My Active Courses was still listed with the Hika Product Codes which I can see with all the Closed courses on Moodle as well. 

When I activate the current active courses in Joomdle Shop, it recrates the courses again within Hika shop and duplicating the courses. When I unpublish the duplicated courses, it deactivates it in Joomdle Shop Tab. 
I am a bit stuck at what should be the correct process if the courses was added before the last update. Joomla 5.4.5 and Hikashop Essential 6.4.1 and Moodle 4.5.8.

It drives me crazy.

 

Hi.

The new plugin brings a change in how the courses and products are mapped.
Before, we were using the SKU field in the product.
To be more flexible, we changed this to use our own table.
In theory, the upgrade process should have created all the entries in this new table, thus keeping the relationship.
It seems this didn't happen in your case for some reason, because you see all courses unpublished in Joomdle->Shop right?

First thing: did you upgrade the Hikashop plugins to use the new versions? I guess you did if you are not getting any errors....

Second: check table #__joomdle_products to see if you have entries there. I guess you will at least have some for the courses you created again in the shop.

"It seems this didn't happen in your case for some reason, because you see all courses unpublished in Joomdle->Shop right?"

(Yes) they are all unpublish in the Joomdle shop except the latest new workshop. That one did not duplicate in Hikashop.

"First thing: did you upgrade the Hikashop plugins to use the new versions?" (yes) "I guess you did if you are not getting any errors...." (No errors)

plg_joomdleshop_hikashop_v2.0.0
plg_joomdleprofile_hikashop_v2.0.1
plg_system_joomdlehikashop_v2.0.0
plg_system_joomdlehikashopgroups_v2.0.0

"Second: check table #__joomdle_products to see if you have entries there."  Yes I have the 13 original products in there because I have unpublished the duplicates that was created when I activated the course in Joomdle Shop.

When I activate the courses in Joomdle Shop it creates new set of products but without the Hika Product Codes.
For example, the existing course:
Hika Product Name = Test; 
Hika Product Code = 127

When I activate these courses in the Joomdle shop I get a duplicate in Hika Shop Product:
Hika Product Name = Test; (Same Course name)
Hika Product Code = Test (Different Product Code)

If I change the Product Code to 127 it conflicts with the current one and unpublish both. 

The other issue is that Joomdle shop activates the same course and immediately displays the course as free in Hikashop Product Front Page display. 

Must I empty the existing courses in the Hika Shop Products and then reactivate them via Joomdle shop and then make the changes and add the the Hikashop Picture?
 

> (Yes) they are all unpublish in the Joomdle shop except the latest new workshop. That one did not duplicate in Hikashop.

Ok, but if you only have a record for each one, and you published all the courses manually again, those records were created by your manual action.
For some reason, the install script did not create the records in this table, so you were left with no records and the shop showing all courses as non published.
When you published the courses again, it did not find any matching records, so it assumed they were new products.

So, what to do now: as you don't have many courses, it may be faster to just update the database manually to link the old Hikashop products to the courses, so you can then delete the new ones created.

To do this you would need to set the product_id field in the table the the Hikashop product ID corresponding to that Moodle course ID (in course_id field, this is the ID that shows in the URL when you open a course in Moodle).

Let me know if you have any doubts about this process.

Thanks Antonio. It worked.

Is it possible in future releases to make the Moodle Course ID to sort the courses according to the that ID to make it easier to check. Currently we can only sort by Course.

Great, I am glad to know that you managed to fix it.

> Is it possible in future releases to make the Moodle Course ID to sort the courses according to the that ID to make it easier to check. Currently we can only sort by Course.

I will put it in my list, thanks for the suggestion.

Thanks