MSRP contrib

hbtrading,

I really like your product display for www.hbwatches.com.

Did you use the tab products pro mod? What mod?

Thanks, Kim
##############################___
kburner
www.burnerbooks.com

I accidently put this post in the wrong area....can someone please move it? Thanks, Kim

I have the same question as Kitteh

I have a site with 16000 products already on it I'd like to add this mod to. What is the best way to get the RRP pricing into the database?

I can create a csv with product id and rrp but no idea how to get that data into the database in the right place and in the right order. I could use vlookup in a spreadsheet if I can get the products table into a csv or something similar and be able to reimport it but im sure there must be an easier way to do it.

Can anybody help?

Thankyou
Claire

I've created a table zen_products_rrp with products_model and rrp in it and imported a csv with the relevant information.

Ive created products_msrp in zen_products and am trying to update it with the correct rrp's.

Can anyone tell me what is wrong with this sql query in phpmyadmin..

UPDATE 'zen_products' SET `products_msrp` = ( SELECT 'rrp'
FROM 'zen_products_rrp'
WHERE 'zen_products_rrp.products_model' = `zen_products.products_model` )

It returns an error..

#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 ''zen_products' SET `products_msrp` = ( SELECT 'rrp'
FROM 'zen_products_rrp'
WH' at line 1

Im picking this up as I go along so syntax could be completely wrong!

Thankyou
Claire

Worked it out, thanks anyway. It works if you remove the 's

Hmm the problem now is that leading 0's have been stripped from my model numbers in zen_products so dont match the rrp ones. :ohmy:

Trying to get this to work for me but I can't seem to add the table to my DB. I have no idea how to do this with phpMyadmin, so I tried the script using the SQL patches tool in admin.

Here is the code that I submitted:

ALTER TABLE `zen_products` ADD `products_msrp` DECIMAL( 15, 4 ) NOT NULL AFTER `products_price` ;

And here is the error that I received:

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 'zen_products ADD products_msrp DECIMAL( 15, 4 ) NOT NULL AFTER products_price' at line 1
in:
[ALTER TABLE zen_ zen_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.

So then I saw the zen_zen_products statement and figured that I should just write it simply as "products" since the "zen_" was being inserted.

Nope. Here is the error message:

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 'products ADD products_msrp DECIMAL( 15, 4 ) NOT NULL AFTER products_price' at line 1
in:
[ALTER TABLE zen_ products ADD products_msrp DECIMAL( 15, 4 ) NOT NULL AFTER products_price ;]

Any ideas on step one?

make sure you are using the slanty quotes next to number 1 and not single quotes next to semi-colon on your keyboard. It is usually Ok to ommit them if in any doubt.

Always make a backup of your database before messing with it though.

Hi,

I did everything it said but my store still shows just my regular prices. I do not see any error messages to why it want show the MSRP prices and YOU SAVE percentage.

http://lazywebprofits.com/cstore/

OK. I discovered that the script doesn't work in the SQL Patches tool and I got it to work using MyPHPadmin. What a great Contrib!

I have one more request, if y'all don't mind...

I would like to get rid of the strike through in "Retail Price" while still leaving it in the dollar amount.

I find it unreadable when it spans the entire line.

Any help would be exceptionally appreciated.