• Toll-free  888-665-8637
  • International  +1 717-220-0012
Welcome Guest! To enable all features please Login or Register.

Notification

Icon
Error

SMJOHN
#1 Posted : Friday, June 27, 2014 8:56:32 AM(UTC)
SMJOHN

Rank: Member

Joined: 6/26/2014(UTC)
Posts: 9
American Samoa
Location: Ca

Hello Team,


We have bvc version 2013. When I try to add the sales price for any product. It is not being updated at the front end. But when I restart IIS, it is displaying updated prices (Correct prices).

I have one product with sku: xxx-001 and its current price is $5.50. I went to admin in marketing--> sales and changed its sales price to fixed price at $4.49 for any valid date range. Afterwards, I went to the front end and checked its price it was showing old price $5.50. This one is issued. I have refreshed page and opened same page in private browsing, but the issue is still there. It was showing old price $5.50. Then I have restarted IIS and then checked its price. Finally, it has correct price $4.49.

Now I have deleted that sales form marketing--> sales. Now product xxx-001 has to show price $5.50. But it is showing previous price $4.49. Again, I have restarted IIS and checked its price and it has with correct one $5.50

I have to restart IIS after adding, Updating, deleting sales price. May I know the reason why?

I have tried below steps to solve it.But All are not working.

1) I have checked the tables and its stored procedures at database level, but All is working fine.
2) I have made clone of the same site with bvc 5.8 and tested it. But in test site sales price are working fine. So will you please tell me what exactly I have to do?
3) I have exchanged anthem library with asp.net control, but didn't work.

Please provide me correct solution. I am waiting for your response.

Regards,
SMJOHN

Edited by user Friday, June 27, 2014 9:29:59 AM(UTC)  | Reason: Not specified

Aaron
#2 Posted : Friday, June 27, 2014 1:34:44 PM(UTC)
Aaron

Rank: Administration

Joined: 4/2/2004(UTC)
Posts: 2,393
United States
Location: Hummelstown, PA

Thanks: 6 times
Was thanked: 163 time(s) in 158 post(s)
Let me ask you a few questions to get started:

  1. Was this site a fresh install of BVC 2013 or an upgrade from a previous version?
  2. What version of Windows is your server running?
  3. Does your site have any customizations to the Core?
  4. Do you see any errors in the Audit Log?

The next step will probably be for us to get access to your site admin. To do this you should open a support ticket to keep this information private.
Aaron Sherrick
BV Commerce
Toll-free 888-665-8637 - Int'l +1 717-220-0012
SMJOHN
#3 Posted : Tuesday, July 1, 2014 4:16:15 AM(UTC)
SMJOHN

Rank: Member

Joined: 6/26/2014(UTC)
Posts: 9
American Samoa
Location: Ca

Thank you Aaron. For your response.

Please check my answers below each questions.

1) Was this site a fresh install of BVC 2013 or an upgrade from a previous version?

We have up gradated BVC 5.8 to 2013 using following steps .

Taken BVC 2013 fresh website then change connection string which points to 5.8 database afterwards we have
run site and run database update from website


2) What version of Windows is your server running?

win server 2008 with IIS7.5 and MS-SQL 2008

3) Does your site have any customizations to the Core?

Yes . we have .

4) Do you see any errors in the Audit Log?

we have lots of entry in Audit log table so we are not able to check it.

Edited by user Tuesday, July 1, 2014 4:21:12 AM(UTC)  | Reason: Not specified

Steve95
#4 Posted : Tuesday, July 1, 2014 5:44:01 AM(UTC)
Steve95

Rank: Member

Joined: 4/29/2010(UTC)
Posts: 256

Thanks: 4 times
Was thanked: 11 time(s) in 10 post(s)
4) Do you see any errors in the Audit Log?

we have lots of entry in Audit log table so we are not able to check it.

We have this issue on a lot of our stores too, we normally get around this by sql queries rather than the BV front end assuming you have SQL access?

Another thing to check IIS settings to ensure that the Output Caching has not been enabled for any of the product templates for instance.
SMJOHN
#5 Posted : Tuesday, July 1, 2014 6:12:27 AM(UTC)
SMJOHN

Rank: Member

Joined: 6/26/2014(UTC)
Posts: 9
American Samoa
Location: Ca

Thank you steve for your suggestion.

We have checked IIS setting for Output caching. We haven't done any type of output caching. but I have seen one line of code to prevent output caching
Code:
 Utilities.WebForms.MakePageNonCacheable(Me) 
in so many pages. Would this line help me ?


And I will check Audit Log entry in database and let you know.

Edited by user Tuesday, July 1, 2014 6:16:48 AM(UTC)  | Reason: Not specified

