Problem with different prices (end date/start date)

-- url of the page with the problem -- : www.paardenmestonderzoek.com/mestonderzo...sturen-mestonderzoek
-- HikaShop version -- : 4.0.1
-- Joomla version -- : 3.9.1.
-- Browser(s) name and version -- : Chrome 71.0.3578.98

Hi,

I am having a problem with the different prices for products. Some explanation;

I have a product that has different prices; buy 1, price is X, buy 2, price is Y, buy 3, prices i Z. So far, no problem. This works fine in all versions of Hikashop. However, I want to change the prices per february 1st. So I purchased the Hikashop Business Version, so that I could implement prices that would end on January 31st at 23:59 and the new prices would start on February 1st at 00:01. Somehow I can not get this working.

I put in an end date in al the prices that were already there and I added new prices, starting on the new date. This is when things got messed up. It doesn't remember the end dates or startdates, it changes the times and dates arbitrarily and prices even dissapeared.

What am I doing wrong?

Hi Nicholas,

thanks for your response. Believe me, I've done it exactly as you describe. And on some occasion it would save the price correctly, but the next time I "open" the product, things are messed up again. And believe me, prices do dissappear.

Hi Nicholas,

thanks again. I've looked at your suggestions. I do not use mass actions or uploades, but checked them and do not see anything. (There is no mass action and no upload). Any idea what kind of extension might cause problems?

I've also asked someone with more technical skills than myself to look at it. Oh and I would be happy to give you a login if you're interested to have a look (you can send a bill)

I checked the database, this is what I get. Only one item says "Missing" but it appears to have been fixed? I will wait a bit if my developer can find what is wrong, otherwise I will let you know so you can have a look (I can reproduce the issue)

OK Table "hikashop_address" checked

OK Table "hikashop_badge" checked

OK Table "hikashop_banner" checked

OK Table "hikashop_cart" checked

OK Table "hikashop_cart_product" checked

OK Table "hikashop_category" checked

OK Table "hikashop_characteristic" checked

OK Table "hikashop_click" checked

OK Table "hikashop_config" checked

OK Table "hikashop_currency" checked

OK Table "hikashop_discount" checked

OK Table "hikashop_download" checked

OK Table "hikashop_entry" checked

OK Table "hikashop_field" checked

OK Table "hikashop_file" checked

OK Table "hikashop_filter" checked

OK Table "hikashop_geolocation" checked

OK Table "hikashop_history" checked

OK Table "hikashop_limit" checked

OK Table "hikashop_massaction" checked

OK Table "hikashop_order" checked

OK Table "hikashop_orderstatus" checked

OK Table "hikashop_order_product" checked

OK Table "hikashop_payment" checked

OK Table "hikashop_price" checked

OK Table "hikashop_product" checked

OK Table "hikashop_product_category" checked

OK Table "hikashop_product_related" checked

OK Table "hikashop_plugin" checked

OK Table "hikashop_shipping" checked

OK Table "hikashop_shipping_price" checked

OK Table "hikashop_tax" checked

OK Table "hikashop_taxation" checked

OK Table "hikashop_user" checked

OK Table "hikashop_variant" checked

OK Table "hikashop_vote" checked

OK Table "hikashop_vote_user" checked

OK Table "hikashop_waitlist" checked

OK Table "hikashop_widget" checked

OK Table "hikashop_zone" checked

OK Table "hikashop_zone_link" checked

OK Table "hikashop_warehouse" checked

OK Table "hikashop_email_log" checked

Info Missing core categories fixed

OK Product categories checked

OK Variants orphan links cleaned

OK Joomla users synchronized

OK User email addresses synchronized

Could it be related to the problem I reported earlier today?
https://www.hikashop.com/forum/product-category-display/896643-price-date-restrictions-applied-when-editing-product.html

With a new install of joomla, HikaShop & HikaMarket I set a price start date in the past and an end date in 2 minutes time then set a new price starting a second after and leave the end date blank and save. If I make a dummy edit in the product and save, when I view the product in the 2nd price period the price shown is 'Free' because the blank end date has been replaced by 1970-01-01

Apologies if it isn't related

regards
Trevor

The changing of the date after saving is what happens with me as well, in some cases deleting the price. It doesn't change to 1970 though. It's just one ore two days before or after the dat I try to set.

1. Login to the backend (you have the details)
2. Select the product: this product
3. Go to pricing section and select the product with minimum quantity 10 (current price is 10,75 incl VAT)by clicking the pencil/edit icon
4. Set the enddate tot 2019-01-31 23:59. You can use either the datepicker, or type it in manually, this makes no difference
5. Click “Ok” (you will see the dates are correct)
6. Click “Save” at the top to save the product with the prices
7. Click the “+” sign to add a price
8. Enter the price including VAT of 10,95 and set the start date at 2019-02-01 00:01. You can use either the datepicker, or type it in manually, this makes no difference
9. Click “Ok” (you will see the dates are correct)
10. Click “Save” at the top to save the product with the prices
11. In my example, after Saving the product with the prices (as set in the above stept) resulted in the following changes;
a. The end date of the old price (10,75) changed to 2019-01-31 21:59
b. The start date of the new price (10,95) changed to 2019-01-31 23:01

Hi!

The timezonesetting for my own admin account was correct (amsterdam), but for your account I did not set a specific timezone (use standard/default). I changed the timezone setting of my own account to use default and had the same results. So I tried to do it with the account I provided you with and I have the same problem.

I noticed that I missed One step in my list of instructions; After saving the product, close the product, then open it and then the times are changed.
You might have to "save & close" the product twice, but trust me, the date/times change again.

Hi there! Thanks for testing again. I am glad you were able to reproduce what happened as well.

I will try to go further into the time zone issue.

Hi there.

I tested on a different server of which I knew for sure had a correct timezone setting. I had no problems there. So I contacted my host and they said that the timezone was correct, but that they reconfirmed the setting to make sure. After that I had no problems anymore.

So it's fixed!

Thanks for helping and testing.