Where is item price stored?

[Comix Zone]

Hello-

Trying to cleanup database and mainly items. exported the "items" table and it has every field except for the actually selling price for the item. Where is that stored?

thanx!
Greg

[Andrew Shelton]

Good afternoon and Happy New Year Greg

Your question while detailed has a lot of potential answers based on how versatile Everest is settings wise for merchants to setup selling prices. 

Below are a couple questions to help guide you:

• Do you use COST + MARKUP or do you use straight fixed selling prices on items? 
  
• Do you have multiple selling prices based on different units of measure?  
  
• Do you use MSRP and Customer Level Pricing (discounted web prices)?
  
• Do you use special pricing rules (ie where you go into special pricing and assign a discount on every item within a brand/category or tracking choice - this one is most difficult to work with)?  
  

We work with Everest merchants that use all of the above types of pricing. 

If you are using any of the above then the only/best way to get the data out of the database will be via an advanced query (in Everest) or via SQL (ssms). You will not be able to access/see the prices on an items browser export (unless you wrote a script to update the prices to a couple custom numeric fields). In looking at one of your product pages, https://www.comixzone.com/itemdesc.asp?buy=Grrl-Scouts-Stone-Ghost-1&ic=SEP210027, it looks like you are doing some form of discounting. Typically the $3.99 retail/msrp is stored in the dbo.item_measure (meas_type = 1) table while the sale/your price of $3.19 is stored in the dbo.item_cust_level_detail (ICLD) table based on a join to the dbo.item_measure table. If your ICLD prices are based on cost+markup then the data joins and calculations will be a little more difficult if you're not accustomed to working in data layers. 

If you'd like some assistance with this further let us know. 

There is A LOT we could do to help you to ~2x to 3x your web business.  

 

Regards // A

Andrew Shelton - CEO/CMTO Direct: 813.365.3836 | Offices: 813.365.3696 martec360.com | facebook | linkedin

--
--
Email sent to Google Groups: "Everest (Icode/Versata) ERP Users Group" group.
 
- Post: evere...@googlegroups.com
- Unsubscribe: everest-erp...@googlegroups.com
- More options: http://groups.google.com/group/everest-erp?hl=en
---
You received this message because you are subscribed to the Google Groups "Everest (Icode/Versata) ERP Users Group" group.
To unsubscribe from this group and stop receiving emails from it, send an email to everest-erp...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/everest-erp/8e613f35-6020-4ede-8e46-bf19f44ff2ban%40googlegroups.com.

[Info Akute]

Hi,

Item selling price exists in "ITEM_MEASURE" table

Best Regards,

AKUte Team

Open ticket for quick tracking http://www.akutesoft.com/support/open.php

in...@akutesoft.com | www.akutesoft.com | Skype -  info.akute

To view this discussion on the web visit https://groups.google.com/d/msgid/everest-erp/CAEWrG4y2s7d9D0bkHc%2BeZpH%3DV9ryZe3D%2BcmnDNnb%2Boyom%2BAiPg%40mail.gmail.com.

[Comix Zone]

thank you, I had found this. Should have updated.