QuadComm e-commerce solutions
Home

Categories and brands/manufacturers drop-downs not updating

SYMPTOMS

When updating/adding/deleting a category or manufacturer/brand, the quick navigation drop-down menus in the shop don't automatically reflect the changes.

VERSIONS AFFECTED

Q-Shop Pro and Lite v3.5.0.

CAUSE

Drop-downs are cached in memory to reduce database access and improver performance. In Q-Shop 3.5.0 this mechanism was sightly changed and a bug was introduced in files admin/manumgrcmd.asp and admin/catmgrcmd.asp resulting in the data not being refreshed when editing categories and manufacturers.

RESOLUTION

Follow these 2 simple steps:

1. Edit admin/manumgrcmd.asp and where it says:

	'Update manufacturers list %>
	<!--#include file="../inc/updatemanulist.asp"-->

Change it to:

	'Update manufacturers list %>
	<!--#include file="../inc/updatemanulist.asp"-->
	<% BuildManuList 'Update the manufacturer drop-down cache %>

2. Edit admin/catmgrcmd.asp and where it says:

	'Update Quicksel with updated categories
	Application.Lock %>
	<!--#include file="../inc/updatelist.asp"-->
<%	Application.UnLock %>

Change it to:

	'Update Quicksel with updated categories
	Application.Lock %>
	<!--#include file="../inc/updatelist.asp"-->
<% 	BuildCategoryDD 'Now reload the drop-down cache
	Application.UnLock %>

Boost your sales with Web Marketing Today Premium Edition