MSRP contrib

5 Mar 2010, 10:02 PM

#181

autoace

Totally Zenned

Join Date:: Jun 2009
Posts:: 618
Plugin Contributions:: 0

MSRP contrib

I just installed this mod and it works fine except that it DOES NOT display the prices correctly.

It has something to do with:
TEXT_PRODUCT_MSRP
TEXT_PRODUCT_SAVE
TEXT_PRODUCT_OUR

in the includes/functions/functions_prices.php file.

because they show up in the storefront instead of what should be there!

I looked this up in the developers took kit and this is what it came up with:

Line #297 : $final_display_price = '<span class="smalltext1"><s>'.TEXT_PRODUCT_MSRP.$currencies->display_price($display_msrp_price, zen_get_tax_rate($product_check->fields['products_tax_class_id'])).'</s></span><br><span class="save">'.TEXT_PRODUCT_SAVE.$currencies->display_price($save, '').'  ('. number_format((($display_msrp_price - $display_normal_price) / $display_msrp_price), 2, '.', '') * 100 . '%)'.'</span><br><span class="norm">'.TEXT_PRODUCT_OUR.$show_special_price . $show_sale_price . $show_sale_discount.'</span>' ;

Line #304 : $final_display_price = '<span class="smalltext1"><s>'.TEXT_PRODUCT_MSRP.$currencies->display_price($display_msrp_price, zen_get_tax_rate($product_check->fields['products_tax_class_id'])).'</s></span><br><span class="save">'.TEXT_PRODUCT_SAVE.$currencies->display_price($save, '').'  ('. number_format((($display_msrp_price - $display_normal_price) / $display_msrp_price), 2, '.', '') * 100 . '%)'.'</span><br><span class="norm">'.TEXT_PRODUCT_OUR.$show_normal_price . $show_special_price . $show_sale_price . $show_sale_discount.'</span>' ;

Can someone point out what I am missing?

Thank you,
autoace

6 Mar 2010, 4:03 PM

#182

autoace

Totally Zenned

Join Date:: Jun 2009
Posts:: 618
Plugin Contributions:: 0

Re: MSRP contrib

Simple fix, I reviewed the files I uploaded and I missed one, done!

Thank you,
autoace

12 Mar 2010, 11:53 PM

#183

autoace

Totally Zenned

Join Date:: Jun 2009
Posts:: 618
Plugin Contributions:: 0

Re: MSRP contrib

Does anyone know how to switch the display order?

For example, instead of:
List Price
You Save
Our Price

==========
List Price
Our Price
You Save

Thank you,
autoace

13 Mar 2010, 3:43 AM

#184

sonjamichelle

New Zenner

Join Date:: Mar 2009
Posts:: 21
Plugin Contributions:: 0

Re: MSRP contrib

> autoace:

Does anyone know how to switch the display order?

For example, instead of:
List Price
You Save
Our Price

==========
List Price
Our Price
You Save

Yes. In the file ./includes/functions/functions_prices.php between line 295 and 309 (line numbers might not be exact, but close enough) you'll find the following code:

      // don't show the $0.00
	  if(($display_msrp_price!='')&&($display_msrp_price!='0')){
	  $save=$display_msrp_price-$display_normal_price;
      	$final_display_price = '<span class="smalltext1"><s>'.TEXT_PRODUCT_MSRP.$currencies->display_price($display_msrp_price, zen_get_tax_rate($product_check->fields['products_tax_class_id'])).'</s></span><br><span class="save">'.TEXT_PRODUCT_SAVE .$currencies->display_price($save, '').'  ('. number_format((($display_msrp_price -  $display_normal_price) / $display_msrp_price), 2, '.', '') * 100 . '%)'.'</span><br><span class="norm">'.TEXT_PRODUCT_OUR.$show_special_price . $show_sale_price . $show_sale_discount.'</span>' ;
	  }else{
	  	$final_display_price = $show_special_price . $show_sale_price . $show_sale_discount;
	  }
    } else {
	 if(($display_msrp_price!='')&&($display_msrp_price!='0')){
	 $save=$display_msrp_price-$display_normal_price;
      	$final_display_price = '<span class="smalltext1"><s>'.TEXT_PRODUCT_MSRP.$currencies->display_price($display_msrp_price, zen_get_tax_rate($product_check->fields['products_tax_class_id'])).'</s></span><br><span class="save">'.TEXT_PRODUCT_SAVE .$currencies->display_price($save, '').'  ('. number_format((($display_msrp_price -  $display_normal_price) / $display_msrp_price), 2, '.', '') * 100 . '%)'.'</span><br><span class="norm">'.TEXT_PRODUCT_OUR.$show_normal_price . $show_special_price . $show_sale_price . $show_sale_discount.'</span>' ;
	  }else{
	  	$final_display_price = $show_normal_price . $show_special_price . $show_sale_price . $show_sale_discount;
	  }
    }

