Thread: Product ID

Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2012
    Posts
    345
    Plugin Contributions
    0

    Default Product ID

    For some reason our products ids for new created products are large numbers. They were around 600 but now if create any new product using admin or easypop it shows id number larger than 10K. Any idea how to fix it so it shows id number as it used to.

  2. #2
    Join Date
    Jul 2012
    Posts
    16,488
    Plugin Contributions
    17

    Default Re: Product ID

    Quote Originally Posted by jsarwar View Post
    For some reason our products ids for new created products are large numbers. They were around 600 but now if create any new product using admin or easypop it shows id number larger than 10K. Any idea how to fix it so it shows id number as it used to.
    It's actually more important to know how the field identifying the next products_id got changed than the final result. The products_id is basically a place holder. To go back to "600"ish, you'd have to delete the new product (assuming that they have not been indexed yet) and any table associations with it, then modify the auto_increment next value to something larger than the latest products_id, then add the product back to take on the new number...

    The real question though regarding the numbering is what problem is being caused with the numbering as it is right now?
    ZC Installation/Maintenance Support <- Site
    Contribution for contributions welcome...

  3. #3
    Join Date
    Jul 2012
    Posts
    345
    Plugin Contributions
    0

    Default Re: Product ID

    How to I modify auto increment for product id?
    It looks like client somehow enter product id in myphpadmin which lead to large number and now they have over 100 products with large numbers as products ids. Can we leave them as is and modify the auto increment so next added product has id 600ish?

 

 

Similar Threads

  1. v150 Remove Product Image and product name from product page
    By LloydR in forum Templates, Stylesheets, Page Layout
    Replies: 2
    Last Post: 19 Sep 2012, 11:06 AM
  2. Issues with Product info page: my product image is overlapping the product name, etc
    By wmorris in forum Templates, Stylesheets, Page Layout
    Replies: 5
    Last Post: 4 May 2011, 06:30 PM
  3. Missing product name & product price from Product Info Page
    By kpatterson in forum Templates, Stylesheets, Page Layout
    Replies: 3
    Last Post: 16 Feb 2011, 03:11 AM
  4. Replies: 2
    Last Post: 13 Jun 2010, 02:48 PM
  5. Product description in product more info in html format but not in product listing?
    By this side up in forum Customization from the Admin
    Replies: 1
    Last Post: 18 Dec 2006, 06:25 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
disjunctive-egg
Zen-Cart, Internet Selling Services, Klamath Falls, OR