Kryptronic Software Support Forum

You are viewing this forum as a guest. Login to an existing account, or create a new account, to reply to topics and to create new topics.

#1 05-02-2017 09:27:13

GlennMUK
Member
From: Dublin, Ireland
Registered: 03-26-2004
Posts: 155

Is all pricing in one single DB table? Also,hide pricing on some prods

Hi Nick

I need to update all pricing in my V9 DB.  I have everything in excel at the moment so looking to do a complete transfer across to a CSV.

Am I correct in thinking that everything I need is in: ecom_pricemap?


Also - I have a certain amount of my products 'not for sale' so they are showing on my site with no pricing.  Is there an option to use a 'Contact us for Pricing' button here?  Or something similar?

Offline

 

#2 05-03-2017 08:43:52

webmaster
Administrator
From: York, PA
Registered: 04-20-2001
Posts: 19798
Website

Re: Is all pricing in one single DB table? Also,hide pricing on some prods

Yes, all pricing is in ecom_pricemap.  You could bulk load data via CSV import, or use the Bulk Pricing Editor extension module, which makes it a snap.

For those not for sale items, probably the best thing to do is to append your offer long description for those items with a nice button-looking div or strong text or something saying exactly what you want.  Ie:

Code:

<p class="kstrong">Contact Us For Pricing</p>

Nick Hendler

Offline

 

Board footer