You see the entries TEXT_PRODUCT_SAVE and TEXT_PRODUCT_OUR, you'll need to rearrange the functions into the order you want.

Here's the code I put in place:

      // don't show the $0.00
	  if(($display_msrp_price!='')&&($display_msrp_price!='0')){
	  $save=$display_msrp_price-$display_normal_price;
      	$final_display_price = '<span class="smalltext1"><s>'.TEXT_PRODUCT_MSRP.$currencies->display_price($display_msrp_price, zen_get_tax_rate($product_check->fields['products_tax_class_id'])).'</s></span><br><span class="norm">'.TEXT_PRODUCT_OUR.$show_special_price . $show_sale_price . $show_sale_discount.'</span><BR><span class="save">'.TEXT_PRODUCT_SAVE .$currencies->display_price($save, '').'  ('. number_format((($display_msrp_price -  $display_normal_price) / $display_msrp_price), 2, '.', '') * 100 . '%)'.'</span>' ;
	  }else{
	  	$final_display_price = $show_special_price . $show_sale_price . $show_sale_discount;
	  }
    } else {
	 if(($display_msrp_price!='')&&($display_msrp_price!='0')){
	 $save=$display_msrp_price-$display_normal_price;
      	$final_display_price = '<span class="smalltext1"><s>'.TEXT_PRODUCT_MSRP.$currencies->display_price($display_msrp_price, zen_get_tax_rate($product_check->fields['products_tax_class_id'])).'</s></span><br><span class="norm">'.TEXT_PRODUCT_OUR.$show_normal_price . $show_special_price . $show_sale_price . $show_sale_discount.'</span><BR><span class="save">'.TEXT_PRODUCT_SAVE .$currencies->display_price($save, '').'  ('. number_format((($display_msrp_price -  $display_normal_price) / $display_msrp_price), 2, '.', '') * 100 . '%)'.'</span>' ;
	  }else{
	  	$final_display_price = $show_normal_price . $show_special_price . $show_sale_price . $show_sale_discount;
	  }
    }

The key is the contents between the tags.

13 Mar 2010, 4:16 AM

#185

sonjamichelle

New Zenner

Join Date:: Mar 2009
Posts:: 21
Plugin Contributions:: 0

Re: MSRP contrib

Additionally I added a font size tag (yeah I know depreciated but it works) and an extra tag to get, in my opinion, a better flow to the price block.

Now looks like this:

*ACU Coat

Starting at:
Retail Price: $44.99
Our Price: $34.99
You save: $10.00 (22%)
Report a cheaper price seen elsewhere
You earn 34 reward points *

The tag was inserted on line 298 after $final_display_price = ' and again on line 305 after $final_display_price = '

That dropped the prices after the "Starting at:".

I also added a on line 298 before the ' and a at the end of line 298 before the ';

I did this again on line 305.

Those changes just make the whole block look a lot cleaner in my opinion.

These changes also carry over to the product listing as well since it was done in the functions code rather than the layout template.

Anyhoo, I hope all this and the above posted rambling works out.

Thanks for the idea too, it looks much more logical!! :clap:

25 Mar 2010, 9:18 PM

#186

rosrooster

New Zenner

Join Date:: Mar 2010
Posts:: 5
Plugin Contributions:: 0

Re: MSRP contrib

i just installed msrp and now im getting this when i go into the admin console. The msrp is working on the front end though. Any ideas?

Fatal error: Cannot redeclare zen_update_products_price_sorter() (previously declared in D:\Hosting\5493129\html\admin\includes\functions\general.php:2517) in D:\Hosting\5493129\html\admin\includes\functions\functions_prices.php on line 1378

25 Mar 2010, 9:36 PM

#187

sonjamichelle

New Zenner

Join Date:: Mar 2009
Posts:: 21
Plugin Contributions:: 0

Re: MSRP contrib

D:\Hosting\5493129\html\admin\includes\functions\general.php:2517

