Save For Later Support Thread

I don't know of any reason they wouldn't interoperate - but be aware that you will probably need to do some merges; I suspect the two mods overlap somewhat in the files they change.

Zen 1.50

Hi Scott, thank you for the update to 1.5 for save for later :) .

The installation of your mod went fine, but when we go to our shopping cart page, it is blank. Yet, if we drop in the original 1.5 tpl_shopping_cart_default from the 1.50 zen fileset, the shopping cart page is fine. We didn't alter your tpl_shopping_cart_default in the zen150 folder for the installation. Can you please let us know what else we can look at? Thx!

ksoup:

Can you please let us know what else we can look at? Thx!

Review the instructions. You probably haven't done step 3.

Hi Scott blush simple simple mistake... the files were copied to includes/includes/.... LOL... Not includes/ ... all is well! Your time is greatly appreciated!

Ajeh noticed that some attribute combinations were not well handled by Save for Later, so I submitted fixes to resolve this problem. Please update to Save for Later 1.3 if you are using Save for Later in your cart and have products with attributes.

Thank you, Scott and Ajeh!

Scott, we have many of your mods and really appreciate the quality you put into your craft! Thank you!

I have a question regarding the install of Save for Later in a Picaflur-azul template.

I followed the instructions for installing both the files and the mysql script. I logged into the site and added some items to the shopping cart. From there I was given the message "an error occurred try refreshing the page". I did and was given the same message.

I fortunately did a full backup of the sql database before adding to the table and have since reverted to that backup and all is back to "normal" operation.

My question is: Is there something special that needs to be done to use the Andover Modern Template from Picaflur-azul with Save for Later?

Any and all thoughts are appreciated.

We are using Zencart 1.5.0.

Look in your cache directory for an error log.

I found a bunch of them with today's date. Shall I post some info?

Since I haven't perfected my powers of telepathy, I suppose we will be reduced to that.

Ok. This is from the biggest log I have and I've removed a bit of the cache_data = "info".

[03-May-2012 05:18:27] PHP Fatal error: 1062:Duplicate entry 'zc_3d63152cab3e001e45db0f8214ae796d' for key 'PRIMARY' :: insert into znc_db_cache set cache_entry_name = 'zc_3d63152cab3e001e45db0f8214ae796d',
cache_data = ( removed from here )
cache_entry_created = '1336043907' in /home3/username/public_html/domain_name.com/includes/classes/db/mysql/query_factory.php on line 101

Now, I've removed the files and have done a restore of the database and here's what I see now.

[03-May-2012 06:24:56] PHP Fatal error: 1146:Table 'theburg2_znc1.znc_customers_basket_later' doesn't exist :: select products_id, customers_basket_quantity
from znc_customers_basket_later
where customers_id = '2' in /home3/username/public_html/domain_name.com/includes/classes/db/mysql/query_factory.php on line 101

Now, I'm no sql programmer nor do I know much about php but if you hum a few lines I can follow along.

Thanks for your help.

The second one is the relevant log. You forgot to create the tables. See step 3 in the instructions.

I did create the tables and we have a prefix on the table structure of znc_ so i prepended that to the mysql_slf.sql file here:

DROP TABLE IF EXISTS znc_customers_basket_later;
CREATE TABLE znc_customers_basket_later

and here:

DROP TABLE IF EXISTS znc_customers_basket_later_attributes;
CREATE TABLE znc_customers_basket_later_attributes (

Now, those are the only 2 places I put that in and I copied and pasted the entire statement into the "Install SQL Patch" window and sent it. I was given a ( 4 lines processed ) message and then things didn't work.

So, I restored the database that I had backed up approximately 10 minutes before and removed all the files I copied in.

So Doc, what's the prognosis?

If you use the Install SQL Patches facility under Tools, you should not manually add your own prefix. Install SQL Patches does this for you.

Then should I try just adding the mysql_sfl.sql ( the unchanged version ) again and retry the files?

I got it to work properly and thanks for your help.

But I have one more question. Is there a way for the Save for Later to Total what is in there? For Example, I have 1 item at 2.00 and 1 item at 4.00 and so on. Can it be made to total what is in the saved cart?

Thanks again for your help.

No. There's no easy mechanism to arrive at a total for items which are not in the cart.

Q: How can I find how many people are using Save For Later?
A: Run the following query against your database in phpMyAdmin:

SELECT count(DISTINCT customers_id), count(distinct products_id) from customers_basket_later;

Is there a way to do this from install SQL Patches?

techextreme:

Is there a way to do this from install SQL Patches?

No. Install SQL Patches is for running SQL patches, not getting query results.

Ok. I have one more question.

I'm wondering if it's possible to add a "Save For Later" button next to each product somewhere near the "Add To Cart" Button.

The only reason I'm asking is this would make it simpler for logged in customers to create their "wish list" or "Save for Later" list instead of having to add them to the cart first.

Thanks in advance.