Releasing a new product version: changes in files

  • Posts: 105
  • Thank you received: 6
  • Hikashop Business
9 years 9 months ago #190865

-- HikaShop version -- : 2.3.5
-- Joomla version -- : 3.3.6
-- PHP version -- : 5.4.36
-- Browser(s) name and version -- : all

Let's say that I am selling a downloadable product.
I want to release the next product version, with lots of new features. Existing customers will have to pay to upgrade.

Here is my problem and my question:
If I merely replace the product file, then the owners of the previous product version will be able to download the new version for free (using the Customer Account > Show the Downloads).
What must I do, in order to make sure that those customers who haven't upgraded will still be able to download the old product version they have paid for?

Thank you
P.

Last edit: 9 years 9 months ago by panefs.

Please Log in or Create an account to join the conversation.

  • Posts: 12953
  • Thank you received: 1778
9 years 9 months ago #190868

Hello,

What must I do, in order to make sure that those customers who haven't upgraded will still be able to download the old product version they have paid for?

You can for example create a "Version" characteristic and attach different file per variant.

Please Log in or Create an account to join the conversation.

  • Posts: 105
  • Thank you received: 6
  • Hikashop Business
9 years 9 months ago #191660

Hi Mohamed; sorry for the delay in getting back.

Thanks for the tip.
Question: what happens with the customers who have already purchased a product, before I created the various variants.
Will they be able to redownload the file the purchased?

Thanks

Please Log in or Create an account to join the conversation.

  • Posts: 26158
  • Thank you received: 4028
  • MODERATOR
9 years 9 months ago #191661

Hi,

It depends if you remove the files of the main product or not.
But the easier will be to update the database in order to change the "product_id" of the past orders (in the table "hikashop_order_product") and maybe some elements in the table "hikashop_download".
So you will assign a specific variant to the past orders, thanks to that they will still be able to download the specific versionned file.

Regards,


Jerome - Obsidev.com
HikaMarket & HikaSerial developer / HikaShop core dev team.

Also helping the HikaShop support team when having some time or couldn't sleep.
By the way, do not send me private message, use the "contact us" form instead.

Please Log in or Create an account to join the conversation.

  • Posts: 105
  • Thank you received: 6
  • Hikashop Business
9 years 9 months ago #191858

Jerome,
Can you please elaborate on "maybe some elements in the table "hikashop_download".

That 'maybe' scares me out a bit. The EU is asking us to keep the transactions date stored for 10 years.
I certainly don't want to mess up with the database.

Thank you very much!
P.

Please Log in or Create an account to join the conversation.

  • Posts: 26158
  • Thank you received: 4028
  • MODERATOR
9 years 9 months ago #191862

Hi,

In the table "hikashop_download" you have a record of the downloads.
It links an order_id with a file_id and store the number of time the user has download it.
If you switch the download file to another product, depending how you modify it, the file_id can change, so you should update the database to update the downloads. But if you do not modify that table, you will "just" reset the downloads.
It is not something critical if you do not limit the number of downloads ; otherwise it will give more downloads to some of your users.

The most import part is in the "hikashop_order / hikashop_order_product" tables.

Regards,


Jerome - Obsidev.com
HikaMarket & HikaSerial developer / HikaShop core dev team.

Also helping the HikaShop support team when having some time or couldn't sleep.
By the way, do not send me private message, use the "contact us" form instead.

Please Log in or Create an account to join the conversation.

  • Posts: 105
  • Thank you received: 6
  • Hikashop Business
9 years 8 months ago #192094

Hi Jerome.
I won't touch the "hikashop_download" table since it's been only a few days that I installed Hikashop on my live site.

Unfortunately many things are still not clear in my mind, especially on the Hikashop side (and a few on phpMyAdmin).
I would kindly like to ask you to be much more specific in your reply. since I am completely newbie in using Hikashop.

Here's what I did before I got stuck (for testing purposes I followed these steps for 1 product only):

1. I selected Products > Characteristics and created a new characteristic called 'version'

2. I edited one of my products: I went to 'Characteristics"; I clicked on "Add" and then I added the 'version' characteristic;
I then clicked on 'Manage variants', and clicked on "New" to create a new variant.
I uploaded a new file, I entered a new product code, and finally entered the same name & price as in the main product. I saved the variant.

But now the product page shows this error:
version No values found

What am I doing wrong?

Next:
Let's say that I've corrected the errors above and that I successfully created a new variant for all my products.
Here comes the second part: changing the tables. Can you please be more specific regarding which exact values need be updated and how?
I noticed the column 'order_product_id' in the 'hikashop_order_product' table.
I guess I need to update all values in that column. Where do I retrieve the values from (table / column)?

You also mentioned 'hikashop_order' table in your message. What exact changes need to be made to this table?

Thank you for your patience. Once again, please keep in mind that we are not experts in Hikashop. Any errors made from our side may expose us to our customers. That's why I am asking you to be more specific.

Thank you
Panos

Last edit: 9 years 8 months ago by panefs.

Please Log in or Create an account to join the conversation.

  • Posts: 105
  • Thank you received: 6
  • Hikashop Business
9 years 8 months ago #192363

Anyone please?

Please Log in or Create an account to join the conversation.

  • Posts: 82863
  • Thank you received: 13372
  • MODERATOR
9 years 8 months ago #192524

Hi,

I've read the whole thread.
I don't see how creating variants will help you.

Here is what I would do in your case:
Simply create another product and disable the sales of the current product (for example by setting the quantity of the product to 0 so that it doesn't display on products listings with the "display out of stock products" option turned off in the HikaShop configuration.
Your customers who purchased the old product will still be able to access their downloads of the previous version of the product and the new customers will only see the new product with its new downloads.
Wouldn't that be an easy solution ? Is there a problem in doing that ?

The following user(s) said Thank You: panefs

Please Log in or Create an account to join the conversation.

  • Posts: 105
  • Thank you received: 6
  • Hikashop Business
9 years 8 months ago #192648

Nicolas, this is a great solution: simple, easy and to the point.
Thank you very much!

Please Log in or Create an account to join the conversation.

Time to create page: 0.079 seconds
Powered by Kunena Forum