Results 1 to 7 of 7
  1. #1
    ABW Veteran Student Heyder's Avatar
    Join Date
    January 18th, 2005
    Posts
    5,482
    I've set up mysql with an id row that auto increments. I use this as my primary index because it's the fastest way to positively identify the product while doing queries on the database.

    My problem is that when I go to replace the data, the search engines still remember the old numbers and their associated product. example: id # 34959405 = a luxury pair of earrings but when I replace the data with new that number = a pair of socks or whatever and google remembers it as earrings.

    I could dump using the id field but I really prefer it because it makes for better searches and short query strings.

    Any ideas would be very much appreciated.

  2. #2
    ABW Ambassador Greg Rice's Avatar
    Join Date
    January 18th, 2005
    Location
    Ohio
    Posts
    4,889
    Not sure if this solves your problem but I use the SKU or Product ID as my primary index so my product page name stays the same, prod_detail1234.php. My merchants are different directories so the SKU number/pages don't overlap.
    Greg Rice Affiliate Program Management
    www.gocmc.com info(AT)gocmc.com | 330-259-1223

    Join us! - MiNeeds.com | DiscountCandleShop/CheeseSupply | Feng Shui Plaza

  3. #3
    ABW Ambassador
    Join Date
    January 18th, 2005
    Posts
    4,423
    Why not always use a new id?

    Chet

  4. #4
    Pimp Duck popdawg's Avatar
    Join Date
    January 18th, 2005
    Location
    Take off eh?
    Posts
    3,249
    I assign an ID field as well, although I use Sql Server.
    What I do is update the product_id as long as it is in stock then, if it's no longer in stock, I change it's status to a "no longer in stock/no longer available" page, and I remove all the product info. After a set period of time, if the product doesn't reappear (based on merchant and sku) I set it up to do a permanent redirect to the category page on my site that the product belongs to.
    ================================================================
    Been away, now I'm back. Not as much, but I'm back & starting from scratch. Where I was, was fantastic. Where I am now, less so. Things have changed, become harder. So have I. Game ON!!!
    ================================================================

  5. #5
    ABW Veteran Student Heyder's Avatar
    Join Date
    January 18th, 2005
    Posts
    5,482
    <BLOCKQUOTE class="ip-ubbcode-quote"><font size="-1">quote:</font><HR>Originally posted by Xandman:
    Not sure if this solves your problem but I use the SKU or Product ID as my primary index so my product page name stays the same, prod_detail1234.php. My merchants are different directories so the SKU number/pages don't overlap. <HR></BLOCKQUOTE>

    I had been using the sku in the past but with this database I have multiple merchants all lumped together and often more than one will have the same sku number. Not only that but many of them don't assigne one at all so I gave up on that and started using the id's that I use now.

  6. #6
    Moderator MichaelColey's Avatar
    Join Date
    January 18th, 2005
    Location
    Mansfield, TX
    Posts
    16,232
    Another possibility is to have both the merchant id and the sku as keys.
    Michael Coley
    Amazing-Bargains.com
     Affiliate Tips | Merchant Best Practices | Affiliate Friendly? | Couponing | CPA Networks? | ABW Tips | Activating Affiliates
    "Education is the most powerful weapon which you can use to change the world." Nelson Mandela

  7. #7
    Newbie
    Join Date
    January 18th, 2005
    Posts
    3,219
    I use an identifying SKU

    Example:
    Overstock: O-12567

    If the feed does not supply the SKU, I have it produce one for the product utilizing the incremental #'s

  8. Newsletter Signup

+ Reply to Thread

Similar Threads

  1. What a Mess
    By glittered in forum Rakuten LinkShare - LS
    Replies: 0
    Last Post: September 13th, 2009, 01:15 AM
  2. CJ is a mess!!!
    By ~Michelle in forum Commission Junction - CJ
    Replies: 16
    Last Post: July 7th, 2007, 02:38 PM
  3. What a mess!!
    By Grumpy in forum Rakuten LinkShare - LS
    Replies: 1
    Last Post: January 22nd, 2006, 08:46 AM

Posting Permissions

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