Doesn't sound right. Looks like you might have a path error.

26 Mar 2010, 12:23 AM

#188

rosrooster

New Zenner

Join Date:: Mar 2010
Posts:: 5
Plugin Contributions:: 0

Re: MSRP contrib

I got it figured out. I just copied in a new functions_prices.php and its working again.
Thanks

26 Mar 2010, 9:04 PM

#189

autoace

Totally Zenned

Join Date:: Jun 2009
Posts:: 618
Plugin Contributions:: 0

Re: MSRP contrib

sonjamichelle:

Yes. In the file ./includes/functions/functions_prices.php between line 295 and 309 (line numbers might not be exact, but close enough) you'll find the following code:

  // don't show the $0.00
  if(($display_msrp_price!='')&&($display_msrp_price!='0')){
  $save=$display_msrp_price-$display_normal_price;
  	$final_display_price = '<span class="smalltext1"><s>'.TEXT_PRODUCT_MSRP.$currencies->display_price($display_msrp_price, zen_get_tax_rate($product_check->fields['products_tax_class_id'])).'</s></span><br><span class="save">'.TEXT_PRODUCT_SAVE .$currencies->display_price($save, '').'  ('. number_format((($display_msrp_price -  $display_normal_price) / $display_msrp_price), 2, '.', '') * 100 . '%)'.'</span><br><span class="norm">'.TEXT_PRODUCT_OUR.$show_special_price . $show_sale_price . $show_sale_discount.'</span>' ;
  }else{
  	$final_display_price = $show_special_price . $show_sale_price . $show_sale_discount;
  }
} else {
 if(($display_msrp_price!='')&&($display_msrp_price!='0')){
 $save=$display_msrp_price-$display_normal_price;
  	$final_display_price = '<span class="smalltext1"><s>'.TEXT_PRODUCT_MSRP.$currencies->display_price($display_msrp_price, zen_get_tax_rate($product_check->fields['products_tax_class_id'])).'</s></span><br><span class="save">'.TEXT_PRODUCT_SAVE .$currencies->display_price($save, '').'  ('. number_format((($display_msrp_price -  $display_normal_price) / $display_msrp_price), 2, '.', '') * 100 . '%)'.'</span><br><span class="norm">'.TEXT_PRODUCT_OUR.$show_normal_price . $show_special_price . $show_sale_price . $show_sale_discount.'</span>' ;
  }else{
  	$final_display_price = $show_normal_price . $show_special_price . $show_sale_price . $show_sale_discount;
  }
}

