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

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

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

@Tsimi Wondering if Pheonix update is close before I tackle it myself.  Also have some custom feature questions if you have time for a custom job hire.  


Two forks diverged in a git, and I— I took the fork traveled by burt, And that has made all the difference.

Share this post


Link to post
Share on other sites

Anyone get this to work for Phoenix? I tried but it keeps saying this error and I can't figure out why.

 

[Wed Feb 12 17:57:59.909408 2020] [proxy_fcgi:error] [pid 26414:tid 140385988876032] [client 216.244.66.234:60424] AH01071: Got error 'PHP message: PHP Fatal error:  Cannot declare class wishlist, because the name is already in use in catalog/includes/classes/>

Share this post


Link to post
Share on other sites
5 hours ago, tmcca said:

'PHP message: PHP Fatal error:  Cannot declare class wishlist, because the name is already in use in catalog/includes/classes/

In Phoenix 1.0.4.1 or later (e.g. 1.0.5.0), remove any lines that say require or include includes/classes/wishlist.php


Always back up before making changes.

Share this post


Link to post
Share on other sites

I finished it and testing it for Phoenix 1.0.5.0, so far so good.

I fixed the Wishlist Box to make it look cleaner. What you think?

Screenshot_20200213_212957.png.4e342004de496113d3de097e7a83e49c.png

 

Edited by tmcca

Share this post


Link to post
Share on other sites
On 2/13/2020 at 9:30 PM, tmcca said:

I finished it and testing it for Phoenix 1.0.5.0, so far so good.

I fixed the Wishlist Box to make it look cleaner. What you think?

Screenshot_20200213_212957.png.4e342004de496113d3de097e7a83e49c.png

 

Hello. Are you planning to release to public or for your purposes? I'm seeking a basic wishlist addon and maybr add a few features

Thanks

Share this post


Link to post
Share on other sites
On 2/20/2020 at 8:10 PM, tmcca said:

I am planning to release it once I test it more. I will say like next week or so.

Did you ever do this as I cannot find a working Phoenix wishlist addon anywhere?


REMEMBER BACKUP, BACKUP AND BACKUP

Get the latest Responsive osCommerce CE (community edition) here

It's very easy to over complicate what are simple things in life

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

×