Jump to content

Recommended Posts

37 minutes ago, tmcca said:

@TsimiWas this fixed?

If you mean the issue reflex-ocasion mentioned, no, not that I know of.

Edited by Tsimi

Share this post


Link to post
Share on other sites

No, I have not been able to solve it, I have not had time and now less because I have a family in the hospital.

It should not be complicated, just add missing code at that particular point. Right now I do not remember which line it is, I'm sorry.

Share this post


Link to post
Share on other sites

Same thing happened:

This is the query:

 

DROP TABLE IF EXISTS customers_wishlist;
CREATE TABLE customers_wishlist (
  customers_wishlist_id int unsigned NOT NULL auto_increment,
  customers_id int unsigned NOT NULL default '0',
  products_id tinytext NOT NULL,
  customers_wishlist_quantity int(2) NOT NULL,
  final_price decimal(15,4),
  customers_wishlist_date_added char(8),
  PRIMARY KEY  (customers_wishlist_id),
  KEY idx_wishlist_customers_id (customers_id)
) CHARACTER SET utf8 COLLATE utf8_unicode_ci;

DROP TABLE IF EXISTS customers_wishlist_attributes;
CREATE TABLE customers_wishlist_attributes (
  customers_wishlist_attributes_id int unsigned NOT NULL auto_increment,
  customers_id int unsigned NOT NULL default '0',
  products_id tinytext NOT NULL,
  products_options_id int unsigned NOT NULL default '0',
  products_options_value_id int unsigned NOT NULL default '0',
  PRIMARY KEY  (customers_wishlist_attributes_id),
  KEY idx_wishlist_att_customers_id (customers_id)
) CHARACTER SET utf8 COLLATE utf8_unicode_ci;

INSERT INTO configuration_group ( configuration_group_id , configuration_group_title , configuration_group_description , sort_order , visible ) VALUES ( '12954', 'Wish List Settings', 'Settings for your Wish List', '25', '1' );
INSERT INTO configuration ( configuration_id , configuration_title , configuration_key , configuration_value , configuration_description , configuration_group_id , sort_order , last_modified , date_added , use_function , set_function ) VALUES ( '', 'Max Wish List', 'MAX_DISPLAY_WISHLIST_PRODUCTS', '30', 'How many wish list items to show per page on the main wishlist page', '12954', '', now(), now(), NULL , NULL );
INSERT INTO configuration ( configuration_id , configuration_title , configuration_key , configuration_value , configuration_description , configuration_group_id , sort_order , last_modified , date_added , use_function , set_function ) VALUES ( '', 'Max Wish List Box', 'MAX_DISPLAY_WISHLIST_BOX', '4', 'How many wish list items to display in the infobox before it changes to a counter', '12954', '', now(), now(), NULL , NULL );
INSERT INTO configuration ( configuration_id , configuration_title , configuration_key , configuration_value , configuration_description , configuration_group_id , sort_order , last_modified , date_added , use_function , set_function ) VALUES ( '', 'Display Emails', 'DISPLAY_WISHLIST_EMAILS', '10', 'How many emails to display when the customer emails their wish list link', '12954', '', now(), now(), NULL , NULL );
INSERT INTO configuration ( configuration_id , configuration_title , configuration_key , configuration_value , configuration_description , configuration_group_id , sort_order , last_modified , date_added , use_function , set_function ) VALUES ( '', 'Wish List Redirect', 'WISHLIST_REDIRECT', 'No', 'Do you want to redirect back to the original page when a customer adds a product to their wish list?', '12954', '', now(), now(), NULL , 'tep_cfg_select_option(array(\'Yes\', \'No\'),' );
 

Share this post


Link to post
Share on other sites

Are you uploading the sql file via the import function or are you copy&pasting the sql code and then running it?

Check your configuration_group table if there is an entry with the configuration_group_id 12954 already in there.

If yes delete that entry and try to rund the sql file or code again.

Edited by Tsimi

Share this post


Link to post
Share on other sites

Hello !!

Does anyone know if this addon is compatible with OSC 2.3.4.1 EDGE?

Best regards

Valqui


Please do not falsify my words. Are you interested in knowing who does it? Send me a PM.

The Phoenix Club won't allow me to join - why not?

Setting up a new Frozen site with so many nice addons available on the market. 

:heart: Community Oscommerce fan :heart:

 

Share this post


Link to post
Share on other sites

@valquiria23

