| Steve Wolf 2006-10-31, 1:24 am |
| In SQL the List Price (cy_list_price) and Original Price (OriginalPrice)
columns are both 7214.5298. My XML specified 7214.53 as the ListPrice
attribute.
This is the case for both the product family and the product variant
entries.
""Vinayak Tadas[MSFT]"" wrote:
> Can you check the price of the product in the catalogName_catalogproducts
> table for the productid
>
>
> Thanks
> Vinayak Tadas
> Microsoft
> http://blogs.msdn.com/vinayakt
>
> This posting is provided "AS IS" with no warranties, and confers no rights.
> You assume all risk for your use. © 2002 Microsoft Corporation. All rights
> reserved.
> Use of included script samples are subject to the terms specified at
> http://www.microsoft.com/info/cpyright.htm
> Get Secure! For more info visit http://www.microsoft.com/security. Please
> reply to the newsgroups only
>
>
> --------------------
> Thread-Topic: CS 2007 Import of listprice attribute is mangeling decimal
> amounts
> thread-index: Acb50m9sNBm8K2qUSAOj0P0kwThymA==
> X-WBNR-Posting-Host: 85.82.166.66
> From: =?Utf-8?B?U3RldmUgV29sZg==?= <SteveWolf@discussions.microsoft.com>
> Subject: CS 2007 Import of listprice attribute is mangeling decimal amounts
> Date: Fri, 27 Oct 2006 07:16:03 -0700
> Lines: 11
> Message-ID: <C0465C5E-ABED-4196-80EA-D6632FE72271@microsoft.com>
> MIME-Version: 1.0
> Content-Type: text/plain;
> charset="Utf-8"
> Content-Transfer-Encoding: 7bit
> X-Newsreader: Microsoft CDO for Windows 2000
> Content-Class: urn:content-classes:message
> Importance: normal
> Priority: normal
> X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.1830
> Newsgroups: microsoft.public.commerceserver.catalog
> Path: TK2MSFTNGXA01.phx.gbl
> Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.commerceserver.catalog:6454
> NNTP-Posting-Host: TK2MSFTNGXA01.phx.gbl 10.40.2.250
> X-Tomcat-NG: microsoft.public.commerceserver.catalog
>
> I am importing products to the product catalog via the standard import XML
> process. When I set a list price of (say) 7214.53, the price which shows
> up
> on the catalog is 7214.5298. It appears CS 2007 is doing some sort of
> mathematical processing on the list price which ends up creating a float
> amount which is nearly but not exactly the price I want.
>
> I got around the problem by importing all of my prices in whole (Kroner)
> amounts. Is there a way to control the listprice attribute to indicate
> that
> it is a fixed (2 decimal places) amount?
>
> XML Snippet: <Product UseCategoryPricing="0" listprice="7214.53" and so
> on..
|