bob22
Starting Member
1 Posts |
Posted - April 30 2004 : 12:26:32
|
Hi I'm using ms access. I have added 20 items to the bottom of product table (actual ms access database shopping500 table). They show up on the merchant administration product table (MAPT), but the do not show up on the shop. I have realised that eventhough category is defined on the table, and it is shown on the MAPT , it is not highlighted on the edit product page. After I highlight product category, then it will show up on the shop. Do you know why is that, and how can I avoid it. I already have 2000 items on my existing access table and it would be very time consuming to enter them one by one instead of adding the whole thing in one shot. I thank you very much |
|
ouresolutions
Starting Member
Australia
45 Posts |
Posted - May 01 2004 : 15:06:10
|
Hi Bob22, There is another table called "prodcategories" that you need to populate. This table records which products go in which category/subcategory, by listing each Product's ID (called "intcatalogid" and which needs to match the "catalogid" field in the Products table) against the relevant Category ID(s) (called "intcategoryid" and which needs to match the "categoryid" field in the Categories table).
So, if a product was to be displayed in 3 categories and 5 subcategories then there would need to be a total of 8 records in the ProdCategories table, one for each of the Categories/SubCategories where the product is to be listed.
Graeme
------------------------- Our eSolutions www.ouresolutions.com.au |
|
|