HikaShop - Moodle CourseId and Hika product Code ....

Hi Antonio,

We are using Joomdle together with HikaShop. Everything is working fluently however we've recently experienced a problem.
It seems that Joomdle create hikashop product using the Moodle's CourseId as the hikashop product code.
We have over 100 courses in both. We've created a course in Moodle. It has been sync via Joomdle and shows up in the "shop" part of the joomdle interface. But it never shows up in the hikaShop as a product.
However the product code (ie courseId inside moodle) is #23. A low one comparing to some recently created courses. It seems that Moodle attributes an available id (first gap) rather incrementing it. We' probably delete this course in Moodle.
The result is that Joomdle get a course from Moodle with a courseID that it uses to build an hikaShop product with a product code already existing. Somewhere, it does not go.... Hence we were not able to find our newly created course in Hikashop.product list.
After deleting the product in HikaShop (old one), a new product has been created with the same product code.
Is this expected behavior ?
Wouldn't be better to create the hikashop product with a product code "23 rev2" or else rather than not creating at all ? Is there some setup in Moodle that we missed ?

Thanks for your inputs.

> It seems that Joomdle create hikashop product using the Moodle's CourseId as the hikashop product code.

That's correct: that's how Joomdle links Moodle courses and Hikashop products.

> However the product code (ie courseId inside moodle) is #23. A low one comparing to some recently created courses. It seems that Moodle attributes an available id (first gap) rather incrementing it.

I don't think so. I've never seen that behaviour, it always increments from larger one, as far as I know.

> We've created a course in Moodle. It has been sync via Joomdle and shows up in the "shop" part of the joomdle interface. But it never shows up in the hikaShop as a product.

I guess you created course in Moodle and then went to to Joomdle->Shop. Normally, you would need to click on the publish icon so that the product is created in Hikashop. But if there was already a product with that code, icon would show item as already created and published in shop. But in reality, it is just showing an "incorrect link", ie: as there is a product in shop with that code, the system thinks it is linked to that course.

> After deleting the product in HikaShop (old one), a new product has been created with the same product code.
Is this expected behavior ?

After deleting old product, you can see the publish icon available to create it in joomdle shop section, and when you do, it jutst creates the product normally.

I've never seen this happening, aside from cases where users had normal products already created, and some having product codes that conflicted with Moodle course ids.
In your case it has happened because somehow your Moodle created a new course with an already used ID, and the old deleted course had a linked product in Hikashop that had not been deleted. Again, I don't know how Moodle gave you that ID, but I would test creating some new courses to see what's going on.

Thanks for the answer.
We had a new similar situation recently. Some time the course creation in Moodle goes well in Hikashop through Joomdle. Sometimes it doesn't due to these strange ids.
I'll manage to carefully watch the moodle process next time we'll have to create a course to see why it does not use the usual "auto-increment" index feature of Mysql.
I'll keep you inform