ProductCart E-Commerce Solutions Homepage
Forum Home Forum Home > ProductCart > Customizing ProductCart
  New Posts New Posts RSS Feed - Running two stores from one db?
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Running two stores from one db?
 Post Reply Post Reply
Author
Message
  Topic Search Topic Search  Topic Options Topic Options
Kimbala View Drop Down
Newbie
Newbie


Joined: 08-March-2006
Location: United States
Status: Offline
Points: 0 		Post Options Post Options   Thanks (0) Thanks(0)   Quote Kimbala Quote  Post ReplyReply Direct Link To This Post Topic: Running two stores from one db?
    Posted: 15-June-2006 at 11:39am

Hi - I am setting up two stores that will run from the same Access db. MOST of the products overlap, but there are a few that can appear only in one store or the other.  I am approaching it by adding a field to the product table that identifies whether the product should appear in just Store A,  just Store B, or both.

Each store will also have a different set of categories. The categories are set into two family "branches" - has anyone edited the incCatMenuA to start the display from a LOWER category level? Any advice appreciated, especially as it relates to foreseeable problems, as I am fairly new at this. 

Thanks in advance.
Back to Top
netprofits View Drop Down
Certified ProductCart Developers
Certified ProductCart Developers


Joined: 05-January-2006
Location: United States
Status: Offline
Points: 22 		Post Options Post Options   Thanks (0) Thanks(0)   Quote netprofits Quote  Post ReplyReply Direct Link To This Post Posted: 16-June-2006 at 7:06am

First, you will most likely need to purchase two Product Cart licenses to run two stores, even if they share a database.

There are quite a few ASP pages that you need to add checks for product displays to skip products not available for a specific store...
1. Regular and advanced searches. The advanced search page can show categories as well.
2. The Browse Catalog page starts at the top level category
3. Specials, Featured Products, New Arrivals, Best Sellers

For the inc_CatMenuA, around line 108 you should see code like the following:


'----- Start Categories Level 1
query="select idcategory,categorydesc from categories where idParentCategory=1 and idCategory>1 and iBTOhide=0 " & pcv_strTemp & " ORDER BY priority, categoryDesc ASC"

Change the "1" in "idParentCategory=1" to the idCategory for the top level category in the specific store. That should start your list with the categories directly below the cateegory you specify.
NetProfits Internet Consulting

Certified ProductCart Developer

Our Site
Back to Top
 Post Reply Post Reply
  Share Topic   

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.04
Copyright ©2001-2021 Web Wiz Ltd.

This page was generated in 0.063 seconds.