MSRP contrib

[kburner]

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

[majoritywhip]

I have the same question as Kitteh

[ceegeeaar]

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

[ceegeeaar]

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

[ceegeeaar]

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

[ceegeeaar]

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.

[majoritywhip]

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?

[ceegeeaar]

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.

[melvin41bet]

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/

[majoritywhip]

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.