> 
> You see the entries TEXT_PRODUCT_SAVE and TEXT_PRODUCT_OUR, you'll need to rearrange the functions into the order you want. 
> 
> Here's the code I put in place:
> 
> ```
      // don't show the $0.00
	  if(($display_msrp_price!='')&&($display_msrp_price!='0')){
	  $save=$display_msrp_price-$display_normal_price;
      	$final_display_price = '<span class="smalltext1"><s>'.TEXT_PRODUCT_MSRP.$currencies->display_price($display_msrp_price, zen_get_tax_rate($product_check->fields['products_tax_class_id'])).'</s></span><br><span class="norm">'.TEXT_PRODUCT_OUR.$show_special_price . $show_sale_price . $show_sale_discount.'</span><BR><span class="save">'.TEXT_PRODUCT_SAVE .$currencies->display_price($save, '').'  ('. number_format((($display_msrp_price -  $display_normal_price) / $display_msrp_price), 2, '.', '') * 100 . '%)'.'</span>' ;
	  }else{
	  	$final_display_price = $show_special_price . $show_sale_price . $show_sale_discount;
	  }
    } else {
	 if(($display_msrp_price!='')&&($display_msrp_price!='0')){
	 $save=$display_msrp_price-$display_normal_price;
      	$final_display_price = '<span class="smalltext1"><s>'.TEXT_PRODUCT_MSRP.$currencies->display_price($display_msrp_price, zen_get_tax_rate($product_check->fields['products_tax_class_id'])).'</s></span><br><span class="norm">'.TEXT_PRODUCT_OUR.$show_normal_price . $show_special_price . $show_sale_price . $show_sale_discount.'</span><BR><span class="save">'.TEXT_PRODUCT_SAVE .$currencies->display_price($save, '').'  ('. number_format((($display_msrp_price -  $display_normal_price) / $display_msrp_price), 2, '.', '') * 100 . '%)'.'</span>' ;
	  }else{
	  	$final_display_price = $show_normal_price . $show_special_price . $show_sale_price . $show_sale_discount;
	  }
    }

The key is the contents between the tags.

Thank you, worked great!

Thank you,
autoace

26 Mar 2010, 9:30 PM

#190

autoace

Totally Zenned

Join Date:: Jun 2009
Posts:: 618
Plugin Contributions:: 0

Re: MSRP contrib

sonjamichelle:

Additionally I added a font size tag (yeah I know depreciated but it works) and an extra tag to get, in my opinion, a better flow to the price block.

Now looks like this:

The tag was inserted on line 298 after $final_display_price = ' and again on line 305 after $final_display_price = ' 

That dropped the prices after the "Starting at:".

I also added a on line 298 before the ' and a at the end of line 298 before the ';

I did this again on line 305.

Those changes just make the whole block look a lot cleaner in my opinion.

These changes also carry over to the product listing as well since it was done in the functions code rather than the layout template.

Anyhoo, I hope all this and the above posted rambling works out.

Thanks for the idea too, it looks much more logical!! :clap:

Would you know how to separate the text from the numbers?
i.e.
List Price: $99.99
and so forth

Thank you,
autoace

27 Mar 2010, 2:22 PM

#191

autoace

Totally Zenned

Join Date:: Jun 2009
Posts:: 618
Plugin Contributions:: 0

Re: MSRP contrib

List Price.......................................$99.99

Thank you,
autoace

27 Mar 2010, 3:45 PM

#192

lankeeyankee

Totally Zenned

Join Date:: Jan 2007
Posts:: 1,514
Plugin Contributions:: 1

Re: MSRP contrib

autoace:

List Price.......................................$99.99

If you just want blank space in between use for each space you want. This cannot come inside php tags, so close the tag but in the spaces and add a new opening tag such as ?> <?php

Zen Cart and it's community are the best!!

1 Apr 2010, 2:42 AM

#193

autoace

Totally Zenned

Join Date:: Jun 2009
Posts:: 618
Plugin Contributions:: 0

Re: MSRP contrib

lankeeyankee:

If you just want blank space in between use for each space you want. This cannot come inside php tags, so close the tag but in the spaces and add a new opening tag such as ?> <?php

There is no way to do it via css?

Thank you,
autoace

3 Apr 2010, 10:29 AM

#194

lankeeyankee

Totally Zenned

Join Date:: Jan 2007
Posts:: 1,514
Plugin Contributions:: 1

Re: MSRP contrib

autoace:

There is no way to do it via css?

Sure, you need to wrap the whole block in a <div> and give it an ID, then each part that you want separate control over in their own <div> with unique IDs(right before the tags would be a good place). Then you can float one right and one left within the wrapper. You can set the width of the container <div> that everything is wrapped in to whatever you want to fit your template layout, either a fixed width in pixels or a percentage of the main page container's width.

Zen Cart and it's community are the best!!

4 Apr 2010, 8:12 AM

#195

evariety

New Zenner

Join Date:: Apr 2008
Posts:: 24
Plugin Contributions:: 0

Re: MSRP contrib

I'm new on zen-cart, I have some problem on it
I have successfully install this moduke already, at my admin pages it did appear
Tax Class: --none--Taxable Goods
Products Price (Net):
Products MSRP:
Products Price (Gross )
but when i enter the price there at the site it only show the products MSRP price, my site is https://www.mumnbaby.com
is that anybody can help me on it?
actually previously i did use dual pricing but now i wish to remove it and use this MSRP module.
Thanks

8 May 2010, 6:38 PM

#196

kburner

Totally Zenned

Join Date:: Apr 2008
Location:: Flint, Michigan
Posts:: 684
Plugin Contributions:: 0

Re: MSRP contrib

iZilla_Pod:

I messed around with the code for awhile. Hopefully this will help someone.

Heres the original piece of code for the contribution you will be replacing:

if ($display_normal_price == 0) {
  // don't show the $0.00
  if(($display_msrp_price!='')&&($display_msrp_price!='0')){
  $save=$display_msrp_price-$display_normal_price;
      $final_display_price = '<span class="smalltext1">' . TEXT_PRODUCT_MSRP . '<s>' . $currencies->display_price($display_msrp_price, zen_get_tax_rate($product_check->fields['products_tax_class_id'])) . '</s></span><br><span class="save">' . TEXT_PRODUCT_SAVE .$currencies->display_price($save, '') . '  ('. number_format((($display_msrp_price -  $display_normal_price) / $display_msrp_price), 2, '.', '') * 100 . '%)' . '</span><br><span class="norm">' . TEXT_PRODUCT_OUR.$show_special_price . $show_sale_price . $show_sale_discount.'</span>' ;
  }else{
      $final_display_price = $show_special_price . $show_sale_price . $show_sale_discount;
  }
} else {
 if(($display_msrp_price!='')&&($display_msrp_price!='0')){
 $save=$display_msrp_price-$display_normal_price;
      $final_display_price = '<span class="smalltext1">'.TEXT_PRODUCT_MSRP.'<s>'.$currencies->display_price($display_msrp_price, zen_get_tax_rate($product_check->fields['products_tax_class_id'])).'</s></span><br><span class="save">'.TEXT_PRODUCT_SAVE .$currencies->display_price($save, '').'  ('. number_format((($display_msrp_price -  $display_normal_price) / $display_msrp_price), 2, '.', '') * 100 . '%)'.'</span><br><span class="norm">'.TEXT_PRODUCT_OUR.$show_normal_price . $show_special_price . $show_sale_price . $show_sale_discount.'</span>' ;
  }else{
      $final_display_price = $show_normal_price . $show_special_price . $show_sale_price . $show_sale_discount;
  }
}

> This will show the "You Save" with dollar amount only:
> ```php
    if ($display_normal_price == 0) {
      // don't show the $0.00
      if(($display_msrp_price!='')&&($display_msrp_price!='0')){
      $save=$display_msrp_price-$display_normal_price;
          $final_display_price = '<span class="smalltext1">' . TEXT_PRODUCT_MSRP . '<s>' . $currencies->display_price($display_msrp_price, zen_get_tax_rate($product_check->fields['products_tax_class_id'])) . '</s></span><br><span class="save">' . TEXT_PRODUCT_SAVE . $currencies->display_price($save, '') . '</span><br><span class="norm">' . TEXT_PRODUCT_OUR.$show_special_price . $show_sale_price . $show_sale_discount.'</span>' ;
      }else{
          $final_display_price = $show_special_price . $show_sale_price . $show_sale_discount;
      }
    } else {
     if(($display_msrp_price!='')&&($display_msrp_price!='0')){
     $save=$display_msrp_price-$display_normal_price;
          $final_display_price = '<span class="smalltext1">'.TEXT_PRODUCT_MSRP.'<s>'.$currencies->display_price($display_msrp_price, zen_get_tax_rate($product_check->fields['products_tax_class_id'])).'</s></span><br><span class="save">'.TEXT_PRODUCT_SAVE . $currencies->display_price($save, '') . '</span><br><span class="norm">'.TEXT_PRODUCT_OUR.$show_normal_price . $show_special_price . $show_sale_price . $show_sale_discount.'</span>' ;
      }else{
          $final_display_price = $show_normal_price . $show_special_price . $show_sale_price . $show_sale_discount;
      }
    }

