more than 1 of a product, one product relevant to more categories, New Products

[IMpure]

I had few questions:-

 

1.) I wanted to display more than 1 s of the product. Like 1 front view, 1 rear view, 1 side view and 1 special feature. How can I?

 

2.) If one product is relevant to more than one category, how can I configure it?

 

3.) I wanted to know how long does OsCommerce show the new products? Can I set some time or days so It automatically excludes a product from new products category after set days?

 

Awaiting..........

[cudd1es]

Q number 1. There is a contribution that will allow you to have more than one image per item.

 

 

 

Q number 2.

 

I think that MS3 when it comes out can do this.

 

But for the time being.

 

Locate the item number for the item in question.

 

You can find this by going into the product either in catalog or admin and looking ad the address bar.

 

NEXT, find the Category number that you want to insert it into.

 

Again, you can find this by doing the same as above.

 

Now, run the following SQL

 

insert into products_to_categories (products_id, categories_id) values ('999', '99');

 

Where 999 is the item number and 99 is the category number.

 

I will warn you to first BACKUP! your database.

 

NEVER change anything via SQL without backing up first.

 

 

 

 

Q number 3.

 

I think the answer to your number 3 is there is no limit... I think it just displays the last x amount of items as per the settings in admin.

[IMpure]

Thanks a lot!

 

1.) Where can i download that contribution?

 

2.) How can I insert that statement? Please guide. I am not good at editing.

 

3.) Where in Admin I can set the number of items which'll be displayed in new products.

 

Anxiously waiting...

Please respond!

[cudd1es]

Q1. Community/Contributions at the top will allow you to find lot sof add ons.

 

http://www.oscommerce.com/community/contributions,1289 is the one I think would work for you.

 

 

 

Q2. SQL Statements... Do you have MyPHPAdmin?

 

If not, I tend to use the update.php in the extra folder that came with the installation.

Configure the mysql.php file with the relevant info from a configure.php. Then create a text based file with the comment in and upload as xxx.sql.

 

BEFOREHAND.... BACK UP YOUR DATABASE!!!!! can be done from the Admin/Tools section.

 

 

 

Q3. Admin / Configuration / Maximum Values... Set the New products module to something like 9 and it will only show the last 9 items.

[IMpure]

Bundle of thanks....

 

Q1. I'll try it and let you know if i encounter any problem.

 

Q2. I do have MyPHPAdmin available in CPANEL for my site. Sorry I can't get your instructions :blush: I don't have any 'extra' folder available in my installation which I downloaed. I don't have any 'update.php', 'mysql.php' available in my installation.

Please ... Please ... help me

 

Q3. Thank you so very much. After adding a product, how long will it persist in NEW PRODUCT category after addition. If I haven't get you wrong then as long as the number of added products is lower than 'Maximum Values for New Products', OS will show that product in New Product section. Right?

 

Like

 

Suppose I have set the Admin / Configuration / Maximum Values... the New products to 9.

 

After adding 9 products, If'll add the 10th product... It'll automatically remove the 1st product from New Product section and will replace it with 10th product.

 

Looking for your reply.

[Guest]

I had few questions:-

 

1.) I wanted to display more than 1 s of the product. Like 1 front view, 1 rear view, 1 side view and 1 special feature. How can I?

 

2.) If one product is relevant to more than one category, how can I configure it?

 

3.) I wanted to know how long does OsCommerce show the new products? Can I set some time or days so It automatically excludes a product from new products category after set days?

 

Awaiting..........

 

Answer to question 2) products in more than one category - contribution available for this on the following url;

 

http://www.oscommerce.com/community/contri...an+one+category

 

Hope that helps ;)