Import Subscriptions - trick How to

-- HikaShop version -- : 3.1.1
-- Joomla version -- : 3.7.5
-- PHP version -- : 7.1.8
-- Browser(s) name and version -- : Chrome 60

Hi guys,
HikaSubscriptions beta has been release.
Here I asked for a way to import User Subscriptions , but at the moment there isn't.

Now, asking if there is way/trick to manage a CSV import using the HikaShop feature, I think that a simple migration solution is one of the most needed feature to allow users to choose your new HikaSubscription solution. This is why, in case there are no tricks to perform it, i ask you to move this topic in the "Feature Request" Forum.

Many Thanks

Hi Nicolas,
Yes, I understand. In my specific case is too simple, just a way to Export a CSV Subscription file > fill in and complete it > Import the CSV Subscription file:

Till now, when a user bought the Subscription (one year long) customer moved the user, manually by the joomla administrator panel, to the Subscribed group. When the Subscription arrive to its end life, he moved back the user to the Registered group. So:

A - I have a joomla site that is running, this mean that all the Subscribed users are yet registered in joomla;
B - I have installed HikaShop business and HikaSerial Subscription, so, I suppose, this mean that all Joomla users are yet HikaShop users (which is related to a Joomla account);
C - I create the Subscription Plan, so we'll have the Plan ID;
D - I create the Product(s) adding the Plan;
E - In HikaSerial > Subscriptions: I don't understand what is "Subscription data" ?
F - In HikaSerial > Subscriptions: "Status" - in my case all the users in the "Subscribed gruop" should be "Status" active subscriber.

At this point would be good a CSV Subscription Export to have the exact CSV with all the columns as needed.
Have the possibility to select C / E / F before the export will save a bit of time.
Lastly will have to input (manually) in the CSV exported file the:

G - Subscription start date
H - Subscription end date

In the right format as HikaSerial Subscription need, so, please, instructions here would be too glad.
Finally we can import the completed CSV Subscription file.

Last but not least, having planned from now that all the Subscribed users will receive an email 60 and 30 days before the subscription expiration date as discounted renew advice, send an email with AcyMailing would be good because some users could be yet expiring (less than 60 and 30 days).

Hello and sorry for the late reply,

Jerome is actually on holiday and will be back next Wednesday. He is in charge of HikaSerial so he will come back to you as soon as possible.

Once again, we are sorry for any inconvenience caused.

Best regards,
Mohamed Thelji.

Hi Jerome,
Just to be clear, I know what you wrote me, infact this thread has been opened with:

Here I asked for a way to import User Subscriptions, but at the moment there isn't.
Now, asking if there is way/trick to manage a CSV import using the HikaShop feature, I think that a simple migration solution is one of the most needed feature to allow users to choose your new HikaSubscription solution. This is why, in case there are no tricks to perform it, I ask you to move this topic in the "Feature Request" Forum.

Because a subscription is related to an HikaShop user (which is related to a Joomla account), you can't import a subscription without performing the link with the corresponding user. That's why I'm not sure that the HikaSerial import system is the right solution for such kind of purpose.

I think that it will be more appropriate to perform the import/migration directly in the database or via a custom PHP script.

Jerome wrote: F - I don't know what you're talking about.
Please just take a look at a subscription in HikaSubscription and you will what are the possibilities for the subscription statuses.

Now about the general content of your message ; as I told you previously, it is not possible to perform an import using CSV.

I think that it will be more appropriate to perform the import/migration directly in the database or via a custom PHP script.

www.hikashop.com/forum/hikasubscription/...s-how-to.html#276288

But I can reformulate it :
No the HikaSubscription import or the HikaShop import won't support such kind of feature since it would be too complicated to generate an appropriate CSV content.
The only adapted solution would be to perform the import/migration directly in the database since you would need already a lot of content prepared (users, etc).

In the right format as HikaSerial Subscription need, so, please, instructions here would be too glad.

Please just take a look at a subscription in HikaSubscription and you will what are the possibilities for the subscription statuses.