Jump to content
surfalot

[Contribution] Availability

Recommended Posts

are you absolutely certain those English language files actually got uploaded?

 

Do you have Admin Access Levels contribution installed? (adds multi-level multi-account access to the admin)

 

When you are seeing that you are missing the right column, post to me everything after the /availability_options.php? part of the URL in the address bar of your browser.

 

EX: page=1&action=new&osCAdminID=d1f3fbd898ecbfa46f0fa5da389e25b3

I've uploaded all those English language files. I don't have Admin Access Levels contribution but I have Administration Login Management for login password.

 

Here is the URL address bar

/availability_options.php?page=1&aID=2&lID=1&action=edit

exactly same as my local site URL address bar

 

Thank you for all your time.

Share this post


Link to post
Share on other sites
I've uploaded all those English language files. I don't have Admin Access Levels contribution but I have Administration Login Management for login password.

 

Here is the URL address bar

/availability_options.php?page=1&aID=2&lID=1&action=edit

exactly same as my local site URL address bar

 

Thank you for all your time.

 

I'm sorry, I just can't come up with a reason why the right column would disappear. It should at least show the default stuff there.

Share this post


Link to post
Share on other sites

Hello, great addons!

 

I've a request ;) Is it possible to show the Availability Options also in the "checkout_confirmation.php".

 

I'm trying but with no good result ;)

 

..and second: It is possible to disable the buton "Confirm order" (in the "checkout_confirmation.php") whith "Zero stock Availability" ?

 

Many Thanks

Share this post


Link to post
Share on other sites

Hello,

 

Is it possible to trigg those unique messages with price tag? For example if I set a price '666666' then it shall show 'Ask for price' with 'add to cart' button disabled?

 

I'm trying to find substitute for Free Call For Price 3 (http://addons.oscommerce.com/info/134) because I can't get it work woth Additional Images 2.11.

 

Can this be used as a substitute?

 

Cheers!

Share this post


Link to post
Share on other sites

Hello @ll,

 

@ surfalot: Thanx for this great Addon. Its works fine :D

 

It was soo good, thats i must pimp it ;)

 

Added a Warranty Manager and Configurer:

 

You can display on the Product Pages a Warranty Message (with or without a Warranty Image) for each Product a different Message.

 

Added 3 extra Availability Messages and a Traffic Light System:

 

You can chose now 5 Availability Messages or a Traffic Light System for each Product different Messages.

You dont need make changes in the code, to set the Stock value for displaying the Traffic Lights or the Availability Messages, any more.

 

German, French and English Translated.

 

Demo: http://www.e-commerce4nuke.org/modules.php?name=catalog

 

 

Best Regards

 

 

Peter

Share this post


Link to post
Share on other sites

Hello @ll,

 

@ surfalot: Thanx for this great Addon. Its works fine :D

 

It was soo good, thats i must pimp it ;)

 

Added a Warranty Manager and Configurer:

 

You can display on the Product Pages a Warranty Message (with or without a Warranty Image) for each Product a different Message.

 

Added 3 extra Availability Messages and a Traffic Light System:

 

You can chose now 5 Availability Messages or a Traffic Light System for each Product different Messages.

You dont need make changes in the code, to set the Stock value for displaying the Traffic Lights or the Availability Messages, any more.

 

German, French and English Translated.

 

Demo: http://www.e-commerc...hp?name=catalog

 

 

Best Regards

 

 

Peter

I don't understand what warranties have to do with the availability messages.

Share this post


Link to post
Share on other sites

I don't understand what warranties have to do with the availability messages.

 

 

@ surfalot: Nothing. But the Warranty Messages based on your availability messages and i have added it in the same time if i made the extension of the addon.

So I could not separate the extensions and i dont have the time to do that. :(

 

I am also fulfilled your wish to configure the addon only via the admin panel.

You have made this Great Addon and so all your Credits are in it and thats good so, thats the reason why i don't Upload it as new addon.

 

Have a look:

 

categories.php Top

 

categories.php availability messages

 

Warranty Manager Based on Availability Messages Manager

 

 

Best Regards

 

Peter

Share this post


Link to post
Share on other sites

Hello @ll,

 

@ surfalot: Thanx for this great Addon. Its works fine :D

 

It was soo good, thats i must pimp it ;)

 