This will show the "You Save" as a percentage only:

if ($display_normal_price == 0) {
  // don't show the $0.00
  if(($display_msrp_price!='')&&($display_msrp_price!='0')){
  $save=$display_msrp_price-$display_normal_price;
      $final_display_price = '<span class="smalltext1">' . TEXT_PRODUCT_MSRP . '<s>' . $currencies->display_price($display_msrp_price, zen_get_tax_rate($product_check->fields['products_tax_class_id'])) . '</s></span><br><span class="save">' . TEXT_PRODUCT_SAVE . number_format((($display_msrp_price -  $display_normal_price)), 2, '.', '') . '%' . '</span><br><span class="norm">' . TEXT_PRODUCT_OUR.$show_special_price . $show_sale_price . $show_sale_discount.'</span>' ;
  }else{
      $final_display_price = $show_special_price . $show_sale_price . $show_sale_discount;
  }
} else {
 if(($display_msrp_price!='')&&($display_msrp_price!='0')){
 $save=$display_msrp_price-$display_normal_price;
      $final_display_price = '<span class="smalltext1">'.TEXT_PRODUCT_MSRP.'<s>'.$currencies->display_price($display_msrp_price, zen_get_tax_rate($product_check->fields['products_tax_class_id'])).'</s></span><br><span class="save">'.TEXT_PRODUCT_SAVE . number_format((($display_msrp_price -  $display_normal_price)), 2, '.', '') . '%' . '</span><br><span class="norm">'.TEXT_PRODUCT_OUR.$show_normal_price . $show_special_price . $show_sale_price . $show_sale_discount.'</span>' ;
  }else{
      $final_display_price = $show_normal_price . $show_special_price . $show_sale_price . $show_sale_discount;
  }
}

