Wish List for osC 2.3.4 BS GOLD

[tmcca 3]

@TsimiWas this fixed?

[♥Tsimi 518]

37 minutes ago, tmcca said:

@TsimiWas this fixed?

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

Edited September 6, 2017 by Tsimi

[reflex-ocasion 8]

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.

[Michalis2421 0]

hi,

I am trying to install the Wishlist module for 2.3.

https://apps.oscommerce.com/jABxb&wishlist&v=23

But while importing the sql i get the following error:

#1062 - Duplicate entry '12954' for key 'PRIMARY'

Any ideas on what should i do?

THanks

[♥Tsimi 518]

@Michalis2421

When you import the sql file in phpMyAdmin uncheck Do not use AUTO_INCREMENT for zero values and try it again.

[Michalis2421 0]

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\'),' );
 

[♥Tsimi 518]

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 March 8, 2018 by Tsimi

[valquiria23 153]

Hello !!

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

Best regards

Valqui

[♥Tsimi 518]

@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.

 

[♥Tsimi 518]

New version uploaded. Now compatible with the latest osC CE Frozen version.

https://apps.oscommerce.com/wS75s&wishlist-bs

If you use an older version of the community edition please download the previous release.

[valquiria23 153]

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

[♥Tsimi 518]

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.

[♥Tsimi 518]

@valquiria23

New package uploaded.
Now containing files and install instructions for FROZEN and EDGE version.

Enjoy!

[valquiria23 153]

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

[puggybelle 27]

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:

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):

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

 

[kgtee 30]

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.