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 07-09-2017 07:13:05
- larry
- Member
- Registered: 07-21-2003
- Posts: 437
Search Product Offer by pricemap field
It is quite handy when doing price reviews to be able to search / sort the offers by price. But since the tables are split, that is not so easy to do in Admin. Would you provide an SQL query that will accomplish this task? Examples: search for all product offers that have a wholesale price greater than $0; or display any offer that has a comparison price so anything "on sale" can be reviewed.
Laurie Stephens
Offline
#2 07-10-2017 09:09:46
Re: Search Product Offer by pricemap field
search for all product offers that have a wholesale price greater than $0
SELECT DISTINCT(xofferid) FROM ecom_pricemap WHERE channelid='DEFAULT' AND whlprice<=0
display any offer that has a comparison price so anything "on sale" can be reviewed
SELECT DISTINCT(xofferid) FROM ecom_pricemap WHERE channelid='DEFAULT' AND compprice<=0
Nick Hendler
Offline