X-Cart forums

[B00MER]

First product bought in admin->orders:

{$orders_full[cat_num].product}

in orders.tpl

Kinda off subject but thought I'd throw that in

[adpboss]

Looks like this is turning into a MM2.0 thread.

Groovico, can I see how many times a product appears in the wishlist table?

That is essential. I want to know if 1 or 100 customers have it in their wishlist.

[leon]

Back to the real subject here:

Originally Posted by funkydunk

what would be really good is a summary page showing the top ten products added to wishlists and maybe a mail the users who have added them to the wishlist with 'something' to make them actually buy it then...

just thought I would add that into your to do list

ps - you wont be able to not do that now

Great idea to add this in. You can actually convert a SIMPLE mod into a GREAT MULTIPURPOSE one here with these ideas.

[BCSE]

Hum. I look at this code and wonder why I did some things that I did as far as the sql query. It could be written much better. If I ever get back to this and "clean up" the code I'll post the mod here. It does work though.

Carrie

[groovico]

Originally Posted by adpboss

Looks like this is turning into a MM2.0 thread.

Groovico, can I see how many times a product appears in the wishlist table?

That is essential. I want to know if 1 or 100 customers have it in their wishlist.

You'll be able to see whats in the wishlists via a straight forward lists, wishlists generally don't have huge amounts of the same product in them as customers remove items from their wishlist once purchased of if they change their mind.

We've ran the wishlist viewer on some of the busiest x-cart sites around, depending on the type of site you have the use of the wishlist by customers will vary drastically.

[adpboss]

Groovico,

My personal experience with Wishlists has been different.

My customers tend to "clump" around core products.

Anyway,

I am getting really tired of waiting for MM 2.0.

I kicked off some development today that I think is in your product but I simply cannot keep waiting for.

Please tell me it is coming soon.

[groovico]

Originally Posted by adpboss

I am getting really tired of waiting for MM 2.0.

I kicked off some development today that I think is in your product but I simply cannot keep waiting for.

Please tell me it is coming soon.

Public release date 26th Jan.

However, you may check your email instead

[B00MER]

From the demo I've seen 2.0 is worth the wait! =P~

[groovico]

Originally Posted by B00MER

From the demo I've seen 2.0 is worth the wait! =P~

That'll have been Marketing Manager 2.0 Pro bundle you've been peaking at

[garryhs]

Displaying All Users Wish Lists in Admin 3.4.11

Here is the same solution for X-Cart 3.4.11

Change to module ../skin1/admin/menu.tpl
Note: Add this line under the link to users.php (after line 3)

Wish lists


New module ../skin1/admin/main/adminwish.tpl

This page allows you to view all user's wishlists.



{capture name=dialog}
{ include file="customer/main/navigation.tpl" }
<table border=0 cellspacing=5>
<tr>
<td valign=top>Name</td>
<td valign=top>Products Desired</td>
<td valign=top>Quantity</td>
<td valign=top>Price Each</td>
<td valign=top>Purchased</td>
</tr>
{section name=cust_num loop=$wl_data}
<tr>
<td valign=top align=left>{$wl_data[cust_num].firstname} {$wl_data[cust_num].lastname}</td>
<td valign=top align=left>{$wl_data[cust_num].product}</td>
<td valign=top align=center>{$wl_data[cust_num].amount}</td>
<td valign=top align=right>${$wl_data[cust_num].price}</td>
<td valign=top align=center>{$wl_data[cust_num].purchased}</td>
</tr>
{/section}
</table>



{ include file="customer/main/navigation.tpl" }
{/capture}
{include file="dialog.tpl" title="Wish Lists" content=$smarty.capture.dialog extra="width=100%"}



New module ../admin/adminwish.php

<?
require "../smarty.php";
require "../config.php";
require "./auth.php";
require "../include/security.php";

$objects_per_page = $config["Appearance"]["users_per_page_admin"];

#
# Obtain wishlist from database
#

$wl_data = func_query("select xcart_customers.firstname, xcart_customers.lastname, xcart_products.product, xcart_wishlist.amount, xcart_pricing.price, xcart_wishlist.purchased from xcart_customers, xcart_wishlist, xcart_products, xcart_pricing where xcart_wishlist.login=xcart_customers.login and xcart_wishlist.productid=xcart_products.productid and xcart_wishlist.productid=xcart_pricing.productid") ;

$total_items = count($wl_data);
$total_nav_pages = ceil($total_items/$objects_per_page)+1;

require "../include/navigation.php";

if (is_array($wl_data))
$wl_data = array_slice($wl_data, $first_page, $objects_per_page);;

$smarty->assign("navigation_script","adminwish.php?");

$smarty->assign("wl_data",$wl_data);
$smarty->assign("main","adminwish");

@include "../modules/gold_display.php";
$smarty->display("admin/home.tpl");
?>



Change to module ../skin1/single/home.tpl
Note: Add these 2 lines after the line {include file="main/subscribe_confirmation.tpl"}

{elseif $main eq "adminwish"}
{include file="admin/main/adminwish.tpl"}

Thats it...

Simple.

Regards

Garry