> This will remove the "You Save" line completely:
> ```php
    if ($display_normal_price == 0) {
      // don't show the $0.00
      if(($display_msrp_price!='')&&($display_msrp_price!='0')){
      $save=$display_msrp_price-$display_normal_price;
          $final_display_price = '<span class="smalltext1">' . TEXT_PRODUCT_MSRP . '<s>' . $currencies->display_price($display_msrp_price, zen_get_tax_rate($product_check->fields['products_tax_class_id'])) . '</s></span><br />' . '<span class="norm">' . TEXT_PRODUCT_OUR.$show_special_price . $show_sale_price . $show_sale_discount.'</span>' ;
      }else{
          $final_display_price = $show_special_price . $show_sale_price . $show_sale_discount;
      }
    } else {
     if(($display_msrp_price!='')&&($display_msrp_price!='0')){
     $save=$display_msrp_price-$display_normal_price;
          $final_display_price = '<span class="smalltext1">'.TEXT_PRODUCT_MSRP.'<s>'.$currencies->display_price($display_msrp_price, zen_get_tax_rate($product_check->fields['products_tax_class_id'])).'</s></span><br />' . '<span class="norm">'.TEXT_PRODUCT_OUR.$show_normal_price . $show_special_price . $show_sale_price . $show_sale_discount.'</span>' ;
      }else{
          $final_display_price = $show_normal_price . $show_special_price . $show_sale_price . $show_sale_discount;
      }
    }

I'm also looking at moving the "You Save" line below the "MSRP Price" and "Our Price" so that it's in a more logical order. I need to get some rest right now though.

I am looking to remove the "You save" line completely. I inserted the code above into includes/functions/functions_prices.php on line 294. But makes my site go blank. Am I changing the correct file?

Thanks, Kim

kburner
Burner Christian Bookstore
https://www.burnerbooks.com

10 May 2010, 7:35 PM

#197

little_red_crane

New Zenner

Join Date:: Mar 2009
Posts:: 20
Plugin Contributions:: 0

Re: MSRP contrib

MSRP Color/Code Problem Solved

http://www.zen-cart.com/forum/showthread.php?p=881908#post881908

:clap:

Little Red Crane

14 May 2010, 2:24 AM

#198

kburner

Totally Zenned

Join Date:: Apr 2008
Location:: Flint, Michigan
Posts:: 684
Plugin Contributions:: 0

Re: MSRP contrib

This is a great module! I finally was able to figure out how to remove 'You save" from the products page with the help of other posts.

Now it looks like this:
Retail Price: $39.95
Our Price: $33.95

**Don't don't know where in includes/functions/functions_prices.php and how to change code for specials.
**
Specials Look like this:
Retail Price: $14.99
Our Price: $14.79 $14.59
Save: 3% off

How do I remove -
Save: 3% off

I would like specials to look like:
Retail Price: $14.99
Our Price: $14.79
Limited time Sale Price: $14.59

kburner
Burner Christian Bookstore
https://www.burnerbooks.com

17 Jul 2010, 6:33 AM

#199

bettyc

New Zenner

Join Date:: Apr 2008
Posts:: 37
Plugin Contributions:: 0

Re: MSRP contrib

I don't understand Step 1 of the mod for MSRP. What exactly do we put in the SQL query under admin? I put in what is indicated in step one and I get errors.

This is what I get -

1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'tableprefix_products ADD products_msrp DECIMAL( 15, 4 ) NOT NULL AFTER products' at line 1
in:
[ALTER TABLE zen_ tableprefix_products ADD products_msrp DECIMAL( 15, 4 ) NOT NULL AFTER products_price ;]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

What is the correct verbiage that I am supposed to use to get this part to work?

Please advise. I would appreciate it. Thanks

14 Oct 2010, 7:38 PM

#200

smoke133

Zen Follower

Join Date:: Jul 2007
Location:: Roseville, Michigan
Posts:: 188
Plugin Contributions:: 0

Re: MSRP contrib

Is there a way to have an image show up behind our price and just for the product page?

https://www.jhelectronics.com
Using Zencart 1.3.9h