Aaron
#6 Posted : Tuesday, July 1, 2014 9:52:44 AM(UTC)
Aaron

Rank: Administration

Joined: 4/2/2004(UTC)
Posts: 2,393
United States
Location: Hummelstown, PA

Thanks: 6 times
Was thanked: 163 time(s) in 158 post(s)
It does sound like it could be caching-related. Is any of your custom code performing any caching of product data? Also, when you add the item to your cart are you still seeing the same incorrect price that you're seeing on the category and product page?
Aaron Sherrick
BV Commerce
Toll-free 888-665-8637 - Int'l +1 717-220-0012
SMJOHN
#7 Posted : Wednesday, July 2, 2014 1:20:25 AM(UTC)
SMJOHN

Rank: Member

Joined: 6/26/2014(UTC)
Posts: 9
American Samoa
Location: Ca

yes, In a cart it is displaying incorrect pricing.

Edited by user Wednesday, July 2, 2014 1:22:34 AM(UTC)  | Reason: Not specified

SMJOHN
#8 Posted : Thursday, July 3, 2014 12:24:15 AM(UTC)
SMJOHN

Rank: Member

Joined: 6/26/2014(UTC)
Posts: 9
American Samoa
Location: Ca

Hi Aaron,

Do you have any solution?
Steve95
#9 Posted : Thursday, July 3, 2014 4:46:44 AM(UTC)
Steve95

Rank: Member

Joined: 4/29/2010(UTC)
Posts: 256

Thanks: 4 times
Was thanked: 11 time(s) in 10 post(s)
John,

What is the WebAppSettings.DisableProductCaching set to? If this is enabled have you tried disabling it via Admin -> Options -> Performance -> Disable Product Caching


Are you running this in a web garden or a single worker process? I have seen this happen when a Web Garden has been configured on the application pool.

SMJOHN
#10 Posted : Thursday, July 3, 2014 7:03:04 AM(UTC)
SMJOHN

Rank: Member

Joined: 6/26/2014(UTC)
Posts: 9
American Samoa
Location: Ca

Hi Steve,

Thanks for reply,

Sorry but we have already tried this option it but it didn't work for us.We have set DisableProductCaching to 0 in the bvc_WebAppSetting table because we don't have an option in admin site.

In server I have to check for worker processes. I will inform you about worker process.

Now Issue become head ache for us. I need solution for it.

Edited by user Thursday, July 3, 2014 7:04:55 AM(UTC)  | Reason: Not specified

Aaron
#11 Posted : Thursday, July 3, 2014 7:16:16 AM(UTC)
Aaron

Rank: Administration

Joined: 4/2/2004(UTC)
Posts: 2,393
United States
Location: Hummelstown, PA

Thanks: 6 times
Was thanked: 163 time(s) in 158 post(s)
Product caching has been disabled for several versions (DisableProductCaching setting in the bvc_WebAppSetting table is not used), so unless the code has been altered, this should not be the issue.

The next step is for us to get access to your site admin. To do this you should open a support ticket to keep this information private.
Aaron Sherrick
BV Commerce
Toll-free 888-665-8637 - Int'l +1 717-220-0012
SMJOHN
#12 Posted : Thursday, July 3, 2014 8:24:48 AM(UTC)
SMJOHN

Rank: Member

Joined: 6/26/2014(UTC)
Posts: 9
American Samoa
Location: Ca

Hi Aaron,

We have opened support ticket. Please check it
Steve95
#13 Posted : Friday, July 11, 2014 5:54:04 AM(UTC)
Steve95

Rank: Member

Joined: 4/29/2010(UTC)
Posts: 256

Thanks: 4 times
Was thanked: 11 time(s) in 10 post(s)
John, Aaron

Hopefully this has now been resolved, assuming some sort of customization was not responsible for the issue would it be possible to publish the cause/fix for this?

Aaron
#14 Posted : Friday, July 11, 2014 9:39:06 AM(UTC)
Aaron

Rank: Administration

Joined: 4/2/2004(UTC)
Posts: 2,393
United States
Location: Hummelstown, PA

Thanks: 6 times
Was thanked: 163 time(s) in 158 post(s)
Originally Posted by: Steve95 Go to Quoted Post
Hopefully this has now been resolved, assuming some sort of customization was not responsible for the issue would it be possible to publish the cause/fix for this?

The investigation is still ongoing. We'll update this thread once we know the cause.
Aaron Sherrick
BV Commerce
Toll-free 888-665-8637 - Int'l +1 717-220-0012
Forum Jump  
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.

©2024 Develisys. All rights reserved.
  • Toll-free  888-665-8637
  • International  +1 717-220-0012