Micke

April 13, 2007

Hi All!

This Suppliers Product Administration Solution is really a combination of other contributions that, with a small addition, will make it possible for you to let your supplier's maintain their products on your site themselves.

There is a lot of hard work here if you have a fresh install of osCommerce, but it's a sought after feature.

The supplier will be able to:

- change the properties you want them to. (Including their price to you)

- add their products if you want them to. (You will have to approve and set a selling price for the product yourself though before they go public)

- delete the products they supply if you want them to.

//Micke

April 12, 2007

Hello all.

A simple question ...

Is there a admin part of this module ??

meaning .. for the customer who won the auction, is there a place where i can make that auction a order and send to customer ???

Am i missing something on the admin part ???

Thank you

You'll need this manual order maker contribution to do that. If you can activate an auction you are not missing anything inside the contrib package...

//Micke

April 4, 2007

Hi All!
Thanks, juerg for the "modified e-Mail notification for higher bids which really works".

I have a question regarding these messages.

Sometime long ago I must have managed to wreck some code somewhere in this Auction module.

The e-mail notifications are recieved with the message header and all.

The other mail messages the site sends all work as you expect (in html by the way).

Does anyone know a good place to start looking?

//Micke

The messages recipient field is empty too.

//Micke

April 4, 2007

Hi All!

Thanks, juerg for the "modified e-Mail notification for higher bids which really works".

I have a question regarding these messages.

Sometime long ago I must have managed to wreck some code somewhere in this Auction module.

The e-mail notifications are recieved with the message header and all.

The other mail messages the site sends all work as you expect (in html by the way).

Does anyone know a good place to start looking?

//Micke

March 23, 2007

Hi All!

Has anyone a solution for closing the auction at another time than midnight?

Our customers are most active during day-time...

//Micke

March 8, 2007

Hi All!

Hide price if $0 hides the "put in cart"-button as well and that's of course the way it should be..

But how do I give away stuff now?

//Micke

March 3, 2007

You just want to customize a text string on index.php? Having it showing different messages for different customer groups?

February 12, 2007

Any News on this issue?

I have tried some moves with the email but since I'm no programmer I've had no success.

There is also a SEO_URLS dimension to [auction_url]

Maybe the other vars can be stuffed into hidden fields in the bidding form?

A possible workaround can be to leave these var out of the email message, like:

Hi Mike Lastname,
You have placed a bid in an auction on our site. Now someone's bid over you.

Go to www.blablabla.com if consider to place a higher bid yourself.

It's still a bargain!

With kind regards,

www.blablabla.com

Desperate solution? Yes!

I have never seen the "same amount bidding" feature actually. I'll try it some day.

//Micke

January 31, 2007

Hi all!

I think I'm ready to start my first auction if we can get the "Overbid amount" feature working.

My "cut-and-paste-only" brain can't figure out how to modify this statement in order to check whether the amount the bidder has bidden is higher than the last bidded amount + overbid_amount...

...in product_info.php:

$exist_auction = tep_db_fetch_array(tep_db_query($sql_auction));
if ( ($exist_auction['bid_status']!='won')&& ($exist_auction['bid_price']<$bid_price) ){

(or should we mod somewhere else?)

All you coders - what's the trick?

//Micke

January 25, 2007

Hi all!

(Thanks Jan, your countdown setup works for me too...)

I thought I'd chip in with a multilingual twist to the countdown... Here it comes:

In includes/languages/english/auction.php

after:

define('TEXT_DATETIME_LEFT','left');

add:

define('TEXT_DATETIME_DAY','day');

define('TEXT_DATETIME_DAYS','s');

define('TEXT_DATETIME_HOUR',' h. ');

define('TEXT_DATETIME_MINUTES',' min. ');

define('TEXT_DATETIME_SECONDS',' sec.');

define('TEXT_DATETIME_ENDED','Time is out');

(Repeat this for all languages as usual)

In includes/modules/auction_bids.php

before:

add:

<?php

$TEXT_DATETIME_ENDED = TEXT_DATETIME_ENDED;

$TEXT_DATETIME_DAY = TEXT_DATETIME_DAY;

$TEXT_DATETIME_DAYS = TEXT_DATETIME_DAYS;

$TEXT_DATETIME_HOUR = TEXT_DATETIME_HOUR;

$TEXT_DATETIME_MINUTES = TEXT_DATETIME_MINUTES;

$TEXT_DATETIME_SECONDS = TEXT_DATETIME_SECONDS;

$TEXT_DATETIME_LEFT = TEXT_DATETIME_LEFT;

?>

Find the one row:

document.getElementById(tzcd).innerHTML = days + " day" + (days == 1 ? '' : 's') + ' + ' +hours+ 'h : ' +mins+ 'm : '+secs+'s';

and replace with these two rows:

// document.getElementById(tzcd).innerHTML = days + " day" + (days == 1 ? '' : 's') + ' + ' +hours+ 'h : ' +mins+ 'm : '+secs+'s';

document.getElementById(tzcd).innerHTML = days + " <?php print "".$TEXT_DATETIME_DAY.""; ?>" + (days == 1 ? '' : (<?php print "'".$TEXT_DATETIME_DAYS."'"; ?>)) + ' + ' +hours+ (<?php print "'".$TEXT_DATETIME_HOUR."'"; ?>) +mins+ (<?php print "'".$TEXT_DATETIME_MINUTES."'"; ?>)+secs+(<?php print "'".$TEXT_DATETIME_SECONDS."'"; ?>)+(<?php print "' ".$TEXT_DATETIME_LEFT."'"; ?>);

Save, close and upload the files and you're in orbit.

//Micke

January 23, 2007

Hi all!

The mail that says someone has bidden over you shows only the lastname. To include the firstname the line:

$acustomer_firstname = $acustomer['customer_firstname'];

has to be changed to:

$acustomer_firstname = $acustomer['customers_firstname'];

in product_info.php

If anyone knows where to grab [auction_name], [auction_url] or [bid_price], tell me...

//Micke

January 23, 2007

Hi

Maybe you can fix the 12hrs here:

var tz = 1;		 //  Offset for your timezone in hours from UTC

//Micke

January 22, 2007

Hi All!

The timer counting down is a little funny.

When I finally got it showing the right time and counting down nicely I noticed that the countdown was the same no matter what Expiry Date I selected...

I'd hope that it would change accordingly...

Or is it me being tired and stupid?

Anyone got it working?

//Micke

January 22, 2007

Hi all!

Maybe you'll be in trouble if you have more than one customer with the same first name...

<td class="productListing-data"><?php echo $products['customers_firstname'] ?></td>

Here's Name and ID, like "William_231" or "Eric_98"...

<td class="productListing-data"><?php echo $products['customers_firstname'] ?>_<?php echo $products['customers_id']; ?></td>

Any of you guys got the "Overbid amount"-feature or "bidding in non default currency" working?

//Micke

January 21, 2007

Hi all!

Here are lines 20 to 29 in supplier_area.php:

  $languages = tep_get_languages();
 $languages_array = array();
 $languages_selected = DEFAULT_LANGUAGE;
 for ($i = 0, $n = sizeof($languages); $i < $n; $i++) {
$languages_array[] = array('id' => $languages[$i]['code'],
						   'text' => $languages[$i]['name']);
if ($languages[$i]['directory'] == $language) {
  $languages_selected = $languages[$i]['code'];
}
 }

//Micke

January 21, 2007

Hi all!

I really need some Contribution Support...

The Supplier Area Contribution is one of the greatest ideas I have ever heard of...

Here's what Rochdalemark said when he released it a year ago:

It's a contribution that allows you to create some suppliers and set a markup percentage for each one and select which categories they can add their products to with a login name and password.
The suppliers can then login to their own pages where they can add products to their categories entering the cost price that they sell the product to you for. The front of the shop will show the list price determined by the markup on cost you had set for that supplier.

The suppliers can only see and modify their own products and not any other suppliers.

Once installed you will have a supplier box in the left admin menu where you add new suppliers, select there markup % and also which categories they can add products too.

The supplier can login to add their products to your store at

http://www.your-domain.com/catalog/supplier_area.php

Here they can add products as well as being able to see how many items they have sold through your store each month...

Great idea, right?

For some reason I can't get this up and running, although others in this thread claim they have.

On the Admin side there is no problem, I can add suppliers and their markup.

So what's my problem?

When I have logged in as a supplier to the Suppliers Area I get a:

Fatal error: Call to undefined function: tep_get_languages() in /home/a/xxxxxx/www/catalog/supplier_area.php on line 20

Any ideas on how to solve it?

//Micke

January 21, 2007

Hi all!

It can't be right to make a new /includes directory under the /supplier/ can it?

And it can't be right to make a new /images directory under the /supplier/ directory either...

How would these images be found by product_info.php later?

It must be the supplier_area.php in the catalog root directory we should be working on...

Or what do you think?

//Micke

January 21, 2007

Hi all!

This could be one of the classic contributions if someone could make it work.

Apparently some of you have succeeded...

There seems to be two ways here:

Using supplier_area.php in the catalog root or...
Using supplier/supplier_area.php.

I can't get any of them to work right now - but which one should I chose to work on?

Anyway.. When I manage to log in at any of the supplier_area.php files the first thing is:

Fatal error: Call to undefined function: tep_get_languages() in /home/a/xxxxxx/www/catalog/supplier_area.php on line 20

How do I get passed this one?

I would really want to get this to work...

//Micke

January 9, 2007

Hi All!

OK, problem is solved.

I had missed a call and the database was not cleaned up.

I had to use phpMyAdmin to go into the table "ls_conversations" and delete a couple of entries there...

Now everything works fine...

//Micke

January 9, 2007

Hi All!

I have been using this contribution for a month without any problems.

Today I got the same problem as the rest of you here.

If I understand things right this is the code that triggers the window to open (in ls_messages.php)

<?
$status_query = tep_db_query("select status from " . TABLE_LS_TECHS . " a where tech_id ='1' ");
while ($status = tep_db_fetch_array($status_query)) {
if($status['status'] == 'yes') {
	echo "<p align=\"center\"><b style=\"font-size:16pt;\">Waiting for a call!</b></p>\n";
	$i = 0;
	$conversation_query = tep_db_query("select guest, session_id from " . TABLE_LS_CONVERSATIONS . " a where tech ='Support' ");
	while ($conversation =tep_db_fetch_array($conversation_query)) {
		$i++;
	}
	if($i > 0) { 
		echo "<script>NewWindow('ls_newcall.php','conversation','280','320','no')</script>\n";
	}
}
if($status['status'] == 'busy') {
	echo "<p align=\"center\"><b style=\"font-size:16pt;\">Busy!</b></p>\n";
}
}
?>

This is the Javascript it calls:

<script language="javascript">
var limit="0:5"
if (document.images){
	var parselimit=limit.split(":")
	parselimit=parselimit[0]*60+parselimit[1]*1
}
function beginrefresh(){
	if (!document.images) 
		return
	if (parselimit==1) 
		window.location.reload() && window.scroll(0,20000)
	else{
		parselimit-=1
		curmin=Math.floor(parselimit/60)
		cursec=parselimit%60
	if (curmin!=0)
		curtime=curmin+" minutes and "+cursec+" seconds left until page refresh!"
	else
		curtime=cursec+" seconds left until page refresh!"
		setTimeout("beginrefresh()",1000)
	}
}
window.onload=beginrefresh

var win = null;
function NewWindow(mypage,myname,w,h,scroll){
	LeftPosition = (screen.width) ? (screen.width-w)/2 : 0;
	TopPosition = (screen.height) ? (screen.height-h)/2 : 0;
	settings =
	'height='+h+',width='+w+',top='+TopPosition+',left='+LeftPosition+',scrollbars='+scroll+',resizable'
	win = window.open(mypage,myname,settings)
}
</script>

Is the problem in the database?

Why does the problem appear?

//Micke

December 27, 2006

First you backup the database, or just the table products_groups and then try:
insert into products_group select '6' as customers_group_id, customers_group_price, products_id from products_groups where customers_group_id = '1';
If it not right, use the backup :)

