Results 1 to 6 of 6

Hybrid View

  1. #1
    Join Date
    Nov 2006
    Posts
    4
    Plugin Contributions
    0

    application error Special Products beforNew Products of the month and delete product with quantity zero

    Question 1) I would like that in "Home Page" the Specials Products must position befor the new products of the month..... which file must change? and how it edit?

    Question 2) I would like to delete from the database all products with quantity equal to zero.....exists a fast method?

    P.S. Excuse me for any grammatical errors! I'm italian!

  2. #2
    Join Date
    Sep 2003
    Location
    Ohio
    Posts
    69,402
    Plugin Contributions
    6

    Default Re: Special Products beforNew Products of the month and delete product with quantity

    To sort the Centerboxes ... go to the Configuration ... Index Listing ...

    There are "sets" of centerboxes that you can sort ...

    0 means OFF and any other value is the Sort Order to display order of the centerboxes ...

    To completely remove from the database all products with a products_quantity of 0 ... it is really safer to do via the Admin as there are many database tables associated with each Product and the Admin delete of a Product will manage this for you ...

    How many Products do you have that you want deleted?
    Linda McGrath
    If you have to think ... you haven't been zenned ...

    Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!

    Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today!]
    Officially PayPal-Certified! Just click here

    Try our Zen Cart Recommended Services - Hosting, Payment and more ...
    Signup for our Announcements Forums to stay up to date on important changes and updates!

  3. #3
    Join Date
    Nov 2006
    Posts
    4
    Plugin Contributions
    0

    Default Re: Special Products beforNew Products of the month and delete product with quantity

    Our company has a supplier who will send us their database as a text file which contains many products with quantity equal to zero and i use EasyPopulate for to add the products in my database. Now, i would like to delete all products with quantity to zero..... it is possible to do via the Admin ??? or else, if i make a PHP programm for to delete all this products, which database tables i must consider?

    I hope is all clear!

  4. #4
    Join Date
    Sep 2003
    Location
    Ohio
    Posts
    69,402
    Plugin Contributions
    6

    Default Re: Special Products beforNew Products of the month and delete product with quantity

    It would be best to write a program to delete the product based on the delete routine that a standard delete makes ...

    If you are importing a file with quantity 0 ... can't you just delete those before you import?
    Linda McGrath
    If you have to think ... you haven't been zenned ...

    Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!

    Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today!]
    Officially PayPal-Certified! Just click here

    Try our Zen Cart Recommended Services - Hosting, Payment and more ...
    Signup for our Announcements Forums to stay up to date on important changes and updates!

  5. #5
    Join Date
    Nov 2006
    Posts
    4
    Plugin Contributions
    0

    Default Re: Special Products beforNew Products of the month and delete product with quantity

    Quote Originally Posted by Ajeh View Post
    It would be best to write a program to delete the product based on the delete routine that a standard delete makes ...

    If you are importing a file with quantity 0 ... can't you just delete those before you import?
    Bhè! Yes! But i had to think to us before adding the products! By now i have make the damage!

  6. #6
    Join Date
    Sep 2003
    Location
    Ohio
    Posts
    69,402
    Plugin Contributions
    6

    Default Re: Special Products beforNew Products of the month and delete product with quantity

    You might peek at the file:
    /admin/includes/modules/delete_product_confirm.php

    NOTE: Backup your database before you try to apply your own script to clean up the database tables ...
    Linda McGrath
    If you have to think ... you haven't been zenned ...

    Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!

    Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today!]
    Officially PayPal-Certified! Just click here

    Try our Zen Cart Recommended Services - Hosting, Payment and more ...
    Signup for our Announcements Forums to stay up to date on important changes and updates!

 

 

Similar Threads

  1. Products with zero quantity showing as Sold Out
    By miguel991 in forum Setting Up Categories, Products, Attributes
    Replies: 2
    Last Post: 22 Dec 2010, 09:36 PM
  2. Replies: 1
    Last Post: 19 Aug 2009, 10:29 AM
  3. help with parent products and child products, how to seperate size and quantity?
    By blankman in forum Templates, Stylesheets, Page Layout
    Replies: 2
    Last Post: 20 Aug 2008, 03:04 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
  •  
disjunctive-egg