Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Display products from database on a physical page


karstenvoigt

Recommended Posts

We are currently installing a shop for art and are nearly ready to go live - thanks to the help we received from this forum. We still have one problem which we could not solve yet, and I hope someone in this community can give us some hints.

 

Imagine you are a interested in buying a surrealist painting. We have different style-buttons on our website, so all you would have to do is click the button "surrealism". Now, we want that clicking on this button will lead you to a page which is designed especially for displaying surrealist paintings; we do not simply present the paintings on the generic advanced_search_resutls.php. So, if you would click on the button "cubism" instead, you would see a page with different text, different design elements, and have all our cubist paintings displayed.

 

We have therefore created a new page for each style (surrealism.php; cubism.php; etc). What we don't know is how we can display the corresponding paintings on these pages. It can't be that difficult, really, as all one has to do is search through the field in the database which defines the style, identify the paintings wich are surrealist (or cubist, or ...), and display them on the corresponding page. It's just that none of us is bright enough to do the coding...

 

Is there anybody out there who can help us?

 

Thanks,

Karsten

Link to comment
Share on other sites

If you add all of these different types of products as 'Categories' (e.g. Cubism, Post-Modern, Surrealist etc) then the links to them will automatically appear in the Categories menu. Anyone following those links will go to a page with the products from that category displayed.

 

This is a built-in feature of osCommerce.

 

Vger

Link to comment
Share on other sites

Sorry, didn't realise you were also talking of fixed pages. When you hover your mouse over the product in your Catalog in osCommerce 'admin' you will see a file pathway. You can use this file pathway to construct a 'buy now' button pathway which people can use to add that product to their shopping cart from your static page e.g.

 

<a href="cubism.php?cPath=22&sort=2a&action=buy_now&products_id=100"><img src="images/addtobasket.gif" border=0 width=20 height=15 alt="Add To Basket"></a>

 

Vger

Link to comment
Share on other sites

Sorry, didn't realise you were also talking of fixed pages.  When you hover your mouse over the product in your Catalog in osCommerce 'admin' you will see a file pathway.  You can use this file pathway to construct a 'buy now' button pathway which people can use to add that product to their shopping cart from your static page e.g.

 

<a href="cubism.php?cPath=22&sort=2a&action=buy_now&products_id=100"><img src="images/addtobasket.gif" border=0 width=20 height=15 alt="Add To Basket"></a>

 

Vger

 

 

Seems like this is what i was looking for! Thanks a lot. Concerning your first posting: sorry, i had forgotten that i cannot define the different styles as seperate categories (we don't only classify pictures by style, but also by themes, schools, etc. if i use categories and sub-categories, i would have to duplicate and triplicate products in the database in order to include the same product in the different type of classifications.).

Concerning your second posting, just let me see if i understood you correclty:

On the new page surrealism.php, we would have to include manually a copy of our product image, plus a "buy now" button with the pathway i can identify through the admin area the way you described it, correct? As we do not so frequently add new products, this wouldn't be a problem.

 

Thanks for the hint. just let me know if i understood you correctly before i start th working on this, ok?

 

Again, thanks a lot for your help,

karsten

Link to comment
Share on other sites

Yes, the new page you would set up exactly as you would a normal html page - with a product image, product text, and a link to a Buy Now button.

 

If you use your own tables at the level of includes/languages/english/ (or your language), then once you've set up the one table you can copy/paste and just change the product image, text, and the cPath (if necessary) and the product_id.

 

You can see hard-coded product pages if you look at my Live Shop entry.

 

Vger

Link to comment
Share on other sites

Yes, the new page you would set up exactly as you would a normal html page - with a product image, product text, and a link to a Buy Now button.

 

If you use your own tables at the level of includes/languages/english/ (or your language), then once you've set up the one table you can copy/paste and just change the product image, text, and the cPath (if necessary) and the product_id.

 

You can see hard-coded product pages if you look at my Live Shop entry.

 

Vger

 

Just had a look at your live shop, and yes, at first glance it looks like what i need. thanks a lot for your help. before i will start bulding the new pages, i would like to ask you a question which is quite basic:

i developed quite a few additional pages for my store, giving theclient background information on the artists, the countries they come from, etc. i made all these pages as .php files. now you say that i can set up pages in osc also as html pages, which brings the advantage that these can be designed much easier via front page than a .php file. so could i make all these pages as .html files? also the new pages we have been talking about (those including my surrealist, cubist, etc. paintings), also those i could design as .html-files? and would i simply upload those .html-files to the includes/languages/english/ folder, just as i do it with an .php file?

 

sorry for this basic question, but i just now realized that there seems to be something important about osc i have not yet understood. i always assumed that in osc you can only work with php files.

 

Thanks again for your help,

karsten

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...