It is not compatible with Edge or Frozen version.
You'll have to hard code the FILENAME_ definitions replace all the HTTP_POST_VARS and HTTP_GET_VARS and all DIR_WS. I am sure you'll have to change some of the code to match it to the latest structure.

 

Share this post


Link to post
Share on other sites

Dear @Tsimi

Have you planned to update the old version to be compatible with 2.3.4.1 BS Edge where the file names are hardcoded?

Best regards

Valqui


Please do not falsify my words. Are you interested in knowing who does it? Send me a PM.

The Phoenix Club won't allow me to join - why not?

Setting up a new Frozen site with so many nice addons available on the market. 

:heart: Community Oscommerce fan :heart:

 

Share this post


Link to post
Share on other sites
9 minutes ago, valquiria23 said:

Dear @Tsimi

Have you planned to update the old version to be compatible with 2.3.4.1 BS Edge where the file names are hardcoded?

Best regards

Valqui

Yes i wanted to do that next. Probably tomorrow i should have time.

Share this post


Link to post
Share on other sites

Thank you very much @Tsimi !!!! :heart: it!!


Please do not falsify my words. Are you interested in knowing who does it? Send me a PM.

The Phoenix Club won't allow me to join - why not?

Setting up a new Frozen site with so many nice addons available on the market. 

:heart: Community Oscommerce fan :heart:

 

Share this post


Link to post
Share on other sites

A lot of posters have been looking for the ability to show Out Of Stock on items with zero quantity on a Wish List.  Me, too so....this is what I came up with.

I added a new language define for Out Of Stock in catalog/includes/languages/english/wishlist.php

define('TEXT_OUT', 'Out Of Stock');

Then in catalog/includes/classes/wishlist.php, around line 350, you'll see a list of entries for the products_array, looks like this:

'name' => $products['products_name'],
                                                'products_status' => $products['products_status'],
                        'model' => $products['products_model'],
                        'image' => $products['products_image'],
                        'price' => $products['products_price'],
                        'quantity' => $this->contents[$products_id]['qty'],
                        'stock' => $products['products_quantity'],
                        'weight' => $products['products_weight'],
                        'final_price' => ($products['products_price'] + $this->attributes_price($products_id)),
                        'tax_class_id' => $products['products_tax_class_id'],

The new line to be entered is the one in boldface above for 'stock'

Lastly, open catalog/wishlist.php and scroll down, around line 375, to see ****** CHECK TO SEE IF PRODUCT IS NO LONGER AVAILABLE ******

Directly below it you will see:

if($products[$i]['products_status'] == 0) {
                   echo '<br /><strong style="color: red">' . TEXT_ITEM_NOT_AVAILABLE . '</strong>';
              }

Below that, add the following code:

if($products[$i]['stock'] == 0) {
                 echo '<br /><strong style="color: red">' . TEXT_OUT . ' </strong>';
}

The end result will be your items with zero quantity displaying Out Of Stock on the Wishlist, like this:

wishlist2.JPG.307470ebcbdd3b1d1dc6b4e4ab95ea44.JPG

For those of you who have items set up to be turned off in Admin when quantity hits zero, you will see the Item no longer available message instead.

What I don't like about that...and it's always been an issue....is that the Select box gets removed from that one.  See A Bug's Life (now turned off in Admin):

wishlist3.JPG.5f3e2729b6410b41ad69bb16e80b8d9b.JPG

The intent is to not allow the item to be added to the cart, but...if the Select field is gone...you can't delete it from your Wish List, either!

This has always been a problem, no fix that I'm aware of, so....I personally just use the if statement regarding 'stock' and get rid of the first one that references 'products_status'.  I never turn off items in Admin, anyway.

The one thing I can't seem to remedy is what happens with the wishlist_public.php file.  That's the link that is sent to someone after a buyer chooses to send their Wish List to a friend.  The same code I applied in wishlist.php is not achieving the same result in wishlist_public.php.  It's simply putting Out Of Stock on every item in the list, whether it's available or not.  So, I leave that file alone for now.  Perhaps someone else can take a look at that file.

Other than that, the wishlist_public.php file is okay - just no Out Of Stock messages for those receiving a link to the customer's Wish List.

They'll only know the item is available (or not) after adding it to their cart.

- Andrea

 

Share this post


Link to post
Share on other sites

The select boxes are good if you have a long list of items. Otherwise the table can be modified to that of shopping cart where there is a refresh button and delete button next to the quantity box of each item.

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

×