Search options

Sorry, I should have said c_header.ihtml, however, my own build of phpShop is so radically different sometimes I forget to reference the original source when address problems. Glad you got it working.

To generate a select box to enable your customers to quickly browse by manufacturer, add the following code where you would like the control to appear ( in menu perhaps? )

     <form action="?page=shop/manufacturer" method="post">
      <fieldset>
       <select name="manufacturer" onchange="this.form.submit()">
        <option value="1">Manufacturer</option>
        <option value="1">----------</option>
<?php

/// query to select only manufacturers who currently have products listed

$q = "
SELECT
    pm.id,
    pm.name
FROM
    product p,
    product_manufacturer pm
WHERE
    pm.id = p.product_manufacturer AND
    p.product_publish = 'Y'
GROUP BY
    pm.id
ORDER BY
    pm.name ASC
";

$db->query( $q );

// output the list of available manufacturers
while ( $db->next_record() )
{
    if ( $manufacturer == $db->f( 'id' ) )
    {
        $selected = ' selected="selected"';
    }
    else
    {
        $selected = '';
    }
        

?>
        <option value="<?php $db->p( 'id' ); ?>"<?php echo $selected; ?>><?php $db->p( 'name' ); ?></option>
<?php

}

?>
       </select>
       <input type="submit" value="submit" />
      </fieldset>
     </form>

As stated, this will dynamically build the list of active manufacturers stored on your database. Look for my next post illustrating the manufacturer browse page momentarily...

I believe Uli made a complete Paypal module ( correct me if I'm wrong Uli ).

Take a look at his site: www.ulisoft.org

No.

The bugs you were reading about on bugtraq were specific to an earlier build of phpShop. Not sure when they were addressed, however, they certainly don't effect the most recent release 0.8.0

That makes more sense.

The default installation of phpShop has no optional fields for additional information. However, its really not all that difficult to add an additional field.

In a nutshell:

1. Using phpMyAdmin create a new field in the product table for storing your information
2. Modify the add / update routines in ps_product.inc to accept the additional field
3. Modify product_form.ihtml to display the additional field in an input element
4. Modify shop/flypage to display the addtional input element
5. Modify order/order_print to include the additonal field
6. Modify the email_reciept method in ps_checkout.inc to send the additional field

I don't think I forgot anything. But that should be enough to get you started.

Not sure what you mean by "notes", however, product attributes ( though rudimentary ) are part of the default  phpShop installation.

There are two types of products. A product and a product item.

Attributes such as color, size, etc.. are defined as a product attribute and stored as an additional product in the database along with all your other products.

The downside to this method is that for every color, size etc... attribute there will be a product that corresponds.

Parent Product T-Shirt
-- Child Product: T-Shirt, color red, size s
-- Child Product: T-Shirt, color red, size m
-- Child Product: T-Shirt, color red, size l

The above illustrates how attributes are handled.

To have one product available in one color but three sizes, you end up with 4 products in the database. Only one of which ( the parent product ) is displayed in your storefront.

The attributes for which are displayed in a select box. Regardless how many attributes you have, you will always have only a single select box with all the various child products listed as options.

Hope that clarifies how product attributes are handled.

Glad I could be of service.

I have been using and writing code for phpShop for over a year and half now and its truly an easy framework to both learn and extend.

I have released a few basic modules here on the forums, however the bulk of the code I have written is for my highly modified application. I would love to give back even more, but my shop is so evolved now that its nearly impossible to release modules at this point.

Thank you Pablo for providing an open source application for others to use and build upon.

Cheers,
Jason

Log in to your store. From the administrative backend, click on Admin > Module List > Product. Then in your left menu you should have some new options. Click on Add Function to add your first new function. Continue until you have added all new functions outlined in step 2.