Results 1 to 2 of 2
  1. #1
    Member
    Join Date
    September 5th, 2005
    Location
    Mansfield, TX
    Posts
    161
    Category Question
    A newbie question. How do you handle a data feed that varying category depths? In otherwords one product could be two levels into a category and the next 4 categories. How would you store that in your database? Any help would be appreciated. Thanks.

  2. #2
    ABW Ambassador FFoc's Avatar
    Join Date
    January 18th, 2005
    Posts
    1,015
    You have two easy-ish choices:

    - Parse the categories on the fly. (more expensive, processing-wise)

    - Make a separate table for linking category 'parents' and 'children' together, then store the last 'child' category in your main table. Use the categories table to build your map, and pull out any products that level category matches. (requires an import script)
    “An adventure is an inconvenience rightly considered. An inconvenience is an adventure wrongly considered.” - G.K. Chesterton

  3. Newsletter Signup

+ Reply to Thread

Similar Threads

  1. Replies: 0
    Last Post: February 25th, 2009, 02:51 PM
  2. Category
    By carpunky in forum WebMerge (Fourthworld.com)
    Replies: 20
    Last Post: February 29th, 2004, 05:10 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •