Very weird dilema

[mcritz]

im taking over a current oscommerce site and i am finding products to have different prices on the website when you are logged in compared to when your not.

 

 

for instance. logged out the price will be 1200 dollars, but logged in it will show as 400.

 

the question is where can i edit this at? and to determine the markup?

[Guest]

John,

 

 

I would check to see if SPPC (separate price per customer) or Group Pricing is installed. Those to contribution that COULD alter the displayed price depending on which group customers are placed in.

 

 

 

 

 

Chris

[mcritz]

i do not see either of these, i have personally looked through every panel in the admin as well as searched majority of all the files for the field or the number "300" since thats what the markup is.

 

this isnt a built in feature with ossc is it? and if those contributions arent there how could i track it down?

 

like what could i search for that would alter the product price depending on if you are logged in?

 

thank you.

[Guest]

John,

 

 

The best way to check for Customer Groups or SPPC is to look in admin>>customers area. Edit one of the customers and check to see if that customer form has an extra field called Group.

 

 

 

 

 

Chris

[mcritz]

there are no extra boxes in the customer section. i have looked through everything within the control panel and don't see anything resembling a reason to a different logged in price.

 

this is actually something the site owner wants, however i need to figure out where its pulling the value of 300 percent.

[Guest]

John,

 

 

More than likely, the code is very custom and MAY not have an admin configuration area for the price change. For a complete change, several files would have to be edited including product_info.php, specials.php, new_products.php, checkout_payment.php, checkout_process,php, checkout_shipping.php and others.

 

 

 

Chris

[multimixer]

[...] i need to figure out where its pulling the value of 300 percent.

 

Did you check the taxes? It looks like a tax rate is getting applied after login, maybe just for the particular zone your address as a customer belongs too. Check the tax rates

[mcritz]

Did you check the taxes? It looks like a tax rate is getting applied after login, maybe just for the particular zone your address as a customer belongs too. Check the tax rates

 

i thought that as well, but it doesn't have any tax rates set except europe at 17.5%.

 

if it was taxes would that explain why "logged in" users see the lower price? this all takes place as your viewing the catalog.

[Guest]

John,

 

No, the tax rates have nothing to do with the price display after log in.

 

Unfortunately, I believe you are going to have to check the code to determine how the price is displayed.

 

 

 

 

 

Chris

[multimixer]

Somebody would need to take a look, it's like guessing now

[mcritz]

in what files do you recommend i look in. i have searched most for "300" but that may not be what i need to search for.

[mcritz]

there is a file named hideprice.php that includes

 

<?php
if (tep_session_is_registered('customer_id')){
?>
<p class="details-price">Price: <b>$regularpricestrike</b></p><br />
<?php 
}else{
echo '<p class="details-price">Price: <i>Only logged users</i></p><br />';
}
?>

[mcritz]

as well in product_info.phphtml, (this is an sts template)

 

	<div class="product-details">
		    	            <p class="details-name">$productname</p><br />
		  	                <p class="details-price">Price: <b>$regularpricestrike</b></p><br />
		                </div>

[mcritz]

i don't think this is what im looking for, nothing has a strike through it and this doesn't pertain to specials, but it appears thats how its told to display

[multimixer]

ok, so lets check

1) Are all prices getting divided by 3 when logged in (eg item1: not logged 1200, logged 300, item 2 not logged 900 logged 300) or is it like when not logged all prices are 1200 and when logged various prices?

2) Check the DB, table products, to see what price is there (1 price, more prices ?)

3) Check DB if you have a table called "products_price_break"

4) Does the price issue appear on all pages or just index or just product_info

5) Disable sts and then check prices again. If problem persist post the query named "$product_info_query"of file product_info.php here. If not then say so

6) add an item to the cart, how is the price?

 

Just some thoughts

 

I don't know, what to do depends always from what was the result of the previous checking, in any case, it makes no sense to search for "300" in any files

[mcritz]

ok, so lets check

1) Are all prices getting divided by 3 when logged in (eg item1: not logged 1200, logged 300, item 2 not logged 900 logged 300) or is it like when not logged all prices are 1200 and when logged various prices?