Added a Warranty Manager and Configurer:

 

You can display on the Product Pages a Warranty Message (with or without a Warranty Image) for each Product a different Message.

 

Added 3 extra Availability Messages and a Traffic Light System:

 

You can chose now 5 Availability Messages or a Traffic Light System for each Product different Messages.

You dont need make changes in the code, to set the Stock value for displaying the Traffic Lights or the Availability Messages, any more.

 

German, French and English Translated.

 

Demo: http://www.e-commerce4nuke.org/modules.php?name=catalog

 

 

Best Regards

 

 

Peter

 

 

Hello, and thank you for this fine update :rolleyes:

 

Unfortunately i get this error on product_info.php:

 

1054 - Unknown column 'pd.warranty_id_image' in 'field list'

 

I think: warranty_id_image doesn't exist in TABLE products_description!?

Als i must take the sql file to update the availability_configurer.php gave me errors too!

 

Any ideas?

 

Thank you for your support

Share this post


Link to post
Share on other sites

Hello, and thank you for this fine update :rolleyes:

 

Unfortunately i get this error on product_info.php:

 

1054 - Unknown column 'pd.warranty_id_image' in 'field list'

 

I think: warranty_id_image doesn't exist in TABLE products_description!?

Als i must take the sql file to update the availability_configurer.php gave me errors too!

 

Any ideas?

 

Thank you for your support

 

 

Yes, the field doesn't exist TABLE products_description.

 

Please open the product_info.php and go to Line 72:

 