Better yet, try it on your local server.

Thanks JanZ!

Worked like a charm!

(I had to add an 's' to 'products_group', that's all...)

The 'hide stunt' will have to wait until tomorrow... (if I can wait...)

Thanks again!

//Micke

December 27, 2006

Hi All!

I think I need help from someone who knows his/her way around SPPC and SQL...

Here's why:

I have just created my sixth customer group (ID6) and it will (to 98%) be the same as customer group 1 (ID1).

First: There must be some smart SQL command to run from phpMyAdmin that copies whatever is in the price field for customer group 1 to the price field for customer group 6. How do you do that?

Second: Would it be possible to design some smart command that would check the products_hide_from_groups field and if that contains a '1' add a ',6' to the end of the string?

//Micke

December 1, 2006

Hi All!

I installed Center Shop CSS ms2 and it was really simple and worked really well.

Now that the shop is centered and fine I'd like to have a nice gradient background like they have at this beautiful 'Enshi Lifestyle' site here.

When I try to 'mimic' that page design with margins and backgrounds the top margin gets white...

How do I avoid that?

Here's the CSS in my includes/heading.php

 <DIV style="BACKGROUND: url(../images/gradient.gif) repeat-x; MARGIN: 0px; TEXT-ALIGN: center; layer-background-image: url(../images/gradient.gif); border: 1px none #000000;"><!-- Center Shop CSS ms2 -->
<DIV style="margin-top: 10px; WIDTH: 900px; TEXT-ALIGN: left; background-color: #FFFFFF;"><!-- Center Shop CSS ms2 -->

//Micke

November 24, 2006

PS: Do you know how to put in a bullet in the "articles.php" page. I got it right in the "articles_new.php" page, but I can't seem to find the insert point for that image bullet...

Sorry, Helle, for taking so long with an answer to this...

I think the insertion point you are looking for is on line 48 in the file: "catalog/includes/modules/article_listing.php"

Lines 47 to 52 in my copy of article listing says:

<?php
 echo '<a href="' . tep_href_link(FILENAME_ARTICLE_INFO, 'articles_id=' . $articles_listing['articles_id']) . '"><b>' . $articles_listing['articles_name'] . '</b></a> ';
 if (DISPLAY_AUTHOR_ARTICLE_LISTING == 'true' && tep_not_null($articles_listing['authors_name'])) {
  echo TEXT_BY . ' ' . '<a href="' . tep_href_link(FILENAME_ARTICLES, 'authors_id=' . $articles_listing['authors_id']) . '"> ' . $articles_listing['authors_name'] . '</a>';
 }
?>

//Micke

November 24, 2006

Hi freedmini!

I don't think there is such a contribution to pull right out of the hat...

Maybe the guys developing the Custom PC creator contrib has the dependency function working?

Selecting a certain PC processor leaves you with one set of sockets and so on...

Same thing as you are looking for, really..

//Micke

Micke

Posts

Joined

Last visited

Content Type

Profiles

Forums

Posts posted by Micke

Suppliers Product Administration Solution

[Contribution] Auction Module

[Contribution] Auction Module

[Contribution] Auction Module

[Contribution] Auction Module

Free products and Hide price if $0

seperate index for customer group

[Contribution] Auction Module

[Contribution] Auction Module

[Contribution] Auction Module

[Contribution] Auction Module

[Contribution] Auction Module

[Contribution] Auction Module

[Contribution] Auction Module

Supplier Area Contribution

Supplier Area Contribution

Supplier Admin Area Contribution

Supplier Admin Area Contribution

Live Support v 1.2 ! POPUP PROBLEM !!

Live Support v 1.2 ! POPUP PROBLEM !!

Seperate Pricing Per Customer v3.5

Seperate Pricing Per Customer v3.5

I want to get rid of the white [CSS] line in the top

Article Manager v1.0

Step by Step getting to the right product

Browse

Activity