2) Check the DB, table products, to see what price is there (1 price, more prices ?)

3) Check DB if you have a table called "products_price_break"

4) Does the price issue appear on all pages or just index or just product_info

5) Disable sts and then check prices again. If problem persist post the query named "$product_info_query"of file product_info.php here. If not then say so

6) add an item to the cart, how is the price?

 

Just some thoughts

 

I don't know, what to do depends always from what was the result of the previous checking, in any case, it makes no sense to search for "300" in any files

 

 

1. Prices in DB and OSC Control Panel are high. ie. Price for item x is 2874.42 in database/osc control panel, when not logged in the item shows at 8623.26, they are all 3 times more not logged in.

2. can not find more than one price listened within the database or osc control pael

3. i see no tables in the database with that name.

4. its across the board, all pages, all searches, index etc. (If your logged ou you see a price 3* more then when you are)

5. when all sts is disabled it does the same thing.

6. when entering a new item at 100 it shows 100 when logged in, and 300 when logged out.

 

i thank you for the help thus far and if you or anyone have any more ideas please let me know.

[multimixer]

And how is the query in product_info.php?

 

I don't know, guessing like this without seeing anything ....

 

Maybe it's something obvious you are just overlooking and we are hunting here for ghosts ....

[mcritz]

product_info.php

 

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<?php include('includings/header_productinfo.php'); ?>

<div id="wrapper">

   <?php include('includings/top.php'); ?>

   <div id="main">
	<?php include('includings/leftcol.php'); ?>
       <div class="mainRight">

           <div class="mainBucket">
			<?php include('includings/topboxes.php'); ?>
           </div>
           <br clear="all" />

           <div class="mainContent">

                   <div id="mainimageHolder" class="mainimageHolder">
                       $content
                   </div>
				<!-- BOF Product Description -->
                   <div id="productDesc">						
					<!-- BOF CONTAINER -->
                       <div class="container">
						$startform
						<div class="product-details">
		    	            <p class="details-name">$productname</p><br />
		  	                <p class="details-price">Price: <b>$regularpricestrike</b></p><br />
		                </div>
					    <ul class="tabs">
					        <li><a href="#tab1">Product info</a></li>
					        <!--<li><a href="#tab2">Returns Policy</a></li>-->


					    </ul>
					    <div class="tab_container">
					        <div id="tab1" class="tab_content">
					            <p>$productdesc</p>
					        </div>
					        <div id="tab2" class="tab_content">
					            	$returns	
								</div>


					   	</div>
					</div>
					<!-- EOF CONTAINER -->

					<br clear="all"/><br />
                          		$options 


                       <p>$stock</p>
					<div style="visibility: hidden;height:3px;">$qty</div>

					<!--Buttons-->
                       <div id="addtocart">
                           <div id="wishlistBuy">
                              <!-- WISHLIST-->
							$wishlist
							<!-- WISHLIST-->
                           </div>
						<br clear="all" /><br/>
						<div id="wishlistBuy">
                               $qty
                           </div>
						<br clear="all" /><br/>
                           <div id="productBuy">
                             <A HREF="javascript:history.go(-1)">
							<IMG SRC="includes/languages/english/images/buttons/button_back.gif" BORDER="0">
						  </A>
						   $addtocartbutton
                           </div>
						<br clear="all" /><br/>
                       </div>
                       <!--Buttons-->
					<br clear="all" /><br/>
					$endform
					<br clear="all" /><br/>
                   </div>
				<!-- EOF Product Description -->
                   <br clear="all" /><br/>

       	</div>
           <br clear="all" />
       </div>

   </div>

   <?php include('includings/footer.php'); ?>

</div>

</body>

</html>

[mcritz]

searching for 300 in the database it returned.

 

 

SELECT *

FROM `sbtdb`.`products_to_categories`

WHERE (

CONVERT( `products_id`

USING utf8 ) LIKE '%300%'

OR CONVERT( `categories_id`

USING utf8 ) LIKE '%300%'

)

 

would that set the 300 percent?

[multimixer]

I have no idea. Your store seems to have some special customizations in it, they are impossible to find out by guessing in the dark. Maybe somebody else can help