// BOF: Availability
   $product_info_query = tep_db_query("select p.products_id, pd.products_name, pd.warranty_id_image, p.warranty_id, p.availability_id_in_stock, p.availability_id_in_stock2, p.availability_id_in_stock3, p.availability_id_in_stock_special, p.availability_id_out_of_stock, p.availability_id_in_stock_image, p.availability_id_in_stock2_image, p.availability_id_in_stock3_image, p.availability_id_in_stock_special_image, p.availability_id_out_of_stock_image, p.quantity_stock, p.quantity_stock_2, p.quantity_stock_3, p.quantity_stock_special, p.quantity_stock_zero, pd.products_description, p.products_model, p.products_quantity, p.products_image, pd.products_url, p.products_price, p.products_tax_class_id, p.products_date_added, p.products_date_available, p.manufacturers_id from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_status = '1' and p.products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "' and pd.products_id = p.products_id and pd.language_id = '" . (int)$languages_id . "'");
// EOF: Availability

 

Change it to:

 

// BOF: Availability + Warranty
   $product_info_query = tep_db_query("select p.products_id, pd.products_name, w.warranty_id_image, p.warranty_id, p.availability_id_in_stock, p.availability_id_in_stock2, p.availability_id_in_stock3, p.availability_id_in_stock_special, p.availability_id_out_of_stock, p.availability_id_in_stock_image, p.availability_id_in_stock2_image, p.availability_id_in_stock3_image, p.availability_id_in_stock_special_image, p.availability_id_out_of_stock_image, p.quantity_stock, p.quantity_stock_2, p.quantity_stock_3, p.quantity_stock_special, p.quantity_stock_zero, pd.products_description, p.products_model, p.products_quantity, p.products_image, pd.products_url, p.products_price, p.products_tax_class_id, p.products_date_added, p.products_date_available, p.manufacturers_id from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_WARRANTY . " w where p.products_status = '1' and p.products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "' and pd.products_id = p.products_id and p.warranty_id = w.warranty_id and pd.language_id = '" . (int)$languages_id . "'");
// EOF: Availability + Warranty

 

This fix the first Error

 

Did you have try to install the sql file or did you use only the Configurer Option ?

 

I will fix the erros now

 

Best Regards

 

Peter

Share this post


Link to post
Share on other sites

Now open in catalog/admin/includes the availability_configurer.php mand go to Line 79:

 

 $table_mods_array[] = array ( 'tablename' => 'products',
                                'columnname' => 'availability_id_in_stock',
                                'create' => "ALTER TABLE products ADD availability_id_in_stock int(11) default '1' AFTER products_quantity;",
                                'remove' => "ALTER TABLE products DROP availability_id_in_stock" );
 $table_mods_array[] = array ( 'tablename' => 'products',
                                'columnname' => 'availability_id_out_of_stock',
                                'create' => "ALTER TABLE products ADD availability_id_out_of_stock int(11) default '2' AFTER availability_id_in_stock;",
                                'remove' => "ALTER TABLE products DROP availability_id_out_of_stock" );
 $table_mods_array[] = array ( 'tablename' => 'products',
                                'columnname' => 'availability_id_in_stock2',
                                'create' => "ALTER TABLE products ADD availability_id_in_stock2 int(11) default '3' AFTER availability_id_out_of_stock;",
                                'remove' => "ALTER TABLE products DROP availability_id_in_stock2" );
 $table_mods_array[] = array ( 'tablename' => 'products',
                                'columnname' => 'availability_id_in_stock3',
                                'create' => "ALTER TABLE products ADD availability_id_in_stock3 int(11) default '4' AFTER availability_id_in_stock2;",
                                'remove' => "ALTER TABLE products DROP availability_id_in_stock3" );
 $table_mods_array[] = array ( 'tablename' => 'products',
                                'columnname' => 'availability_id_in_stock_special',
                                'create' => "ALTER TABLE products ADD availability_id_in_stock_special int(11) default '5' AFTER availability_id_in_stock3;",
                                'remove' => "ALTER TABLE products DROP availability_id_in_stock_specia" );
 $table_mods_array[] = array ( 'tablename' => 'products',
                                'columnname' => 'availability_id_in_stock_image',
                                'create' => "ALTER TABLE products ADD availability_id_in_stock_image` varchar(64) default 'red.png' AFTER `availability_id_in_stock;",
                                'remove' => "ALTER TABLE products DROP availability_id_in_stock_image" );
 $table_mods_array[] = array ( 'tablename' => 'products',
                                'columnname' => 'availability_id_out_of_stock_image',
                                'create' => "ALTER TABLE products ADD availability_id_out_of_stock_image varchar(64) default 'remove.png' AFTER availability_id_out_of_stock;",
                                'remove' => "ALTER TABLE products DROP availability_id_out_of_stock_image" );
 $table_mods_array[] = array ( 'tablename' => 'products',
                                'columnname' => 'availability_id_in_stock2_image',
                                'create' => "ALTER TABLE products ADD availability_id_in_stock2_image varchar(64) default 'yellow.png' AFTER availability_id_in_stock2;",
                                'remove' => "ALTER TABLE products DROP availability_id_in_stock2_image" );
 $table_mods_array[] = array ( 'tablename' => 'products',
                                'columnname' => 'availability_id_in_stock3_image',
                                'create' => "ALTER TABLE products ADD availability_id_in_stock3_image varchar(64) default 'green.png' AFTER availability_id_in_stock3;",
                                'remove' => "ALTER TABLE products DROP availability_id_in_stock3_image" );
 $table_mods_array[] = array ( 'tablename' => 'products',
                                'columnname' => 'availability_id_in_stock_special_image',
                                'create' => "ALTER TABLE products ADD availability_id_in_stock_special_image varchar(64) default 'lila.png' AFTER availability_id_in_stock_special;",
                                'remove' => "ALTER TABLE products DROP availability_id_in_stock_special_image" );
 $table_mods_array[] = array ( 'tablename' => 'products',
                                'columnname' => 'quantity_stock',
                                'create' => "ALTER TABLE products ADD quantity_stock int(4) NOT NULL default '2' AFTER availability_id_in_stock_image;",
                                'remove' => "ALTER TABLE products DROP quantity_stock" );
 $table_mods_array[] = array ( 'tablename' => 'products',
                                'columnname' => 'quantity_stock_2',
                                'create' => "ALTER TABLE products ADD quantity_stock_2 int(4) NOT NULL default '5' AFTER availability_id_out_of_stock_image;",
                                'remove' => "ALTER TABLE products DROP quantity_stock_2" );
 $table_mods_array[] = array ( 'tablename' => 'products',
                                'columnname' => 'quantity_stock_3',
                                'create' => "ALTER TABLE products ADD quantity_stock_3 int(4) NOT NULL default '5' AFTER availability_id_in_stock2_image;",
                                'remove' => "ALTER TABLE products DROP quantity_stock_3" );
 $table_mods_array[] = array ( 'tablename' => 'products',
                                'columnname' => 'quantity_stock_special',
                                'create' => "ALTER TABLE products ADD quantity_stock_special int(4) NOT NULL default '-1' AFTER availability_id_in_stock3_image;",
                                'remove' => "ALTER TABLE products DROP quantity_stock_special" );
 $table_mods_array[] = array ( 'tablename' => 'products',
                                'columnname' => 'quantity_stock_zero',
                                'create' => "ALTER TABLE products ADD quantity_stock_zerol int(4) NOT NULL default '0' AFTER availability_id_in_stock_special_image;",
                                'remove' => "ALTER TABLE products DROP quantity_stock_zero" );
 $table_mods_array[] = array ( 'tablename' => 'products',
                                'columnname' => 'warranty_id',
                                'create' => "ALTER TABLE products ADD warranty_id int(11) default '1' AFTER availability_id_in_stock_special;",
                                'remove' => "ALTER TABLE products DROP warranty_id" );

 

Change it to:

 

 $table_mods_array[] = array ( 'tablename' => 'products',
                                'columnname' => 'availability_id_in_stock',
                                'create' => "ALTER TABLE products ADD availability_id_in_stock int(11) default '1' AFTER products_quantity;",
                                'remove' => "ALTER TABLE products DROP availability_id_in_stock" );
 $table_mods_array[] = array ( 'tablename' => 'products',
                                'columnname' => 'availability_id_out_of_stock',
                                'create' => "ALTER TABLE products ADD availability_id_out_of_stock int(11) default '2' AFTER availability_id_in_stock;",
                                'remove' => "ALTER TABLE products DROP availability_id_out_of_stock" );
 $table_mods_array[] = array ( 'tablename' => 'products',
                                'columnname' => 'availability_id_in_stock2',
                                'create' => "ALTER TABLE products ADD availability_id_in_stock2 int(11) default '3' AFTER availability_id_out_of_stock;",
                                'remove' => "ALTER TABLE products DROP availability_id_in_stock2" );
 $table_mods_array[] = array ( 'tablename' => 'products',
                                'columnname' => 'availability_id_in_stock3',
                                'create' => "ALTER TABLE products ADD availability_id_in_stock3 int(11) default '4' AFTER availability_id_in_stock2;",
                                'remove' => "ALTER TABLE products DROP availability_id_in_stock3" );
 $table_mods_array[] = array ( 'tablename' => 'products',
                                'columnname' => 'availability_id_in_stock_special',
                                'create' => "ALTER TABLE products ADD availability_id_in_stock_special int(11) default '5' AFTER availability_id_in_stock3;",
                                'remove' => "ALTER TABLE products DROP availability_id_in_stock_special" );
 $table_mods_array[] = array ( 'tablename' => 'products',
                                'columnname' => 'availability_id_in_stock_image',
                                'create' => "ALTER TABLE products ADD availability_id_in_stock_image varchar(64) default 'red.png' AFTER availability_id_in_stock;",
                                'remove' => "ALTER TABLE products DROP availability_id_in_stock_image" );
 $table_mods_array[] = array ( 'tablename' => 'products',
                                'columnname' => 'availability_id_in_stock_image',
                                'create' => "ALTER TABLE products ADD availability_id_in_stock_image varchar(64) default 'red.png' AFTER availability_id_in_stock;",
                                'remove' => "ALTER TABLE products DROP availability_id_in_stock_image" );
 $table_mods_array[] = array ( 'tablename' => 'products',
                                'columnname' => 'availability_id_out_of_stock_image',
                                'create' => "ALTER TABLE products ADD availability_id_out_of_stock_image varchar(64) default 'remove.png' AFTER availability_id_out_of_stock;",
                                'remove' => "ALTER TABLE products DROP availability_id_out_of_stock_image" );
 $table_mods_array[] = array ( 'tablename' => 'products',
                                'columnname' => 'availability_id_in_stock2_image',
                                'create' => "ALTER TABLE products ADD availability_id_in_stock2_image varchar(64) default 'yellow.png' AFTER availability_id_in_stock2;",
                                'remove' => "ALTER TABLE products DROP availability_id_in_stock2_image" );
 $table_mods_array[] = array ( 'tablename' => 'products',
                                'columnname' => 'availability_id_in_stock3_image',
                                'create' => "ALTER TABLE products ADD availability_id_in_stock3_image varchar(64) default 'green.png' AFTER availability_id_in_stock3;",
                                'remove' => "ALTER TABLE products DROP availability_id_in_stock3_image" );
 $table_mods_array[] = array ( 'tablename' => 'products',
                                'columnname' => 'availability_id_in_stock_special_image',
                                'create' => "ALTER TABLE products ADD availability_id_in_stock_special_image varchar(64) default 'lila.png' AFTER availability_id_in_stock_special;",
                                'remove' => "ALTER TABLE products DROP availability_id_in_stock_special_image" );
 $table_mods_array[] = array ( 'tablename' => 'products',
                                'columnname' => 'quantity_stock',
                                'create' => "ALTER TABLE products ADD quantity_stock int(4) NOT NULL default '2' AFTER availability_id_in_stock_image;",
                                'remove' => "ALTER TABLE products DROP quantity_stock" );
 $table_mods_array[] = array ( 'tablename' => 'products',
                                'columnname' => 'quantity_stock_2',
                                'create' => "ALTER TABLE products ADD quantity_stock_2 int(4) NOT NULL default '5' AFTER availability_id_out_of_stock_image;",
                                'remove' => "ALTER TABLE products DROP quantity_stock_2" );
 $table_mods_array[] = array ( 'tablename' => 'products',
                                'columnname' => 'quantity_stock_3',
                                'create' => "ALTER TABLE products ADD quantity_stock_3 int(4) NOT NULL default '5' AFTER availability_id_in_stock2_image;",
                                'remove' => "ALTER TABLE products DROP quantity_stock_3" );
 $table_mods_array[] = array ( 'tablename' => 'products',
                                'columnname' => 'quantity_stock_special',
                                'create' => "ALTER TABLE products ADD quantity_stock_special int(4) NOT NULL default '-1' AFTER availability_id_in_stock3_image;",
                                'remove' => "ALTER TABLE products DROP quantity_stock_special" );
 $table_mods_array[] = array ( 'tablename' => 'products',
                                'columnname' => 'quantity_stock_zero',
                                'create' => "ALTER TABLE products ADD quantity_stock_zero int(4) NOT NULL default '0' AFTER availability_id_in_stock_special_image;",
                                'remove' => "ALTER TABLE products DROP quantity_stock_zero" );
 $table_mods_array[] = array ( 'tablename' => 'products',
                                'columnname' => 'warranty_id',
                                'create' => "ALTER TABLE products ADD warranty_id int(11) default '1' AFTER availability_id_in_stock_special;",
                                'remove' => "ALTER TABLE products DROP warranty_id" );

 

Best Regards

 

Peter

Share this post


Link to post
Share on other sites

Yes, the field doesn't exist TABLE products_description.

 

Please open the product_info.php and go to Line 72:

 

// BOF: Availability
   $product_info_query = tep_db_query("select p.products_id, pd.products_name, pd.warranty_id_image, p.warranty_id, p.availability_id_in_stock, p.availability_id_in_stock2, p.availability_id_in_stock3, p.availability_id_in_stock_special, p.availability_id_out_of_stock, p.availability_id_in_stock_image, p.availability_id_in_stock2_image, p.availability_id_in_stock3_image, p.availability_id_in_stock_special_image, p.availability_id_out_of_stock_image, p.quantity_stock, p.quantity_stock_2, p.quantity_stock_3, p.quantity_stock_special, p.quantity_stock_zero, pd.products_description, p.products_model, p.products_quantity, p.products_image, pd.products_url, p.products_price, p.products_tax_class_id, p.products_date_added, p.products_date_available, p.manufacturers_id from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_status = '1' and p.products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "' and pd.products_id = p.products_id and pd.language_id = '" . (int)$languages_id . "'");
// EOF: Availability

 

Change it to:

 

// BOF: Availability + Warranty
   $product_info_query = tep_db_query("select p.products_id, pd.products_name, w.warranty_id_image, p.warranty_id, p.availability_id_in_stock, p.availability_id_in_stock2, p.availability_id_in_stock3, p.availability_id_in_stock_special, p.availability_id_out_of_stock, p.availability_id_in_stock_image, p.availability_id_in_stock2_image, p.availability_id_in_stock3_image, p.availability_id_in_stock_special_image, p.availability_id_out_of_stock_image, p.quantity_stock, p.quantity_stock_2, p.quantity_stock_3, p.quantity_stock_special, p.quantity_stock_zero, pd.products_description, p.products_model, p.products_quantity, p.products_image, pd.products_url, p.products_price, p.products_tax_class_id, p.products_date_added, p.products_date_available, p.manufacturers_id from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_WARRANTY . " w where p.products_status = '1' and p.products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "' and pd.products_id = p.products_id and p.warranty_id = w.warranty_id and pd.language_id = '" . (int)$languages_id . "'");
// EOF: Availability + Warranty

 

This fix the first Error

 

Did you have try to install the sql file or did you use only the Configurer Option ?

 

I will fix the erros now

 

Best Regards

 

Peter

 

Thank you, i've fixed this already, I've adapted the sql query from products_new.

 

First i try to use the Configurer Option but an error has occurred: "You have an error in MySql syntax ...."

Then i tried the sql file.

 

I've got another question. Unfortunately the %s in "%s in Stock" did not work. On Catalog side the output is "%s in Stock"!?

 

Thank you that is exactly what i'am looking for. Unfortunately v1.03 did not update the Status automatically.

Edited by 2fix4u

Share this post


Link to post
Share on other sites

....

I've got another question. Unfortunately the %s in "%s in Stock" did not work. On Catalog side the output is "%s in Stock"!?

 

Thank you that is exactly what i'am looking for. Unfortunately v1.03 did not update the Status automatically.

 

If you use the Traffic Light System it don't works. If you use "without_traffic_light_System" it should works.

 

See it here: http://demo.osc2pragmamx.org/catalog-file-product_info-products_id-26.html it was the v.1.0.3 without my changes.

 

I will check it today in the evening.

 

Best Regards

 

Peter

Share this post


Link to post
Share on other sites

Yes, the field doesn't exist TABLE products_description.

 

Please open the product_info.php and go to Line 72:

 

// BOF: Availability
   $product_info_query = tep_db_query("select p.products_id, pd.products_name, pd.warranty_id_image, p.warranty_id, p.availability_id_in_stock, p.availability_id_in_stock2, p.availability_id_in_stock3, p.availability_id_in_stock_special, p.availability_id_out_of_stock, p.availability_id_in_stock_image, p.availability_id_in_stock2_image, p.availability_id_in_stock3_image, p.availability_id_in_stock_special_image, p.availability_id_out_of_stock_image, p.quantity_stock, p.quantity_stock_2, p.quantity_stock_3, p.quantity_stock_special, p.quantity_stock_zero, pd.products_description, p.products_model, p.products_quantity, p.products_image, pd.products_url, p.products_price, p.products_tax_class_id, p.products_date_added, p.products_date_available, p.manufacturers_id from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_status = '1' and p.products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "' and pd.products_id = p.products_id and pd.language_id = '" . (int)$languages_id . "'");
// EOF: Availability

 

Change it to:

 

// BOF: Availability + Warranty
   $product_info_query = tep_db_query("select p.products_id, pd.products_name, w.warranty_id_image, p.warranty_id, p.availability_id_in_stock, p.availability_id_in_stock2, p.availability_id_in_stock3, p.availability_id_in_stock_special, p.availability_id_out_of_stock, p.availability_id_in_stock_image, p.availability_id_in_stock2_image, p.availability_id_in_stock3_image, p.availability_id_in_stock_special_image, p.availability_id_out_of_stock_image, p.quantity_stock, p.quantity_stock_2, p.quantity_stock_3, p.quantity_stock_special, p.quantity_stock_zero, pd.products_description, p.products_model, p.products_quantity, p.products_image, pd.products_url, p.products_price, p.products_tax_class_id, p.products_date_added, p.products_date_available, p.manufacturers_id from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_WARRANTY . " w where p.products_status = '1' and p.products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "' and pd.products_id = p.products_id and p.warranty_id = w.warranty_id and pd.language_id = '" . (int)$languages_id . "'");
// EOF: Availability + Warranty

 

This fix the first Error

 

Did you have try to install the sql file or did you use only the Configurer Option ?

 

I will fix the erros now

 

Best Regards

 

Peter

 

Hi Peter,

 

Sorry, I've got another question. Unfortunately the %s in "%s in Stock" did not work. On Catalog side the output is "%s in Stock".

What i can do to fix that?

 

Best regards

Harry

Share this post


Link to post
Share on other sites

If you use the Traffic Light System it don't works. If you use "without_traffic_light_System" it should works.

 

See it here: http://demo.osc2pragmamx.org/catalog-file-product_info-products_id-26.html it was the v.1.0.3 without my changes.

 

I will check it today in the evening.

 

Best Regards

 

Peter

 

Thank you very much!

And excuse the double posting :blush:

 

Regards Harry

Share this post


Link to post
Share on other sites

I have upload the fix for the Errors.

And i have checked the products_new.php, product_info.php and the shopping_cart.php and fixed some Issues.

The files *_ohne-without_ampel_traffic-lights.php are now without images and shows only Messages.

 

You need the Availability 1.0.4 Packet.

 

Best Regards

 

Peter

Share this post


Link to post
Share on other sites

Hi, I think in the Warranty Options, if it can add more than one warranty options per product it will be nice. because most of time in retail has 3 months for retailer, 1 year for manufacture. just one little suggestion.

ken

Share this post


Link to post
Share on other sites

Hi, I think in the Warranty Options, if it can add more than one warranty options per product it will be nice. because most of time in retail has 3 months for retailer, 1 year for manufacture. just one little suggestion.

ken

 

Yes i think it too, if i made the warranty externsion, but to try i made one only.

In the Next Update i can put 2 extra warranty options in it.

 

Thanx for the feedback :D :thumbsup:

 

 

Best Regards

 

 

Peter

Share this post


Link to post
Share on other sites

has any one install this on oscmax 2.0.4?

 

if they have could they walk me throuvh the install process, please


All the best

&

Kind Regards

 

Richard Armstrong AKA Ciscoeuk

 

all help greatly apprecated

Share this post


Link to post
Share on other sites

has any one install this on oscmax 2.0.4?

 

if they have could they walk me throuvh the install process, please

 

No not really.

 

I will have a look on the oscmax files, to check what is difference to the osc Original files.

 

Best Regards

 

Peter

Share this post


Link to post
Share on other sites

Hey,

 

First of all thanks for this wonderfull contribution.

 

Now I want to know:

 

-how do i add the availability message in the product listing?

 

Thanks in advance

Share this post


Link to post
Share on other sites

Add the availability message in the product_listing.php and in the new_product.php is not so easy, i will try to fix it in the next Version. I have added now a switch in the categories.php to turn ON/OFF the Traffic Light System for each product. If you turn the Traffic Light System OFF, than its shown the availability message on the Products Info

 

Best Regards

 

Peter

Share this post


Link to post
Share on other sites

Hi, thanks for great contribution, I have a problem, can you please help? It didn't update my settings in product edit page after I have put the # of stock for each message, if I go back in the product, the settings did not save and everything is blank. Please help, im running OSCmax.

Edited by ptt81

Share this post


Link to post
Share on other sites

Hi can someone help me,

 

I´ve installed this contribution and it seems to work fine, aldo im not able to see the text Availability and the units in stock, is there something i can do to alter this, i only see the traffic light, also i don't se where i can change the Traffic Light System ON/OFF.

 

Here is the link - "http://loungemarket.com/trade/product_info.php?cPath=23&products_id=34"

 

Many thanks in advance.

Edited by urbanfactory

Share this post


Link to post
Share on other sites

Hi,

when I want to start the configurer I get the login for the admin... after logging in, I have the normal admin screen of oscommerce.

 

some ideas ?

 

thanks

M@rio

Share this post


Link to post
Share on other sites

How easy is it to make this contribution set another status after a specific date?

 

Like i set:

 

Soon available (when i add my product)

and on 21/10/2010 it changes automaticly to "in stock"

 

How easy can this be done and who can do this for me? (i'm no expert in coding these things)

 

Thanks in advance

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×