9ashes Posted July 17, 2013 Share Posted July 17, 2013 Hi there, I've got quite a unique problem with the client I'm putting a prestashop together for and I'd really like some advice/ideas on what I can suggest. Trust me, it seems to make no common sense but, alas, some problems dont! One of manufacturers that my client stocks is dead against selling their products online and doesn't allow companies that stock them to show any prices of their products on their websites. Instead, they want customers to call the distributors, such as my client, and get a price over the phone. Unsurprisingly, this manufacturer is my client's biggest seller. There's a strategy that my client is considering whereby the prices are up over weekends but not during weekdays as this is when he'll get most sales and when the manufacturer is least likely to notice. Basically, I was wondering whether there is an easy way of removing prices from a whole bunch of products by this manufacturer without having to go into each product and uncheck 'Available for order' and 'Show Price'? Any alternative ideas and advice would be most appreciated. Link to comment Share on other sites More sharing options...
9ashes Posted July 18, 2013 Author Share Posted July 18, 2013 BUMP Link to comment Share on other sites More sharing options...
musicmaster Posted July 19, 2013 Share Posted July 19, 2013 It might be best to go directly to the database with a mysql query like update ps_product set available_for_order='0', show_price='0' where id_manufacturer ='99' (PS 1.4.x) or update ps_product_shop s, ps_product p set available_for_order='0', show_price='0' where p.id_product=s.id_product AND p.id_manufacturer='99' (PS 1.5.x) These are from the top of my head so you will need to test them. Link to comment Share on other sites More sharing options...
El Patron Posted July 19, 2013 Share Posted July 19, 2013 check the OEM module developer, prestochangeo, they have a private shop that works by category and possibly at the product level...basically this will hide the prices etc. my private shop does not support by category/product level (maybe someday).... Link to comment Share on other sites More sharing options...
PascalVG Posted July 20, 2013 Share Posted July 20, 2013 Did your client do some 'analysis' what are the risks involved when caught? Will the manufacturer stop distributing to him or so? He should consider twice if the risk is worth taking. Even managers do use Internet, especially in weekends... That said, maybe a 'private shop' as suggested above may 'scare' the managers away a little, but maybe also clients. Are there many new clients involved every day? To get a little better idea about the problem, some questions: - Are the products involved all in a separate category? (or more categories, but at least not mixed with products of other manufacturers/not involved) - Do you know how to handle SQL? - It should be possible to show the price field for all but one (or a few) category and make it day-dependent automatically. But are the clients world wide, or in one country? (i.e. time zones may differ??) My $0.02 pascal Link to comment Share on other sites More sharing options...
PascalVG Posted July 20, 2013 Share Posted July 20, 2013 Add SQL: Do you maintain the client's website for him, or should he be able to do the weekly change himself? Then the question should maybe be: Does your client know SQL... Link to comment Share on other sites More sharing options...
Recommended Posts